📄 getstudent.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
<jsp:directive.page import="jav.classp" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生</title>
</head>
<jsp:useBean id="cla" scope="page" class="jav.classp" />
<body bgcolor="#CCCCFF" text="#FFFFFF" link="#33FF00">
<p>
<p>
</p>
<p align="center">
<font color="#000000" size="+3" face="华文行楷">学生</font>
</p>
<p>
<a href=""><font size="+1" face="华文行楷" color="#000000">返回上一层</font>
</a>
</p>
<div align="center">
<table width="75%" border="2" bordercolorlight="#0000FF"
bordercolordark="#0000FF" bgcolor="#FFFFFF"
style="border-collapse: collapse">
<tr>
<td width="81" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">学生号</font>
</td>
<td width="87" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">专业名称</font>
</td>
<td bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">姓名</font>
</td>
<td width="69" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">籍贯</font>
</td>
<td width="71" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">学院</font>
</td>
<td width="52" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">性别</font>
</td>
<td width="95" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">学籍状态</font>
</td>
<td bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000">详细信息</font>
</td>
</tr>
<% String sql=null;
if(request.getParameter("stuID")==null)
sql="select * from getStudent where claNo='"+request.getParameter("classID")+"'";
else sql="select * from getStudent where stuID='"+request.getParameter("stuID")+"'";
ResultSet rs = cla.QuerySelct(sql);
while (rs.next()) {
String stuID = rs.getString("stuID");
String majorName = rs.getString("majorName");
String stuName = rs.getString("stuName");
String stuOrigin = rs.getString("stuOrigin");
String depNo = rs.getString("depNo");
String stuSex = rs.getString("stuSex");
String stuState = rs.getString("stuState");
%>
<tr>
<td width="81" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=stuID%>
</font>
</td>
<td width="87" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=majorName%>
</font>
</td>
<td bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=stuName%>
</font>
</td>
<td width="69" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=stuOrigin%>
</font>
</td>
<td width="71" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=depNo%>
</font>
</td>
<td width="52" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=stuSex%>
</font>
</td>
<td width="95" bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><%=stuState%>
</font>
</td>
<td bordercolorlight="#0000FF" bordercolordark="#0000FF"
bgcolor="#FFFFFF">
<font color="#000000"><a href="getstudetail.jsp?stuID=<%=stuID%>">点击查看详细信息</a>
</font>
</td>
</tr>
<%
} rs.close();
%>
</table>
</div>
<p align="center">
<font color="#000000"> </font>
</p>
<a href=""><font color="#000000"><<Back </font> </a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -