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

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

教育系统应用

开发平台：

WORD

UnitTestPaper.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  2. <%@ page import="java.sql.*" %>
  3. <%@ page import="jinghua.*"%>
  4. <%@ page import="java.text.*" %>
  6. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  7. </jsp:useBean>
  8. <%! boolean debug=false;%>
  9. <%
  10. String testID=request.getParameter("testID");
  11. String studentID=request.getParameter("stuID");
  12. //http://localhost:8080/jinghua/student/UnitTestPaper.jsp?testID=100&stuID=s11
  13. //String testID="100";
  14. //String studentID="s11";
  17. ResultSet rs=null;
  18. String sql="";
  19. String title="";
  20. int testnum=0;
  21. int testmark=0;
  22. PreparedStatement pstmt=null;
  23. StringBuffer dbmsg=new StringBuffer();
  24. StringBuffer testIDs=new StringBuffer();
  25. //StringBuffer Answer=new StringBuffer();
  26. //StringBuffer Mark=new StringBuffer();
  27. int testNumber=0;
  28. try{
  29.     Connection con=DBCon.getConnection();
  31.     sql="select id,paper,title,testnum from test where id="+testID;
  32.     pstmt=con.prepareStatement(sql);
  33.     rs=pstmt.executeQuery();
  35.     if(rs.next()){
  36.         //分析试题：试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  37.         String paper=rs.getString("paper");
  38.         title=rs.getString("title");
  39.         testnum=rs.getInt("testnum");
  41.         if(debug) dbmsg.append("<br>paper="+paper);
  42.         String [] tests=paper.split("#");
  43.         for(int i=0;i<tests.length;i++){
  44.             //取回试题号
  45.             String [] test=tests[i].split("@");
  46.             testIDs.append(test[0]+",");//题号
  47.             //Answer.append(test[1]+"#");//答案
  48. //Mark.append(test[2]+"#");
  50.             testmark+=Float.parseFloat(test[2]);
  51.         }
  52.         sql=testIDs.toString().substring(0,testIDs.length()-1);
  53.         sql="select id,questtext,mark from question where id in ("+sql+") order by id";
  54. rs.close();
  55.         pstmt.close();
  58.         pstmt=con.prepareStatement(sql);
  59.         rs=pstmt.executeQuery();
  63. %>
  64. <html>
  67. <head>
  68. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  69. <title>考试阶段 | <%=title%> | 单项选择题</title>
  70. <link rel="stylesheet" type="text/css" href="../css.css">
  71. </head>
  73. <body>
  74. <center>
  75.   <table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="71">
  76.     <tr>
  77.       <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">
  78.         <img src="../images/ksks.gif" width="108" height="28" border="0"></td>
  79.     </tr>
  80.     <tr>
  81.       <td height="21">当前位置：考试阶段 &gt; </td>
  82.     </tr>
  83.     <tr>
  84.         <TD class=p2 height=30><center>
  85.                     <font color="#74a8d1" size="+2">
  86.                             <strong><B>
  87.                                 <%=title%>
  88.                                     </B>
  89.                             </strong>
  90.                         </font></center></TD>
  91.     </tr>
  92.   </table>
  93. </center>
  94. <center><form name="viewdatabase"  ACTION="unit_sel_rs.jsp"  method="post">
  95.   <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="82">
  96.     <tr class="trh">
  97.       <td width="44" align="center" bgcolor="#799AE1" height="24">
  98.       <font color="#FFFFFF"><b>序号</b></font></td>
  99.       <td align="center" bgcolor="#799AE1" width="592" height="24">
  100.       <p align="center"><font color="#FFFFFF"><b>单项选择题（共<%=testnum%>题,<%=testmark%>分）</b></font></td>
  101.     </tr>
  102.     <%while(rs.next()){%>
  103.     <tr class="trh1">
  104.         <td align="center"   height="35" width="44">　
  105.           <table width="100%" border="0">
  106.             <tr>
  107.               <td><center><%=(++testNumber)%></center></td>
  108.             </tr>
  109.             <tr>
  110.               <td><center><%DecimalFormat df=new DecimalFormat("###");
  111.                   String numNF=df.format(rs.getFloat("mark"));
  112.               out.print("("+numNF+")分");%></center></td>
  113.             </tr>
  114.           </table></td>
  115.       <td align="left" width="592" height="35">
  116.        <br>
  117.         <%=rs.getString("questtext")%>
  118.         <br>
  119.        </td>
  120.     </tr>
  121.     <%}
  122.     rs.close();
  123.     pstmt.close();
  124.     %>
  125.     <tr>
  126.         <td align="center" bgcolor="#FFFFFF" height="16" width="640" colspan="2" bordercolor="#FFFFFF">
  127.           <input class="s02"  type="submit" value="提交" name="submit1">
  128.           &nbsp;&nbsp;
  129.           <input class="s02" type="reset" name="submit2" value="重置">
  130.           <input name="testid" type="hidden" id="testid2" value="<%=testID %>">
  131.           <input name="studentid" type="hidden" id="studentid2" value="<%=studentID %>">
  132.         </td>
  133.       </tr>
  135.   </table>
  136. </form>
  137.  </center>
  140. </body>
  142. </html>
  143. <%
  144. }else{
  145.         Tools.showalert("从数据库中取出试题出错，没有找到相应试卷!",out);
  146.         Tools.goback(out);
  148. }
  149. }catch(SQLException e){
  150.     out.print("<br>SQL Error:sql="+sql+"<br>"+e.toString());
  151. }catch(Exception e){
  152.     out.print(e.toString() );
  153. }
  154. finally{
  155.     DBCon.dropConnection();
  156. }
  157. %>