?? mn_test.jsp

?? JSP在線考試系統(tǒng),后臺數(shù)據(jù)庫為MySQL_test_online_1.4.1
?? JSP
字號:
<!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;//該學生是否已經做過試卷
    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("這次模擬考試當前已經無效，您可以做其中的試卷，\\n但系統(tǒ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());
    }
    //生成試題編號數(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());
    }
    //檢查學生是否過做與該試卷相同科目的試卷(此次模擬考試中)

    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()){
                //做過該試卷
                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>共創(chuà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>
  <table width="650" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><img src="images/test_pop_01.gif" width="102" height="27"></td>
      <td align="right"><img src="images/test_pop_02.gif" width="134" height="27"></td>
    </tr>
  </table>
  <!--begin test -->
  <table width="650" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td class="title1" align="center"><div align="left">
            <p>&nbsp;</p>
            <p>考試說明：每份試卷只能做一次(提交一次)，同一科目的試卷只記錄第一次測試的分數(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 ){//沒有做過的試卷%>


              <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="_blank">★ <%=t.title%> </a></FONT></B></p>


              <%}else{//做過的試卷%>


              <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="_blank">★ <%=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-->
          &nbsp;&nbsp;
          <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>
      <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
        <TBODY>
        <TR>
          <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
            target=_blank>關于我們</A> | <A
            href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
            target=_blank>聯(lián)系方式</A> | 網站地圖 | <A
            href="http://jsptestonline.cosoft.org.cn/about/service.html"
            target=_blank>服務條款</A> | <A
            href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
            target=_blank>隱私權保護</A> | <A
            href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
            target=_blank>版權聲明</A></TD>
          <TD align=middle width=220>版權所有：<A href="http://jsptestonline.cosoft.org.cn/"
            target=_blank>共創(chuàng)教育機構</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--end bottom --></CENTER>
			</form>
			</BODY></HTML>

<%
}//if test_paper!=null
else{
Tools.showalert("該次模擬考試還沒有發(fā)布試卷，請耐心等待或與系統(tǒng)管理員聯(lián)系",out);
Tools.showJS("window.close()",out);
}

}catch(Exception e){
    System.out.print(e.toString());
}
finally{
    DBCon.dropConnection();
}
%>
?? 文件大小 4808 K
?? 上傳用戶 Even_Moon
?? 所屬分類 Jsp/Servlet
??? 相關標簽

#MySQL_test_online #JSP #后臺
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? mn_test.jsp

?? 快捷鍵說明
