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

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

教育系统应用

开发平台：

WORD

err_test_print.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. String studentID;
  10. %>
  11. <%
  12. try{
  13.     studentID=(String)session.getAttribute("studentID");
  14.     if(studentID==null){
  15.         throw new Exception();
  16.     }
  17.     //Tools.showalert(studentID,out);
  19. }catch(Exception e){
  20.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  21.      Tools.showJS("window.open('../login.jsp','_self')",out);
  23. }
  25. //testtype: 1浏览的错题;2浏览列表中选中的错题;3错题本中的所有错题
  26. //testorder:2随机顺序;2从难到易;3从易到难
  27. int testtype=Integer.parseInt(request.getParameter("testtype"));
  28. int testorder=Integer.parseInt(request.getParameter("testorder"));
  29. int testnumber=Integer.parseInt(request.getParameter("testnumber"));
  30. boolean printtest;
  31. boolean printanswer;
  32. boolean printtip;
  33. int rownum=0;
  34. if(request.getParameter("printtest")==null)
  35.     printtest=false;
  36. else{
  37.     printtest=true;
  38.     rownum++;
  39. }
  40. if(request.getParameter("printanswer")==null)
  41.     printanswer=false;
  42. else{
  43.     printanswer=true;
  44.     rownum++;
  45. }
  46. if(request.getParameter("printtip")==null)
  47.     printtip=false;
  48. else{
  49.     printtip=true;
  50.     rownum+=2;
  51. }
  53. int selectnum=0;
  54. String errorpad_selectID=(String)session.getAttribute("errorpad_selectID");
  55. String errorpad_sqlcon=(String)session.getAttribute("errorpad_sqlcon");
  57. if(debug){
  58.     out.print("<br>testtype="+testtype+
  59.             "<br>testorder="+testorder+
  60.             "<br>errorpad_sqlcon="+errorpad_sqlcon+
  61.             "<br>errorpad_selectid="+errorpad_selectID+
  62.             "<br>printtest="+printtest+
  63.             "<br>printanswer="+printanswer+
  64.             "<br>printtip="+printtip+
  65.             "<br>rownum="+rownum);
  66. }
  67. ResultSet rs=null;
  68. String sql="";
  69. String sqlcon="";
  70. String sqlorder="";
  71. int testnum=0;
  72. int testmark=0;
  74. PreparedStatement pstmt=null;
  75. Statement stmt=null;
  76. StringBuffer dbmsg=new StringBuffer();
  77. StringBuffer testIDs=new StringBuffer();
  78. StringBuffer errorIDs=new StringBuffer();
  79. //StringBuffer Answer=new StringBuffer();
  80. //StringBuffer Mark=new StringBuffer();
  81. int testNumber=0;
  82. String strName=null;
  83. String strDate=null;
  84. try{
  85.     Connection con=DBCon.getConnection();
  86.     //查询学生信息
  87.     try{
  88.         sql="SELECT   CURRENT_DATE as curdate,`UserInfo`.`vcName` FROM  `UserInfo`"+
  89.             " WHERE  (`UserInfo`.`vcUserNo` = '"+studentID+"')";
  90.         stmt=con.createStatement();
  91.         rs=stmt.executeQuery(sql);
  92.         if(rs.next()){
  93.             strName=rs.getString("vcName");
  94.             strDate=rs.getString("curdate");
  95.         }
  96.         rs.close();
  97.         stmt.close();
  98.     }
  99.     catch(Exception e){
  100.         out.println("<BR>Query student error sql="+sql);
  101.         out.print("<br>"+e.toString());
  102.     }
  104. //构造查询条件
  105. //testtype: 1浏览的错题;2浏览列表中选中的错题;3错题本中的所有错题
  106. //testorder:2随机顺序;2从难到易;3从易到难
  107. switch(testtype){
  108.     case 1:
  109.         sqlcon=errorpad_sqlcon;
  110.         break;
  111.     case 2:
  112.         //计算提交的所选择的错题的数量
  113.         if(errorpad_selectID==null|| errorpad_selectID.trim().equals("")){
  114.             Tools.showalert("还没有从错题本中选择错题！",out);
  115.             Tools.goback(out);
  116.         }else{
  117.        // String [] strarr=errorpad_selectID.split(",");
  118.        // if(debug)   out.print("<br>select num="+strarr.length);
  119.        // if(strarr.length<testnumber){
  120.        //     Tools.showalert("您从错题本中选择的题目数量不足!!",out);
  121.        //     Tools.goback(out);
  122.        // }else{
  123.             sqlcon=errorpad_sqlcon+ " AND (errorpad.id IN ("+errorpad_selectID+")) ";
  124.        // }
  125.         }
  126.         break;
  127.     case 3:
  128.         sqlcon="(`errorpad`.`stu_id` = '"+studentID+"')";
  129.         break;
  130.     default:
  131.         break;
  132. }
  133. switch(testorder){
  134.     case 1:
  135.         sqlorder=" ORDER BY RAND()";
  136.         break;
  137.     case 2:
  138.         sqlorder=" ORDER BY errorpad.errorcount DESC,errorpad.add_date DESC";
  139.         break;
  140.     case 3:
  141.         sqlorder=" ORDER BY errorpad.errorcount ASC,errorpad.add_date DESC";
  142.         break;
  143.     default:
  144.         break;
  145. }
  146. sql="SELECT  errorpad.`id` as errorID,  `question`.`ID`,`question`.`Tip`,`question`.`PreHard` , `question`.`QuestText`,  "+
  147.     " `question`.`Mark`,  `question`.`Answer`"+
  148.     " FROM  `errorpad`"+
  149.     " LEFT OUTER JOIN `question` ON (`errorpad`.`question_id` = `question`.`ID`) "+
  150.     " WHERE "+sqlcon+sqlorder+" LIMIT "+testnumber;
  152.     pstmt=con.prepareStatement(sql);
  153.     rs=pstmt.executeQuery();
  154.     testmark=0;
  155.     testnum=0;
  156.     while(rs.next()){
  157.         testmark+=rs.getInt("Mark");
  158.         testnum++;
  159.         //试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  160.         testIDs.append(rs.getString("ID")+"@"+rs.getString("Answer")+"@"+rs.getString("Mark")+
  161.             "@"+ rs.getString("PreHard")+"#");
  162.         errorIDs.append(rs.getString("errorID")+",");
  163.     }
  165.     rs.beforeFirst();
  167.     if(debug){
  168.         out.print("<br>query question sql="+sql);
  169.     }
  175. %>
  178. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  179. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  180. <HTML><HEAD><TITLE>共创学堂-错题本在线测验</TITLE>
  181. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  182. <LINK
  183. href="../student/style/style.css" type=text/css rel=stylesheet>
  184. <SCRIPT src="../student/js/html.js"></SCRIPT>
  186. <SCRIPT src="../student/js/gnb_menus_layer.js"></SCRIPT>
  188. <SCRIPT src="../student/js/menu.js"></SCRIPT>
  190. <SCRIPT src="../student/js/jumpmenu.js"></SCRIPT>
  192. <SCRIPT src="../student/js/Valid.js"></SCRIPT>
  194. <META content="MSHTML 6.00.2722.900" name=GENERATOR>
  195. <style media="print">
  196. .noprint { display: none }
  197. </style>
  198. <script language="VBScript">
  199. dim hkey_root,hkey_path,hkey_key
  200. hkey_root="HKEY_CURRENT_USER"
  201. hkey_path="SoftwareMicrosoftInternet ExplorerPageSetup"
  202. '//设置网页打印的页眉页脚为空
  203. function pagesetup_null()
  204. on error resume next
  205. Set RegWsh = CreateObject("WScript.Shell")
  206. hkey_key="header"
  207. RegWsh.RegWrite hkey_root+hkey_path+hkey_key,""
  208. hkey_key="footer"
  209. RegWsh.RegWrite hkey_root+hkey_path+hkey_key,""
  210. end function
  211. '//设置网页打印的页眉页脚为默认值
  212. function pagesetup_default()
  213. on error resume next
  214. Set RegWsh = CreateObject("WScript.Shell")
  215. hkey_key="header"
  216. RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"&w&b页码，&p/&P"
  217. hkey_key="footer"
  218. RegWsh.RegWrite hkey_root+hkey_path+hkey_key,"&u&b&d"
  219. end function
  220. </script>
  222. </HEAD>
  223. <BODY text=#000000 bgColor=#ffffff onLoad="pagesetup_null()">
  224. <CENTER>
  225.   <form  ACTION="err_test_rs.jsp"  method="post" name="viewdatabase" target="_blank">
  226.     <table width="80%" border="0" cellspacing="0" cellpadding="0">
  227.       <tr>
  228.         <td width="64%"><img src="../student/images/test_pop_01.gif" width="102" height="27"></td>
  229.         <td align="right"><img src="../student/images/test_pop_02.gif" width="134" height="27"></td>
  230.       </tr>
  231.     </table>
  232.     <!--begin test -->
  233.     <div align="right" class=noprint>
  234.       <OBJECT classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 id=WebBrowser width=0>
  235.       </OBJECT>
  236.       <input name=Button onClick=document.all.WebBrowser.ExecWB(6,6) type=button value=直接打印>
  237.       <input name=Button onClick=document.all.WebBrowser.ExecWB(7,1) type=button value=打印预览>
  238.       <input name=Button onClick=document.all.WebBrowser.ExecWB(8,1) type=button value=页面设置>
  239.       <input name=Button onClick=document.all.WebBrowser.ExecWB(45,1) type=button value=关闭>
  240.     </div>
  241.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
  242.       <tr>
  243.         <td align="center" nowrap class="title1"><div align="center"><font color="#74a8d1" size="+2"><strong><b>共创学堂-错题本</b></strong></font>
  244.           </div></td>
  245.       </tr>
  246.       <tr>
  247.         <td align="center" nowrap class="title1"> <div align="right"> <font color="#74a8d1" size="+2"><strong>
  248.             </strong></font></div>
  249.           <div align="right"></div>
  250.           <div align="left">
  251.             <table width="85%" height="21" border="0" align="center" cellpadding="0" cellspacing="0">
  252.               <tr>
  253.                 <td width="26%"><div align="right"></div></td>
  254.                 <td width="15%" nowrap> <div align="right">姓名：</div></td>
  255.                 <td width="10%" nowrap> <div align="right"><%=strName%></div></td>
  256.                 <td width="4%"><div align="left"></div>
  257.                   <div align="right"></div></td>
  258.                 <td width="45%"><div align="left"><%=strDate%></div></td>
  259.               </tr>
  260.             </table>
  261.           </div>
  262.         </td>
  263.       </tr>
  264.     </table>
  265.   <br>
  266.     <table id=AutoNumber1 style="BORDER-COLLAPSE: collapse"
  267. height=82 cellspacing=1 width="85%" border=0 cellpadding="2" bgcolor="#c1c1c1">
  268.       <tbody>
  269.         <tr class=trh>
  270.           <td width=34 align=center nowrap bgcolor=#eaeaea><b>序号</b></td>
  271.           <td align=middle bgcolor=#eaeaea> <p align=center><b>共<%=testnum%>题</b></p></td>
  272.         </tr>
  273.         <%while(rs.next()){%>
  274.         <tr class=trh1 bgcolor="#FFFFFF">
  275.           <td width="34"  align=center valign="top"><%=(++testNumber)%>. </td>
  276.           <td align=left valign="top">
  277.             <div align="left" >
  278.               <table width="100%" border="0" cellspacing="0" cellpadding="0">
  279.                 <tr class=trh1>
  280.                   <td height="22">
  281.                     <%
  282.          String temp=rs.getString("questtext");
  283.          temp=jinghua.TransformString.deTransformSelection(temp);
  284.          temp=jinghua.TransformString.DeleteBR(temp);
  286.          out.print(temp);
  287.          %>
  288.                   </td>
  289.                 </tr>
  290.         <%if(printanswer){%>
  291.                 <tr class=trh1>
  292.                   <td height="25" align="left" valign="bottom">答案：<%=rs.getString("Answer")%></td>
  293.                 </tr>
  294.         <%}
  295.         if(printtip){
  296.         %>
  297.                 <tr>
  298.                   <td height="22" align="left" valign="bottom">提示：</td>
  299.                 </tr>
  301.                 <tr>
  302.                   <td >
  303.                   <%
  304.                   temp=rs.getString("Tip");
  305.                   temp=jinghua.TransformString.DeleteBR(temp);
  306.                   out.print(temp);
  307.                   %></td>
  308.                 </tr>
  309.         <%}%>
  310.               </table>
  311.             </div>
  313.           </td>
  314.         </tr>
  316.         <%}
  317.     rs.close();
  318.     pstmt.close();
  319.     %>
  320.       </tbody>
  321.     </table>
  323.     <p>&nbsp;</p><p>&nbsp;</p></form></CENTER></BODY></HTML>
  328. <%
  331. }catch(SQLException e){
  332.     out.print("<br>SQL Error:sql="+sql+"<br>"+e.toString());
  333. }catch(Exception e){
  334.     out.print(e.toString() );
  335. }
  336. finally{
  337.     DBCon.dropConnection();
  338. }
  339. %>