📄 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="#4692B3" 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>E_mail</td>
<td>删除</td>
<td>更新</td>
</tr>
<%
ResultSet rs = student.getStudent();
while(rs.next())
{
id=rs.getString("id");
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><%=rs.getString("name")%></td>
<td><%=rs.getString("password")%></td>
<td><%=rs.getString("jiguan")%></td>
<td><%=rs.getString("department")%></td>
<td><%=rs.getString("sex")%></td>
<td><%=rs.getInt("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"><<返 回 </a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -