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

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

教育系统应用

开发平台：

WORD

Query_stu_mn.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. <%!Connection con;
  9. boolean debug=true;
  10. String studentID="";
  11. String gradenote="";
  12. String gradename="";
  13. Statement stmt=null;
  14. ResultSet rs=null;
  15. String sql="";
  16. String sqlCon=null;
  17. int testNumber=0;
  18. int EveryPage=5;//每页显示的记录数；
  19. int OnPage=1; //当前显示的页数；
  20. int Total=0;//记录的总数；
  21. int TotalPage=0;//记录的总页数；
  22. %>
  23. <%
  24. try{
  25.     studentID=(String)session.getAttribute("studentID");
  26.     if(studentID==null){
  27.         throw new Exception();
  28.     }
  30. }catch(Exception e){
  31.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  32.     Tools.showJS("window.open('../login.jsp','_self')",out);
  33. }
  35. try{
  36.     con=DBCon.getConnection();
  38.     //获取学生的年级信息
  39.     sql=" SELECT   `grade`.`Name`,  `grade`.`note` FROM"+
  40.         "  `grade`  INNER JOIN `UserInfo` ON (`grade`.`note` = `UserInfo`.`gradenote`)"+
  41.         " WHERE  (`UserInfo`.`vcUserNo` = '"+studentID+"')";
  43.     try{
  44.         stmt=con.createStatement();
  45.         rs=stmt.executeQuery(sql);
  47.         if(rs.next()){
  48.             gradenote=rs.getString("note");
  49.             gradename=rs.getString("Name");
  50.             rs.close();
  51.             stmt.close();
  52.         }
  53.         if(debug){
  54.             out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
  55.         }
  56.     }
  57.     catch(SQLException se){
  58.         out.print("<br> query grade error sql="+sql);
  59.         out.print("<br>"+se.toString());
  60.     }
  61.     catch(Exception e){
  62.         out.print("<br> query grade error sql="+sql);
  63.         out.print("<br>"+e.toString());
  64.     }
  65.     //查询学生所属年级的错题
  67. %>
  71. <%
  72. //构造查询条件
  73. //String errorpad_grade=(String)session.getAttribute("errorpad_grade");
  74. //String errorpad_sub=(String)session.getAttribute("errorpad_sub");
  75. //String errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
  76. //String errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
  77. //String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  78. sqlCon="";
  79. String errorpad_grade=request.getParameter("Grade");
  81. String errorpad_sub=request.getParameter("Subject");
  82. String errorpad_knowpoint=request.getParameter("KnowPoint");
  83. String errorpad_testtype=request.getParameter("testtype");
  84. String errorpad_errorcount=request.getParameter("errorcount");
  86. if(debug){
  87.     out.print("<br>grade="+errorpad_grade+
  88.     "<br>sub="+errorpad_sub+
  89.     "<br>knowpoint="+errorpad_knowpoint+
  90.     "<br>testtype="+errorpad_testtype+
  91.     "<br>errorcunt="+errorpad_errorcount);
  92. }
  94. if(errorpad_grade!=null)
  95. {
  96.     session.setAttribute("errorpad_grade",errorpad_grade);
  97. }
  98. else
  99. {
  100.     errorpad_grade=(String)session.getAttribute("errorpad_grade");
  101. }
  102. if(errorpad_sub!=null)
  103. {
  104.     session.setAttribute("errorpad_sub",errorpad_sub);
  105. }else
  106. {
  107.     errorpad_sub=(String)session.getAttribute("errorpad_sub");
  108. }
  109. if(errorpad_knowpoint!=null)
  110. {
  111.     session.setAttribute("errorpad_knowpoint",errorpad_knowpoint);
  112. }
  113. else
  114. {
  115.     errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
  116. }
  117. if(errorpad_testtype!=null)
  118. {
  119.     session.setAttribute("errorpad_testtype",errorpad_testtype);
  120. }
  121. else
  122. {
  123.     errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
  124. }
  125. if(errorpad_errorcount!=null)
  126. {
  127.     session.setAttribute("errorpad_errorcount",errorpad_errorcount);
  128. }
  129. else
  130. {
  131.     errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  132. }
  133. if(errorpad_grade==null)
  134.     errorpad_grade="all";
  135. if(errorpad_sub==null)
  136.     errorpad_sub="all";
  137. if(errorpad_knowpoint==null)
  138.     errorpad_knowpoint="all";
  139. if(errorpad_testtype==null)
  140.     errorpad_testtype="all";
  141. if(errorpad_errorcount==null)
  142.     errorpad_errorcount="0";
  144. if(errorpad_grade!=null){
  145.     if(!errorpad_grade.equals("all")){
  146.         if(errorpad_grade.equals("c")){
  147.             sqlCon="(question.gradenote='c1' OR question.gradenote='c2' OR question.gradenote='c3')";
  148.         }else if(errorpad_grade.equals("g")){
  149.             sqlCon="(question.gradenote='g1' OR question.gradenote='g2' OR question.gradenote='g3')";
  150.         }
  151.         else
  152.             sqlCon="(question.gradenote='"+errorpad_grade+"')";
  153.     }
  154. }
  155. if(debug)
  156.     out.println("<br>grade sql="+sqlCon);
  158. if(errorpad_sub!=null){
  159.     if(!errorpad_sub.equals("all")){
  160.         if (!sqlCon.equals(""))
  161.             sqlCon=sqlCon +" AND (question.SubjectID="+errorpad_sub+")";
  162.         else
  163.             sqlCon=" (question.SubjectID="+errorpad_sub+")";
  164.     }
  165. }
  166. if(debug)
  167.     out.println("<br>subject sql="+sqlCon);
  169. if(errorpad_knowpoint!=null){
  170.     if(!errorpad_knowpoint.equals("all")){
  171.         if(!sqlCon.equals(""))
  172.             sqlCon=sqlCon+" AND(question.KnowPointID1="+errorpad_knowpoint +
  173.                 " OR question.KnowPointID2="+errorpad_knowpoint+
  174.                 " OR question.KnowPointID3="+errorpad_knowpoint+")";
  175.         else
  176.             sqlCon=" (question.KnowPointID1="+errorpad_knowpoint +
  177.                 " OR question.KnowPointID2="+errorpad_knowpoint+
  178.                 " OR question.KnowPointID3="+errorpad_knowpoint+")";
  179.     }
  180. }
  181. if(debug)
  182.     out.println("<br>knowpoint sql="+sqlCon);
  185. if(errorpad_testtype!=null){
  186.     if(!errorpad_testtype.equals("all")){
  187.         if(!sqlCon.equals(""))
  188.             sqlCon=sqlCon+ " AND(errorpad.sourcetype="+errorpad_testtype+")";
  189.         else
  190.             sqlCon= " (errorpad.sourcetype="+errorpad_testtype+")";
  191.     }
  192. }
  193. if(debug)
  194.     out.println("<br>testtype sql="+sqlCon);
  196. if(errorpad_errorcount!=null){
  197.     if(!sqlCon.equals(""))
  198.         sqlCon=sqlCon+ " AND(errorpad.errorcount>="+errorpad_errorcount+")";
  199.     else
  200.         sqlCon=" (errorpad.errorcount>="+errorpad_errorcount+")";
  201. }
  202. if(debug)
  203.     out.println("<br>errorcount sql="+sqlCon);
  204. sqlCon="(`errorpad`.`stu_id` = 's11')"+" AND"+sqlCon;
  205. //查询满足条件的错题
  206. sql="SELECT  `errorpad`.`id`, `errorpad`.`question_id`, `question`.`QuestText`, DATE_FORMAT( `errorpad`.`add_date`,"%Y-%m-%e %H:%i:%S") AS add_date, "+
  207.     " `errorpad`.`errorcount`,  ELT(`errorpad`.`sourcetype`,"自由测试","自由单元测试","模拟考试") as sourcename, "+
  208.     " `grade`.`Name` AS `gradename`"+
  209.     " FROM  `errorpad`"+
  210.     "  LEFT OUTER JOIN `question` ON (`errorpad`.`question_id` = `question`.`ID`)"+
  211.     "  LEFT OUTER JOIN `grade` ON (`question`.`gradenote` = `grade`.`note`)"+
  212.     " WHERE  "+sqlCon+
  213.     " ORDER BY  `errorpad`.`add_date` ASC";
  215. session.setAttribute("errorpad_sqlcon",sqlCon);
  216. session.setAttribute("errorpad_sql",sql);
  217. if(debug)
  218.     out.println("<br>at last sql="+sql);
  219. stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  220. rs=stmt.executeQuery(sql);
  221. //rs.last();//移到最后一条记录;
  222. //Total=rs.getRow();//记录的总数；
  224. //TotalPage=(Total%EveryPage==0)?(Total/EveryPage):(Total/EveryPage+1);
  227. %>
  229. <!--年级，科目，知识点三个下拉列表框联动-->
  230. <%
  231. out.print(Tools.sub_know(con));
  232. out.print(Tools.grade_sub(con));
  233. %>
  234. <script language="JavaScript">
  235. function changegs(locationid){
  236. document.myform.Subject.length =1;
  237.         document.myform.KnowPoint.length =1;
  238.         var locationid=locationid;
  239.         var i;
  240.         for (i=0;i < gscount; i++){
  241.             if (grade_sub[i][0] == locationid) {
  242.             document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
  243.             }
  244. }
  245. }
  247. function changesk(locationid){
  248. document.myform.KnowPoint.length =1;
  249. var locationid=locationid;
  250. var i;
  251. for (i=0;i < gskcount; i++){
  252. if (grade_sub_know[i][1] == locationid){
  253. document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
  254. }
  255. }
  256. }
  259. function delit(myform)
  260. {
  261.   if (confirm("将删除所有选择的知识点数据？"))
  262.   {
  263.     myform.action="errorpaddel.jsp";
  264.     myfrom.target="_self";
  265.     myform.submit();
  266.   }
  267. }
  268. function del_check()
  269. {
  270. var count = errorpad.elements.length;
  271. var noSelect = true;
  272.   for(var i=0;i<count;i++)
  273.   {
  274.      if(errorpad.elements[i].checked)
  275.      {
  276.              noSelect = false;
  277.       break;
  278. }
  279.    }
  280. if(noSelect == true)
  281. {
  282.     alert("您还没有选择要删除的错题!");
  283.     return(false);
  284.  }
  285.    else
  286.    {
  287.          if(confirm("将删除所有选择的错题吗？"))
  288.          {
  289.                 document.errorpad.method = "POST";
  290.                 document.errorpad.action = "errorpad_del.jsp";
  291.                 document.errorpad.target="_self";
  292.                 document.errorpad.submit();
  293.          }
  294.          else
  295.          {
  296.                 document.form3.method = "GET";
  297.                 document.form3.action = "";
  298. }
  299.          }
  300.          return false;
  301. }
  302. function addrate_check()
  303. {
  304. var count = errorpad.elements.length;
  305. var noSelect = true;
  306.   for(var i=0;i<count;i++)
  307.   {
  308.      if(errorpad.elements[i].checked)
  309.      {
  310.              noSelect = false;
  311.       break;
  312. }
  313.    }
  314. if(noSelect == true)
  315. {
  316.     alert("您还没有选择要增加错误级别的错题!");
  317.     return(false);
  318.  }
  319.    else
  320.    {
  321.          if(confirm("增加所有选择的错题的错误级别吗？"))
  322.          {
  323.                 document.errorpad.method = "POST";
  324.                 document.errorpad.action = "errorpad_addrate.jsp";
  325.                 document.errorpad.target="_self";
  326.                 document.errorpad.submit();
  327.          }
  328.          else
  329.          {
  330.                 document.errorpad.method = "GET";
  331.                 document.errorpad.action = "";
  332. }
  333.          }
  334.          return false;
  335. }
  336. function decrate_check()
  337. {
  338. var count = errorpad.elements.length;
  339. var noSelect = true;
  340.   for(var i=0;i<count;i++)
  341.   {
  342.      if(errorpad.elements[i].checked)
  343.      {
  344.              noSelect = false;
  345.       break;
  346. }
  347.    }
  348. if(noSelect == true)
  349. {
  350.     alert("您还没有选择要降低错误级别的错题!");
  351.     return(false);
  352.  }
  353.    else
  354.    {
  355.          if(confirm("降低所有选择的错题的错误级别吗？"))
  356.          {
  357.                 document.errorpad.method = "POST";
  358.                 document.errorpad.action = "errorpad_decrate.jsp";
  359.                 document.errorpad.target="_self";
  360.                 document.errorpad.submit();
  361.          }
  362.          else
  363.          {
  364.                 document.errorpad.method = "GET";
  365.                 document.errorpad.action = "";
  366. }
  367.          }
  368.          return false;
  369. }
  370. function subform(stract)
  371. {
  372. switch (stract){
  373. case "del":
  374.             del_check();
  375. break;
  376. case "addrate":
  377.             addrate_check();
  378. break;
  379. case "decrate":
  380. decrate_check();
  381. break;
  382.         case "test":
  383.             selectid();
  384.             break;
  385. case "print":
  386. printerror();
  387.             break;
  389. }
  391. }
  392. function selectid(){
  393.     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');
  394.     var toppos=(window.screen.height-240)/2;
  395.     var leftpos=(window.screen.width-470)/2;
  396.     winpoint.moveTo(toppos,leftpos);
  397.     winpoint.focus();
  398.     document.errorpad.method="POST";
  399.     document.errorpad.action="err_test_type.jsp";
  400.     document.errorpad.target="err_test_type";
  401.     document.errorpad.submit();
  403. }
  404. function printerror(){
  406.     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');
  407.     var toppos=(window.screen.height-240)/2;
  408.     var leftpos=(window.screen.width-470)/2;
  409.     winpoint.moveTo(toppos,leftpos);
  410.     winpoint.focus();
  411.     document.errorpad.method="POST";
  412.     document.errorpad.action="err_print_type.jsp";
  413.     document.errorpad.target="err_print_type";
  414.     document.errorpad.submit();
  415. }
  416. function openDetail(var1){
  417.     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');
  418.     winpoint.focus();
  419. }
  420. function InitMyform(){
  421.     document.myform.Grade.value='<%=errorpad_grade%>';
  422.     changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value);
  423.     document.myform.Subject.value='<%=errorpad_sub%>';
  424.     changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value);
  425.     document.myform.KnowPoint.value='<%=errorpad_knowpoint%>';
  426.     document.myform.testtype.value='<%=errorpad_testtype%>';
  427.     document.myform.errorcount.value='<%=errorpad_errorcount%>';
  429. }
  431. </script>
  432. <HTML>
  433. <HEAD>
  434. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  435. <TITLE>共创学堂-错题本</TITLE>
  436. <SCRIPT language=JavaScript>
  437. <!--
  439. function SymError()
  440. {
  441.   return true;
  442. }
  444. window.onerror = SymError;
  447. //-->
  448. </SCRIPT>
  451. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  452. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
  453. href="../errorpad/style/style.css" type=text/css rel=stylesheet>
  454. <SCRIPT src=""></SCRIPT>
  456. <SCRIPT src=""></SCRIPT>
  458. <SCRIPT src=""></SCRIPT>
  460. <SCRIPT src=""></SCRIPT>
  462. <SCRIPT src=""></SCRIPT>
  464. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  465. <link rel="stylesheet" type="text/css" href="../css.css">
  466. </HEAD>
  467. <BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
  469. <CENTER>
  471. <TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
  472.   <TBODY>
  473.   <TR>
  474.           <TD><IMG height=27 src="../errorpad/images/test_pop_01.gif" width=102></TD>
  475.           <TD align=right><IMG height=27 src="../errorpad/images/test_pop_02.gif"
  476.       width=134></TD>
  477.         </TR></TBODY></TABLE>
  478.   <strong><font color="#3366FF" size="+2" face="黑体">共创学堂成绩查询</font></strong> 
  479.   <!--begin test -->
  480.   <FORM action=../errorpad/errorpad.jsp method=post name=myform target="_self" id="myform">
  481.     <TABLE width=100% height="145" border=0 cellPadding=0 cellSpacing=0>
  482.       <TBODY>
  483.         <TR>
  484.           <TD height="75"  align=middle valign="bottom">
  485.             <table width="84%" height="56" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  486.               <tr> 
  487.                 <td width="87" height="52" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  488.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  489.                     <tr> 
  490.                       <td>年&nbsp;级:</td>
  491.                     </tr>
  492.                     <tr> 
  493.                       <td height="24" nowrap> <select id=select30 name=Grade onclick="changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value)" size="1">
  494.                           <option value="all" selected>-全 部-</option>
  495.                           <%Tools.showGradeOption(con,out);%>
  496.                         </select> </td>
  497.                     </tr>
  498.                   </table>
  499.                   &nbsp; </td>
  500.                 <td width="70" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  501.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  502.                     <tr> 
  503.                       <td nowrap>科&nbsp;目:</td>
  504.                     </tr>
  505.                     <tr> 
  506.                       <td nowrap> <select id=select29 name=Subject onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)"
  507. size="1">
  508.                           <option value="all" selected>全 部</option>
  509.                         </select> </td>
  510.                     </tr>
  511.                   </table>
  512.                   <strong> </strong> </td>
  513.                 <td width="126" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  514.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  515.                     <tr> 
  516.                       <td nowrap>知识点:</td>
  517.                     </tr>
  518.                     <tr> 
  519.                       <td nowrap> <select name=KnowPoint id="select31">
  520.                           <option value="all" selected>----全 部----</option>
  521.                         </select> </td>
  522.                     </tr>
  523.                   </table></td>
  524.                 <td width="105" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  525.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  526.                     <tr> 
  527.                       <td nowrap>考试类型：</td>
  528.                     </tr>
  529.                     <tr> 
  530.                       <td nowrap> <select name="testtype" id="select8">
  531.                           <option value="all" selected>全部</option>
  532.                           <option value="2">单元测试</option>
  533.                           <option value="3">模拟测试 </option>
  534.                         </select> </td>
  535.                     </tr>
  536.                   </table></td>
  537.                 <td width="121" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  538.                   <table width="94%" border="0" cellspacing="0" cellpadding="0">
  539.                     <tr> 
  540.                       <td nowrap>分数段</td>
  541.                     </tr>
  542.                     <tr> 
  543.                       <td nowrap>从 <input name="mark1" type="text" id="mark1" value="0" size="5" maxlength="5">
  544.                         至 
  545.                         <input name="mark2" type="text" id="mark2" size="5" maxlength="5"></td>
  546.                     </tr>
  547.                   </table></td>
  548.                 <td width="47" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  549.                   <p align="center"> 
  550.                     <input type="submit"  class="s03" name="Submit" value="查询">
  551.                 </td>
  552.                 <td width="53" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"><div align="center"><b> 
  553.                     <input name="errPrint" type="button"  class="s03" id="errPrint2" value="打印" onClick=subform("print")>
  554.                     </b></div></td>
  555.               </tr>
  556.             </table>
  557.             </TD>
  558.         </TR>
  559.         <TR>
  560.           <TD  align=middle valign="top">&nbsp; </TD>
  561.         </TR>
  562.       </TBODY>
  563.     </TABLE>
  564. </FORM>
  565.   <FORM method="post" name="errorpad" id="errorpad">
  566.     <%
  567.       testNumber=1;
  568.       while(rs.next()){
  570.   %>
  571.     <TABLE width=80% border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
  572.       <TBODY>
  573.       <TR>
  574.           <td width="650" height=22 bgColor=#E3E3E3 class=l>
  575.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  576.               <tr> 
  577.                 <td width="81" height="20" nowrap>姓名 </td>
  578.                 <td width="60" nowrap><div align="right">注册号</div></td>
  579.                 <td width="43" nowrap><div align="left">年级：</div></td>
  580.                 <td width="100" nowrap>考试名称</td>
  581.                 <td width="100" nowrap><div align="right">考试时间:</div></td>
  582.                 <td width="174" nowrap>分数</td>
  583.                 <td width="155" nowrap>考试类型</td>
  584.                 <td nowrap> <div align="right"> </div></td>
  585.               </tr>
  586.             </table></td>
  587.       </TR>
  588.   <TR>
  589.           <td width="650" height=22 class=l>
  590.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  591.               <tr> 
  592.                 <td width="81" height="20" nowrap>姓名 </td>
  593.                 <td width="60" nowrap><div align="right">注册号</div></td>
  594.                 <td width="43" nowrap><div align="left">年级：</div></td>
  595.                 <td width="100" nowrap>考试名称</td>
  596.                 <td width="100" nowrap><div align="right">考试时间:</div></td>
  597.                 <td width="173" nowrap>分数</td>
  598.                 <td width="154" nowrap>考试类型</td>
  599.                 <td width="12" nowrap>&nbsp; </td>
  600.                 <td width="45" nowrap> <div align="right"> <img src="../errorpad/images/1026.gif" width="27" height="24" onClick="openDetail(<%=rs.getInt("question_id")%>)"></div></td>
  601.               </tr>
  602.             </table></td>
  603.       </TR>
  605.     </TBODY>
  606.   </TABLE>
  607.   <%
  608. testNumber++;
  609. }
  610. %>
  611. <input name="stu_id" type="hidden" id="studentid2" value="<%=studentID %>">
  612. <input name="selectids" type="hidden" id="studentid2" value="">
  613. <input name="selectcount" type="hidden" id="studentid2" value="">
  614. </FORM>
  615. <p>&nbsp;</p>
  616.  <!--end test --><!--begin bottom -->
  617. <TABLE
  618. style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
  619. cellSpacing=0 cellPadding=0 width="100%" border=0>
  620.   <TBODY>
  621.   <TR>
  622.     <TD align=middle colSpan=2 height=30>
  623.       <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
  624.         <TBODY>
  625.         <TR>
  626.           <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
  627.             target=_blank>关于我们</A> | <A
  628.             href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
  629.             target=_blank>联系方式</A> | 网站地图 | <A
  630.             href="http://jsptestonline.cosoft.org.cn/about/service.html"
  631.             target=_blank>服务条款</A> | <A
  632.             href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
  633.             target=_blank>隐私权保护</A> | <A
  634.             href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
  635.             target=_blank>版权声明</A></TD>
  636.           <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
  637.             target=_blank>共创教育机构</A></TD></TR></TBODY>
  638. </TABLE></TD></TR></TBODY>
  639. </TABLE><!--end bottom --></CENTER>
  640. </BODY>
  641. </HTML>
  643. <%}
  644. catch(Exception e){
  645.     out.print(e.toString());
  646. }
  647. finally{
  648.     DBCon.dropConnection();
  649. }
  650. %>