📄 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="stu.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>
<form method="post" action="getstudent_confirm.jsp">
<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><input type="checkbox" name="chkbx" value="<%=id%>")></td>
<td><a href="updatestu.jsp?id=<%=id%> ">更新</a> </td>
</tr>
<%
}
%>
</table>
</div>
<p align="center">
<input type="submit" name="Submit" value="提交">
</p>
</form>
<a href="admin.jsp"><<Back </a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -