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

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

教育系统应用

开发平台：

WORD

free_test_paper.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  2. <%@ page import="java.sql.*" %>
  3. <%@ page import="jinghua.*"%>
  4. <%@ page import="java.text.*" %>
  5. <%@ page import="java.util.*" %>
  7. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  8. </jsp:useBean>
  9. <%! boolean debug=false;
  10. String studentID;
  11. %>
  12. <%
  13. try{
  14.     studentID=(String)session.getAttribute("studentID");
  15.     //Tools.showalert(studentID,out);
  16.     if(studentID==null){
  17.         throw new Exception();
  18.     }
  20. }catch(Exception e){
  21.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  22.     Tools.showJS("window.open('../login.jsp','_self')",out);
  23. }
  28. int subID=Integer.parseInt(request.getParameter("Subject"));//-1为全部
  29. int knowID=Integer.parseInt(request.getParameter("KnowPoint"));//-1为全部
  30. //1:任意；2：容易；3：中等；4：较难
  31. int hardID=Integer.parseInt(request.getParameter("hard"));
  32. //testorder:2随机顺序;2从难到易;3从易到难
  33. int testorder=Integer.parseInt(request.getParameter("testorder"));
  34. int testnumber=Integer.parseInt(request.getParameter("testnumber"));
  35. //难易度设置：A,B,C,D,E
  36. //容易：E:30%,D:30%,C:30%;B:10%
  37. //中等：D:20%,C:30%,B:30%,A:10%,E:10%;
  38. //较难：C:20%,B:20%,A:50%,D:10%
  39. int numA=0,numB=0,numC=0,numD=0,numE=0,numElse=0;//各难度试题的个数
  40. switch(hardID){
  41.     case 1:
  42.         numElse=testnumber;
  43.         break;
  44.     case 2:
  46.         numA=0;
  47.         numB=(int)Math.floor(testnumber*0.1);
  48.         numC=(int)Math.floor(testnumber*0.3);
  49.         numD=(int)Math.floor(testnumber*0.3);
  50.         numE=(int)Math.floor(testnumber*0.3);
  51.         numElse=testnumber-numA-numB-numC-numD-numE;
  52.         break;
  54.     case 3:
  55.         numA=(int)Math.floor(testnumber*0.1);
  56.         numB=(int)Math.floor(testnumber*0.3);
  57.         numC=(int)Math.floor(testnumber*0.3);
  58.         numD=(int)Math.floor(testnumber*0.2);
  59.         numE=(int)Math.floor(testnumber*0.1);
  60.         numElse=testnumber-numA-numB-numC-numD-numE;
  61.         break;
  62.     case 4:
  63.         numA=(int)Math.floor(testnumber*0.4);
  64.         numB=(int)Math.floor(testnumber*0.2);
  65.         numC=(int)Math.floor(testnumber*0.2);
  66.         numD=(int)Math.floor(testnumber*0.1);
  67.         numE=(int)Math.floor(testnumber*0.1);
  68.         numElse=testnumber-numA-numB-numC-numD-numE;
  69.         break;
  70. }
  71. if(debug){
  72.     out.print("<br>studentID="+studentID+
  73.             "<br>subID="+subID+
  74.             "<br>knowID="+knowID+
  75.             "<br>hardID="+hardID+
  76.             "<br>testorder="+testorder+
  77.             "<br>numA="+numA+
  78.             "<br>numB="+numB+
  79.             "<br>numC="+numC+
  80.             "<br>numD="+numD+
  81.             "<br>numE="+numE+
  82.             "<br>numElse="+numElse
  83.             );
  84. }
  85. ResultSet rs=null;
  86. String sql="";
  87. String sqlcon="";
  88. String sqlorder="";
  90. int testnum=0;
  91. int testmark=0;
  92. int i=0;
  93. String strQuestIDs=null;
  94. Statement stmt=null;
  96. StringBuffer testIDs=new StringBuffer();
  98. //StringBuffer Answer=new StringBuffer();
  99. //StringBuffer Mark=new StringBuffer();
  100. int testNumber=0;
  104. try{
  105.     Connection con=DBCon.getConnection();
  106. //构造查询条件
  107. //科目
  108. sqlcon="(`question`.`Source` =1)";
  110. if(subID!=-1){
  111.     sqlcon=sqlcon+" AND "+" (`question`.`SubjectID`="+subID+") ";
  112. }
  113. //知识点
  114. if(knowID!=-1){
  115.     if(sqlcon.equals(""))
  116.         sqlcon=" ((`question`.`KnowPointID1` = "+knowID+") OR "+
  117.                 "  (`question`.`KnowPointID2` = "+knowID+") OR "+
  118.                 "  (`question`.`KnowPointID3` = "+knowID+")) ";
  119.     else
  120.         sqlcon=sqlcon+ " AND "+
  121.                 "((`question`.`KnowPointID1` = "+knowID+") OR "+
  122.                 "  (`question`.`KnowPointID2` = "+knowID+") OR "+
  123.                 "  (`question`.`KnowPointID3` = "+knowID+")) ";
  124. }
  126. if(debug){
  127.     out.println("<br>sqlcon="+sqlcon);
  128. }
  129. //testorder:2随机顺序;2从难到易;3从易到难
  130. switch(testorder){
  131.     case 1:
  132.         sqlorder=" ORDER BY RAND()";
  133.         break;
  134.     case 2:
  135.         sqlorder=" ORDER BY `question`.`PreHard` ASC,`question`.`ID` ASC";
  136.         break;
  137.     case 3:
  138.         sqlorder=" ORDER BY `question`.`PreHard` DESC,`question`.`ID` ASC";
  139.         break;
  140.     default:
  141.         break;
  142. }
  144. //难易度
  145. Vector questIDs=new Vector();
  146. //A
  147. if(numA>0){
  148.     if(sqlcon.equals(""))
  149.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  150.                 "(`question`.`PreHard` = 'A')"+" ORDER BY RAND() "+" LIMIT  "+numA;
  151.     else
  152.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  153.             sqlcon+" AND "+"(`question`.`PreHard` = 'A')"+" ORDER BY RAND() "+" LIMIT  "+numA;
  154.     try{
  155.         stmt=con.createStatement();
  156.         rs=stmt.executeQuery(sql);
  157.         while(rs.next()){
  158.             questIDs.addElement(new String(rs.getString("ID")));
  159.         }
  160.         if(debug)
  161.             out.print("<br>select numA sql="+sql);
  162.     }
  163.     catch(Exception e){
  164.         out.print("<br> query question hard A error sql="+sql);
  165.         out.print("<br>"+e.toString());
  166.     }
  167. }
  168. if(debug){
  169.     out.print("<br>vector number A="+questIDs.size());
  170. }
  171. //B
  172. if(numB>0){
  173.     if(sqlcon.equals(""))
  174.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  175.                 "(`question`.`PreHard` = 'B')"+" ORDER BY RAND() "+" LIMIT  "+numB;
  176.     else
  177.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  178.             sqlcon+" AND "+"(`question`.`PreHard` = 'B')"+" ORDER BY RAND() "+" LIMIT  "+numB;
  179.     try{
  180.         stmt=con.createStatement();
  181.         rs=stmt.executeQuery(sql);
  182.         while(rs.next()){
  183.             questIDs.addElement(new String(rs.getString("ID")));
  184.         }
  185.         if(debug)
  186.             out.print("<br>select numB sql="+sql);
  187.     }
  188.     catch(Exception e){
  189.         out.print("<br> query question hard B error sql="+sql);
  190.         out.print("<br>"+e.toString());
  191.     }
  192. }
  193. if(debug){
  194.     out.print("<br>vector number B="+questIDs.size());
  195. }
  197. //C
  198. if(numC>0){
  199.     if(sqlcon.equals(""))
  200.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  201.                 "(`question`.`PreHard` = 'C')"+" ORDER BY RAND() "+" LIMIT  "+numC;
  202.     else
  203.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  204.             sqlcon+" AND "+"(`question`.`PreHard` = 'C')"+" ORDER BY RAND() "+" LIMIT  "+numC;
  205.     try{
  206.         stmt=con.createStatement();
  207.         rs=stmt.executeQuery(sql);
  208.         while(rs.next()){
  209.             questIDs.addElement(new String(rs.getString("ID")));
  210.         }
  211.         if(debug)
  212.             out.print("<br>select numC sql="+sql);
  213.     }
  214.     catch(Exception e){
  215.         out.print("<br> query question hard C error sql="+sql);
  216.         out.print("<br>"+e.toString());
  217.     }
  218. }
  219. if(debug){
  220.     out.print("<br>vector number C="+questIDs.size());
  221. }
  223. //D
  224. if(numD>0){
  225.     if(sqlcon.equals(""))
  226.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  227.                 "(`question`.`PreHard` = 'D')"+" ORDER BY RAND() "+" LIMIT  "+numD;
  228.     else
  229.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  230.             sqlcon+" AND "+"(`question`.`PreHard` = 'D')"+" ORDER BY RAND() "+" LIMIT  "+numD;
  232.     try{
  233.         stmt=con.createStatement();
  234.         rs=stmt.executeQuery(sql);
  235.         while(rs.next()){
  236.             questIDs.addElement(new String(rs.getString("ID")));
  237.         }
  238.         if(debug)
  239.             out.print("<br>select numD sql="+sql);
  240.     }
  241.     catch(Exception e){
  242.         out.print("<br> query question hard D error sql="+sql);
  243.         out.print("<br>"+e.toString());
  244.     }
  245. }
  246. if(debug){
  247.     out.print("<br>vector number D="+questIDs.size());
  248. }
  250. //E
  251. if(numE>0){
  252.     if(sqlcon.equals(""))
  253.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  254.                 "(`question`.`PreHard` = 'E')"+" ORDER BY RAND() "+" LIMIT  "+numE;
  255.     else
  256.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  257.             sqlcon+" AND "+"(`question`.`PreHard` = 'E')"+" ORDER BY RAND() "+" LIMIT  "+numE;
  258.     try{
  259.         stmt=con.createStatement();
  260.         rs=stmt.executeQuery(sql);
  261.         while(rs.next()){
  262.             questIDs.addElement(new String(rs.getString("ID")));
  263.         }
  264.         if(debug)
  265.             out.print("<br>select numE sql="+sql);
  266.     }
  267.     catch(Exception e){
  268.         out.print("<br> query question hard E error sql="+sql);
  269.         out.print("<br>"+e.toString());
  270.     }
  271. }
  272. if(debug){
  273.     out.print("<br>vector number E="+questIDs.size());
  274. }
  276. //Else  strQuestIDs
  277. if(questIDs.size()<testnumber){
  278. //if(numElse>0){
  279.     numElse=testnumber-questIDs.size();
  280.     StringBuffer sb=new StringBuffer();
  281.     for(i=0;i<questIDs.size();i++)
  282.         sb.append(questIDs.elementAt(i)+",");
  283.     if(sb.length()>0){
  284.         strQuestIDs=sb.toString().substring(0,sb.toString().length()-1);
  285.     }
  286.     else
  287.         strQuestIDs="-1";
  288.     sb=null;
  289.     if(sqlcon.equals(""))
  290.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  291.                 "(`question`.`ID` NOT IN ("+strQuestIDs+"))"+" ORDER BY RAND() "+" LIMIT  "+numElse;
  292.     else
  293.         sql="SELECT   `question`.`ID` FROM  `question` WHERE "+
  294.             sqlcon+" AND "+"(`question`.`ID` NOT IN ("+strQuestIDs+"))"+" ORDER BY RAND() "+" LIMIT  "+numElse;
  296.     if(debug)
  297.         out.print("<br>query question numElse sql="+sql);
  298.     try{
  299.         stmt=con.createStatement();
  300.         rs=stmt.executeQuery(sql);
  301.         while(rs.next()){
  302.             questIDs.addElement(new String(rs.getString("ID")));
  303.         }
  304.     }
  305.     catch(Exception e){
  306.         out.print("<br> query question hard Else error sql="+sql);
  307.         out.print("<br>"+e.toString());
  308.     }
  309. }
  311. if(debug){
  312.     out.print("<br>vector number Else="+questIDs.size());
  313. }
  315. switch(testorder){
  316.     case 1:
  317.         sqlorder=" ORDER BY RAND()";
  318.         break;
  319.     case 2:
  320.         sqlorder=" ORDER BY `question`.`PreHard` ASC,`question`.`ID` ASC";
  321.         break;
  322.     case 3:
  323.         sqlorder=" ORDER BY `question`.`PreHard` DESC,`question`.`ID` ASC";
  324.         break;
  325.     default:
  326.         break;
  327. }
  329. StringBuffer sb=new StringBuffer();
  330. for(i=0;i<questIDs.size();i++)
  331.     sb.append(questIDs.elementAt(i)+",");
  332. if(sb.length()>0){
  333.     strQuestIDs=sb.toString().substring(0,sb.toString().length()-1);
  334. }
  335. else
  336.     strQuestIDs="-1";
  337. sb=null;
  339. if(debug)
  340.     out.print("<br>strQuestIDs="+strQuestIDs);
  343. sql="SELECT  `question`.`ID`,`question`.`PreHard` , `question`.`QuestText`,  "+
  344.     " `question`.`Mark`,  `question`.`Answer`"+
  345.     " FROM  `question` "+
  346.     " WHERE `question`.`ID` IN("+strQuestIDs+") "+sqlorder+" LIMIT "+testnumber;
  348.     if(debug)
  349.         out.print("<br>paper sql="+sql);
  350.     stmt=con.createStatement();
  351.     rs=stmt.executeQuery(sql);
  352.     testmark=0;
  353.     testnum=0;
  354.     while(rs.next()){
  355.         testmark+=rs.getInt("Mark");
  356.         testnum++;
  357.         //试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  358.         testIDs.append(rs.getString("ID")+"@"+rs.getString("Answer")+"@"+rs.getString("Mark")+
  359.             "@"+ rs.getString("PreHard")+"#");
  361.     }
  363.     rs.beforeFirst();
  365.     if(debug){
  366.         out.print("<br>query question sql="+sql);
  367.     }
  373. %>
  376. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  377. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  378. <HTML><HEAD><TITLE>共创学堂-错题本在线测验</TITLE>
  379. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  380. <LINK
  381. href="../student/style/style.css" type=text/css rel=stylesheet>
  382. <SCRIPT src="../student/js/html.js"></SCRIPT>
  384. <SCRIPT src="../student/js/gnb_menus_layer.js"></SCRIPT>
  386. <SCRIPT src="../student/js/menu.js"></SCRIPT>
  388. <SCRIPT src="../student/js/jumpmenu.js"></SCRIPT>
  390. <SCRIPT src="../student/js/Valid.js"></SCRIPT>
  392. <META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
  393. <BODY text=#000000 bgColor=#ffffff>
  394. <CENTER>
  395.   <form  ACTION="free_test_rs.jsp"  method="post" name="viewdatabase" target="_blank">
  396.     <table width="650" border="0" cellspacing="0" cellpadding="0">
  397.     <tr>
  398.       <td><img src="../student/images/test_pop_01.gif" width="102" height="27"></td>
  399.       <td align="right"><img src="../student/images/test_pop_02.gif" width="134" height="27"></td>
  400.     </tr>
  401.   </table>
  402.   <!--begin test -->
  403.   <table width="650" border="0" cellspacing="0" cellpadding="0">
  404.     <tr>
  405.       <td class="title1" align="center"><font color="#74a8d1" size="+2">
  406.                             <strong><B>
  407.                                 共创学堂-自由测验
  408.                                     </B>
  409.                             </strong>
  410.                         </font></td>
  411.     </tr>
  412.   </table>
  413.   <br>
  414.   <table id=AutoNumber1 style="BORDER-COLLAPSE: collapse"
  415. height=82 cellspacing=1 width="650" border=0 cellpadding="2" bgcolor="#c1c1c1">
  416.     <tbody>
  417.       <tr class=trh>
  418.         <td align=center width=80 bgcolor=#eaeaea><b>序号</b></td>
  419.         <td align=middle bgcolor=#eaeaea> <p align=center><b>共<%=testnum%>题,<%=testmark%>分</b></p></td>
  420.       </tr>
  421.   <%while(rs.next()){%>
  422.       <tr class=trh1 bgcolor="#FFFFFF">
  423.           <td width=80 align=center valign="middle">　
  424.             <table width="100%" border=0>
  425.               <tbody>
  426.                 <tr align="center">
  427.                   <td colspan="2">
  428.                     <center>
  429.                       <%=(++testNumber)%> .
  430.                     </center></td>
  431.                 </tr>
  432.                 <tr>
  433.                   <td colspan="2"> <center>
  434.                       <font size="-1">
  435.                       <%DecimalFormat df=new DecimalFormat("###");
  436.                   String numNF=df.format(rs.getFloat("mark"));
  437.               out.print("("+numNF+"分)");%>
  438.                       </font></center></td>
  439.                 </tr>
  440.                 <tr>
  441.                   <td width="60%" align="right">
  442. <div align="right"><font size="-1">难度:</font></div></td>
  443.                   <td width="40%" align="left">
  444. <div align="left"><font size="-1"><%=rs.getString("PreHard")%></font></div></td>
  445.                 </tr>
  446.                 <tr>
  447.                   <td colspan="2"><div align="center"><%if(debug) out.print(rs.getString("ID"));%></div></td>
  448.                 </tr>
  449.                 <tr>
  450.                   <td colspan="2">&nbsp;</td>
  451.                 </tr>
  452.               </tbody>
  453.             </table></td>
  454.         <td align=left>
  456.          <%=jinghua.TransformString.DeleteBR(rs.getString("questtext"))%>
  458.  </td>
  459.       </tr>
  461.   <%}
  462.     rs.close();
  463.     stmt.close();
  464.     %>
  465.     </tbody>
  466.   </table>
  467.   <table cellspacing=0 cellpadding=8 width=650 border=0>
  468.     <tbody>
  469.     <tr>
  470.       <td align=center>
  472.             <!--begin botton-->
  473.             <input class=s02 type=submit value=提交 name=submit1>
  474.         &nbsp;&nbsp;
  475.         <input class=s02 type=reset value=重置 name=submit2>
  477.           <input name="studentid" type="hidden" id="studentid2" value="<%=studentID %>">
  478.           <input name="testresult" type="hidden" id="studentid2" value="<%=testIDs.toString()%>">
  481.         <!--end button-->
  482.       </td>
  483.     </tr>
  484.     </tbody>
  485.   </table>
  486.   <!--end test -->
  487.   <!--begin bottom -->
  488.   <TABLE
  489. style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
  490. cellSpacing=0 cellPadding=0 width="100%" border=0>
  491.   <TBODY>
  492.   <TR>
  493.     <TD align=middle colSpan=2 height=30>
  494.       <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
  495.         <TBODY>
  496.         <TR>
  497.           <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
  498.             target=_blank>关于我们</A> | <A
  499.             href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
  500.             target=_blank>联系方式</A> | 网站地图 | <A
  501.             href="http://jsptestonline.cosoft.org.cn/about/service.html"
  502.             target=_blank>服务条款</A> | <A
  503.             href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
  504.             target=_blank>隐私权保护</A> | <A
  505.             href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
  506.             target=_blank>版权声明</A></TD>
  507.           <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
  508.             target=_blank>共创教育机构</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--end bottom --></form></CENTER></BODY></HTML>
  513. <%
  516. }catch(SQLException e){
  517.     out.print("<br>SQL Error:sql="+sql+"<br>"+e.toString());
  518. }catch(Exception e){
  519.     out.print(e.toString() );
  520. }
  521. finally{
  522.     DBCon.dropConnection();
  523. }
  524. %>