?? 30690045e444001d15d7c37569a0f5da
字號:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
if (session.getAttribute("userid") == null || session.getAttribute("userid").equals("")) {
response.sendRedirect("index.jsp");
}
%>
<jsp:include flush="true" page="head.jsp"/>
<br/>
<p align="center">
<strong>
<font size="4" color="#FF0000"">專業課程資料列表</font>
</strong>
</p>
<table width="768" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td>
<a href="MajorCourseAdd.jsp">新增</a>
</td>
</tr>
</tr></table>
<table width="768" border="1" align="center" cellpadding="3" cellspacing="1">
<tr>
<td>
<div align="center">專業名稱</div>
</td>
<td>
<div align="center">課程名稱</div>
</td>
<td>
<div align="center">所屬分院</div>
</td>
<td>
<div align="center">修改資料</div>
</td>
<td>
<div align="center">刪除資料</div>
</td>
</tr>
<%
String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; //驅動程序，見第十四章
String url = "jdbc:odbc:stud"; //數據庫連接語句，見第十四章
String userID = "sa", pwd = "", sql = "";
try {
Class.forName(driver); //調入JDBC-ODBC橋的驅動程序
Connection conn = DriverManager.getConnection(url, userID, pwd); //建立與數據的連接
//request對象見第四章
sql = "select m1.recid,m2.majorname,c.coursename,d.depname from majorcourse m1 left outer join major m2 on m1.majorid=m2.majorid ";
sql = sql + " left outer join Course c on m1.courseid=c.courseid left outer join department d on m2.depid=d.depid";
Statement stmt = conn.createStatement(); //建立Statement的實例，相當于創建一個查詢分析器的運行環境
ResultSet rs = stmt.executeQuery(sql); //把查詢結果放入ResultSet對象
String recid = "", majorname = "", coursename="",depname = "";
while (rs.next()) {
recid = rs.getString("recid");
majorname = rs.getString("majorname");
coursename = rs.getString("coursename");
depname = rs.getString("depname");
%>
<tr>
<td>
<div align="center"><%=majorname%> </div>
</td>
<td>
<div align="center"><%=coursename%> </div>
</td>
<td>
<div align="center"><%=depname%> </div>
</td>
<td>
<div align="center">
<a href="majorCourseEdit.jsp?recId=<%=recid%>">修改資料</a>
</div>
</td>
<td>
<div align="center">
<a href="majorCourseDel.jsp?recId=<%=recid%>" onclick="return check();">刪除資料</a>
</div>
</td>
</tr>
<%
}
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
</table>
<br/>
<jsp:include flush="true" page="bottom.jsp"/>
</body>
</html>
<script language="javascript">
function check()
{
if(confirm("刪除確認"))
{
return true;
}
return false;
}
</script>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -