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

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

教育系统应用

开发平台：

WORD

errorpad.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
  2. <%@ page import="java.sql.*"%>
  3. <%@ page import="jinghua.Tools"%>
  4. <%@ page import="java.util.*"%>
  7. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  8. </jsp:useBean>
  9. <%!Connection con;
  10. boolean debug=false;
  11. String studentID="";
  12. String gradenote="";
  13. String gradename="";
  14. Statement stmt=null;
  15. ResultSet rs=null;
  16. String sql="";
  17. int pageNumber=0;
  18. String sqlCon=null;
  19. int testNumber=0;
  20. //ArrayList arrQuestSel=null;
  21. String[] arrID=null;
  22. String[] arrSelect=null;
  24. //QuestSel qs=null;
  25. int EveryPage=10;//每页显示的记录数；
  26. int OnPage=1; //当前显示的页数；
  27. int Total=0;//记录的总数；
  28. int TotalPage=0;//记录的总页数；
  29. %>
  30. <%
  31. String strPage=request.getParameter("page");//查询页数
  32. String prePage=request.getParameter("OnPage");
  33. if(debug) {
  34. out.print("<br>page="+strPage);
  35. out.print("<br>OnPage="+prePage);
  36. }
  38. if(strPage==null)
  39. OnPage=1;
  40. else
  41. OnPage=Integer.parseInt(strPage);
  43. String studentID ="s11"; //tools.getString((String)session.getAttribute(Configure.sessUserNo));
  44. //BaseInfo objBase = new BaseInfo(studentID);
  45. //Privs objPrivs = objBase.getPrivs();
  46. //String vcGrade = objPrivs.getGrade();
  48. try{
  49.     con=DBCon.getConnection();
  51.     //获取学生的年级信息
  52.     gradenote="c1";
  53.     gradename="初一";
  54.     //查询学生所属年级的错题
  56. %>
  57. <%
  58. //构造查询条件
  59. //String errorpad_grade=(String)session.getAttribute("errorpad_grade");
  60. //String errorpad_sub=(String)session.getAttribute("errorpad_sub");
  61. //String errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
  62. //String errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
  63. //String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  64. sqlCon="";
  65. //String errorpad_grade=request.getParameter("Grade");
  67. String errorpad_sub=request.getParameter("Subject");
  69. String errorpad_knowpoint=request.getParameter("KnowPoint");
  70. String errorpad_testtype=request.getParameter("testtype");
  71. String errorpad_errorcount=request.getParameter("errorcount");
  73. if(debug){
  74.     out.print("<br>grade="+//errorpad_grade+
  75.     "<br>sub="+errorpad_sub+
  76.     "<br>knowpoint="+errorpad_knowpoint+
  77.     "<br>testtype="+errorpad_testtype+
  78.     "<br>errorcunt="+errorpad_errorcount);
  79. }
  81. //if(errorpad_grade!=null)
  82. //{
  83. //    session.setAttribute("errorpad_grade",errorpad_grade);
  84. //}
  85. //else
  86. //{
  87. //    errorpad_grade=(String)session.getAttribute("errorpad_grade");
  88. //}
  89. if(errorpad_sub!=null)
  90. {
  91.     session.setAttribute("errorpad_sub",errorpad_sub);
  92. }else
  93. {
  94.     errorpad_sub=(String)session.getAttribute("errorpad_sub");
  95. }
  96. if(errorpad_knowpoint!=null)
  97. {
  98.     session.setAttribute("errorpad_knowpoint",errorpad_knowpoint);
  99. }
  100. else
  101. {
  102.     errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
  103. }
  104. if(errorpad_testtype!=null)
  105. {
  106.     session.setAttribute("errorpad_testtype",errorpad_testtype);
  107. }
  108. else
  109. {
  110.     errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
  111. }
  112. if(errorpad_errorcount!=null)
  113. {
  114.     session.setAttribute("errorpad_errorcount",errorpad_errorcount);
  115. }
  116. else
  117. {
  118.     errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  119. }
  120. //if(errorpad_grade==null)
  121. //    errorpad_grade="all";
  122. if(errorpad_sub==null)
  123.     errorpad_sub="all";
  124. if(errorpad_knowpoint==null)
  125.     errorpad_knowpoint="all";
  126. if(errorpad_testtype==null)
  127.     errorpad_testtype="all";
  128. if(errorpad_errorcount==null)
  129.     errorpad_errorcount="0";
  131. //if(errorpad_grade!=null){
  132. //    if(!errorpad_grade.equals("all")){
  133. //        if(errorpad_grade.equals("c")){
  134. //            sqlCon="(question.gradenote='c1' OR question.gradenote='c2' OR question.gradenote='c3')";
  135. //        }else if(errorpad_grade.equals("g")){
  136. //            sqlCon="(question.gradenote='g1' OR question.gradenote='g2' OR question.gradenote='g3l' OR question.gradenote='g3w')";
  137. //        }
  138. //      else
  139. //            sqlCon="(question.gradenote='"+errorpad_grade+"')";
  140.  //   }
  141. //}
  142. if(debug)
  143.     out.println("<br>grade sql="+sqlCon);
  145. if(errorpad_sub!=null){
  146.     if(!errorpad_sub.equals("all")){
  147.         if (!sqlCon.equals(""))
  148.             sqlCon=sqlCon +" AND (question.SubjectID="+errorpad_sub+")";
  149.         else
  150.             sqlCon=" (question.SubjectID="+errorpad_sub+")";
  151.     }
  152. }
  153. if(debug)
  154.     out.println("<br>subject sql="+sqlCon);
  156. if(errorpad_knowpoint!=null){
  157.     if(!errorpad_knowpoint.equals("all")){
  158.         if(!sqlCon.equals(""))
  159.             sqlCon=sqlCon+" AND(question.KnowPointID1="+errorpad_knowpoint +
  160.                 " OR question.KnowPointID2="+errorpad_knowpoint+
  161.                 " OR question.KnowPointID3="+errorpad_knowpoint+")";
  162.         else
  163.             sqlCon=" (question.KnowPointID1="+errorpad_knowpoint +
  164.                 " OR question.KnowPointID2="+errorpad_knowpoint+
  165.                 " OR question.KnowPointID3="+errorpad_knowpoint+")";
  166.     }
  167. }
  168. if(debug)
  169.     out.println("<br>knowpoint sql="+sqlCon);
  172. if(errorpad_testtype!=null){
  173.     if(!errorpad_testtype.equals("all")){
  174.         if(!sqlCon.equals(""))
  175.             sqlCon=sqlCon+ " AND(errorpad.sourcetype="+errorpad_testtype+")";
  176.         else
  177.             sqlCon= " (errorpad.sourcetype="+errorpad_testtype+")";
  178.     }
  179. }
  180. if(debug)
  181.     out.println("<br>testtype sql="+sqlCon);
  183. if(errorpad_errorcount!=null){
  184.     if(!sqlCon.equals(""))
  185.         sqlCon=sqlCon+ " AND(errorpad.errorcount>="+errorpad_errorcount+")";
  186.     else
  187.         sqlCon=" (errorpad.errorcount>="+errorpad_errorcount+")";
  188. }
  189. if(debug)
  190.     out.println("<br>errorcount sql="+sqlCon);
  191. sqlCon="(`errorpad`.`stu_id` = 's11')"+" AND"+sqlCon;
  192. //查询满足条件的错题
  193. sql="SELECT  `errorpad`.`id`, `errorpad`.`question_id`, `question`.`QuestText`, DATE_FORMAT( `errorpad`.`add_date`,"%Y-%m-%e %H:%i:%S") AS add_date, "+
  194.     " `errorpad`.`errorcount`,  ELT(`errorpad`.`sourcetype`,"自由测试","自由单元测试","模拟考试") as sourcename, "+
  195.     " `grade`.`Name` AS `gradename`,`subject`.`name` as `subname`"+
  196.     " FROM  `errorpad`"+
  197.     "  LEFT OUTER JOIN `question` ON (`errorpad`.`question_id` = `question`.`ID`)"+
  198.     "  LEFT OUTER JOIN `grade` ON (`question`.`gradenote` = `grade`.`note`)"+
  199. "  LEFT OUTER JOIN `subject` ON (`question`.`SubjectID` = `subject`.`ID`)"+
  200.     " WHERE  "+sqlCon+
  201.     " ORDER BY  `errorpad`.`add_date` ASC,`errorpad`.`ID`";
  203. session.setAttribute("errorpad_sqlcon",sqlCon);
  204. session.setAttribute("errorpad_sql",sql);
  205.  if(debug)
  206.     out.println("<br>at last sql="+sql);
  207. stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  208. rs=stmt.executeQuery(sql);
  210. //是否是新的查询
  211. String newQuery=request.getParameter("newQuery");
  212. if(newQuery==null)
  213. newQuery="false";
  215. if(debug)
  216. out.print("<br>newQuery="+newQuery);
  217. if(newQuery.equals("true"))
  218. {//构造新的试题选择数组
  219. StringBuffer sb1=new StringBuffer();
  220. StringBuffer sb2=new StringBuffer();
  221. //arrQuestSel=new ArrayList();
  223. while(rs.next()){
  224. //QuestSel qs=new QuestSel();
  225. //qs.id=rs.getInt("ID");
  226. sb1.append(rs.getString("ID")+",");
  227. sb2.append("0,");
  228. //arrQuestSel.add(qs);
  231. }
  232. arrID=sb1.toString().split(",");
  233. arrSelect=sb2.toString().split(",");
  235. //session.setAttribute("arrQuestSel",arrQuestSel);
  238. session.setAttribute("arrID",arrID);
  239. session.setAttribute("arrSelect",arrSelect);
  244. }else{
  245. //arrQuestSel=(ArrayList)session.getAttribute("arrQuestSel");
  246. arrID=(String[])session.getAttribute("arrID");
  247. arrSelect=(String[])session.getAttribute("arrSelect");
  248. }
  250. //if(arrQuestSel==null)
  251. // out.print("<br>arrQuestSel=null");
  256. //处理旧页面
  257. String order_chk=request.getParameter("order_chk");
  258. if(debug){
  259. out.print("<br>order_chk="+order_chk);
  260. out.print("<br>arrID="+arrID.toString());
  261. out.print("<br>arrSelect="+arrSelect.toString());
  262. }
  263. if(order_chk!=null && !order_chk.equals("temp")){
  264. //145:0#146:1#
  265. String arrOrder_Sin[]=null;
  266. String arrOrder_chk[]=order_chk.split("#");
  268. for(int i=0;i<arrOrder_chk.length;i++){
  269. if(debug)
  270. out.print("<br> arrorder_chk["+i+"]="+arrOrder_chk[i]);
  271. arrOrder_Sin=arrOrder_chk[i].split(":");
  272. arrSelect[Integer.parseInt(arrOrder_Sin[0])-1]=arrOrder_Sin[1];
  274. }
  276. }
  280. rs.last();//移到最后一条记录;
  281. Total=rs.getRow();//记录的总数；
  282. //计算出总的页数TotalPage；
  283. if(Total%EveryPage==0)
  284. TotalPage=Total/EveryPage;
  285. else
  286. TotalPage=Total/EveryPage+1;
  288.  if(OnPage>TotalPage)
  289.  {
  290.   OnPage=TotalPage;
  291.  }
  292.  else if(OnPage<=0)
  293.  {
  294.   OnPage=1;
  295.  }
  296. //生成一个javascript数组
  297. //<script language ="JavaScript">
  298. //Quest_Order=new Array()
  299. //Quest_Order[0]=new Array(91,98);
  300. //Quest_Order[9]=new Array(91,107);
  301. //</script>
  302. out.println("<script language ="JavaScript">");
  303. out.println("Quest_Order=new Array();");
  304. rs.absolute((OnPage-1)*EveryPage+1);//指定指针的位置；
  305. pageNumber=0;
  306. testNumber=(OnPage-1)*EveryPage+1;
  307. while( pageNumber<EveryPage ) {
  308. out.println("Quest_Order["+pageNumber+"]=new Array("+testNumber+","+rs.getInt("ID")+");");
  310. pageNumber++;
  311. testNumber++;
  312. if(!rs.next())
  313. break;
  314. }
  315. out.println("var QOCount="+pageNumber+";");
  316. out.println("</script>");
  324. if(debug){
  325. out.print("<br>Total="+Total);
  326. out.print("<br>totalpage="+TotalPage);
  328. }
  332. %>
  335. <!--年级，科目，知识点三个下拉列表框联动-->
  336. <%
  337. out.print(Tools.sub_know(con));
  339. %>
  341. <script language="JavaScript">
  343. function changesk(locationid){
  344. document.myform.KnowPoint.length =1;
  345. var locationid=locationid;
  346. var i;
  347. for (i=0;i < gskcount; i++){
  348. if (grade_sub_know[i][1] == locationid){
  349. document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
  350. }
  351. }
  352. }
  355. function delit(myform)
  356. {
  357.   if (confirm("将删除所有选择的知识点数据？"))
  358.   {
  359.     myform.action="errorpaddel.jsp";
  360.     myform.target="_self";
  361.     myform.submit();
  362.   }
  363. }
  364. function del_check()
  365. {
  366. var count = errorpad.elements.length;
  367. var noSelect = true;
  368.   for(var i=0;i<count;i++)
  369.   {
  370.      if(errorpad.elements[i].checked)
  371.      {
  372.              noSelect = false;
  373.       break;
  374. }
  375.    }
  376. if(noSelect == true)
  377. {
  378.     alert("您还没有选择要删除的错题!");
  379.     return(false);
  380.  }
  381.    else
  382.    {
  383.          if(confirm("将删除所有选择的错题吗？"))
  384.          {
  385.                 document.errorpad.method = "POST";
  386.                 document.errorpad.action = "errorpad_del.jsp";
  387.                 document.errorpad.target="_self";
  388.                 document.errorpad.submit();
  389.          }
  390.          else
  391.          {
  392.                 document.form3.method = "GET";
  393.                 document.form3.action = "";
  394. }
  395.          }
  396.          return false;
  397. }
  398. function addrate_check()
  399. {
  400. var count = errorpad.elements.length;
  401. var noSelect = true;
  402.   for(var i=0;i<count;i++)
  403.   {
  404.      if(errorpad.elements[i].checked)
  405.      {
  406.              noSelect = false;
  407.       break;
  408. }
  409.    }
  410. if(noSelect == true)
  411. {
  412.     alert("您还没有选择要增加错误级别的错题!");
  413.     return(false);
  414.  }
  415.    else
  416.    {
  417.          if(confirm("增加所有选择的错题的错误级别吗？"))
  418.          {
  419.                 document.errorpad.method = "POST";
  420.                 document.errorpad.action = "errorpad_addrate.jsp";
  421.                 document.errorpad.target="_self";
  422.                 document.errorpad.submit();
  423.          }
  424.          else
  425.          {
  426.                 document.errorpad.method = "GET";
  427.                 document.errorpad.action = "";
  428. }
  429.          }
  430.          return false;
  431. }
  432. function decrate_check()
  433. {
  434. var count = errorpad.elements.length;
  435. var noSelect = true;
  436.   for(var i=0;i<count;i++)
  437.   {
  438.      if(errorpad.elements[i].checked)
  439.      {
  440.              noSelect = false;
  441.       break;
  442. }
  443.    }
  444. if(noSelect == true)
  445. {
  446.     alert("您还没有选择要降低错误级别的错题!");
  447.     return(false);
  448.  }
  449.    else
  450.    {
  451.          if(confirm("降低所有选择的错题的错误级别吗？"))
  452.          {
  453.                 document.errorpad.method = "POST";
  454.                 document.errorpad.action = "errorpad_decrate.jsp";
  455.                 document.errorpad.target="_self";
  456.                 document.errorpad.submit();
  457.          }
  458.          else
  459.          {
  460.                 document.errorpad.method = "GET";
  461.                 document.errorpad.action = "";
  462. }
  463.          }
  464.          return false;
  465. }
  466. function Query(myform)
  467. {
  469.     document.myform.action="errorpad.jsp?newQuery=true&page=1";
  471. document.myform.target="_self";
  472. document.myform.method = "POST";
  475.     document.myform.submit();
  477. }
  478. function set_Order_Sel(){
  479. var Order_Sel="";
  480. for (var i=0;i<document.errorpad.elements.length;i++)
  481.     {
  482. var e = document.errorpad.elements[i];
  483. if (e.name == 'id'){
  484.   for( var j=0;j<QOCount;j++){
  485. if(Quest_Order[j][1]==e.value){
  486. if(e.checked)
  487. Order_Sel=Order_Sel+Quest_Order[j][0]+":"+"1#";
  488. else
  489. Order_Sel=Order_Sel+Quest_Order[j][0]+":"+"0#";
  490.          break;
  491. }
  492. }
  493. }
  494. }
  496. document.errorpad.order_chk.value=Order_Sel;
  497. }
  498. function goToPage( topage)
  499. {
  500. set_Order_Sel();
  501. document.errorpad.action="errorpad.jsp";
  502. document.errorpad.target="_self";
  503. document.errorpad.method = "POST";
  504. document.errorpad.page.value = topage;
  505. document.errorpad.submit();
  506. return false;
  507. }
  508. function subform(stract)
  509. {
  510. switch (stract){
  511. case "Query":
  512.             Query();
  513. break;
  514. case "del":
  515.             del_check();
  516. break;
  518. case "addrate":
  519.             addrate_check();
  520. break;
  521. case "decrate":
  522. decrate_check();
  523. break;
  524.         case "test":
  525.             selectid();
  526.             break;
  527. case "print":
  528. printerror();
  529.             break;
  531. }
  533. }
  534. function selectid(){
  535. set_Order_Sel();
  536.     var winpoint=window.open('','err_test_type','height=240,width=470,top=0,left=0,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no,depended=yes,alwaysRaised =yes,z-look=yes');
  537.     var toppos=(window.screen.height-240)/2;
  538.     var leftpos=(window.screen.width-470)/2;
  539.     winpoint.moveTo(toppos,leftpos);
  540.     winpoint.focus();
  541.     document.errorpad.method="POST";
  542.     document.errorpad.action="err_test_type.jsp";
  543.     document.errorpad.target="err_test_type";
  544.     document.errorpad.submit();
  546. }
  547. function printerror(){
  549.     var winpoint=window.open('','err_print_type','height=240,width=520,top=0,left=0,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no,depended=yes,alwaysRaised =yes,z-look=yes');
  550.     var toppos=(window.screen.height-240)/2;
  551.     var leftpos=(window.screen.width-470)/2;
  552.     winpoint.moveTo(toppos,leftpos);
  553.     winpoint.focus();
  554.     document.errorpad.method="POST";
  555.     document.errorpad.action="err_print_type.jsp";
  556.     document.errorpad.target="err_print_type";
  557.     document.errorpad.submit();
  558. }
  559. function openDetail(var1){
  560.     var winpoint=window.open('err_query_detail.jsp?id='+var1,'newwindow','height=400,width=300,top=0,left=0,toolbar=no,menubar=no,scrollbars=yes, resizable=no,location=no, status=no,depended=yes,alwaysRaised =yes,z-look=yes');
  561.     winpoint.focus();
  562. }
  563. </script>
  567. <HTML>
  568. <HEAD>
  569. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  570. <TITLE>共创学堂-错题本</TITLE>
  571. <SCRIPT language=JavaScript>
  572. <!--
  574. function SymError()
  575. {
  576.   return true;
  577. }
  579. window.onerror = SymError;
  582. //-->
  583. </SCRIPT>
  586. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  587. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
  588. href="style/style.css" type=text/css rel=stylesheet>
  589. <STYLE>
  590. <!--
  591. a,a:link  { font-family: 'Tahoma', 'Verdana', 'Arial'; color: gray; text-decoration: none; }
  592. a:visited { font-family: 'Tahoma', 'Verdana', 'Arial'; color: gray; text-decoration: none; }
  593. a:active  { font-family: 'Tahoma', 'Verdana', 'Arial'; color: black; text-decoration: none; }
  594. a:hover   { font-family: 'Tahoma', 'Verdana', 'Arial'; color: black; text-decoration: none; }
  595. -->
  596. A:link  {font-family: 'Tahoma', 'Verdana', 'Arial'; color:blue; text-decoration: none; cursor: hand; }
  597. A:visited  {font-family: 'Tahoma', 'Verdana', 'Arial'; color: Navy; text-decoration: none}
  598. A:active  {font-family: 'Tahoma', 'Verdana', 'Arial'; color: mediumvioletred; text-decoration: none}
  599. A:hover {font-family: 'Tahoma', 'Verdana', 'Arial'; color: red;  text-decoration: none}
  601. body,td,select,input,div,form,textarea,center,option,pre,br {
  602.             font-family: 'Tahoma', 'Verdana', 'Arial'; font-size: 9pt; color: black; }
  604. body      { margin-top: 2px; margin-right: 2px; margin-bottom: 2px; margin-left: 2px;
  605.             scrollbar-face-color: white;
  606.             scrollbar-shadow-color: gainsboro;
  607.             scrollbar-darkshadow-color: whitesmoke;
  608.             scrollbar-highlight-color: gainsboro;
  609.             scrollbar-3dlight-color: whitesmoke;
  610.             scrollbar-track-color: white;
  611.             scrollbar-arrow-color: gainsboro;
  612.             overflow: auto; }
  613. th {
  614. font-family: 'Tahoma', 'Verdana', 'Arial'; font-size: 10pt; color: black; }
  615. .button   { font-family: 'Tahoma', 'Verdana', 'Arial'; background-color: white; height: 20px;
  616.                 border-width: 1px; border-style: solid; border-color: black; }
  617. .input    { font-family: 'Tahoma', 'Verdana', 'Arial'; background-color: white; height: 20px;
  618.                 border-width: 1px; border-style: solid; border-color: black; }
  619. .td_sr {
  620.   background: #ffffff;
  621. }
  622. .tb_sr { background: #eeeeee; }
  623. .th_sr { background: #eeeeee; }
  624. </STYLE>
  625. <SCRIPT src=""></SCRIPT>
  627. <SCRIPT src=""></SCRIPT>
  629. <SCRIPT src=""></SCRIPT>
  631. <SCRIPT src=""></SCRIPT>
  633. <SCRIPT src=""></SCRIPT>
  635. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  636. <link rel="stylesheet" type="text/css" href="../css.css">
  637. </HEAD>
  638. <BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
  640. <CENTER>
  642. <TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
  643.   <TBODY>
  644.   <TR>
  645.           <TD><IMG height=27 src="images/test_pop_01.gif" width=102></TD>
  646.           <TD align=right><IMG height=27 src="images/test_pop_02.gif"
  647.       width=134></TD>
  648.         </TR></TBODY></TABLE>
  649.   <strong><font color="#3366FF" size="+2" face="黑体">共创学堂错题本</font></strong>
  650.   <!--begin test -->
  651.   <FORM action=errorpad.jsp method=post name=myform target="_self" id="myform">
  652.   <script language="JavaScript">
  653. document.onload = InitMyform();
  654. function InitMyform(){
  655.      document.myform.Subject.value='<%=errorpad_sub%>';
  656.      changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value);
  657.      document.myform.KnowPoint.value='<%=errorpad_knowpoint%>';
  658.      document.myform.testtype.value='<%=errorpad_testtype%>';
  659.      document.myform.errorcount.value='<%=errorpad_errorcount%>';
  661. }
  663. </script>
  664.     <TABLE width=100% height="145" border=0 cellPadding=0 cellSpacing=0>
  665.       <TBODY>
  666.         <TR>
  667.           <TD height="75"  align=middle valign="bottom"> <table width="80%" height="56" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  668.               <tr>
  669.                 <td width="78" height="52" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
  670.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  671.                     <tr>
  672.                       <td nowrap>科&nbsp;目:</td>
  673.                     </tr>
  674.                     <tr>
  675.                       <td> <select name=Subject
  676. size="1" id=select8 onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)">
  677.                           <option value="all" selected>全 部</option>
  678.                           <%Tools.showGradeSubjectOption(con,gradenote,out);%>
  680.                         </select></td>
  681.                     </tr>
  682.                   </table>
  683.                   <strong> </strong> </td>
  684.                 <td width="144" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  685.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  686.                     <tr>
  687.                       <td nowrap>知识点:</td>
  688.                     </tr>
  689.                     <tr>
  690.                       <td> <select name=KnowPoint id="select31">
  691.                           <option value="all" selected>----全 部----</option>
  692.                         </select> </td>
  693.                     </tr>
  694.                   </table></td>
  695.                 <td width="127" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
  696.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  697.                     <tr>
  698.                       <td nowrap>考试类型：</td>
  699.                     </tr>
  700.                     <tr>
  701.                       <td><select name="testtype" id="select8">
  702.                           <option value="all" selected>全部</option>
  703.                           <option value="1">自由考试</option>
  704.                           <option value="2">单元测试</option>
  705.                           <option value="3">模拟测试 </option>
  706.                         </select></td>
  707.                     </tr>
  708.                   </table></td>
  709.                 <td width="85" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  710.                   <table width="94%" border="0" cellspacing="0" cellpadding="0">
  711.                     <tr>
  712.                       <td nowrap>错误级别&gt;=</td>
  713.                     </tr>
  714.                     <tr>
  715.                       <td><select name="errorcount" size="1" id="select16">
  716.                           <option value="0" selected>0</option>
  717.                           <option value="1">1</option>
  718.                           <option value="2">2</option>
  719.                           <option value="3">3</option>
  720.                           <option value="4">4</option>
  721.                           <option value="5">5</option>
  722.                           <option value="6">6</option>
  723.                           <option value="7">7</option>
  724.                           <option value="8">8</option>
  725.                           <option value="9">9</option>
  726.                           <option value="10">10</option>
  727.                         </select></td>
  728.                     </tr>
  729.                   </table></td>
  730.                 <td width="85" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  731.                   <p align="left">
  732.                     <input name="errQuery" type="button"  class="s03" id="errQuery" onClick=subform("Query") value="查询">
  734.                 </td>
  735.               </tr>
  736.             </table></TD>
  737.         </TR>
  738.         <TR>
  739.           <TD  align=middle valign="top">
  740.             <table width="80%" height="44" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  741.               <tr>
  742.                 <td height="40" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
  743.                   <p align="center">
  744.                     <input name="errDel" type="button" class="s03" id="errDel" value="删 除" border="0"
  745. onClick=subform("del")>
  746.                     <b><font color="#FFFFFF"> </font></b></td>
  747.                 <td width="156" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
  748.                   <p align="center"><b>
  750. <input name="errAscRate" type="button" class="s03" id="errAscRate2" value="增加级别" border="0" onClick=subform("addrate")>
  751.                     </b> </td>
  752.                 <td width="175" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  753.                   <p align="center"><b>
  754.                     <input name="errDescRate" type="button" class="s03" id="errDescRate" value="降低级别" border="0" onClick=subform("decrate")>
  755.                     </b><b> </b></td>
  756.                 <td width="159" background="images/admin_bg_1.gif" bgcolor="#FFFDE8"><div align="center"><b>
  757.                     <input name="errTest" type="button" class="s03" id="errTest2" value="测 验" border="0" onClick=subform("test")>
  758.                     </b> </div></td>
  759.                 <td width="164" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  760.                   <p align="center"><b>
  761.                     <input name="errPrint" type="button"  class="s03" id="errPrint" value="打 印" onClick=subform("print")>
  762.                     </b></td>
  763.               </tr>
  764.             </table>
  765.             </TD>
  766.         </TR>
  767.       </TBODY>
  768.     </TABLE>
  769. </FORM>
  770.   <FORM method="post" name="errorpad" id="errorpad">
  771.     <TABLE cellSpacing=1 cellPadding=0 width=80% bgColor=#eeeeee border=0>
  772.       <TBODY>
  773.         <TR>
  774.           <TD class=td_sr align=middle width=28 height=20><INPUT title=选择全部记录或取消
  775.       onclick=CheckAllt(); type=checkbox value="Check All" name=allboxt></TD>
  776.           <TD class=td_sr align=right height=20>&nbsp; <A
  777.       href="errorpad.jsp"  onClick="return goToPage(1)">首页</A> <% if(OnPage!=1) {%>
  778.   <A      href="errorpad.jsp"    onClick="return goToPage(<%=OnPage-1%>)">前页</A>
  779.             <% }else {%>
  780.             前页
  781.             <%}%>
  782.             [第<%=OnPage%>页] &nbsp; <%if(OnPage!=TotalPage) {%>
  783. <A      href="errorpad.jsp" onClick="return goToPage(<%=OnPage+1%>)">后页</A>
  784.             <%} else {%>
  785.             后页
  786.             <%}%> <A      href="errorpad.jsp" onClick="return goToPage(<%=TotalPage%>)">尾页</A>
  787.             　跳转到第
  788.             <SELECT      onChange='return goToPage(this.value)'
  789.       size=1 name=topage>
  790.               <%for(int pageI=1;pageI<OnPage;pageI++)
  791. out.println("<OPTION value="+pageI+">"+pageI+"</OPTION>");
  793. %>
  794.               <OPTION value=<%=OnPage%>
  795.         selected><%=OnPage%></OPTION>
  796.               <%for(int pageI=OnPage+1;pageI<=TotalPage;pageI++)
  797. out.println("<OPTION value="+pageI+">"+pageI+"</OPTION>");
  799. %>
  800.             </SELECT>
  801.             页，共 <%=TotalPage%> 页 </TD>
  802.         </TR>
  803.       </TBODY>
  804.     </TABLE>
  805.     <%
  806. rs.absolute((OnPage-1)*EveryPage+1);//指定指针的位置；
  807.     pageNumber=0;
  808.       testNumber=(OnPage-1)*EveryPage+1;
  809.       //while(rs.next()){
  811.   while( pageNumber<EveryPage ) {
  813.    pageNumber++;
  815.   %>
  817.     <TABLE width=80% border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
  818.       <TBODY>
  819.       <TR>
  820.           <td width="650" height=22 bgColor=#E3E3E3 class=l>
  821.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  822.               <tr>
  823.                 <td width="61" height="20" nowrap>
  824. <input name="id" type="checkbox" value="<%=rs.getInt("id")%>"
  825. <%
  826. if(arrSelect[testNumber-1].equals("1"))
  827. out.print(" checked");
  828. %>
  829. >
  830.                   <%=testNumber%>.
  831.                   </td>
  832.                 <td width="51" nowrap><div align="right">年级：</div></td>
  833.                 <td width="60" nowrap><%=rs.getString("gradename")%></td>
  834.                 <td width="114" nowrap> <div align="left">科目：<%=rs.getString("subname")%></div></td>
  835.                 <td width="123" nowrap> <div align="left">错误级别： <%=rs.getInt("errorcount")%></div></td>
  836.                 <td width="74" nowrap><div align="right">添加时间：</div></td>
  837.                 <td width="130" nowrap><%=rs.getString("add_date")%></td>
  838.                 <td width="128" nowrap>来源：<%=rs.getString("sourcename")%></td>
  839.                 <td width="9" nowrap>&nbsp; </td>
  840.                 <td width="33" nowrap> <div align="right">
  841. <img src="images/1026.gif" width="27" height="24" onClick="openDetail(<%=rs.getInt("question_id")%>)"></div></td>
  842.               </tr>
  843.             </table></td>
  844.       </TR>
  845.     </TBODY>
  846.   </TABLE>
  847.   <TABLE cellSpacing=1 width=591 align=center>
  848.     <TBODY>
  849.       <TR>
  850.           <TD width="585" align=left>
  851.             <%if(debug) out.print("ID="+rs.getString("ID"));%> <%=jinghua.TransformString.DeleteBR(rs.getString("QuestText"))%></TD>
  852.       </TR>
  853.     </TBODY>
  854.   </TABLE>
  855.     <%
  856. testNumber++;
  857. if(!rs.next())
  858. break;
  859. }
  860. %>
  862.     <TABLE cellSpacing=1 cellPadding=0 width=80% bgColor=#eeeeee border=0>
  863.       <TBODY>
  864.         <TR>
  865.           <TD class=td_sr align=middle width=28 height=20><INPUT title=选择全部记录或取消
  866.       onclick=CheckAlle(); type=checkbox value="Check All" name=allboxe></TD>
  867.           <TD class=td_sr align=right height=20>&nbsp; <A
  868.       href="errorpad.jsp"  onClick="return goToPage(1)">首页</A> <% if(OnPage!=1) {%> <A      href="errorpad.jsp"    onClick="return goToPage(<%=OnPage-1%>)">前页</A>
  869.             <% }else {%>
  870.             前页
  871.             <%}%>
  872.             [第<%=OnPage%>页] &nbsp;
  873.             <%if(OnPage!=TotalPage) {%> <A      href="errorpad.jsp" onClick="return goToPage(<%=OnPage+1%>)">后页</A>
  874.             <%} else {%>
  875.             后页
  876.             <%}%> <A      href="errorpad.jsp" onClick="return goToPage(<%=TotalPage%>)">尾页</A>
  877.             　跳转到第
  878.             <SELECT      onChange='return goToPage(this.value)'
  879.       size=1 name=select2>
  880.               <%for(int pageI=1;pageI<OnPage;pageI++)
  881. out.println("<OPTION value="+pageI+">"+pageI+"</OPTION>");
  883. %>
  884.               <OPTION value=<%=OnPage%>
  885.         selected><%=OnPage%></OPTION>
  886.               <%for(int pageI=OnPage+1;pageI<=TotalPage;pageI++)
  887. out.println("<OPTION value="+pageI+">"+pageI+"</OPTION>");
  889. %>
  890.             </SELECT>
  891.             页，共 <%=TotalPage%> 页 </TD>
  892.         </TR>
  893.       </TBODY>
  894.     </TABLE>
  895.     <input name="stu_id" type="hidden" id="studentid2" value="<%=studentID %>">
  896.     <input name="selectcount" type="hidden" id="studentid2" value="">
  897.     <SCRIPT language=JavaScript>
  898. <!--
  899. function CheckAllt()
  900.   {
  901.    document.errorpad.allboxe.checked=document.errorpad.allboxt.checked;
  902.     for (var i=0;i<document.errorpad.elements.length;i++)
  903.     {
  904.       var e = document.errorpad.elements[i];
  905.       if (e.name == 'id')
  906.         e.checked = document.errorpad.allboxt.checked;
  907.     }
  908.   }
  909. function CheckAlle()
  910.   {
  911.    document.errorpad.allboxt.checked=document.errorpad.allboxe.checked;
  912.     for (var i=0;i<document.errorpad.elements.length;i++)
  913.     {
  914.       var e = document.errorpad.elements[i];
  915.       if (e.name == 'id')
  916.         e.checked = document.errorpad.allboxe.checked;
  917.     }
  918.   }
  919. //-->
  920. </SCRIPT>
  921.     <input name="OnPage" type="hidden" id="OnPage" value="<%=OnPage%>">
  922.     <input name="page" type="hidden" id="page">
  923.     <input name="order_chk" type="hidden" id="order_chk" value="temp">
  924.   </FORM>
  925. <p>&nbsp;</p>
  926.  <!--end test --><!--begin bottom -->
  927. <TABLE
  928. style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
  929. cellSpacing=0 cellPadding=0 width="100%" border=0>
  930.   <TBODY>
  931.   <TR>
  932.     <TD align=middle colSpan=2 height=30>
  933.       <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
  934.         <TBODY>
  935.         <TR>
  936.           <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
  937.             target=_blank>关于我们</A> | <A
  938.             href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
  939.             target=_blank>联系方式</A> | 网站地图 | <A
  940.             href="http://jsptestonline.cosoft.org.cn/about/service.html"
  941.             target=_blank>服务条款</A> | <A
  942.             href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
  943.             target=_blank>隐私权保护</A> | <A
  944.             href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
  945.             target=_blank>版权声明</A></TD>
  946.           <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
  947.             target=_blank>共创教育机构</A></TD></TR></TBODY>
  948. </TABLE></TD></TR></TBODY>
  949. </TABLE><!--end bottom --></CENTER>
  950. </BODY>
  951. </HTML>
  953. <%}
  954. catch(Exception e){
  955.     out.print(e.toString());
  956. }
  957. finally{
  958.     DBCon.dropConnection();
  959. }
  960. %>