📄 my_test.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="DataBase.Test"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.text.SimpleDateFormat"%>
<script languag=javascript>
function sub(){
document.form1.submit();
}
setTimeout(sub,720000);
</script>
<html>
<head>
<%!
int pdtcount=1;
int xztcount=1;
int tktcount=1;
int id1=1;
int id2=1;
int id3=1;
%>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
DBConn db=new DBConn();
int id=Integer.parseInt(request.getParameter("id"));
String sql="select * from student where id='"+id+"'";
ResultSet rs=db.Query(sql);
rs.next();
String name=rs.getString("name");
String sex=rs.getString("sex");
String classs=rs.getString("class");
String no=rs.getString("no");
String sql2="select * from test";
ResultSet rs1=db.Query(sql2);
rs1.last();
int rowcount=rs1.getRow();
id1=rs1.getInt("id1");
id2=rs1.getInt("id2");
id3=rs1.getInt("id3");
int fenshu1=rs1.getInt("fenshu1");
int fenshu2=rs1.getInt("fenshu2");
int fenshu3=rs1.getInt("fenshu3");
int lastdata=Integer.parseInt(rs1.getString("sj"));
%>
<%String sql3="select * from chengji where no='"+no+"'";
ResultSet rs3=db.Query(sql3);
int i=0;
while(rs3.next()){
if(rs3.getInt("id1")==rowcount){
i=1;
break;
}
}%>
<%if(i==0){ %>
<form name=form1 method=post action="yanzheng13.jsp">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="778" id="AutoNumber1" height="45">
<tr>
<td align="center" valign="top">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" id="AutoNumber2" bgcolor="#CBEFDC" height="40">
<tr>
<td align="center"><a >网上考试系统</a></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" height="100">
<tr>
<td align="center"><font class=test1>第 <%=rowcount%> 期考试</font>
<input type="hidden" name=qi value=<%=rowcount%>>
<input type=hidden name=testid value=<%=id%>>
<br>（本期考试 <%=id1%> 道判断题，<%=id2%> 道选择题，<%=id3%> 道填空题，总分 <%=(id1*fenshu1+id2*fenshu2+id3*fenshu3)%> 分）<br><br>
<input type=hidden name=pd value=<%=id1%>>
<input type=hidden name=xz value=<%=id2%>>
<input type=hidden name=tk value=<%=id3%>>
<input type=hidden name=zf value=<%=(id1*fenshu1+id2*fenshu2+id3*fenshu3)%>>
<input type=hidden name=pds value=<%=fenshu1%>>
<input type=hidden name=xzs value=<%=fenshu2%>>
<input type=hidden name=tks value=<%=fenshu3%>>
<input type=hidden name=lastdata value=<%=lastdata%>>
<%Calendar c = Calendar.getInstance();
c.add(Calendar.DATE,0);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String data = sdf.format(c.getTime());
Calendar c1 = Calendar.getInstance();
c1.add(Calendar.MINUTE,lastdata);
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String data1 = sdf1.format(c1.getTime()); %>
<input type=hidden name=data value=<%=data%>>
<font color="#FF0000">注意：答题时间只有<%=lastdata %>分钟，<%=lastdata %>分钟后未能提交试卷的系统将自动提交。<br>考试开始时间为 <%=data %> 交卷时间为<%=data1%><br> </font>
<br><font color="#000080">考生姓名：<%=name%> 性别： <%=sex %> 班级：<%=classs %> 学号：<%=no %></font><br>
<br>
<div align="center">
<center>
<% String sql4="select * from pdt";
ResultSet rs4=db.Query(sql4);
rs4.last();
pdtcount=rs4.getRow();
String sql5="select * from xzt";
ResultSet rs5=db.Query(sql5);
rs5.last();
xztcount=rs5.getRow();
String sql6="select * from type3";
ResultSet rs6=db.Query(sql6);
rs6.last();
tktcount=rs6.getRow();
Test test=new Test();
int []pdz=test.getsz(pdtcount,id1);
int []xzz=test.getsz(xztcount,id2);
int []tkz=test.getsz(tktcount,id3);
%>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750">
<tr>
<td bgcolor="#CBEFDC">一、判断题（共 <%=id1 %> 道，每题 <%=fenshu1%> 分）</td>
</tr>
<% for(int j=0;j<id1;j++) {
rs4.absolute(pdz[j]+1);
%>
<tr>
<td> <%=(j+1)%>、<%=rs4.getString("tgan") %>
<input type=hidden name="tgpd<%=j+1%>" value=<%=rs4.getString("tgan") %>>
<select name="cate<%=j+1%>" size="1" style="background-color: rgb(224,252,255)">
<option value="1">对</option>
<option value="0">错</option></select>
<input type=hidden name="pdda<%=j+1%>" value=<%=rs4.getString("dan")%>>
</td>
</tr>
<%}%>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750">
<tr>
<td bgcolor="#CBEFDC">二、选择题（共 <%=id2%> 道，每题 <%=fenshu2%> 分）</td>
</tr>
<% for(int k=0;k<id2;k++) {
rs5.absolute(xzz[k]+1);
%>
<tr>
<td> <%=k+1%>、<%=rs5.getString("tgan") %>
<input type=hidden name="tgxz<%=k+1%>" value=<%=rs5.getString("tgan") %>></td>
</tr>
<tr>
<td>
<input type="radio" value="A" name="sele<%=k+1 %>"> A.<%=rs5.getString("A") %>
<input type=hidden name="xzxx1<%=k+1%>" value=<%=rs5.getString("A") %> >
<input type="radio" value="B" name="sele<%=k+1 %>"> B.<%=rs5.getString("B") %>
<input type=hidden name="xzxx2<%=k+1%>" value=<%=rs5.getString("B") %> >
<input type="radio" value="C" name="sele<%=k+1 %>"> C.<%=rs5.getString("C") %>
<input type=hidden name="xzxx3<%=k+1%>" value=<%=rs5.getString("C") %> >
<input type="radio" value="D" name="sele<%=k+1 %>"> D.<%=rs5.getString("D") %>
<input type=hidden name="xzxx4<%=k+1%>" value=<%=rs5.getString("D")%> >
<input type=hidden name="xzda<%=k+1%>" value=<%=rs5.getString("dan") %> >
</td>
</tr>
<%} %>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750">
<tr>
<td bgcolor="#CBEFDC">三、填空题（共 <%=id3%> 道，每题 <%=fenshu3%> 分）</td>
</tr>
<% for(int m=0;m<id3;m++) {
rs6.absolute(tkz[m]+1);
%>
<tr>
<td> <%=m+1 %>、<%=rs6.getString("tgan")%>
<input type=hidden name="tgtk<%=m+1 %>" value=<%=rs6.getString("tgan")%> >
您的答案：<input type="text" name="T<%=m+1 %>" size="20" class="line"></td>
<input type="hidden" name="tkda<%=m+1 %>" value=<%=rs6.getString("dan")%>>
</tr>
<%} %>
</table>
</center>
</div>
<br>
<input type="submit" value="提交" name="B1" onclick="sub()"> <input type="reset" value="重置" name="B2">
<p>
<br>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="778" id="AutoNumber1" height="45">
<tr>
<td align="center" valign="bottom">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" id="AutoNumber2" bgcolor="#CBEFDC" height="40">
<tr>
<td align="center"> <a href="admin.jsp">后台管理入口</a></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
</form>
<%}else{ %>
<script language=javascript>
alert("您已经参加过了考试！");
history.back();
</script>
<%}%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -