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

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

教育系统应用

开发平台：

WORD

Query_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. <%!Connection con;
  9. class Test{
  10.     String id;
  11.     String name;
  12.     String grade;
  13.     String time;
  14.     String totalMark;
  15.     String testclass;
  16.     public String toString(){
  17.         String temp="";
  18.         temp="<br> id="+id+"<br> name="+name;
  19.         return temp;
  20.    }
  21. };
  22. boolean debug=false;
  25. Statement stmt=null;
  26. ResultSet rs=null;
  27. String sql="";
  28. String sqlCon=null;
  29. int testNumber=0;
  30. int EveryPage=5;//每页显示的记录数；
  31. int OnPage=1; //当前显示的页数；
  32. int Total=0;//记录的总数；
  33. int TotalPage=0;//记录的总页数；
  34. %>
  35. <%
  36. ArrayList testSet=new ArrayList();
  38. try{
  39.     con=DBCon.getConnection();
  43. %>
  47. <%
  48. //构造查询条件
  49. //String query_grade=(String)session.getAttribute("query_grade");
  50. //String query_sub=(String)session.getAttribute("query_sub");
  51. //String query_knowpoint=(String)session.getAttribute("query_knowpoint");
  52. //String query_testtype=(String)session.getAttribute("query_testtype");
  53. //String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
  54. sqlCon="";
  55. String query_grade=request.getParameter("Grade");
  56. String query_sub=request.getParameter("Subject");
  57. String query_knowpoint=request.getParameter("KnowPoint");
  58. String query_testtype=request.getParameter("testtype");
  62. if(query_grade!=null)
  63. {
  64.     session.setAttribute("query_grade",query_grade);
  65. }
  66. else
  67. {
  68.     query_grade=(String)session.getAttribute("query_grade");
  69. }
  70. if(query_sub!=null)
  71. {
  72.     session.setAttribute("query_sub",query_sub);
  73. }else
  74. {
  75.     query_sub=(String)session.getAttribute("query_sub");
  76. }
  77. if(query_knowpoint!=null)
  78. {
  79.     session.setAttribute("query_knowpoint",query_knowpoint);
  80. }
  81. else
  82. {
  83.     query_knowpoint=(String)session.getAttribute("query_knowpoint");
  84. }
  85. if(query_testtype!=null)
  86. {
  87.     session.setAttribute("query_testtype",query_testtype);
  88. }
  89. else
  90. {
  91.     query_testtype=(String)session.getAttribute("query_testtype");
  92. }
  94. if(query_grade==null)
  95.     query_grade="all";
  96. if(query_sub==null)
  97.     query_sub="all";
  98. if(query_knowpoint==null)
  99.     query_knowpoint="all";
  100. if(query_testtype==null)
  101.     query_testtype="2";
  103. if(debug){
  104.     out.print("<br>grade="+query_grade+
  105.     "<br>sub="+query_sub+
  106.     "<br>knowpoint="+query_knowpoint+
  107.     "<br>testtype="+query_testtype
  108.     );
  109. }
  110. sqlCon="";
  111. int itesttype=Integer.parseInt(query_testtype);
  112. switch (itesttype){
  113.     case 2://单元测试
  114. sqlCon=" (test.status<>3)";
  115.          if(query_grade!=null){
  116.             if(!query_grade.equals("all")){
  117.                 if(query_grade.equals("c")){
  118.                     if(sqlCon.equals(""))
  119.                         sqlCon=" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  120.                     else
  121.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='c1' OR test.gradenote='c2' OR test.gradenote='c3')";
  122.                 }else if(query_grade.equals("g")){
  123.                     if(sqlCon.equals(""))
  124.                         sqlCon=" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='g3w')";
  125.                     else
  126.                         sqlCon=sqlCon+ " AND "+" (test.gradenote='g1' OR test.gradenote='g2' OR test.gradenote='g3l' OR test.gradenote='gw3')";
  127.                 }
  128.             else
  129.                 if(sqlCon.equals(""))
  130. sqlCon=" (test.gradenote='"+query_grade+"')";
  131.                 else
  132.                     sqlCon=sqlCon+" AND "+" (test.gradenote='"+query_grade+"')";
  134.             }
  135.         }
  136.         if(debug)   out.println("<br>grade sql="+sqlCon);
  138.         if(query_sub!=null){
  139.         if(!query_sub.equals("all")){
  140.             if (!sqlCon.equals(""))
  141.                 sqlCon=sqlCon +" AND (test.subid="+query_sub+")";
  142.             else
  143.                 sqlCon=" (test.subid="+query_sub+")";
  144.             }
  145.         }
  146.         if(debug)    out.println("<br>subject 4"+sqlCon);
  148.         if(query_knowpoint!=null){
  149.             if(!query_knowpoint.equals("all")){
  150.                 if(!sqlCon.equals(""))
  151.                     sqlCon=sqlCon+" AND(test.knowpointid1="+query_knowpoint +
  152.                         " OR test.knowpointid2="+query_knowpoint+
  153.                         " OR test.knowpointid3="+query_knowpoint+")";
  154.                 else
  155.                     sqlCon=" (test.knowpointid1="+query_knowpoint +
  156.                         " OR test.knowpointid2="+query_knowpoint+
  157.                         " OR test.knowpointid3="+query_knowpoint+")";
  158.             }
  159.         }
  160.         if(debug)    out.println("<br>knowpoint sql="+sqlCon);
  161.         sql="SELECT   `test`.`id`,  `grade`.`Name` AS `gradename`,"+
  162.             "  `test`.`title` AS `testname`,  `test`.`mark`,  `test`.`date` AS `testdate`"+
  163.             "  FROM  `test`  LEFT OUTER JOIN `grade` ON (`test`.`gradenote` = `grade`.`note`)";
  165.         if(!sqlCon.equals("")) sql=sql+" WHERE "+sqlCon;
  166.         sql=sql+" ORDER BY  `test`.`gradenote`,`test`.`subid`,`test`.`id`";
  168.         if(debug) out.println("<br>test sql="+sql);
  169.         stmt=con.createStatement();
  170.         rs=stmt.executeQuery(sql);
  171.         while(rs.next()){
  172.             Test t=new Test();
  173.             t.id=rs.getString("id");
  174.             //<a href="Query_test_mn.jsp" target="_self">test</a>
  175.             t.name="<a href="+"Query_test_unit.jsp?testID="+t.id+" target="_self">"+
  176.                         rs.getString("testname")+"</a>";
  177.             t.grade=rs.getString("gradename");
  178.             t.totalMark=rs.getString("mark");
  179.             t.testclass="单元测试";
  180.             t.time=rs.getString("testdate");
  181.             testSet.add(t);
  182.         }
  183.         rs.close();
  184.         stmt.close();
  186.         break;
  187.     case 3://模拟测试
  188.         if(query_grade!=null){
  189.             if(!query_grade.equals("all")){
  190.                 if(query_grade.equals("c")){
  191.                     if(sqlCon.equals(""))
  192.                         sqlCon=" (mn_test.grade_note='c1' OR mn_test.grade_note='c2' OR mn_test.grade_note='c3')";
  193.                     else
  194.                         sqlCon=sqlCon+" AND "+" (mn_test.grade_note='c1' OR mn_test.grade_note='c2' OR mn_test.grade_note='c3')";
  195.                 }else if(query_grade.equals("g")){
  196.                     if(sqlCon.equals(""))
  197.                         sqlCon=" (mn_test.grade_note='g1' OR mn_test.grade_note='g2' OR mn_test.grade_note='g3l' OR mn_test.grade_note='g3w')";
  198.                     else
  199.                         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')";
  200.                 }
  201.             else  if(sqlCon.equals(""))
  202.                     sqlCon=" (mn_test.grade_note='"+query_grade+"')";
  203.                 else
  204.                     sqlCon=sqlCon+" AND "+" (mn_test.grade_note='"+query_grade+"')";
  205.             }
  206.         }
  207.         if(debug)   out.println("<br>grade sql="+sqlCon);
  209.         sql="SELECT   `mn_test`.`id`,  `mn_test`.`name` AS `testname`,"+
  210.             "  `grade`.`Name` AS `gradename`,  `mn_test`.`mntotalmark`,"+
  211.             "  CONCAT(`mn_test`.`begin_date`,"至",  `mn_test`.`end_date`) as testtime FROM  `mn_test`"+
  212.             "  LEFT OUTER JOIN `grade` ON (`mn_test`.`grade_note` = `grade`.`note`)";
  213.         if(!sqlCon.equals("")) sql=sql+" WHERE "+sqlCon;
  214.         sql=sql+" ORDER BY  `mn_test`.`grade_note`,`mn_test`.`begin_date`";
  215.         stmt=con.createStatement();
  216.         rs=stmt.executeQuery(sql);
  217.         while(rs.next()){
  218.             Test t=new Test();
  219.             t.id=rs.getString("id");
  220.             //<a href="Query_test_mn.jsp" target="_self">test</a>
  221.             t.name="<a href="+"Query_test_mn.jsp?mnID="+t.id+" target="_self">"+
  222.                         rs.getString("testname")+"</a>";
  223.             t.grade=rs.getString("gradename");
  224.             t.totalMark=rs.getString("mntotalmark");
  225.             t.testclass="模拟考试";
  226.             t.time=rs.getString("testtime");
  227.             testSet.add(t);
  228.         }
  229.         rs.close();
  230.         stmt.close();
  231.         break;
  232.     default:
  233. }
  241. if(debug)
  242.     out.println("<br>at last sql="+sql);
  244. //rs.last();//移到最后一条记录;
  245. //Total=rs.getRow();//记录的总数；
  247. //TotalPage=(Total%EveryPage==0)?(Total/EveryPage):(Total/EveryPage+1);
  250. %>
  252. <!--年级，科目，知识点三个下拉列表框联动-->
  253. <%
  254. out.print(Tools.sub_know(con));
  255. out.print(Tools.grade_sub(con));
  256. %>
  257. <script language="JavaScript">
  258. function changegs(locationid){
  259. document.myform.Subject.length =1;
  260.         document.myform.KnowPoint.length =1;
  261.         var locationid=locationid;
  262.         var i;
  263.         for (i=0;i < gscount; i++){
  264.             if (grade_sub[i][0] == locationid) {
  265.             document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
  266.             }
  267. }
  268. }
  270. function changesk(locationid){
  271. document.myform.KnowPoint.length =1;
  272. var locationid=locationid;
  273. var i;
  274. for (i=0;i < gskcount; i++){
  275. if (grade_sub_know[i][1] == locationid){
  276. document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
  277. }
  278. }
  279. }
  282. function delit(myform)
  283. {
  284.   if (confirm("将删除所有选择的知识点数据？"))
  285.   {
  286.     myform.action="errorpaddel.jsp";
  287.     myfrom.target="_self";
  288.     myform.submit();
  289.   }
  290. }
  291. function del_check()
  292. {
  293. var count = errorpad.elements.length;
  294. var noSelect = true;
  295.   for(var i=0;i<count;i++)
  296.   {
  297.      if(errorpad.elements[i].checked)
  298.      {
  299.              noSelect = false;
  300.       break;
  301. }
  302.    }
  303. if(noSelect == true)
  304. {
  305.     alert("您还没有选择要删除的错题!");
  306.     return(false);
  307.  }
  308.    else
  309.    {
  310.          if(confirm("将删除所有选择的错题吗？"))
  311.          {
  312.                 document.errorpad.method = "POST";
  313.                 document.errorpad.action = "errorpad_del.jsp";
  314.                 document.errorpad.target="_self";
  315.                 document.errorpad.submit();
  316.          }
  317.          else
  318.          {
  319.                 document.form3.method = "GET";
  320.                 document.form3.action = "";
  321. }
  322.          }
  323.          return false;
  324. }
  325. function addrate_check()
  326. {
  327. var count = errorpad.elements.length;
  328. var noSelect = true;
  329.   for(var i=0;i<count;i++)
  330.   {
  331.      if(errorpad.elements[i].checked)
  332.      {
  333.              noSelect = false;
  334.       break;
  335. }
  336.    }
  337. if(noSelect == true)
  338. {
  339.     alert("您还没有选择要增加错误级别的错题!");
  340.     return(false);
  341.  }
  342.    else
  343.    {
  344.          if(confirm("增加所有选择的错题的错误级别吗？"))
  345.          {
  346.                 document.errorpad.method = "POST";
  347.                 document.errorpad.action = "errorpad_addrate.jsp";
  348.                 document.errorpad.target="_self";
  349.                 document.errorpad.submit();
  350.          }
  351.          else
  352.          {
  353.                 document.errorpad.method = "GET";
  354.                 document.errorpad.action = "";
  355. }
  356.          }
  357.          return false;
  358. }
  359. function decrate_check()
  360. {
  361. var count = errorpad.elements.length;
  362. var noSelect = true;
  363.   for(var i=0;i<count;i++)
  364.   {
  365.      if(errorpad.elements[i].checked)
  366.      {
  367.              noSelect = false;
  368.       break;
  369. }
  370.    }
  371. if(noSelect == true)
  372. {
  373.     alert("您还没有选择要降低错误级别的错题!");
  374.     return(false);
  375.  }
  376.    else
  377.    {
  378.          if(confirm("降低所有选择的错题的错误级别吗？"))
  379.          {
  380.                 document.errorpad.method = "POST";
  381.                 document.errorpad.action = "errorpad_decrate.jsp";
  382.                 document.errorpad.target="_self";
  383.                 document.errorpad.submit();
  384.          }
  385.          else
  386.          {
  387.                 document.errorpad.method = "GET";
  388.                 document.errorpad.action = "";
  389. }
  390.          }
  391.          return false;
  392. }
  393. function subform(stract)
  394. {
  395. switch (stract){
  396. case "del":
  397.             del_check();
  398. break;
  399. case "addrate":
  400.             addrate_check();
  401. break;
  402. case "decrate":
  403. decrate_check();
  404. break;
  405.         case "test":
  406.             selectid();
  407.             break;
  408. case "print":
  409. printerror();
  410.             break;
  412. }
  414. }
  415. function selectid(){
  416.     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');
  417.     var toppos=(window.screen.height-240)/2;
  418.     var leftpos=(window.screen.width-470)/2;
  419.     winpoint.moveTo(toppos,leftpos);
  420.     winpoint.focus();
  421.     document.errorpad.method="POST";
  422.     document.errorpad.action="err_test_type.jsp";
  423.     document.errorpad.target="err_test_type";
  424.     document.errorpad.submit();
  426. }
  427. function printerror(){
  429.     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');
  430.     var toppos=(window.screen.height-240)/2;
  431.     var leftpos=(window.screen.width-470)/2;
  432.     winpoint.moveTo(toppos,leftpos);
  433.     winpoint.focus();
  434.     document.errorpad.method="POST";
  435.     document.errorpad.action="err_print_type.jsp";
  436.     document.errorpad.target="err_print_type";
  437.     document.errorpad.submit();
  438. }
  439. function openDetail(var1){
  440.     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');
  441.     winpoint.focus();
  442. }
  443. function InitMyform(){
  444.     document.myform.Grade.value='<%=query_grade%>';
  445.     changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value);
  446.     document.myform.Subject.value='<%=query_sub%>';
  447.     changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value);
  448.     document.myform.KnowPoint.value='<%=query_knowpoint%>';
  449.     document.myform.testtype.value='<%=query_testtype%>';
  452. }
  454. </script>
  455. <HTML>
  456. <HEAD>
  457. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  458. <TITLE>精华学堂-考试查询</TITLE>
  459. <SCRIPT language=JavaScript>
  460. <!--
  462. function SymError()
  463. {
  464.   return true;
  465. }
  467. window.onerror = SymError;
  470. //-->
  471. </SCRIPT>
  474. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  475. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
  476. href="../errorpad/style/style.css" type=text/css rel=stylesheet>
  477. <SCRIPT src=""></SCRIPT>
  479. <SCRIPT src=""></SCRIPT>
  481. <SCRIPT src=""></SCRIPT>
  483. <SCRIPT src=""></SCRIPT>
  485. <SCRIPT src=""></SCRIPT>
  487. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  488. <link rel="stylesheet" type="text/css" href="../css.css">
  489. </HEAD>
  490. <BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
  492. <CENTER>
  494. <TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
  495.   <TBODY>
  496.   <TR>
  497.           <TD><IMG height=27 src="../errorpad/images/test_pop_01.gif" width=102></TD>
  498.           <TD align=right><IMG height=27 src="../errorpad/images/test_pop_02.gif"
  499.       width=134></TD>
  500.         </TR></TBODY></TABLE>
  501.   <strong><font color="#3366FF" size="+2" face="黑体">精华学堂试卷查询</font></strong>
  502.   <!--begin test -->
  503.   <FORM action=Query_test.jsp method=post name=myform target="_self" id="myform">
  504.     <TABLE width=100% height="60" border=0 cellPadding=0 cellSpacing=0>
  505.       <TBODY>
  506.         <TR>
  507.           <TD height="75"  align=middle>
  508.             <table width="600" height="56" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  509.               <tr>
  510.                 <td width="100" height="52" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  511.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  512.                     <tr>
  513.                       <td>年&nbsp;级:</td>
  514.                     </tr>
  515.                     <tr>
  516.                       <td height="24" nowrap> <select id=select30 name=Grade onclick="changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value)" size="1">
  517.                           <option value="all" selected>-全 部-</option>
  518.                           <%Tools.showGradeOption(con,out);%>
  519.                         </select> </td>
  520.                     </tr>
  521.                   </table>
  522.                   &nbsp; </td>
  523.                 <td width="88" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  524.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  525.                     <tr>
  526.                       <td nowrap>科&nbsp;目:</td>
  527.                     </tr>
  528.                     <tr>
  529.                       <td nowrap> <select id=select29 name=Subject onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)"
  530. size="1">
  531.                           <option value="all" selected>全 部</option>
  532.                         </select> </td>
  533.                     </tr>
  534.                   </table>
  535.                   <strong> </strong> </td>
  536.                 <td width="187" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
  537.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  538.                     <tr>
  539.                       <td nowrap>知识点:</td>
  540.                     </tr>
  541.                     <tr>
  542.                       <td nowrap> <select name=KnowPoint id="select31">
  543.                           <option value="all" selected>----全 部----</option>
  544.                         </select> </td>
  545.                     </tr>
  546.                   </table></td>
  547.                 <td width="104" align="center" valign="baseline" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
  548.                   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  549.                     <tr>
  550.                       <td nowrap>考试类型：</td>
  551.                     </tr>
  552.                     <tr>
  553.                       <td nowrap> <select name="testtype" id="select8">
  554.                           <option value="2" selected>单元测试</option>
  555.                           <option value="3">模拟测试 </option>
  556.                         </select> </td>
  557.                     </tr>
  558.                   </table></td>
  559.                 <td width="111" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"><input type="submit"  class="s03" name="Submit" value="查询"></td>
  560.               </tr>
  561.             </table>
  562.             </TD>
  563.         </TR>
  565.       </TBODY>
  566.     </TABLE>
  567. </FORM>
  568.  <%if (testSet.size()>0){
  569.  %>
  570.   <FORM method="post" name="errorpad" id="errorpad">
  571.     <TABLE width=600 border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
  572.       <TBODY>
  573.         <TR>
  574.           <td width="587" height=22 bgColor=#E3E3E3 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  575.               <tr>
  576.                 <td width="41" height="20" nowrap><div align="center"><strong>序号</strong></div></td>
  577.                 <td width="50" nowrap><div align="center"><strong>年级</strong></div></td>
  578.                 <td width="190" nowrap> <div align="left"><strong>考试名称</strong></div></td>
  579.                 <td width="149" nowrap><div align="center"><strong>考试发布时间</strong></div></td>
  580.                 <td width="78" nowrap><div align="center"><strong>考试类型</strong></div></td>
  581.                 <td width="84" nowrap><div align="center"><strong>总分</strong></div></td>
  582.               </tr>
  583.             </table></td>
  584.         </TR>
  585. <%          Iterator iter = testSet.listIterator();
  586.             int order=0;
  587.             while (iter.hasNext()) {
  588.                 Test t = (Test) iter.next();
  589.                 order++;
  590. %>
  591.             <TR>
  592.           <td width="587" height=22 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  593.               <tr>
  594.                 <td width="41" height="20" nowrap><div align="center"><%=order%>.</div></td>
  595.                 <td width="48" nowrap><div align="center"><%=t.grade%></div></td>
  596.                 <td width="190" nowrap> <div align="left"><%=t.name%></div></td>
  597.                 <td width="153" nowrap><div align="center"><%=t.time%></div></td>
  598.                 <td width="77" nowrap><div align="center"><%=t.testclass%></div></td>
  599.                 <td width="83" nowrap> <div align="center"><%=t.totalMark%></div></td>
  600.               </tr>
  601.             </table></td>
  602.         </TR>
  605. <%
  606.             }
  607. %>
  608.       </TBODY>
  609.     </TABLE>
  610.     <p>
  612. <input name="stu_id" type="hidden" id="studentid2" value="">
  614. </FORM>
  615. <%}
  616. else{
  617.    %>
  620.   <table width="77%" border="0" cellspacing="0" cellpadding="0">
  621.     <tr>
  622.       <td width="33%"><img src="images/pic_notice.gif" width="150" height="150"></td>
  623.       <td width="67%" align="center" valign="middle" nowrap>
  624.         <div align="center"><font size="+2">没有查询到满足条件的数据!</font></div></td>
  625.     </tr>
  626.   </table>
  628.    <%
  629. }
  630. %>
  631.   <!--end test -->
  632.   <!--begin bottom -->
  633.   <!--end bottom -->
  634. </CENTER>
  635. </BODY>
  636. </HTML>
  638. <%}
  639. catch(SQLException se){
  640.     out.println("<br>sql="+sql);
  641.     out.println("<br>"+se.toString());
  642. }
  643. catch(Exception e){
  644.     out.print(e.toString());
  645. }
  646. finally{
  647.     DBCon.dropConnection();
  648. }
  649. %>