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

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

教育系统应用

开发平台：

WORD

modify_test.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
  3. <%@ page import="java.sql.*"%>
  4. <%@ page import="jinghua.*"%>
  5. <%@ page import="java.util.*"%>
  6. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  7. </jsp:useBean>
  8. <%!boolean debug=false;
  9. Connection con;
  10. class Test{
  11.     String id;
  12.     String name;
  13.     String grade;
  14.     String time;
  15.     String totalMark;
  16.     String testclass;
  17.     String status;
  18.     public String toString(){
  19.         String temp="";
  20.         temp="<br> id="+id+"<br> name="+name;
  21.         return temp;
  22.    }
  23. };
  27. Statement stmt=null;
  28. ResultSet rs=null;
  29. String sql="";
  30. String sqlCon=null;
  31. int testNumber=0;
  32. int EveryPage=5;//每页显示的记录数；
  33. int OnPage=1; //当前显示的页数；
  34. int Total=0;//记录的总数；
  35. int TotalPage=0;//记录的总页数；
  36. %>
  37. <%
  38. ArrayList testSet=new ArrayList();
  40. try{
  41.     con=DBCon.getConnection();
  45. %>
  49. <%
  50. //构造查询条件
  51. //String query_grade=(String)session.getAttribute("query_grade");
  52. //String query_sub=(String)session.getAttribute("query_sub");
  53. //String query_knowpoint=(String)session.getAttribute("query_knowpoint");
  54. //String query_testtype=(String)session.getAttribute("query_testtype");
  55. //String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  56. sqlCon="";
  57. String query_grade=request.getParameter("Grade");
  58. String query_sub=request.getParameter("Subject");
  59. String query_knowpoint=request.getParameter("KnowPoint");
  60. String query_testtype=request.getParameter("testtype");
  64. if(query_grade!=null)
  65. {
  66.     session.setAttribute("query_grade",query_grade);
  67. }
  68. else
  69. {
  70.     query_grade=(String)session.getAttribute("query_grade");
  71. }
  72. if(query_sub!=null)
  73. {
  74.     session.setAttribute("query_sub",query_sub);
  75. }else
  76. {
  77.     query_sub=(String)session.getAttribute("query_sub");
  78. }
  79. if(query_knowpoint!=null)
  80. {
  81.     session.setAttribute("query_knowpoint",query_knowpoint);
  82. }
  83. else
  84. {
  85.     query_knowpoint=(String)session.getAttribute("query_knowpoint");
  86. }
  87. if(query_testtype!=null)
  88. {
  89.     session.setAttribute("query_testtype",query_testtype);
  90. }
  91. else
  92. {
  93.     query_testtype=(String)session.getAttribute("query_testtype");
  94. }
  96. if(query_grade==null)
  97.     query_grade="all";
  98. if(query_sub==null)
  99.     query_sub="all";
  100. if(query_knowpoint==null)
  101.     query_knowpoint="all";
  102. if(query_testtype==null)
  103.     query_testtype="2";
  105. if(debug){
  106.     out.print("<br>grade="+query_grade+
  107.     "<br>sub="+query_sub+
  108.     "<br>knowpoint="+query_knowpoint+
  109.     "<br>testtype="+query_testtype
  110.     );
  111. }
  112. sqlCon="";
  113. int itesttype=Integer.parseInt(query_testtype);
  114. switch (itesttype){
  115. case 1://自由测试
  116. //test.status=3:模拟考试，4：自由测试, 2:单元测试
  117. sqlCon=" (test.status<>3 AND test.status<>2)";
  118.         if(query_grade!=null){
  119.             if(!query_grade.equals("all")){
  120.                 if(query_grade.equals("c")){
  121.                     if(sqlCon.equals(""))
  122.                         sqlCon=" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  123.                     else
  124.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  125.                 }else if(query_grade.equals("g")){
  126.                     if(sqlCon.equals(""))
  127.                         sqlCon=" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='g3w')";
  128.                     else
  129.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='g3w')";
  130.                 }
  131.                 else if(sqlCon.equals(""))
  132.                         sqlCon=" (test.gradenote='"+query_grade+"')";
  133.                     else
  134.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='"+query_grade+"')";
  135.             }
  136.         }
  137.         if(debug)   out.println("<br>grade sql="+sqlCon);
  139.         if(query_sub!=null){
  140.         if(!query_sub.equals("all")){
  141.             if (!sqlCon.equals(""))
  142.                 sqlCon=sqlCon +" AND (test.subid="+query_sub+")";
  143.             else
  144.                 sqlCon=" (test.subid="+query_sub+")";
  145.             }
  146.         }
  147.         if(debug)    out.println("<br>subject 4"+sqlCon);
  149.         if(query_knowpoint!=null){
  150.             if(!query_knowpoint.equals("all")){
  151.                 if(!sqlCon.equals(""))
  152.                     sqlCon=sqlCon+" AND(test.knowpointid1="+query_knowpoint +
  153.                         " OR test.knowpointid2="+query_knowpoint+
  154.                         " OR test.knowpointid3="+query_knowpoint+")";
  155.                 else
  156.                     sqlCon=" (test.knowpointid1="+query_knowpoint +
  157.                         " OR test.knowpointid2="+query_knowpoint+
  158.                         " OR test.knowpointid3="+query_knowpoint+")";
  159.             }
  160.         }
  161.         if(debug)    out.println("<br>knowpoint sql="+sqlCon);
  162.         sql="SELECT   `test`.`id`, `test`.`status`, `grade`.`Name` AS `gradename`,"+
  163.             "  `test`.`title` AS `testname`,  `test`.`mark`,  `test`.`date` AS `testdate`"+
  164.             "  FROM  `test`  LEFT OUTER JOIN `grade` ON (`test`.`gradenote` = `grade`.`note`)";
  166.         if(!sqlCon.equals("")) sql=sql+" WHERE "+sqlCon;
  167.         sql=sql+" ORDER BY  `test`.`gradenote`,`test`.`subid`,`test`.`id`";
  169.         if(debug) out.println("<br>test sql="+sql);
  170.         stmt=con.createStatement();
  171.         rs=stmt.executeQuery(sql);
  172.         while(rs.next()){
  173.             Test t=new Test();
  174.             if(rs.getInt("status")==4)
  175.                 t.status="已发布";
  176.             else
  177.                 t.status="己注销";
  178.             t.id=rs.getString("id");
  179.             //<a href="Query_test_mn.jsp" target="_self">test</a>
  180.             t.name="<a href="+"modify_test_free.jsp?testID="+t.id+" target="_self">"+
  181.                         rs.getString("testname")+"</a>";
  182.             t.grade=rs.getString("gradename");
  183.             t.totalMark=rs.getString("mark");
  184.             t.testclass="单元测试";
  185.             t.time=rs.getString("testdate");
  186.             testSet.add(t);
  187.         }
  188.         rs.close();
  189.         stmt.close();
  191.         break;
  192.     case 2://单元测试
  193. //test.status=3:模拟考试，4：自由测试
  194. sqlCon=" (test.status<>3 AND test.status<>4)";
  195.         if(query_grade!=null){
  196.             if(!query_grade.equals("all")){
  197.                 if(query_grade.equals("c")){
  198.                     if(sqlCon.equals(""))
  199.                         sqlCon=" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  200.                     else
  201.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  202.                 }else if(query_grade.equals("g")){
  203.                     if(sqlCon.equals(""))
  204.                         sqlCon=" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='g3w')";
  205.                     else
  206.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='g3w')";
  207.                 }
  208.                 else if(sqlCon.equals(""))
  209.                         sqlCon=" (test.gradenote='"+query_grade+"')";
  210.                     else
  211.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='"+query_grade+"')";
  212.             }
  213.         }
  214.         if(debug)   out.println("<br>grade sql="+sqlCon);
  216.         if(query_sub!=null){
  217.         if(!query_sub.equals("all")){
  218.             if (!sqlCon.equals(""))
  219.                 sqlCon=sqlCon +" AND (test.subid="+query_sub+")";
  220.             else
  221.                 sqlCon=" (test.subid="+query_sub+")";
  222.             }
  223.         }
  224.         if(debug)    out.println("<br>subject 4"+sqlCon);
  226.         if(query_knowpoint!=null){
  227.             if(!query_knowpoint.equals("all")){
  228.                 if(!sqlCon.equals(""))
  229.                     sqlCon=sqlCon+" AND(test.knowpointid1="+query_knowpoint +
  230.                         " OR test.knowpointid2="+query_knowpoint+
  231.                         " OR test.knowpointid3="+query_knowpoint+")";
  232.                 else
  233.                     sqlCon=" (test.knowpointid1="+query_knowpoint +
  234.                         " OR test.knowpointid2="+query_knowpoint+
  235.                         " OR test.knowpointid3="+query_knowpoint+")";
  236.             }
  237.         }
  238.         if(debug)    out.println("<br>knowpoint sql="+sqlCon);
  239.         sql="SELECT   `test`.`id`, `test`.`status`, `grade`.`Name` AS `gradename`,"+
  240.             "  `test`.`title` AS `testname`,  `test`.`mark`,  `test`.`date` AS `testdate`"+
  241.             "  FROM  `test`  LEFT OUTER JOIN `grade` ON (`test`.`gradenote` = `grade`.`note`)";
  243.         if(!sqlCon.equals("")) sql=sql+" WHERE "+sqlCon;
  244.         sql=sql+" ORDER BY  `test`.`gradenote`,`test`.`subid`,`test`.`id`";
  246.         if(debug) out.println("<br>test sql="+sql);
  247.         stmt=con.createStatement();
  248.         rs=stmt.executeQuery(sql);
  249.         while(rs.next()){
  250.             Test t=new Test();
  251.             if(rs.getInt("status")==2)
  252.                 t.status="已发布";
  253.             else
  254.                 t.status="己注销";
  255.             t.id=rs.getString("id");
  256.             //<a href="Query_test_mn.jsp" target="_self">test</a>
  257.             t.name="<a href="+"modify_test_unit.jsp?testID="+t.id+" target="_self">"+
  258.                         rs.getString("testname")+"</a>";
  259.             t.grade=rs.getString("gradename");
  260.             t.totalMark=rs.getString("mark");
  261.             t.testclass="单元测试";
  262.             t.time=rs.getString("testdate");
  263.             testSet.add(t);
  264.         }
  265.         rs.close();
  266.         stmt.close();
  268.         break;
  269.     case 3://模拟测试
  271.         if(query_grade!=null){
  272.             if(!query_grade.equals("all")){
  273.                 if(query_grade.equals("c")){
  274.                     if(sqlCon.equals(""))
  275.                         sqlCon=" (mn_test.grade_note='c1' OR mn_test.grade_note='c2' OR mn_test.grade_note='c3')";
  276.                     else
  277.                         sqlCon=sqlCon+" AND "+" (mn_test.grade_note='c1' OR mn_test.grade_note='c2' OR mn_test.grade_note='c3')";
  278.                 }else if(query_grade.equals("g")){
  279.                     if(sqlCon.equals(""))
  280.                         sqlCon=" (mn_test.grade_note='g1' OR mn_test.grade_note='g2' OR mn_test.grade_note='g3l' OR mn_test.grade_note='g3w')";
  281.                     else
  282.                         sqlCon=sqlCon+" AND "+" (mn_test.grade_note='g1' OR mn_test.grade_note='g2' OR mn_test.grade_note='g3l' OR mn_test.grade_note='g3w')";
  283.                 }
  284.             else  if(sqlCon.equals(""))
  285.                     sqlCon=" (mn_test.grade_note='"+query_grade+"')";
  286.                 else
  287.                     sqlCon=sqlCon+" AND "+" (mn_test.grade_note='"+query_grade+"')";
  288.             }
  289.         }
  290.         if(debug)   out.println("<br>grade sql="+sqlCon);
  292.         sql="SELECT   `mn_test`.`id`,`mn_test`.`status`,  `mn_test`.`name` AS `testname`,"+
  293.             "  `grade`.`Name` AS `gradename`,  `mn_test`.`mntotalmark`,"+
  294.             "  CONCAT(`mn_test`.`begin_date`,"至",  `mn_test`.`end_date`) as testtime FROM  `mn_test`"+
  295.             "  LEFT OUTER JOIN `grade` ON (`mn_test`.`grade_note` = `grade`.`note`)";
  296.         if(!sqlCon.equals("")) sql=sql+" WHERE "+sqlCon;
  297.         sql=sql+" ORDER BY  `mn_test`.`grade_note`,`mn_test`.`begin_date`";
  298.         stmt=con.createStatement();
  299.         rs=stmt.executeQuery(sql);
  300. if(debug) out.print("<br>mn_test sql="+sql);
  301.         while(rs.next()){
  302.             Test t=new Test();
  303.             if(rs.getInt("status")==2)
  304.                 t.status="已发布";
  305.             else
  306.                 t.status="己注销";
  307.             t.id=rs.getString("id");
  308.             //<a href="Query_test_mn.jsp" target="_self">test</a>
  309.             t.name="<a href="+"modify_test_mn.jsp?mnID="+t.id+" target="_self">"+
  310.                         rs.getString("testname")+"</a>";
  311.             t.grade=rs.getString("gradename");
  312.             t.totalMark=rs.getString("mntotalmark");
  313.             t.testclass="模拟考试";
  314.             t.time=rs.getString("testtime");
  315.             testSet.add(t);
  316.         }
  317.         rs.close();
  318.         stmt.close();
  319.         break;
  320.     default:
  321. }
  329. if(debug)
  330.     out.println("<br>at last sql="+sql);
  332. //rs.last();//移到最后一条记录;
  333. //Total=rs.getRow();//记录的总数；
  335. //TotalPage=(Total%EveryPage==0)?(Total/EveryPage):(Total/EveryPage+1);
  338. %>
  340. <!--年级，科目，知识点三个下拉列表框联动-->
  341. <%
  342. out.print(Tools.sub_know(con));
  343. out.print(Tools.grade_sub(con));
  344. %>
  345. <script language="JavaScript">
  346. function changegs(locationid){
  347. document.myform.Subject.length =1;
  348.         document.myform.KnowPoint.length =1;
  349.         var locationid=locationid;
  350.         var i;
  351.         for (i=0;i < gscount; i++){
  352.             if (grade_sub[i][0] == locationid) {
  353.             document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
  354.             }
  355. }
  356. }
  358. function changesk(locationid){
  359. document.myform.KnowPoint.length =1;
  360. var locationid=locationid;
  361. var i;
  362. for (i=0;i < gskcount; i++){
  363. if (grade_sub_know[i][1] == locationid){
  364. document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
  365. }
  366. }
  367. }
  370. function delit(myform)
  371. {
  372.   if (confirm("将删除所有选择的知识点数据？"))
  373.   {
  374.     myform.action="errorpaddel.jsp";
  375.     myfrom.target="_self";
  376.     myform.submit();
  377.   }
  378. }
  379. function del_check()
  380. {
  381. var count = myform.elements.length;
  382. var noSelect = true;
  383.   for(var i=0;i<count;i++)
  384.   {
  385.      if(myform.elements[i].checked)
  386.      {
  387.              noSelect = false;
  388.       break;
  389. }
  390.    }
  391. if(noSelect == true)
  392. {
  393.     alert("您还没有选择要删除的试卷!");
  394.     return(false);
  395.  }
  396.    else
  397.    {
  398.          if(confirm("将删除所有选择的试卷吗？"))
  399.          {
  400.                 document.myform.method = "POST";
  401.                 document.myform.action = "test_del.jsp";
  402.                 document.myform.target="_self";
  403.                 document.myform.submit();
  404.          }
  405.          else
  406.          {
  407.                 document.myform.method = "GET";
  408.                 document.myform.action = "";
  409. }
  410.      }
  411.      return false;
  412. }
  413. function active_check()
  414. {
  415. var count = myform.elements.length;
  416. var noSelect = true;
  417.   for(var i=0;i<count;i++)
  418.   {
  419.      if(myform.elements[i].checked)
  420.      {
  421.              noSelect = false;
  422.       break;
  423. }
  424.    }
  425. if(noSelect == true)
  426. {
  427.     alert("您还没有选择要激活的试卷!");
  428.     return(false);
  429.  }
  430.    else
  431.    {
  432.          if(confirm("激活所有选择的试卷吗？"))
  433.          {
  434.                 document.myform.method = "POST";
  435.                 document.myform.action = "test_activde.jsp";
  436.                 document.myform.target="_self";
  437.                 document.myform.submit();
  438.          }
  439.          else
  440.          {
  441.                 document.myform.method = "GET";
  442.                 document.myform.action = "";
  443. }
  444.          }
  445.          return false;
  446. }
  447. function deactive_check()
  448. {
  449. var count = myform.elements.length;
  450. var noSelect = true;
  451.   for(var i=0;i<count;i++)
  452.   {
  453.      if(myform.elements[i].checked)
  454.      {
  455.              noSelect = false;
  456.       break;
  457. }
  458.    }
  459. if(noSelect == true)
  460. {
  461.     alert("您还没有选择要注销的试卷!");
  462.     return(false);
  463.  }
  464.    else
  465.    {
  466.          if(confirm("注销所有选择的试卷吗？"))
  467.          {
  468.                 document.myform.method = "POST";
  469.                 document.myform.action = "test_deactivde.jsp";
  470.                 document.myform.target="_self";
  471.                 document.myform.submit();
  472.          }
  473.          else
  474.          {
  475.                 document.myform.method = "GET";
  476.                 document.myform.action = "";
  477. }
  478.          }
  479.          return false;
  480. }
  481. function subform(stract)
  482. {
  483. switch (stract){
  484. case "del":
  485.             del_check();
  486. break;
  487. case "active":
  488.             active_check();
  489. break;
  490. case "deactive":
  491. deactive_check();
  492. break;
  494. }
  495. }
  497. function selectid(){
  498.     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');
  499.     var toppos=(window.screen.height-240)/2;
  500.     var leftpos=(window.screen.width-470)/2;
  501.     winpoint.moveTo(toppos,leftpos);
  502.     winpoint.focus();
  503.     document.errorpad.method="POST";
  504.     document.errorpad.action="err_test_type.jsp";
  505.     document.errorpad.target="err_test_type";
  506.     document.errorpad.submit();
  508. }
  509. function printerror(){
  511.     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');
  512.     var toppos=(window.screen.height-240)/2;
  513.     var leftpos=(window.screen.width-470)/2;
  514.     winpoint.moveTo(toppos,leftpos);
  515.     winpoint.focus();
  516.     document.errorpad.method="POST";
  517.     document.errorpad.action="err_print_type.jsp";
  518.     document.errorpad.target="err_print_type";
  519.     document.errorpad.submit();
  520. }
  521. function openDetail(var1){
  522.     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');
  523.     winpoint.focus();
  524. }
  525. function InitMyform(){
  526.     document.myform.Grade.value='<%=query_grade%>';
  527.     changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value);
  528.     document.myform.Subject.value='<%=query_sub%>';
  529.     changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value);
  530.     document.myform.KnowPoint.value='<%=query_knowpoint%>';
  531.     document.myform.testtype.value='<%=query_testtype%>';
  534. }
  536. </script>
  537. <HTML>
  538. <HEAD>
  539. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  540. <TITLE>共创学堂-考试查询</TITLE>
  541. <SCRIPT language=JavaScript>
  542. <!--
  544. function SymError()
  545. {
  546.   return true;
  547. }
  549. window.onerror = SymError;
  552. //-->
  553. </SCRIPT>
  556. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  557. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
  558. href="../errorpad/style/style.css" type=text/css rel=stylesheet>
  559. <SCRIPT src=""></SCRIPT>
  561. <SCRIPT src=""></SCRIPT>
  563. <SCRIPT src=""></SCRIPT>
  565. <SCRIPT src=""></SCRIPT>
  567. <SCRIPT src=""></SCRIPT>
  569. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  570. <link rel="stylesheet" type="text/css" href="../css.css">
  571. </HEAD>
  572. <BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
  574. <CENTER>
  576. <TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
  577.   <TBODY>
  578.   <TR>
  579.           <TD><IMG height=27 src="../errorpad/images/test_pop_01.gif" width=102></TD>
  580.           <TD align=right><IMG height=27 src="../errorpad/images/test_pop_02.gif"
  581.       width=134></TD>
  582.         </TR></TBODY></TABLE>
  583.   <strong><font color="#3366FF" size="+2" face="黑体">共创学堂试卷查询</font></strong>
  584.   <!--begin test -->
  585.   <FORM action=modify_test.jsp method=post name=myform target="_self" id="myform">
  586.     <TABLE width=100% height="60" border=0 cellPadding=0 cellSpacing=0>
  587.       <TBODY>
  588.         <TR>
  589.           <TD height="75"  align=middle valign="bottom">
  590.             <table width="600" height="56" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  591.               <tr>
  592.                 <td width="100" height="52" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  593.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  594.                     <tr>
  595.                       <td>年&nbsp;级:</td>
  596.                     </tr>
  597.                     <tr>
  598.                       <td height="24" nowrap> <select id=select30 name=Grade onclick="changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value)" size="1">
  599.                           <option value="all" selected>-全 部-</option>
  600.                           <%Tools.showGradeOption(con,out);%>
  601.                         </select> </td>
  602.                     </tr>
  603.                   </table>
  604.                   &nbsp; </td>
  605.                 <td width="88" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  606.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  607.                     <tr>
  608.                       <td nowrap>科&nbsp;目:</td>
  609.                     </tr>
  610.                     <tr>
  611.                       <td nowrap> <select id=select29 name=Subject onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)"
  612. size="1">
  613.                           <option value="all" selected>全 部</option>
  614.                         </select> </td>
  615.                     </tr>
  616.                   </table>
  617.                   <strong> </strong> </td>
  618.                 <td width="187" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  619.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  620.                     <tr>
  621.                       <td nowrap>知识点:</td>
  622.                     </tr>
  623.                     <tr>
  624.                       <td nowrap> <select name=KnowPoint id="select31">
  625.                           <option value="all" selected>----全 部----</option>
  626.                         </select> </td>
  627.                     </tr>
  628.                   </table></td>
  629.                 <td width="104" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  630.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  631.                     <tr>
  632.                       <td nowrap>考试类型：</td>
  633.                     </tr>
  634.                     <tr>
  635.                       <td nowrap> <select name="testtype" id="select8">
  636.                           <option value="1">自由测试</option>
  637.                           <option value="2" selected>单元测试</option>
  638.                           <option value="3">模拟测试 </option>
  639.                         </select> </td>
  640.                     </tr>
  641.                   </table></td>
  642.               </tr>
  643.             </table>
  644.             </TD>
  645.         </TR>
  646. <tr>
  647.           <td valign="top">
  648.             <table width="600" height="44" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  649.               <tr>
  650.                 <td width="150" height="40" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  651.                   <p align="center">
  652.                     <input name="errDel" type="button" class="s03" id="errDel" value="删 除" border="0" onClick=subform("del")>
  653.                     <b><font color="#FFFFFF"> </font></b></td>
  654.                 <td width="150" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  655.                   <p align="center"><b>
  656.                     <input name="errAscRate" type="button" class="s03" id="errAscRate2" value="激 活" border="0" onClick=subform("active")>
  657.                     </b> </td>
  658.                 <td width="150" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  659.                   <p align="center"><b>
  660.                     <input name="errDescRate" type="button" class="s03" id="errDescRate" value="注 销" border="0" onClick=subform("deactive")>
  661.                     </b><b> </b></td>
  662.                 <td width="150" background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  663.                   <div align="center"><b>
  664.                     <input type="submit"  class="s03" name="Submit" value="查 询">
  665.                     </b> </div></td>
  666.               </tr>
  667.             </table></td></tr>
  668.       </TBODY>
  669.     </TABLE>
  671.  <%if (testSet.size()>0){
  672.  %>
  673.     <br>
  674.     <TABLE width=600 border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
  675.       <TBODY>
  676.         <TR>
  677.           <td width="587" height=22 bgColor=#E3E3E3 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  678.               <tr>
  679.                 <td width="49" height="20" nowrap><div align="center"><strong>序号</strong></div></td>
  680.                 <td width="49" nowrap><div align="center"><strong>年级</strong></div></td>
  681.                 <td width="180" nowrap> <div align="left"><strong>考试名称</strong></div></td>
  682.                 <td width="142" nowrap><div align="center"><strong>考试发布时间</strong></div></td>
  683.                 <td width="66" nowrap><div align="center"><strong>考试类型</strong></div></td>
  684.                 <td width="49" nowrap><div align="center"><strong>总分</strong></div></td>
  685.                 <td width="57" nowrap><div align="center"><strong>状态</strong></div></td>
  686.               </tr>
  687.             </table></td>
  688.         </TR>
  689. <%          Iterator iter = testSet.listIterator();
  690.             int order=0;
  691.             while (iter.hasNext()) {
  692.                 Test t = (Test) iter.next();
  693.                 order++;
  694. %>
  695.             <TR>
  696.           <td width="587" height=22 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  697.               <tr>
  698.                 <td width="49" height="20" align="left" valign="middle" nowrap>
  699.                   <div align="left">
  700.                     <input name="id" type="checkbox" id="id" value="<%=t.id%>">
  701.                     <%=order%>.</div></td>
  702.                 <td width="47" nowrap><div align="center"><%=t.grade%></div></td>
  703.                 <td width="185" nowrap> <div align="left"><%=t.name%></div></td>
  704.                 <td width="141" nowrap><div align="center"><%=t.time%></div></td>
  705.                 <td width="65" nowrap><div align="center"><%=t.testclass%></div></td>
  706.                 <td width="49" nowrap> <div align="center"><%=t.totalMark%></div></td>
  707.                 <td width="56" nowrap><div align="center"><%=t.status%></div></td>
  708.               </tr>
  709.             </table></td>
  710.         </TR>
  713. <%
  714.             }
  715. %>
  716.       </TBODY>
  717.     </TABLE>
  718.     <p>
  720. <input name="stu_id" type="hidden" id="studentid2" value="">
  722. </FORM>
  723. <%}
  724. else{
  725.    %>
  728.   <table width="77%" border="0" cellspacing="0" cellpadding="0">
  729.     <tr>
  730.       <td width="33%"><img src="images/pic_notice.gif" width="150" height="150"></td>
  731.       <td width="67%" align="center" valign="middle" nowrap>
  732.         <div align="center"><font size="+2">没有查询到满足条件的数据!</font></div></td>
  733.     </tr>
  734.   </table>
  736.    <%
  737. }
  738. %>
  739.   <!--end test -->
  740.   <!--begin bottom -->
  741.   <!--end bottom -->
  742. </CENTER>
  743. </BODY>
  744. </HTML>
  746. <%}
  747. catch(SQLException se){
  748.     out.println("<br>sql="+sql);
  749.     out.println("<br>"+se.toString());
  750. }
  751. catch(Exception e){
  752.     out.println("<br>sql="+sql);
  753.     out.print(e.toString());
  755. }
  756. finally{
  757.     DBCon.dropConnection();
  758. }
  759. %>