getstudent.jsp

来自「课设做的工程分析」· JSP 代码 · 共 127 行

JSP

127 行

<%@ 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">&nbsp; </font>
		</p>
		<a href=""><font color="#000000">&lt;&lt;Back </font> </a>
	</body>
</html>

getstudent.jsp - 源码说明

本页面展示了「课设做的工程分析」中的 getstudent.jsp 源码文件，采用 JSP 编程语言编写，共 127 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与学籍管理系统相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?