开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 教育系统应用 > 查看源码
free_test_rs.jsp
资源名称：0102010.rar　[点击查看]
上传用户：nbluoke
上传日期：2013-08-09
资源大小：4851k
文件大小：13k
源码类别：

教育系统应用

开发平台：

WORD

free_test_rs.jsp：源码内容
  2. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  3. <%@ page import="java.sql.*" %>
  4. <%@ page import="jinghua.*"%>
  5. <%@ page import="java.util.*"%>
  6. <%@ page import="java.text.*"%>
  7. <%! boolean debug=false;%>
  9. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  10. </jsp:useBean>
  13. <%
  14. //String testID=request.getParameter("testid");
  15. String studentID=request.getParameter("studentid");
  16. String paper=request.getParameter("testresult");
  18. if(debug)
  19.     out.print("<br>studentID="+studentID);
  20. //String mn_testID=request.getParameter("mn_testID");
  21. //int valid=Integer.parseInt(request.getParameter("valid"));
  23. //int old=Integer.parseInt(request.getParameter("old"));
  25. //String testID="62";
  26. //String studentID="1";
  27. if(studentID==null){
  28.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  29.     Tools.showJS("window.open('../login.jsp','_self')",out);
  31. }
  32. if(paper==null){
  33.     Tools.showalert("没有取得试卷信息，请重试!!",out);
  34.     Tools.goback(out);
  36. }
  37. else{
  40. ResultSet rs=null;
  41. String sql="";
  42. String title="";
  43. int testnum=0;
  44. StringBuffer sb=new StringBuffer();
  46. Statement stmt=null;
  47. String name="";//考生姓名
  49. int correct=0;
  50. int error=0;
  51. String correctAns="";
  52. String youAns="";
  53. StringBuffer dbmsg=new StringBuffer();
  54. StringBuffer testIDs=new StringBuffer();
  55. StringBuffer Answer=new StringBuffer();
  56. StringBuffer Mark=new StringBuffer();
  57. StringBuffer SubAns=new StringBuffer();
  58. StringBuffer SubMark=new StringBuffer();
  59. StringBuffer TF=new StringBuffer();
  60. StringBuffer Dif=new StringBuffer();
  61. int sub_num=0;
  62. Vector explain=new Vector();
  63. String [] arrMark=null;
  64. String [] arrAnswer=null;
  65. String [] arrSubAns=null;
  66. String [] arrTestID=null;
  67. String [] arrTF=null;
  68. String temp="";
  69. String subid="";//科目ID
  70. String markPercent="";//百分制的分数
  71. float testmark=0.0f;
  72. float totalmark=0.0f;
  73. int testNumber=0;
  74. try{
  75.     Connection con=DBCon.getConnection();
  76.     if(paper!=null){
  77.         //分析试题：试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  78.         if(debug) out.print("<br>begin:");
  79.         String [] tests=paper.split("#");
  80.         testnum=tests.length;
  81.         if(debug) out.print("<br>paper="+paper+"<br>testnum="+testnum);
  83.         for(int i=0;i<testnum;i++){
  84.             //取回试题号
  85.             String [] test=tests[i].split("@");
  86.             if(debug) {
  87.                 out.print("<BR>tests["+i+"]="+tests[i]);
  88.             }
  89.             testIDs.append(test[0]+",");//题号
  90.             Answer.append(test[1]+",");//答案
  91. Mark.append(test[2]+",");
  92.             Dif.append(test[3]+",");
  93.             testmark+=Float.parseFloat(test[2]);//总分数
  94.         }
  96.         arrMark=Mark.toString().split(",");
  97.         arrAnswer=Answer.toString().split(",");
  98.         arrTestID=testIDs.toString().split(",");
  99.         //根据arrTestID提取考生提交的答案信息，不填写的为"空";
  100.         if(debug){
  101.             out.print("<br>Mark="+Mark.toString());
  102.             out.print("<br>Answer="+Answer.toString());
  103.             out.print("<br>TestID="+testIDs.toString());
  104.             out.print("<br>Mark="+Mark.toString() );
  105.             out.print("<br>Dif="+Dif.toString());
  106.         }
  108.         //取回用户提交的答案
  109.         for(int i=0;i<testnum;i++){
  111.            temp=request.getParameter("radio"+arrTestID[i]);
  112.            if (temp==null){
  113.                SubAns.append("空"+",") ;
  114.                //arrSubAns[i]=new String("@");
  115.            }else{
  116.                SubAns.append(temp+",");
  117.                //arrSubAns[i]=new String(temp);
  118.            }
  119.         }
  120.         if(debug){
  121.             out.print("<br>Mark="+Mark.toString());
  122.             out.print("<br>Answer="+Answer.toString());
  123.             out.print("<br>TestID="+testIDs.toString());
  124.             out.print("<br>SubAns="+SubAns.toString());
  126.         }
  127.         arrSubAns=SubAns.toString().split(",");
  128.         //评分
  129.         correct=0;
  130.         error=0;
  131.         testmark=0;
  132.         totalmark=0.0f;
  133.         for(int i=0;i<testnum;i++)
  134.         {
  135.             jinghua.T_Question.addUsedCount(con,Integer.parseInt(arrTestID[i]));
  136.             totalmark+=Float.parseFloat(arrMark[i]);
  137.             if(arrSubAns[i].equals(arrAnswer[i])){
  138.                 jinghua.T_Question.addCorrectCount(con,Integer.parseInt(arrTestID[i]));
  139.                 TF.append("T,");
  140.                 SubMark.append(arrMark[i]+",");
  141.                 correct++;
  142.                 if(debug){
  143.                     Tools.debugmsg("<br>arrMark["+i+"]="+arrMark[i],out);
  144.                 }
  145.                 testmark+=Float.parseFloat(arrMark[i]);
  146.             }else {
  148.                 error++;
  149.                 SubMark.append("0,");
  150.                 if(arrSubAns[i].equals(" "))
  151.                     TF.append("@,");
  152.                 else
  153.                     TF.append("F,");
  154.             }
  156.         }
  157.         if(debug){
  158.             out.print("<br>TF="+TF.toString() );
  159.             out.print("<br>SubMark="+SubMark.toString() );
  160.             out.print("<br>TF[2]="+TF.toString().charAt(2));
  161.         }
  162.         arrTF=TF.toString().split(",");
  163.         //考生信息
  164.         sql="select vcUserNo,vcName from UserInfo where vcUserNo="+"'"+studentID+"'";
  165.         stmt=con.createStatement();
  166.         rs=stmt.executeQuery(sql);
  167.         if(rs.next()){
  169.             name=""+rs.getString("vcName");
  170.         }
  171.         rs.close();
  172.         stmt.close();
  175.         //将错题插入错题本
  176. for(int i=0;i<testnum;i++){
  177. if(debug) out.println("<BR>question error id="+arrTestID[i]+
  178.              ": result="+arrTF[i] );
  179. if(!arrTF[i].equals("T")){
  181. int count=0;
  182. sql=" select count(*) as errcount from errorpad where stu_id='"+studentID+"'"+
  183. " and question_id="+arrTestID[i];
  184. try{
  185.      stmt=con.createStatement();
  186.      rs=stmt.executeQuery(sql);
  187.      if(rs.next()){
  188. count=rs.getInt("errcount");
  189.      }
  190. rs.close();
  191. stmt.close();
  192. if(debug){
  193.              out.print("<br>errorpad question_id="+arrTestID[i]+
  194. "<br>count="+count);
  195.          }
  196. if(count==0){//插入新记录
  197. sql=" insert into errorpad(stu_id,question_id,add_date,errorcount,test_id,mn_test_id,sourcetype)"+
  198. " values('"+studentID+"',"+arrTestID[i]+",CURRENT_TIMESTAMP,1,0,0,1) ";
  199. stmt=con.createStatement();
  200. stmt.executeUpdate(sql);
  201. stmt.close();
  202. }else{
  203. sql=" update errorpad set errorcount=errorcount+1 where stu_id='"+studentID+"'"+
  204. " and question_id="+arrTestID[i];
  205. stmt=con.createStatement();
  206. stmt.executeUpdate(sql);
  207. stmt.close();
  208. }
  211. }
  212.      catch(SQLException se){
  213.              out.print("<br> query errorpad info error sql="+sql);
  214.          out.print("<br>"+se.toString());
  215.      }
  216.     catch(Exception e){
  217.          out.print("<br> query errorpad info error sql="+sql);
  218.         out.print("<br>"+e.toString());
  219.     }
  220. }//end_if
  221. }//end for errorpad
  223.     //试题记录集
  224.     //sql="select id,questtext,tip,mark from question where id in ("+sql+") order by id";
  226.      }
  227. %>
  229. <html>
  231. <head>
  232. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  233. <title>成绩查询 | 考试成绩 |  | 单项选择题</title>
  234. <link rel="stylesheet" type="text/css" href="../css.css">
  235. </head>
  237. <body>
  238. <center>
  239.   <table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
  240.     <tr>
  241.       <td width="100%" height="29" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
  242.         <img border="0" src="../images/cxcj.gif"></td>
  243.     </tr>
  244.     <tr>
  245.       <p>&nbsp;</p>
  246.     </tr>
  247.   </table>
  248.   <p>&nbsp;</p>
  249. </center>
  250. <div align="center">
  251.   <center>
  252.   <table cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="469" id="AutoNumber2" border="1">
  253.       <form method="POST" action=""><tr>
  254.       <td width="100%" height="25" bgcolor="#6699CC" background="../student/images/admin_bg_1.gif" bordercolor="#799AE1">
  255.       <p align="center"><b>&nbsp;<font color="#FFFFFF">成绩单</font></b></td>
  256.     </tr>
  257.     <tr>
  258.       <td width="100%" height="160" bgcolor="#FFFDE8" bordercolor="#799AE1">
  260.         <p align="center">　</p>
  261.             <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="202">
  262.               <tr>
  263.                 <td width="8%" height="28"> <p align="right">考生编号：</td>
  264.                 <td height="28" colspan="4">　<%=studentID%></td>
  265.               </tr>
  266.               <tr>
  267.                 <td width="8%" height="29"> <p align="right">姓&nbsp;&nbsp;&nbsp;
  268.                     名：</td>
  269.                 <td height="29" colspan="4"><%=name%>&nbsp;</td>
  270.               </tr>
  271.               <tr>
  272.                 <td width="8%" height="29"> <p align="right">得&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;分：</td>
  273.                 <td width="13%" height="29">卷面分：</td>
  274.                 <td width="23%"><%=testmark%>&nbsp;</td>
  275.                 <td width="15%">百分制：</td>
  276.                 <td width="41%">
  277.                 <% DecimalFormat df=new DecimalFormat("###");
  278.                     String r=df.format(testmark/totalmark*100);
  279.                     out.print(r);
  280.                 %>
  281.             &nbsp;&nbsp;</td>
  282.               </tr>
  283.               <tr>
  284.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;错：</td>
  285.                 <td height="29" colspan="4"><%=error%>&nbsp;</td>
  286.               </tr>
  287.               <tr>
  288.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;对：</td>
  289.                 <td height="29" colspan="4"><%=correct%>&nbsp;</td>
  290.               </tr>
  291.               <tr>
  292.                 <td height="29"> <p align="right">正确答案：</p></td>
  293.                 <td height="29" colspan="4"><%=Answer.toString() %>&nbsp;</td>
  294.               </tr>
  295.               <tr>
  296.                 <td height="29"><p align="right">您的答案：</p></td>
  297.                 <td height="29" colspan="4"><%=SubAns.toString()%>&nbsp;</td>
  298.               </tr>
  299.             </table>
  300.         <p align="center">　</p>
  302.       </td>
  303.     </tr>
  304.     <tr>
  305.           <td width="100%" height="25" bgcolor="#FFFFFF" bordercolor="#799AE1"> <p align="center">
  306.               <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close2>
  307.               <span lang="en-us"> </span></td>
  309.  </tr></form>
  310.   </table>
  311.   </center>
  312. </div>
  313. <center><form name="viewdatabase"  ACTION=""  method="post">
  314.   <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="82">
  315.     <tr class="trh">
  316.       <td width="44" align="center" bgcolor="#799AE1" height="24">
  317.       <font color="#FFFFFF"><b>序号</b></font></td>
  318.         <td align="center" bgcolor="#799AE1" width="592" height="24"> <p align="center"><font color="#FFFFFF">
  319. <b>单项选择题（共<%=testnum%>&nbsp;题,<%=totalmark%>分）</b></font></td>
  320.     </tr>
  321. <% testNumber=0;
  323. while(testNumber<testnum){%>
  324.     <tr class="trh1">
  325.         <td align="center"   height="35" width="44">　
  326. <center>
  327.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  328.               <tr>
  329.                 <td> <div align="center">
  330.                     <%out.print(testNumber+1);%>.
  331.                   </div></td>
  332.               </tr>
  333.               <tr>
  334.                 <td><div align="center">(<%=Math.round(Float.parseFloat(arrMark[testNumber]))%>分)</div></td>
  335.               </tr>
  336.             </table>
  337.           </center>&nbsp;</td>
  338.         <td align="left" width="592" height="35"><br>
  339. <%
  341. out.print("正确答案是"+arrAnswer[testNumber]+",&nbsp;&nbsp;");
  343.                         if(arrTF[testNumber].equals("T")){
  344.                             out.print("您的答案是"+arrSubAns[testNumber] +"<br>");
  345.                         }else{
  346.                             out.print("<font color=Red>您的答案是"+arrSubAns[testNumber] +"</font><br>");
  347.                         }
  350.              sql="select id,questtext,tip,mark from question where id="+arrTestID[testNumber];
  351.             stmt=con.createStatement();
  352.             rs=stmt.executeQuery(sql);
  353.             if(rs.next()){
  354.      out.print("原题目:<br>"+rs.getString("questtext"));
  355.      out.print("<br>提示：<br>"+""+rs.getString("tip"));
  356.             }
  357.             rs.close();
  358.             stmt.close();
  359. testNumber++;
  360. %>
  361. </td>
  362.     </tr>
  363. <%}
  365.     %>
  366.     <tr>
  367.       <td align="center" bgcolor="#FFFFFF" height="16" width="640" colspan="2" bordercolor="#FFFFFF">
  368.       <p align="center">
  369.       <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close>
  371.       </p>
  372.       </td>
  374.       </tr>
  377.   </table>
  378. </form>
  379.  </center>
  380.  <center> <form ACTION="" METHOD="GET">
  381.     <table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
  382.       <tr>
  383.         <td width="576">
  384.         <p ALIGN="center">&nbsp;</p>
  385.         <p>　</td>
  386.       </tr>
  387.     </table>
  388.   </form>
  389.  </center>
  390. </body>
  392. </html>
  393. <%}
  394. catch (Exception e){
  395.     if(debug){
  396.        Tools.debugmsg("<BR>Exception:"+e.toString() ,out);
  397.     }
  398. }
  399. finally{
  400.     DBCon.dropConnection();
  401. }
  402. }
  403. %>