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

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

教育系统应用

开发平台：

WORD

mn_test_rs.jsp：源码内容
  2. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  3. <%@ page import="java.sql.*" %>
  4. <%@ page import="jinghua.*"%>
  5. <%@ page import="java.util.*"%>
  6. <%@ page import="java.text.*"%>
  7. <%! boolean debug=false;%>
  9. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  10. </jsp:useBean>
  13. <%
  14. String testID=request.getParameter("testid");
  15. String studentID=request.getParameter("studentid");
  16. String mn_testID=request.getParameter("mn_testID");
  17. int valid=Integer.parseInt(request.getParameter("valid"));
  19. int old=Integer.parseInt(request.getParameter("old"));
  21. //String testID="62";
  22. //String studentID="1";
  23. if(studentID==null){
  24.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  25.     Tools.showJS("window.open('../login.jsp','_self')",out);
  27. }
  28. ResultSet rs=null;
  29. String sql="";
  30. String title="";
  31. int testnum=0;
  32. StringBuffer sb=null;
  33. PreparedStatement pstmt=null;
  34. Statement stmt=null;
  35. String name="";//考生姓名
  37. int correct=0;
  38. int error=0;
  39. String correctAns="";
  40. String youAns="";
  41. StringBuffer dbmsg=new StringBuffer();
  42. StringBuffer testIDs=new StringBuffer();
  43. StringBuffer Answer=new StringBuffer();
  44. StringBuffer Mark=new StringBuffer();
  45. StringBuffer SubAns=new StringBuffer();
  46. StringBuffer SubMark=new StringBuffer();
  47. StringBuffer TF=new StringBuffer();
  48. StringBuffer Dif=new StringBuffer();
  49. int sub_num=0;
  50. Vector explain=new Vector();
  51. String [] arrMark=null;
  52. String [] arrAnswer=null;
  53. String [] arrSubAns=null;
  54. String [] arrTestID=null;
  55. String [] arrTF=null;
  56. String temp="";
  57. String subid="";//科目ID
  58. String markPercent="";//百分制的分数
  59. float testmark=0.0f;
  60. float totalmark=0.0f;
  61. int testNumber=0;
  62. try{
  63.     Connection con=DBCon.getConnection();
  65.     sql="select id,paper,title,testnum,subid from test where id="+testID;
  66.     pstmt=con.prepareStatement(sql);
  67.     rs=pstmt.executeQuery();
  68.    // pstmt.close();
  70.     if(debug){
  71.         out.print("<br>sql="+sql);
  72.     }
  73.     if(rs.next()){
  74.         //分析试题：试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  75.         if(debug) out.print("<br>begin:");
  76.         String paper=rs.getString("paper");
  77.         title=rs.getString("title");
  78.         testnum=rs.getInt("testnum");//总试题数量
  79.         subid=rs.getString("subid");
  81.         if(debug) out.print("<br>paper="+paper+"<br>testnum="+testnum);
  82.         String [] tests=paper.split("#");
  83.         for(int i=0;i<testnum;i++){
  84.             //取回试题号
  85.             String [] test=tests[i].split("@");
  86.             if(debug) {
  87.                 out.print("<BR>tests["+i+"]="+tests[i]);
  88.             }
  89.             testIDs.append(test[0]+",");//题号
  90.             Answer.append(test[1]+",");//答案
  91. Mark.append(test[2]+",");
  92.             Dif.append(test[3]+",");
  93.             testmark+=Float.parseFloat(test[2]);//总分数
  94.         }
  96.         arrMark=Mark.toString().split(",");
  97.         arrAnswer=Answer.toString().split(",");
  98.         arrTestID=testIDs.toString().split(",");
  99.         //根据arrTestID提取考生提交的答案信息，不填写的为"空";
  100.         if(debug){
  101.             out.print("<br>Mark="+Mark.toString());
  102.             out.print("<br>Answer="+Answer.toString());
  103.             out.print("<br>TestID="+testIDs.toString());
  104.             out.print("<br>Mark="+Mark.toString() );
  105.             out.print("<br>Dif="+Dif.toString());
  106.         }
  108.         //取回用户提交的答案
  109.         for(int i=0;i<testnum;i++){
  111.            temp=request.getParameter("radio"+arrTestID[i]);
  112.            if (temp==null){
  113.                SubAns.append("空"+",") ;
  114.                //arrSubAns[i]=new String("@");
  115.            }else{
  116.                SubAns.append(temp+",");
  117.                //arrSubAns[i]=new String(temp);
  118.            }
  119.         }
  120.         if(debug){
  121.             out.print("<br>Mark="+Mark.toString());
  122.             out.print("<br>Answer="+Answer.toString());
  123.             out.print("<br>TestID="+testIDs.toString());
  124.             out.print("<br>SubAns="+SubAns.toString());
  126.         }
  127.         arrSubAns=SubAns.toString().split(",");
  128.         //评分
  129.         correct=0;
  130.         error=0;
  131.         testmark=0;
  132.         totalmark=0.0f;
  133.         for(int i=0;i<testnum;i++)
  134.         {
  135.             if(valid==1 && old==0){
  136.                 jinghua.T_Question.addUsedCount(con,Integer.parseInt(arrTestID[i]));
  137.             }
  138.             totalmark+=Float.parseFloat(arrMark[i]);
  139.             if(arrSubAns[i].equals(arrAnswer[i])){
  140.                 if(valid==1 && old==0){
  141.                     jinghua.T_Question.addCorrectCount(con,Integer.parseInt(arrTestID[i]));
  142.                 }
  143.                 TF.append("T,");
  144.                 SubMark.append(arrMark[i]+",");
  145.                 correct++;
  146.                 if(debug){
  147.                     Tools.debugmsg("<br>arrMark["+i+"]="+arrMark[i],out);
  148.                 }
  149.                 testmark+=Float.parseFloat(arrMark[i]);
  150.             }else {
  151.                 error++;
  152.                 SubMark.append("0,");
  153.                 if(arrSubAns[i].equals(" "))
  154.                     TF.append("@,");
  155.                 else
  156.                     TF.append("F,");
  157.             }
  159.         }
  160.         if(debug){
  161.             out.print("<br>TF="+TF.toString() );
  162.             out.print("<br>SubMark="+SubMark.toString() );
  163.             out.print("<br>TF[2]="+TF.toString().charAt(2));
  164.         }
  165.         arrTF=TF.toString().split(",");
  166.         //考生信息
  167.         rs.close();
  168.         pstmt.close();
  169.         sql="select vcUserNo,vcName from UserInfo where vcUserNo="+"'"+studentID+"'";
  170.         pstmt=con.prepareStatement(sql);
  171.         rs=pstmt.executeQuery();
  172.         if(rs.next()){
  174.             name=""+rs.getString("vcName");
  175.         }
  176.         rs.close();
  177.         pstmt.close();
  181.         //将错题插入错题本
  182. for(int i=0;i<testnum;i++){
  183. if(debug) out.println("<BR>question error id="+arrTestID[i]+
  184.              ": result="+arrTF[i] );
  185. if(!arrTF[i].equals("T")){
  187. int count=0;
  188. sql=" select count(*) as errcount from errorpad where stu_id='"+studentID+"'"+
  189. " and question_id="+arrTestID[i];
  190. try{
  191.      stmt=con.createStatement();
  192.      rs=stmt.executeQuery(sql);
  193.      if(rs.next()){
  194. count=rs.getInt("errcount");
  195.      }
  196. rs.close();
  197. stmt.close();
  198. if(debug){
  199.              out.print("<br>errorpad question_id="+arrTestID[i]+
  200. "<br>count="+count);
  201.          }
  202. if(count==0){//插入新记录
  203. sql=" insert into errorpad(stu_id,question_id,add_date,errorcount,test_id,mn_test_id,sourcetype)"+
  204. " values('"+studentID+"',"+arrTestID[i]+",CURRENT_TIMESTAMP,1,"+testID+","+mn_testID+",3) ";
  205. stmt=con.createStatement();
  206. stmt.executeUpdate(sql);
  207. stmt.close();
  208. }else{
  209. sql=" update errorpad set errorcount=errorcount+1 where stu_id='"+studentID+"'"+
  210. " and question_id="+arrTestID[i];
  211. stmt=con.createStatement();
  212. stmt.executeUpdate(sql);
  213. stmt.close();
  214. }
  217. }
  218.      catch(SQLException se){
  219.              out.print("<br> query errorpad info error sql="+sql);
  220.          out.print("<br>"+se.toString());
  221.      }
  222.     catch(Exception e){
  223.          out.print("<br> query errorpad info error sql="+sql);
  224.         out.print("<br>"+e.toString());
  225.     }
  226. }//end_if
  227. }//end for errorpad
  233. //记录考试结果
  234. if(valid==1 && old==0){
  235.         DecimalFormat df=new DecimalFormat("###.0");//分数换算
  236.         markPercent=df.format(testmark/totalmark*100);
  237. //将分数记录到mn_scores表：
  238.         //查询mn_scores中是否有相应记录，有则删除
  239.         sql="select * from mn_scores where stu_id='"+studentID+"' and mn_test_id="+mn_testID+" and sub_id="+subid;
  240.         try{
  241.             stmt=con.createStatement();
  242.             rs=stmt.executeQuery(sql);
  243.             if(rs.next()){//已经有记录，则不更新
  244.                 rs.close();
  245.                 stmt.close();
  247.             }else
  248.             {
  249.                 rs.close();
  250.                 stmt.close();
  251.                 //在mn_scores中增加新的记录
  252.                 //构造test_rs串：正确答案串#分数串#个人答案串#TF串#难易度串#得分串
  253.                 //temp=Answer.toString()+"#"+Mark.toString()+"#"+SubAns.toString()+"#"+
  254.                 //TF.toString()+"#"+Dif.toString()+"#"+SubMark.toString();
  255.                 temp=SubAns.toString()+"#"+TF.toString()+"#"+SubMark.toString();
  257.                 sql=" insert into mn_scores(stu_id,mn_test_id,sub_id,score,tea_id,test_date,test_id,test_rs)"+
  258.                     " values( "+
  259.                      "'"+studentID+"',"+mn_testID+","+subid+","+testmark+",1,CURRENT_DATE,"+testID+",'"+
  260.                      temp+"'"+" )";
  262.                 try{
  263.                 stmt=con.createStatement();
  264.                 stmt.executeUpdate(sql);
  265.                 stmt.close();
  266.                 if(debug){
  267.                     out.print("<br>insert into mn_scores sql="+sql);
  268.                 }
  270.                 }catch(SQLException se){
  271.                     out.print("<br> insert into mn_scores error sql="+sql);
  272.                     out.print("<br>"+se.toString());
  273.                 }
  274.                 catch(Exception e){
  275.                     out.print("<br> insert into mn_scores error sql="+sql);
  276.                     out.print("<br>"+e.toString());
  277.                 }
  279.                     //检查这次模拟考试的总科目数
  280.         try{
  281.             sql="select sub_num from mn_test where id="+mn_testID;
  282.             stmt=con.createStatement();
  283.             rs=stmt.executeQuery(sql);
  284.             if(rs.next())
  285.                 sub_num=rs.getInt("sub_num");
  286.             else
  287.                 sub_num=Integer.MAX_VALUE;
  288.             rs.close();
  289.             stmt.close();
  290.             if(debug){
  291.                 out.print("<br>select subnum sql="+sql);
  292.             }
  293.         }
  294.         catch(SQLException se){
  295.             out.print("<br> query mn_test error sql="+sql);
  296.             out.print("<br>"+se.toString());
  297.         }
  298.         catch(Exception e){
  299.             out.print("<br> query mn_test error sql="+sql);
  300.             out.print("<br>"+e.toString());
  301.         }
  302.         //查询已经完成的科目数
  303.         int have_test=0;
  304.         try{
  305.             sql="select count(*) as tnum from mn_scores where stu_id='"+studentID+"' and mn_test_id="+mn_testID;
  306.             stmt=con.createStatement();
  307.             rs=stmt.executeQuery(sql);
  308.             if(rs.next()){
  309.                 have_test=rs.getInt("tnum");
  310.             }
  311.             rs.close();
  312.             stmt.close();
  313.             if(debug){
  314.                 out.print("<br>have test subs="+have_test);
  315.             }
  316.         }
  317.         catch(SQLException se){
  318.             out.print("<br> query mn_scores error sql="+sql);
  319.             out.print("<br>"+se.toString());
  320.         }
  321.         catch(Exception e){
  322.             out.print("<br> query mn_scores error sql="+sql);
  323.             out.print("<br>"+e.toString());
  324.         }
  327.         if(have_test==sub_num){
  330.             //如果完成了模拟考试，则在mn_history中增加记录，表明学生完成了这次测试
  331.             sql="select * from mn_history where stu_id='"+studentID+"' and mn_test_id="+mn_testID;
  332.             try{
  333.                 stmt=con.createStatement();
  334.                 rs=stmt.executeQuery(sql);
  335.                 if(rs.next()){
  336.                    rs.close();
  337.                    stmt.close();
  338.                 }else{
  339.                     rs.close();
  340.                     stmt.close();
  341.                     //查询这次模拟考试的总分及积各科目分数
  342.                      sql=" SELECT  `subject`.`id` AS  `subid`,`subject`.`Name` AS `subname`, "+
  343.                     " FORMAT(`test`.`mark`,0) AS `totalmark`,  FORMAT(`mn_scores`.`score`,0) AS `score` "+
  344.         " FROM  `mn_scores`  LEFT OUTER JOIN `subject` ON (`mn_scores`.`sub_id` = `subject`.`ID`)"+
  345.         " LEFT JOIN `test` ON (`mn_scores`.`test_id` = `test`.`id`)"+
  346.         " WHERE  (`mn_test_id` = "+mn_testID+") AND (`stu_id` = '"+studentID+"')"+
  347.         " ORDER BY `subid`";
  349.                         int his_subnum=0;
  350.                         int hisreal=0;
  351.                         sb=new StringBuffer();//化学:50#物理:20#英语:40#
  352.                         stmt=con.createStatement();
  353.                         rs=stmt.executeQuery(sql);
  355.                         while(rs.next()){
  356.                             his_subnum++;
  357.                             hisreal+=rs.getInt("score");
  358.                             sb.append(rs.getString("subname")+":"+rs.getString("score")+"#");
  359.                         }
  360.                         rs.close();
  361.                         stmt.close();
  370.                     sql="insert into mn_history(stu_id,mn_test_id,test_date,totalmark,submark,sub_num) "+
  371.                     " values('"+studentID+"',"+mn_testID+",CURRENT_DATE,"+hisreal+",'"+sb.toString()+"',"+
  372.                      his_subnum+")";
  374.                     stmt=con.createStatement();
  375.                     stmt.executeUpdate(sql);
  377.                 }
  378.                 if(debug){
  379.                     out.print("<br>insert into mn_history sql="+sql);
  380.                 }
  381.             }
  382.             catch(SQLException se){
  383.                 out.print("<br>insert into mn_history sql="+sql);
  384.                 out.print("<br>"+se.toString());
  385.             }
  386.             catch(Exception e){
  387.                 out.print("<br>insert into mn_history sql="+sql);
  388.                 out.print("<br>"+e.toString());
  389.             }
  390.             //增加参加考试的人数
  392.              //获取参加模拟考试的总人数,而且必须完成这次模拟考试的全部测试
  393.              int testPeople=0;
  394.             sql="SELECT count(*) as tested from mn_history where mn_test_id="+mn_testID;
  395.             try{
  396.                 stmt=con.createStatement();
  397.                 rs=stmt.executeQuery(sql);
  398.                 if(rs.next()){
  399.                     testPeople=rs.getInt("tested");
  400.                 }
  401.                 else{
  402.                     testPeople=0;
  403.                 }
  404.                 rs.close();
  405.                 stmt.close();
  406.             }
  407.             catch(SQLException se){
  408.                 out.print("<br> query mn_history error sql="+sql);
  409.                 out.print("<br>"+se.toString());
  410.             }
  411.             catch(Exception e){
  412.                 out.print("<br> query mn_history error sql="+sql);
  413.                 out.print("<br>"+e.toString());
  414.             }
  417.             //有人做完模拟考试
  418.             //将参加模拟考试的总人数写入数据库
  419.             try{
  420.             sql="update mn_test set testpeople="+testPeople+" where id="+mn_testID;
  421.             stmt=con.createStatement();
  422.             stmt.executeUpdate(sql);
  423.             stmt.close();
  424.             }
  425.             catch(SQLException se){
  426.                 out.print("<br> update mn_test.testpeople error sql="+sql);
  427.                 out.print("<br>"+se.toString());
  428.             }
  429.             catch(Exception e){
  430.                 out.print("<br> update mn_test.testpeople error sql="+sql);
  431.                 out.print("<br>"+e.toString());
  432.             }
  434.             if(debug){
  435.                 out.print("<br>mn_test totalpeople sql="+sql);
  436.                 out.print("<br>mn_test totalpeople="+testPeople);
  437.             }
  440.         }//end if(have_test==sub_num)
  444.         }
  445.         }catch(SQLException se){
  446.             out.print("<br> query mn_scores error sql="+sql);
  447.             out.print("<br>"+se.toString());
  448.         }
  449.         catch(Exception e){
  450.             out.print("<br> query mn_scores error sql="+sql);
  451.             out.print("<br>"+e.toString());
  452.         }
  455.         }//end if(valid=1)
  457.     //试题记录集
  458. sql=testIDs.toString().substring(0,testIDs.length()-1);
  459.         sql="select id,questtext,tip,mark from question where id in ("+sql+") order by id";
  460. pstmt=con.prepareStatement(sql);
  461.         rs=pstmt.executeQuery();
  462.      }
  463. %>
  470. <html>
  472. <head>
  473. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  474. <title>成绩查询 | 考试成绩 |  | 单项选择题</title>
  475. <link rel="stylesheet" type="text/css" href="../css.css">
  476. </head>
  478. <body>
  479. <center>
  480.   <table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
  481.     <tr>
  482.       <td width="100%" height="29" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
  483.         <img border="0" src="../images/cxcj.gif"></td>
  484.     </tr>
  485.     <tr>
  486.       <p>&nbsp;</p>
  487.     </tr>
  488.   </table>
  489.   <p>&nbsp;</p>
  490. </center>
  491. <div align="center">
  492.   <center>
  493.   <table cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="469" id="AutoNumber2" border="1">
  494.       <form method="POST" action=""><tr>
  495.       <td width="100%" height="25" bgcolor="#6699CC" background="images/admin_bg_1.gif" bordercolor="#799AE1">
  496.       <p align="center"><b>&nbsp;<font color="#FFFFFF">成绩单</font></b></td>
  497.     </tr>
  498.     <tr>
  499.       <td width="100%" height="160" bgcolor="#FFFDE8" bordercolor="#799AE1">
  501.         <p align="center">　</p>
  502.             <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="202">
  503.               <tr>
  504.                 <td width="8%" height="28"> <p align="right">考生编号：</td>
  505.                 <td height="28" colspan="4">　<%=studentID%></td>
  506.               </tr>
  507.               <tr>
  508.                 <td width="8%" height="29"> <p align="right">姓&nbsp;&nbsp;&nbsp;
  509.                     名：</td>
  510.                 <td height="29" colspan="4"><%=name%>&nbsp;</td>
  511.               </tr>
  512.               <tr>
  513.                 <td width="8%" height="29"> <p align="right">得&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;分：</td>
  514.                 <td width="13%" height="29">卷面分：</td>
  515.                 <td width="23%"><%=testmark%>&nbsp;</td>
  516.                 <td width="15%">百分制：</td>
  517.                 <td width="41%">
  518.                 <% DecimalFormat df=new DecimalFormat("###");
  519.                     String r=df.format(testmark/totalmark*100);
  520.                     out.print(r);
  521.                 %>
  522.             &nbsp;&nbsp;</td>
  523.               </tr>
  524.               <tr>
  525.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;错：</td>
  526.                 <td height="29" colspan="4"><%=error%>&nbsp;</td>
  527.               </tr>
  528.               <tr>
  529.                 <td width="8%" height="29"> <p align="right">答&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;对：</td>
  530.                 <td height="29" colspan="4"><%=correct%>&nbsp;</td>
  531.               </tr>
  532.               <tr>
  533.                 <td height="29"> <p align="right">正确答案：</p></td>
  534.                 <td height="29" colspan="4"><%=Answer.toString() %>&nbsp;</td>
  535.               </tr>
  536.               <tr>
  537.                 <td height="29"><p align="right">您的答案：</p></td>
  538.                 <td height="29" colspan="4"><%=SubAns.toString()%>&nbsp;</td>
  539.               </tr>
  540.             </table>
  541.         <p align="center">　</p>
  543.       </td>
  544.     </tr>
  545.     <tr>
  546.           <td width="100%" height="25" bgcolor="#FFFFFF" bordercolor="#799AE1"> <p align="center">
  547.               <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close2>
  548.               <span lang="en-us"> </span></td>
  550.  </tr></form>
  551.   </table>
  552.   </center>
  553. </div>
  554. <center><form name="viewdatabase"  ACTION=""  method="post">
  555.   <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="82">
  556.     <tr class="trh">
  557.       <td width="44" align="center" bgcolor="#799AE1" height="24">
  558.       <font color="#FFFFFF"><b>序号</b></font></td>
  559.         <td align="center" bgcolor="#799AE1" width="592" height="24"> <p align="center"><font color="#FFFFFF">
  560. <b>单项选择题（共<%=testnum%>&nbsp;题,<%=totalmark%>分）</b></font></td>
  561.     </tr>
  562. <% testNumber=0;
  563. while(rs.next()){%>
  564.     <tr class="trh1">
  565.         <td align="center"   height="35" width="44">　
  566. <center>
  567.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  568.               <tr>
  569.                 <td> <div align="center">
  570.                     <%out.print(testNumber+1);%>.
  571.                   </div></td>
  572.               </tr>
  573.               <tr>
  574.                 <td><div align="center">(<%=arrMark[testNumber]%>分)</div></td>
  575.               </tr>
  576.             </table>
  577.           </center>&nbsp;</td>
  578.         <td align="left" width="592" height="35"><br>
  579. <%
  581. out.print("正确答案是"+arrAnswer[testNumber]+",&nbsp;&nbsp;");
  583.                         if(arrTF[testNumber].equals("T")){
  584.                             out.print("您的答案是"+arrSubAns[testNumber] +"<br>");
  585.                         }else{
  586.                             out.print("<font color=Red>您的答案是"+arrSubAns[testNumber] +"</font><br>");
  587.                         }
  589. out.print("原题目:<br>"+rs.getString("questtext"));
  590. out.print("<br>提示：<br>"+""+rs.getString("tip"));
  591. testNumber++;
  592. %>
  593. </td>
  594.     </tr>
  595. <%}
  596.     rs.close();
  597.     pstmt.close();
  598.     %>
  599.     <tr>
  600.       <td align="center" bgcolor="#FFFFFF" height="16" width="640" colspan="2" bordercolor="#FFFFFF">
  601.       <p align="center">
  602.       <INPUT class="s02" onclick="window.close()" type=button value=返回 name=close>
  604.       </p>
  605.       </td>
  607.       </tr>
  610.   </table>
  611. </form>
  612.  </center>
  613.  <center> <form ACTION="" METHOD="GET">
  614.     <table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
  615.       <tr>
  616.         <td width="576">
  617.         <p ALIGN="center">&nbsp;</p>
  618.         <p>　</td>
  619.       </tr>
  620.     </table>
  621.   </form>
  622.  </center>
  623. </body>
  625. </html>
  626. <%}
  627. catch (Exception e){
  628.     if(debug){
  629.        Tools.debugmsg("<BR>Exception:"+e.toString() ,out);
  630.     }
  631. }
  632. finally{
  633.     DBCon.dropConnection();
  634. }
  635. %>