?? getstudent.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>學生</title>
</head>
<jsp:useBean id="student" scope="page" class="student"/>
<body bgcolor="#0099FF" text="#FFFFFF" link="#33FF00">
<p>
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String name="",id="",password="",jiguan="",dep="",sex="",tel="",mail="";
int mark=0;
%>
</p>
<p> </p>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">所有學生</font></p>
<p><a href="addstudent.jsp"><font size="+1" face="華文行楷">新加學生</font></a></p>
<div align="center">
<table width="75%" border="1">
<tr>
<td>學生號</td>
<td>姓名</td>
<td>密碼</td>
<td>籍貫</td>
<td>系別</td>
<td>性別</td>
<td>學分</td>
<td>電話</td>
<td><p>E_mail</p></td>
<td>刪除</td>
<td>更新</td>
</tr>
<%
ResultSet rs = student.getStudent();
while(rs.next())
{
id=rs.getString("id");
name=rs.getString("name");
password=rs.getString("password");
jiguan=rs.getString("jiguan");
dep=rs.getString("department");
sex=rs.getString("sex");
mark=rs.getInt("mark");
tel=rs.getString("tel");
if(tel==null || tel.equals(""))
tel="沒有";
mail=rs.getString("e_mail");
if(mail==null || mail.equals(""))
mail="沒有";
%>
<tr>
<td><%=id%></td>
<td><%=name%></td>
<td><%=password%></td>
<td><%=jiguan%></td>
<td><%=dep%></td>
<td><%=sex%></td>
<td><%=mark%></td>
<td><%=tel%></td>
<td><%=mail%></td>
<td><a href="StudentSvlt?action=delete&id=<%=id%>">刪除</a></td>
<td><a href="updatestu.jsp?id=<%=id%> ">更新</a> </td>
</tr>
<%
}
%>
</table>
</div>
<p align="center"> </p>
<a href="admin.jsp"><<Back </a>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -