📄 getstudent.jsp
字号:
<%@page language="java" contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*,stuman.*" errorPage="errorpage.jsp" %>
<html>
<head>
<LINK href="images/Default.css" type=text/css rel=stylesheet>
<title>学生</title>
</head>
<jsp:useBean id="std" scope="page" class="stuman.student"/>
<body scroll=auto MS_POSITIONING="GridLayout" bgcolor="E7F2FF">
<%
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;
%>
<center><font size="+2" face="华文行楷">学生列表</font></center>
<div align="center">
<table class="main_w" width="75%" border="1" cellpadding="4" cellspacing="0" bordercolor="#3E8A91" bgcolor="E7F2FF" align=center>
<tr><td colspan=11 align=right><a href="addstudent.jsp"><font face="宋体">新增</font></a> </td></tr>
<tr>
<td>学生号</td>
<td>姓名</td>
<td>密码</td>
<td>籍贯</td>
<td>系别</td>
<td>性别</td>
<td>学分</td>
<td>电话</td>
<td><p>E_mail</p></td>
<td colspan=2 align=center>管理操作</td>
</tr>
<%
ResultSet rs = std.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="updatestu.jsp?id=<%=id%> ">修改</a> </td>
<td><a href="StudentSvlt?action=delete&id=<%=id%>">删除</a></td>
</tr>
<%
}
%>
<tr><td colspan=11 align=center><img src="images/replynow.gif"><a href="admin.jsp">返回</a></td></tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -