📄 reading.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" import="java.util.*" import="java.lang.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>准备答题</title>
<link href="img/cssexamin.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript" src="/myside/examin/img/youno.js"></script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
.unnamed1 {
font-size: 12px;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head>
<body>
<div align="center">
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%
String userNow = request.getParameter("userid");
String password=request.getParameter("password");
System.out.print(password);
%>
<%linejdbc.setdrivername();%>
<%
//通过传来的ID提取学生资料
Connection conn = linejdbc.getopenConnection();
PreparedStatement s = conn.prepareStatement
("select * from student where S_id=? and S_psw=?");
s.setString(1,userNow);
s.setString(2,password);
ResultSet result = s.executeQuery();
if (result.next())
{
String S_id = result.getString("S_id");
String S_name = result.getString("S_name");
String Sex=result.getString("sex");
String Major=result.getString("major");
String Grade=result.getString("grade");
%>
<%/*
//随机在学生所要考的科目中提取题库的ID
int romad = 0;
int t = 0;
int i = 0;
Connection connn = linejdbc.getopenConnection();
PreparedStatement p = connn.prepareStatement
("select MAX(id) from quiz ");
ResultSet resultp = p.executeQuery();
resultp.next();
t = resultp.getInt(1);
Random rand = new Random();
i = rand.nextInt(t);
romad = i + 1;
*/
%>
<form action="begin.jsp" method="post" name="formzhunbei" id="formzhunbei">
<span class="unnamed1">登陆成功!</span>
<table width="360" border="0" cellpadding="0" cellspacing="2" >
<tr>
<td colspan="2"><p class="table">您的相关信息:</p></td>
</tr>
<tr>
<td width="48%" class="table">学号:<%=userNow%></td>
<td width="52%" class="table">姓名:<%=S_name%></td>
</tr>
<tr>
<td class="table">性别:<%=(Sex==null?"":Sex)%></td>
<td class="table">年级:<%=(Grade==null?"":Grade)%></td>
</tr>
<tr>
<td colspan="2" class="table">专业:<%=(Major==null?"":Major)%>
<input name="S_id" type="hidden" id="S_id" value="<%=S_id%>"> <input name="S_name" type="hidden" id="S_name" value="<%=S_name%>"></td>
</tr>
<%
s = conn.prepareStatement("select * from score where s_id=?");
s.setString(1,userNow);
ResultSet rs=s.executeQuery();
if(rs.next())
{
%>
<tr>
<td colspan="2" class="table"> 你已经参加过考试了，你的上次考试成绩为:<%=rs.getInt("score")%> </td>
</tr>
<%
}
%>
<tr>
<td colspan="2"><p align="center" class="unnamed1">警告:</p>
<p align="center" class="unnamed1">答题过程不能中断!如果您试图进行作弊或者超过答题时间,</p>
<p align="center" class="unnamed1">您将被强令在24小时后进行补考,补考时间到期前,您不能参加考试!</p>
<p align="center" class="banquan">如果您准备完毕,点按钮开始答题!</p>
<p align="center">
<input type="image" border="0" src="img/zhunbei.gif" align="准备完毕" width="97" height="38" onClick="formzhunbei.submit()" name="image">
</p></td>
</tr>
</table>
<p class="banquan"> </p>
</form>
<p> </p>
<p> </p>
</div>
<%
}
else
{
out.print(" <span class='unnamed1'>用户ID不存在或密码错误!<br><a href='login.jsp' target='_self'>返回</a></span>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -