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

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

教育系统应用

开发平台：

WORD

unit_sel_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 testID="62";
  17. //String studentID="1";
  18. ResultSet rs=null;
  19. Statement stmt=null;
  21. String sql="";
  22. String title="";
  23. int testnum=0;
  24. int i=0;
  25. StringBuffer sb=new StringBuffer();
  26. PreparedStatement pstmt=null;
  27. String name="";//考生姓名
  29. int correct=0;
  30. int error=0;
  31. int count=0;
  32. String correctAns="";
  33. StringBuffer dbmsg=new StringBuffer();
  34. StringBuffer testIDs=new StringBuffer();
  35. StringBuffer Answer=new StringBuffer();
  36. StringBuffer Mark=new StringBuffer();
  37. StringBuffer SubAns=new StringBuffer();
  38. StringBuffer TF=new StringBuffer();
  39. StringBuffer Dif=new StringBuffer();
  40. Vector explain=new Vector();
  41. String [] arrMark=null;
  42. String [] arrAnswer=null;
  43. String [] arrSubAns=null;
  44. String [] arrTestID=null;
  45. String arrTF="";
  46. String temp="";
  47. float testmark=0.0f;
  48. float totalmark=0.0f;
  49. int testNumber=0;
  50. try{
  51.     Connection con=DBCon.getConnection();
  53.     sql="select id,paper,title,testnum from test where id="+testID;
  54.     pstmt=con.prepareStatement(sql);
  55.     rs=pstmt.executeQuery();
  56.    // pstmt.close();
  58.     if(debug){
  59.         out.print("<br>sql="+sql);
  60.     }
  61.     if(rs.next()){
  62.         //分析试题：试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  63.         if(debug) out.print("<br>begin:");
  64.         String paper=rs.getString("paper");
  65.         title=rs.getString("title");
  66.         testnum=rs.getInt("testnum");//总试题数量
  68.         if(debug) out.print("<br>paper="+paper+"<br>testnum="+testnum);
  69.         String [] tests=paper.split("#");
  70.         for(i=0;i<testnum;i++){
  71.             //取回试题号
  72.             String [] test=tests[i].split("@");
  73.             if(debug) {
  74.                 out.print("<BR>tests["+i+"]="+tests[i]);
  75.             }
  76.             testIDs.append(test[0]+",");//题号
  77.             Answer.append(test[1]+",");//答案
  78. Mark.append(test[2]+"#");
  79.             Dif.append(test[3]+"#");
  80.             testmark+=Float.parseFloat(test[2]);//总分数
  86.         }
  88.         arrMark=Mark.toString().split("#");
  89.         arrAnswer=Answer.toString().split(",");
  90.         arrTestID=testIDs.toString().split(",");
  91.         //根据arrTestID提取考生提交的答案信息，不填写的为"空";
  92.         if(debug){
  93.             out.print("<br>Mark="+Mark.toString());
  94.             out.print("<br>Answer="+Answer.toString());
  95.             out.print("<br>TestID="+testIDs.toString());
  96.         }
  98.         for( i=0;i<testnum;i++){
  100.            temp=request.getParameter("radio"+arrTestID[i]);
  101.            if (temp==null){
  102.                SubAns.append("空"+",") ;
  103.                //arrSubAns[i]=new String("@");
  104.            }else{
  105.                SubAns.append(temp+",");
  106.                //arrSubAns[i]=new String(temp);
  107.            }
  108.         }
  109.         if(debug){
  110.             out.print("<br>Mark="+Mark.toString());
  111.             out.print("<br>Answer="+Answer.toString());
  112.             out.print("<br>TestID="+testIDs.toString());
  113.             out.print("<br>SubAns="+SubAns.toString());
  115.         }
  116.         arrSubAns=SubAns.toString().split(",");
  117.         //评分
  118.         correct=0;
  119.         error=0;
  120.         testmark=0;
  121.         totalmark=0.0f;
  122.         for(i=0;i<testnum;i++)
  123.         {
  124.             totalmark+=Float.parseFloat(arrMark[i]);
  125.             if(arrSubAns[i].equals(arrAnswer[i])){
  126.                 TF.append("T");
  127.                 correct++;
  128.                 if(debug){
  129.                     Tools.debugmsg("<br>arrMark["+i+"]="+arrMark[i],out);
  130.                 }
  131.                 testmark+=Float.parseFloat(arrMark[i]);
  132.             }else {
  133.                 error++;
  134.                 if(arrSubAns[i].equals(" "))
  135.                     TF.append("@");
  136.                 else
  137.                     TF.append("F");
  138.             }
  140.         }
  141.         arrTF=TF.toString();
  142.         //考生信息
  143.         rs.close();
  144.         pstmt.close();
  145.         sql="select vcUserNo,vcName from UserInfo where vcUserNo="+"'"+studentID+"'";
  146.         pstmt=con.prepareStatement(sql);
  147.         rs=pstmt.executeQuery();
  148.         if(rs.next()){
  150.             name=""+rs.getString("vcName");
  151.         }
  152.         rs.close();
  153.         pstmt.close();
  154.         //记录考试结果
  156.         DecimalFormat df=new DecimalFormat("###.0");//分数换算
  157.         String r=df.format(testmark/totalmark*100);
  160.         jinghua.T_score t_score=new jinghua.T_score(studentID,Integer.parseInt(testID) ,testmark ,"2",1);    //2:自由单元测试 1:系统判分
  161.         r=t_score.storeMark(2);
  162.         if(debug){
  163.             out.print("<br>t_score:"+r);
  164.         }
  165.         if(!r.equals("OK")){
  166.             throw new Exception("自由单元测试成绩入库错误！cbd");
  167.         }
  169. //将错题插入错题本
  170. for(i=0;i<testnum;i++){
  171. if(debug) out.println("<BR>question error id="+arrTestID[i]+
  172.              ": result="+arrTF.charAt(i) );
  173. if(arrTF.charAt(i)!='T'){
  175. count=0;
  176. sql=" select count(*) as errcount from errorpad where stu_id='"+studentID+"'"+
  177. " and question_id="+arrTestID[i];
  178. try{
  179.      stmt=con.createStatement();
  180.      rs=stmt.executeQuery(sql);
  181.      if(rs.next()){
  182. count=rs.getInt("errcount");
  183.      }
  184. rs.close();
  185. stmt.close();
  186. if(debug){
  187.              out.print("<br>errorpad question_id="+arrTestID[i]+
  188. "<br>count="+count);
  189.          }
  190. if(count==0){//插入新记录
  191. sql=" insert into errorpad(stu_id,question_id,add_date,errorcount,test_id,sourcetype)"+
  192. " values('"+studentID+"',"+arrTestID[i]+",CURRENT_TIMESTAMP,1,"+testID+",2) ";
  193. stmt=con.createStatement();
  194. stmt.executeUpdate(sql);
  195. stmt.close();
  196. }else{
  197. sql=" update errorpad set errorcount=errorcount+1 where stu_id='"+studentID+"'"+
  198. " and question_id="+arrTestID[i];
  199. stmt=con.createStatement();
  200. stmt.executeUpdate(sql);
  201. stmt.close();
  202. }
  205. }
  206.      catch(SQLException se){
  207.              out.print("<br> query errorpad info error sql="+sql);
  208.          out.print("<br>"+se.toString());
  209.      }
  210.     catch(Exception e){
  211.          out.print("<br> query errorpad info error sql="+sql);
  212.         out.print("<br>"+e.toString());
  213.     }
  214. }//end_if
  215. }//end for errorpad
  217.     //试题记录集
  218. sql=testIDs.toString().substring(0,testIDs.length()-1);
  219.         sql="select id,questtext,tip,mark from question where id in ("+sql+") order by id";
  220. pstmt=con.prepareStatement(sql);
  221.         rs=pstmt.executeQuery();
  222.      }
  223. %>
  230. <html>
  232. <head>
  233. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  234. <title>成绩查询 | 考试成绩 |  | 单项选择题</title>
  235. <link rel="stylesheet" type="text/css" href="../css.css">
  236. </head>
  238. <body>
  239. <center>
  240.   <table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
  241.     <tr>
  242.       <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">
  243.         <img border="0" src="../images/cxcj.gif"></td>
  244.     </tr>
  245.     <tr>
  246.       <p>&nbsp;</p>
  247.     </tr>
  248.   </table>
  249.   <p>&nbsp;</p>
  250. </center>
  251. <div align="center">
  252.   <center>
  253.   <table cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="469" id="AutoNumber2" border="1">
  254.       <form method="POST" action=""><tr>
  255.       <td width="100%" height="25" bgcolor="#6699CC" background="images/admin_bg_1.gif" bordercolor="#799AE1">
  256.       <p align="center"><b>&nbsp;<font color="#FFFFFF">成绩单</font></b></td>
  257.     </tr>
  258.     <tr>
  259.       <td width="100%" height="160" bgcolor="#FFFDE8" bordercolor="#799AE1">
  261.         <p align="center">　</p>
  262.             <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="202">
  263.               <tr>
  264.                 <td width="8%" height="28"> <p align="right">考生编号：</td>
  265.                 <td height="28" colspan="4">　<%=studentID%></td>
  266.               </tr>
  267.               <tr>
  268.                 <td width="8%" height="29"> <p align="right">姓&nbsp;&nbsp;&nbsp;
  269.                     名：</td>
  270.                 <td height="29" colspan="4"><%=name%>&nbsp;</td>
  271.               </tr>
  272.               <tr>
  273.                 <td width="8%" height="29"> <p align="right">得&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;分：</td>
  274.                 <td width="13%" height="29">卷面分：</td>
  275.                 <td width="23%"><%=testmark%>&nbsp;</td>
  276.                 <td width="15%">百分制：</td>
  277.                 <td width="41%">
  278.                 <% DecimalFormat df=new DecimalFormat("###");
  279.                     String r=df.format(testmark/totalmark*100);
  280.                     out.print(r);
  281.                 %>
  282.             &nbsp;&nbsp;</td>
  283.               </tr>
  284.               <tr>
  285.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;错：</td>
  286.                 <td height="29" colspan="4"><%=error%>&nbsp;</td>
  287.               </tr>
  288.               <tr>
  289.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;对：</td>
  290.                 <td height="29" colspan="4"><%=correct%>&nbsp;</td>
  291.               </tr>
  292.               <tr>
  293.                 <td height="29"> <p align="right">正确答案：</p></td>
  294.                 <td height="29" colspan="4"><%=Answer.toString() %>&nbsp;</td>
  295.               </tr>
  296.               <tr>
  297.                 <td height="29"><p align="right">您的答案：</p></td>
  298.                 <td height="29" colspan="4"><%=SubAns.toString()%>&nbsp;</td>
  299.               </tr>
  300.             </table>
  301.         <p align="center">　</p>
  303.       </td>
  304.     </tr>
  305.     <tr>
  306.           <td width="100%" height="25" bgcolor="#FFFFFF" bordercolor="#799AE1"> <p align="center">
  307.               <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close2>
  308.               <span lang="en-us"> </span></td>
  310.  </tr></form>
  311.   </table>
  312.   </center>
  313. </div>
  314. <center><form name="viewdatabase"  ACTION=""  method="post">
  315.   <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="82">
  316.     <tr class="trh">
  317.       <td width="44" align="center" bgcolor="#799AE1" height="24">
  318.       <font color="#FFFFFF"><b>序号</b></font></td>
  319.         <td align="center" bgcolor="#799AE1" width="592" height="24"> <p align="center"><font color="#FFFFFF">
  320. <b>单项选择题（共<%=testnum%>&nbsp;题,<%=totalmark%>分）</b></font></td>
  321.     </tr>
  322. <% testNumber=0;
  323. while(rs.next()){%>
  324.     <tr class="trh1">
  325.         <td align="center"   height="35" width="44">　
  326. <center><%out.print(testNumber+1);%></center>&nbsp;</td>
  327.         <td align="left" width="592" height="35"><br>
  328. <%
  329. out.print("正确答案是"+arrAnswer[testNumber]+",&nbsp;&nbsp;");
  330.                         if(arrTF.charAt(testNumber)=='T'){
  331.                             out.print("您的答案是"+arrSubAns[testNumber] +"<br>");
  332.                         }else{
  333.                             out.print("<font color=Red>您的答案是"+arrSubAns[testNumber] +"</font><br>");
  334.                         }
  336. out.print("原题目:<br>"+rs.getString("questtext"));
  337. out.print("<br>提示：<br>"+""+rs.getString("tip"));
  338. testNumber++;
  339. %>
  340. </td>
  341.     </tr>
  342. <%}
  343.     rs.close();
  344.     pstmt.close();
  345.     %>
  346.     <tr>
  347.       <td align="center" bgcolor="#FFFFFF" height="16" width="640" colspan="2" bordercolor="#FFFFFF">
  348.       <p align="center">
  349.       <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close>
  351.       </p>
  352.       </td>
  354.       </tr>
  357.   </table>
  358. </form>
  359.  </center>
  360.  <center> <form ACTION="" METHOD="GET">
  361.     <table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
  362.       <tr>
  363.         <td width="576">
  364.         <p ALIGN="center">&nbsp;</p>
  365.         <p>　</td>
  366.       </tr>
  367.     </table>
  368.   </form>
  369.  </center>
  370. </body>
  372. </html>
  373. <%}
  374. catch (Exception e){
  375.     if(debug){
  376.        Tools.debugmsg("<BR>Exception:"+e.toString() ,out);
  377.     }
  378. }
  379. finally{
  380.     DBCon.dropConnection();
  381. }
  382. %>