?? 004fb56c4547001d1f899fce23f5ae12
字號(hào):
<%@ 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"">學(xué)生資料列表</font></strong></p>
<table width="768" border="0" align="center" cellpadding="3" cellspacing="1">
<tr><td><a href="StudAdd.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">專(zhuān)業(yè)名稱(chēng)</div></td>
<td><div align="center">學(xué)生編號(hào)</div></td>
<td><div align="center">學(xué)生姓名 </div></td>
<td><div align="center">所在班級(jí)</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"; //驅(qū)動(dòng)程序，見(jiàn)第十四章
String url="jdbc:odbc:stud";//數(shù)據(jù)庫(kù)連接語(yǔ)句，見(jiàn)第十四章
String userID="sa",pwd="",sql="";
try{
Class.forName(driver);//調(diào)入JDBC-ODBC橋的驅(qū)動(dòng)程序
Connection conn = DriverManager.getConnection(url,userID,pwd);//建立與數(shù)據(jù)的連接
//request對(duì)象見(jiàn)第四章
sql = "select s.*,c.classname,m.majorname,d.depname from studinfo s left outer join class c on s.classid=c.classid left outer join major m on m.majorid=c.majorid left outer join department d on d.depid=m.depid";
Statement stmt = conn.createStatement();//建立Statement的實(shí)例，相當(dāng)于創(chuàng)建一個(gè)查詢(xún)分析器的運(yùn)行環(huán)境
ResultSet rs = stmt.executeQuery(sql); //把查詢(xún)結(jié)果放入ResultSet對(duì)象
String studId="",studName="",classID="",sex="",age="",majorname="",depname="";
while(rs.next()){
studId=rs.getString("StudID");
studName=rs.getString("StudName");
sex=rs.getString("Sex");
age=rs.getString("Age");
classID=rs.getString("ClassName");
majorname=rs.getString("majorname");
depname=rs.getString("depname");
%>
<tr>
<td><div align="center"><%=depname%></div></td>
<td><div align="center"><%=majorname%></div></td>
<td><div align="center"><%=studId%></div></td>
<td><div align="center"><%=studName%></div></td>
<td><div align="center"><%=classID%></div></td>
<td><div align="center"><%=sex%></div></td>
<td><div align="center"><%=age%></div></td>
<td><div align="center"><a href="StudEdit.jsp?studId=<%=studId%>" onclick="return check();">修改資料</a></div></td>
<td><div align="center"><a href="StudDel.jsp?studId=<%=studId%>" 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("刪除確認(rèn)"))
{
return true;
}
return false;
}
</script>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -