📄 score.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>score</title>
</head>
<jsp:useBean id="deter" scope="page" class="database.determine" />
<body bgcolor="#0099FF" text="#FFFFFF" link="#00FF00">
<div align="center">
<p>
</p>
<p>
<font color="#00FF00" size="+3" face="方正舒体">选报该课程的学生有</font>
</p>
<p>
</p>
<table width="75%" border="1">
<tr>
<td>
学生姓名
</td>
<td>
所在系
</td>
<td>
性别
</td>
<td>
学分
</td>
<td>
Email
</td>
<td>
Tel
</td>
<td>
成绩
</td>
</tr>
<%String class_id = request.getParameter("class_id");
String name = null;
String dep = null;
String sex = null;
int mark = 0;
String e_mail = null;
String tel = null;
ResultSet rs = deter.getStudents2(class_id);
String stu_id = null;
while (rs.next()) {
stu_id = rs.getString("id");
name = rs.getString("name");
dep = rs.getString("department");
sex = rs.getString("sex");
mark = rs.getInt("mark");
e_mail = rs.getString("e_mail");
tel = rs.getString("tel");
%>
<tr>
<td>
<%=name%>
</td>
<td>
<%=dep%>
</td>
<td>
<%=sex%>
</td>
<td>
<%=mark%>
</td>
<td>
<%=e_mail%>
</td>
<td>
<%=tel%>
</td>
<td>
<a href="marking.jsp?stu_id=<%=stu_id%>&class_id=<%=class_id%> ">score</a>
</td>
</tr>
<%}
%>
</table>
<p>
</p>
<p align="left">
<a href="choosestu.jsp"><<Back </a>
</p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -