📄 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="database.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 + -