?? mn_test.jsp
字號(hào):
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="jinghua.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=false;
String studentID="";
String mn_testID="";
String mn_test_name="";
Statement stmt=null;
ResultSet rs=null;
String sql="";
int test_num=-1;
String test_paper="";
String [] arrTestID=null;
int mn_testValid=0;
public class testItem{
int id;
int subid;
String title;
boolean old=false;//該考生是否已經(jīng)做過(guò)試卷
public String toString(){
String temp="";
temp="<br> id="+id+"<br> subid="+subid+"<br> title="+title+"<br> old="+old+"<br>";
return temp;
}
};
%>
<%
Vector test=new Vector();
studentID=(String)request.getParameter("stuID");
//Tools.showalert(studentID,out);
mn_testID=(String)request.getParameter("mn_testID");
if(debug){
out.print("<br>stuID="+studentID+"<br>mn_testID="+mn_testID);
}
try{
con=DBCon.getConnection();
//查詢正式考試(mn_testID)信息
sql=" select name,test_num,test_paper,begin_date,end_date, "+
" IF(CURRENT_DATE>end_date OR CURRENT_DATE<begin_date,0,1) as valid "+
" from mn_test where id="+mn_testID;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
mn_testValid=rs.getInt("valid");
test_num=rs.getInt("test_num");
test_paper=rs.getString("test_paper");
mn_test_name=rs.getString("name");
rs.close();
stmt.close();
}
if(mn_testValid==0){
Tools.showalert("這次正式考試當(dāng)前已經(jīng)無(wú)效，您可以做其中的試卷，\\n但系統(tǒng)不記錄成績(jī)，如有疑問(wèn)請(qǐng)與系統(tǒng)管理員聯(lián)系。",out);
}
}catch(SQLException se){
out.print("<br> query mn_test error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query mn_test error sql="+sql);
out.print("<br>"+e.toString());
}
//生成試題編號(hào)數(shù)組(test表ID)
if(debug){
out.print("<br>test_paper="+test_paper);
}
if(test_paper!=null){
arrTestID=test_paper.split("#");
sql="";
for(int i=0;i<arrTestID.length;i++){
sql+=arrTestID[i]+",";
}
sql=sql.substring(0,sql.length()-1);
sql="select * from test where id in("+sql+") order by subid";
if(debug){
out.print("<br>query test sql="+sql);
}
//查詢test表
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
testItem t=new testItem();
t.id=rs.getInt("id");
t.subid=rs.getInt("subid");
t.title=rs.getString("title");
t.old=false;
test.addElement(t);
}
rs.close();
stmt.close();
}catch(SQLException se){
out.print("<br> query mn_test error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query mn_test error sql="+sql);
out.print("<br>"+e.toString());
}
if(debug){
out.print("<br>Vector test="+test.toString());
}
//檢查考生是否過(guò)做與該試卷相同科目的試卷(此次正式考試中)
for(int i=0;i<test.size();i++){
testItem t=(testItem)test.elementAt(i);
int testID=t.id;
//sql="select * from scores where test_class=3 and test_id="+testID+" and stu_id='"+studentID+"'";
sql="select * from mn_scores where sub_id="+t.subid+" and stu_id='"+studentID+"'"+
" and mn_test_id="+mn_testID;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(debug){
out.print("<br>query mn_scores sql="+sql);
}
if(rs.next()){
//做過(guò)該試卷
t.old=true;
}
rs.close();
stmt.close();
}catch(SQLException se){
out.print("<br> query whether the student do the test error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query whether the student do the test error sql="+sql);
out.print("<br>"+e.toString());
}
}
if(debug){
out.print("<br>Vector test="+test.toString());
}
%>
<HTML><HEAD><TITLE>考試系統(tǒng)</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="style/style.css" type=text/css rel=stylesheet>
<SCRIPT src="js/html.js"></SCRIPT>
<SCRIPT src="js/gnb_menus_layer.js"></SCRIPT>
<SCRIPT src="js/menu.js"></SCRIPT>
<SCRIPT src="js/jumpmenu.js"></SCRIPT>
<SCRIPT src="js/Valid.js"></SCRIPT>
<BODY bgColor=#ffffff text=#000000 link="#0000FF" vlink="#0000FF" alink="#0000FF">
<FORM name="form1" action="UnitTestPaper.jsp" method="post">
<CENTER>
<!--begin test -->
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="title1" align="center"><div align="left">
<p> </p>
<p>考試說(shuō)明：每份試卷只能做一次(提交一次)，同一科目的試卷只記錄第一次測(cè)試的分?jǐn)?shù)。</p>
</div></td>
</tr>
</table>
<br>
<table id=AutoNumber1 style="BORDER-COLLAPSE: collapse"
height=82 cellspacing=1 width="650" border=0 cellpadding="2" bgcolor="#c1c1c1">
<tbody>
<tr class=trh>
<td align=center bgcolor=#eaeaea> <p align=center><b><%=mn_test_name%></b></p></td>
</tr>
<tr class=trh1 bgcolor="#FFFFFF">
<td align=middle>
<!--顯示這次正式考試的各份試卷-->
<%
for(int i=0;i<test.size();i++){
testItem t=(testItem)test.elementAt(i);
if(!t.old ){//沒(méi)有做過(guò)的試卷%>
<p align="left"><B><FONT color=#333300> <a href="mn_test_paper.jsp?testID=<%=t.id%>&stuID=<%=studentID%>&mn_testID=<%=mn_testID%>&old=0&valid=<%=mn_testValid%>"
title="<%=t.title%>"
target="mainFrame">★ <%=t.title%> </a></FONT></B></p>
<%}else{//做過(guò)的試卷%>
<p align="left"><B><FONT color=#333300> <a href="mn_test_paper.jsp?testID=<%=t.id%>&stuID=<%=studentID%>&mn_testID=<%=mn_testID%>&old=1&valid=<%=mn_testValid%>"
title="<%=t.title%>"
target="mainFrame">★ <%=t.title%> </a></FONT></B></p>
<%
}
}
%>
</td>
</tr>
</tbody>
</table>
<table cellspacing=0 cellpadding=8 width=650 border=0>
<tbody>
<tr>
<td align=center>
<!--begin botton-->
<input id="mn_testID"
type="hidden" value="<%=mn_testID%>" name="mn_testID">
<!--end button-->
</td>
</tr>
</tbody>
</table>
<!--end test -->
<!--begin bottom -->
<TABLE
style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle colSpan=2 height=30>
</TD></TR></TBODY></TABLE><!--end bottom --></CENTER>
</form>
</BODY></HTML>
<%
}//if test_paper!=null
else{
Tools.showalert("該次正式考試還沒(méi)有發(fā)布試卷，請(qǐng)耐心等待或與系統(tǒng)管理員聯(lián)系",out);
Tools.showJS("window.close()",out);
}
}catch(Exception e){
System.out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -