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

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

教育系统应用

开发平台：

WORD

Query_mark_mn_print.jsp：源码内容
  1. <%@ page contentType="application/msword; charset=gb2312" language="java" import="java.sql.*" %>
  2. <%@ page import="java.sql.*"%>
  3. <%@ page import="java.text.*"%>
  4. <%@ page import="jinghua.*"%>
  5. <%@ page import="java.util.*"%>
  6. <%@ page import = "jinghua.chart.servlet.WebHitChart" %>
  7. <%@ page import = "jinghua.chart.servlet.WebHitDataSet" %>
  8. <%@ page import = "java.io.PrintWriter" %>
  10. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  11. </jsp:useBean>
  12. <%!Connection con;
  13. //查询参加某次模拟考试的所有学生的ID
  14. String colwidth="";
  16. boolean debug=false;
  17. String studentID="";
  18. String gradenote="";
  19. String gradename="";
  20. int maxHisSubNum =0;
  21. String mn_testID="";
  22. Statement stmt=null;
  23. ResultSet rs=null;
  24. String sql="";
  25. String test_subs="";
  26. int sub_num=0;
  27. int have_test=0;
  28. int i=0;
  29. int j=0;
  30. long i10=0;
  31. long i30=0;
  32. float f10=0;
  33. float f30=0;
  34. DecimalFormat df=new DecimalFormat("####.00");
  35. class mn_test{
  36.     String id;
  37.     String name;
  38.     String gradenote;
  39.     String subs;
  40.     String totalMark;
  41.     int sub_num;
  42.     int testPeople;//全部参加人数
  43.     //参加完所有测试的学生的ID，用","分隔
  44. int flag;//1:complete;2:uncomplete;3:do not any test;
  45.     public String toString(){
  46.         String temp="";
  47.         temp="<br> id="+id+"<br> name="+name;
  48.         return temp;
  49.    }
  50. };
  51. class student{
  52.     String id;
  53.     String name;
  54.     String jh_area;
  55.     String school;
  56.     String jh_area_sch;
  57.     String grade;
  58.     String test_date;
  59.     int total_mark;//总分
  60.     String avgTop10;//top 10%的总分
  61.     String avgTop30;
  62.     int posAll;//全部排名
  63.     int posPercent;//100人排名
  65.     public String toString(){
  66.         String temp="";
  67.         temp="<br> id="+id+"<br> name="+name+"<br> grade="+grade+"<br>jh_area="+jh_area+
  68.         "<br>school="+school+"<br>jh_area_sch="+jh_area_sch+"<br>test_date="+test_date;
  69.         return temp;
  70.    }
  71. };
  72. class History{
  73.     long id;
  74.     String stu_id;
  75.     String mn_test_id;
  76.     int sub_num;
  77.     int testPeople;
  78.     String tested_id;
  79.     int totalmark;
  80.     String position;
  81.     String top10avg;
  82.     String top30avg;
  83.     String testdate;
  84.     String [] sub_names;
  85.     String [] sub_marks;
  86.     String debug;
  87.     public String toString(){
  88.         String temp="";
  89.         temp="<br> id="+id+"<br> stu_id="+stu_id+"<br> mn_test_id="+mn_test_id+
  90.             "<br>totalmark="+totalmark+"<br>position="+position+
  91.             "<br>top10avg="+top10avg+"<br>top30avg="+top30avg;
  92.         return temp;
  93.    }
  94. };
  95. class Subject{
  96.     int sub_id;
  97.     String name;
  98.     String totalMark;
  99.     String realMark;
  100.     String avgArea;
  101.     String avgTotal;
  102.     String avgTop10;
  103.     String avgTop30;
  104.     String posAll;//全部排名
  105.     String posPercent;//100人排名
  106.     int testnum=0;//试题数目
  107.     String [] arrAnswer;
  108.     String [] arrMark;
  109.     String [] arrSubAnswer;
  110.     String [] arrTF;
  111.     String [] arrDif;
  112.     String [] arrSubMark;
  113.     String [] arrRate;//准确率
  114.     String [] arrID;//question id数组
  115.     public String toString(){
  116.         String temp="";
  117.         temp="<br> sub_id="+sub_id+"<br> name="+name+"<br> totalMark="+totalMark+
  118.         "<br>avgArea="+avgArea+"<br>avgTotal="+avgTotal+"<br>avgTop10="+avgTop10+
  119.         "<br>avgTop30="+avgTop30+ "<br>posAll="+posAll+ "<br>posPercent="+posPercent;
  120.         return temp;
  121.    }
  122. };
  123. mn_test mnTest;
  124. student Student;
  125. Vector subs;
  126. Vector hisRS;
  127. %>
  128. <%
  131. try{
  132.     studentID=request.getParameter("stuID");
  133. mn_testID=request.getParameter("mn_testID");
  134.     //Tools.showalert(studentID,out);
  136. }catch(Exception e){
  137.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  138.     Tools.showJS("window.open('../login.jsp','_self')",out);
  139. }
  141. try{
  142.     con=DBCon.getConnection();
  143. String filenamemn =request.getParameter("filenamemn");// WebHitChart.generateMnBarChart(Long.parseLong(mn_testID), session, new PrintWriter(out));
  144. String graphURLmn = request.getContextPath()+"/chart/temp/"+filenamemn; //+ "/servlet/DisplayChart?filename=" + filenamemn;
  146.     String filenamestu = request.getParameter("filenamestu");//WebHitChart.generateStuHisXYChart(studentID, Long.parseLong(mn_testID),session, new PrintWriter(out));
  147. String graphURLstu = request.getContextPath()+"/chart/temp/"+filenamestu; //+ "/servlet/DisplayChart?filename=" + filenamestu;
  149.     out.print("<br>graphURLmn="+graphURLmn);
  150.     out.print("<br>graphURLstu="+graphURLstu);
  151.     //获取学生的年级信息
  152.     sql=" SELECT   `grade`.`Name`,  `grade`.`note` FROM"+
  153.         "  `grade`  INNER JOIN `UserInfo` ON (`grade`.`note` = `UserInfo`.`gradenote`)"+
  154.         " WHERE  (`UserInfo`.`vcUserNo` = '"+studentID+"')";
  156.     try{
  157.         stmt=con.createStatement();
  158.         rs=stmt.executeQuery(sql);
  160.         if(rs.next()){
  161.             gradenote=rs.getString("note");
  162.             gradename=rs.getString("Name");
  163.             rs.close();
  164.             stmt.close();
  165.         }
  166.         if(debug){
  167.             out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
  168.         }
  169.     }
  170.     catch(SQLException se){
  171.         out.print("<br> query student error sql="+sql);
  172.         out.print("<br>"+se.toString());
  173.     }
  174.     catch(Exception e){
  175.         out.print("<br> query student error sql="+sql);
  176.         out.print("<br>"+e.toString());
  177.     }
  181.     //获取模拟考试的科目信息
  182.     sql="select * from mn_test where id="+mn_testID;
  183.     try{
  184.         mnTest=new mn_test();
  185.         Student=new student();
  186.         subs=new Vector();
  187.         stmt=con.createStatement();
  188.         rs=stmt.executeQuery(sql);
  189.         if(rs.next()){
  190.             mnTest.subs=rs.getString("subs");
  191. if(mnTest.subs==null)
  192. mnTest.subs="-1";
  193. else if(mnTest.subs.equals(""))
  194. mnTest.subs="-1";
  195.             mnTest.id=mn_testID;
  196.             mnTest.name=rs.getString("name");
  197.             mnTest.sub_num=rs.getInt("sub_num");
  198.             mnTest.gradenote=gradenote;
  199.             mnTest.testPeople=rs.getInt("testpeople");
  200.         }
  201. rs.close();
  202.         stmt.close();
  203.         if(debug){
  204.             out.print("<br>mn_test_subs="+mnTest.subs+"<br>sub_num="+mnTest.sub_num);
  205.         }
  206.     }
  207.     catch(SQLException se){
  208.         out.print("<br> query mn_test error sql="+sql);
  209.         out.print("<br>"+se.toString());
  210.     }
  211.     catch(Exception e){
  212.         out.print("<br> query mn_test error sql="+sql);
  213.         out.print("<br>"+e.toString());
  214.     }
  215.     //
  216.     //如果完成了模拟考试，
  217.     have_test=0;
  218.     sql="select count(*) as have_test from mn_history where stu_id='"+studentID+"' and mn_test_id="+mn_testID;
  219.     try{
  220.         stmt=con.createStatement();
  221.         rs=stmt.executeQuery(sql);
  222.         if(rs.next()){
  223.             have_test=rs.getInt("have_test");
  224.         }
  225.         rs.close();
  226.         stmt.close();
  228.         if(debug){
  229.             out.print("<br>query mn_history sql="+sql);
  230.         }
  231.     }
  232.     catch(SQLException se){
  233.         out.print("<br>query mn_history sql="+sql);
  234.         out.print("<br>"+se.toString());
  235.     }
  236.     catch(Exception e){
  237.         out.print("<br>query mn_history sql="+sql);
  238.         out.print("<br>"+e.toString());
  239.     }
  240.     //查询该学生是否完成该模拟考试中的所有测试
  242. %>
  245. <%if(mnTest.sub_num==0){
  246.      Tools.showalert("模拟考试还没有进行！",out);
  247.                     Tools.showJS("window.close()",out);
  248. }else if (have_test<1){
  249.      Tools.showalert("您还没有全部参加完这次模拟考试的各科测试，不能统计分数！",out);
  250.                     Tools.showJS("window.close()",out);
  251. }else{
  254.     //查询模拟考试的总分
  255.     sql="select FORMAT(sum(mark),0) as totalmark from test,mn_scores "+
  256.         "where test.id=mn_scores.test_id and mn_test_id="+mn_testID+" and stu_id='"+
  257.         studentID+"'";
  258.     try{
  259.         stmt=con.createStatement();
  260.         rs=stmt.executeQuery(sql);
  261.         if(rs.next()){
  262.             mnTest.totalMark=rs.getString("totalmark");
  263.         }
  264. rs.close();
  265.         stmt.close();
  266.         if(debug){
  267.             out.print("<br>mn_test totalMark sql="+sql);
  268.             out.print("<br>mn_test totalMark="+mnTest.totalMark);
  269.         }
  270.     }
  271.     catch(SQLException se){
  272.         out.print("<br> query totalpeople error sql="+sql);
  273.         out.print("<br>"+se.toString());
  274.     }
  275.     catch(Exception e){
  276.         out.print("<br> query totalpeople error sql="+sql);
  277.         out.print("<br>"+e.toString());
  278.     }
  282.     //查询学生信息，生成成绩单，考试日期取为所有试卷最后做的时间
  283.     sql="SELECT   `UserInfo`.`vcName`,  `UserInfo`.`vcUserNo`, "+
  284.     "  DATE_FORMAT(`mn_scores`.`test_date`,"%Y-%m-%e") as test_date,  `UserInfo`.`vcSchool`,  `UserInfo`.`jh_area`,CONCAT(`UserInfo`.`jh_area`,'<br>(',`UserInfo`.`vcSchool`,')') AS jh_area_sch "+
  285.     "FROM  `UserInfo`  LEFT OUTER JOIN `grade` ON (`UserInfo`.`gradenote` = `grade`.`note`) "+
  286.     "LEFT OUTER JOIN `mn_scores` ON (`UserInfo`.`vcUserNo` = `mn_scores`.`stu_id`) "+
  287.     "WHERE UserInfo.vcUserNo='"+studentID+"' and mn_scores.mn_test_id="+mn_testID+
  288.     " and mn_scores.stu_id='"+studentID+"'"+
  289.     " ORDER BY test_date DESC"+
  290.     " LIMIT 1";
  291.     try{
  292.     stmt=con.createStatement();
  293.     rs=stmt.executeQuery(sql);
  294.     if(rs.next()){
  297.         Student.grade=gradename;
  298.         Student.id=rs.getString("vcUserNo");
  299.         Student.jh_area=rs.getString("jh_area");
  300.         Student.jh_area_sch=rs.getString("jh_area_sch");
  301.         Student.name=rs.getString("vcName");
  302.         Student.school=rs.getString("vcSchool");
  303.         Student.test_date=rs.getString("test_date");
  305.     }
  306.         rs.close();
  307.         stmt.close();
  308.         if(debug){
  309.             out.print("<br> query student info  sql="+sql);
  310.             //out.print("<br>student info="+Student.toString());
  311.         }
  312.     }
  313.     catch(SQLException se){
  314.         out.print("<br> query student info error sql="+sql);
  315.         out.print("<br>"+se.toString());
  316.     }
  317.     catch(Exception e){
  318.         out.print("<br> query student info error sql="+sql);
  319.         out.print("<br>"+e.toString());
  320.     }
  322.     //成绩和排名
  323.     //总分
  325.     try{
  326.     //个人总分
  327.     sql=" SELECT mn_history.stu_id,mn_history.mn_test_id,  FORMAT(SUM(mn_scores.score),0) AS totalmark"+
  328.         " FROM  `mn_history`  LEFT OUTER JOIN `mn_scores` ON  (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`) "+
  329.         "   AND (`mn_history`.`stu_id` = `mn_scores`.`stu_id`) "+
  330.         " WHERE mn_history.mn_test_id="+mnTest.id+" and mn_history.stu_id ='"+Student.id +"'"+
  331.         " GROUP BY mn_history.stu_id,mn_history.mn_test_id"+
  332.         " ORDER BY  totalmark desc";
  333.     stmt=con.createStatement();
  334.     rs=stmt.executeQuery(sql);
  335.     if(debug)
  336.         out.println("<br><br><br> person totalmark sql="+sql);
  337.     if(rs.next()){
  338.         Student.total_mark=rs.getInt("totalmark");
  339.     }
  340.     else{
  341.         Student.total_mark=0;
  342.     }
  343.     rs.close();
  344.     stmt.close();
  346.     //排名
  347.     i10=Math.round(mnTest.testPeople *0.1);//top10
  348.     i30=Math.round(mnTest.testPeople *0.3);
  349.     if(i10==0) i10=1;
  350.     if(i30==0) i30=1;
  351.     f10=0;
  352.     f30=0;
  354.     sql=" SELECT mn_history.stu_id,mn_history.mn_test_id,  FORMAT(SUM(mn_scores.score),0) AS totalmark"+
  355.         " FROM  mn_history LEFT OUTER JOIN mn_scores ON(mn_history.stu_id=mn_scores.stu_id) "+
  356.         " AND (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`)"+
  357.         " WHERE mn_history.mn_test_id="+mnTest.id+
  358.         " GROUP BY mn_history.stu_id,mn_history.mn_test_id"+
  359.         " ORDER BY  totalmark desc";
  360.     stmt=con.createStatement();
  361.     rs=stmt.executeQuery(sql);
  363.     i=0;
  364.     int imark=0;
  365.     int tempPos=1;
  366.     float fmark=0;
  367.     int tmark=Integer.MAX_VALUE;
  368.     while(rs.next()){
  369.         i++;
  370.         imark=rs.getInt("totalmark");
  371.         fmark=rs.getFloat("totalmark");
  373.         if(i<=i10)
  374.             f10+=fmark;
  375.         if(i<=i30)
  376.             f30+=fmark;
  377.         //查找分数的排名
  379.         if(debug){
  380.             out.print("<br><br>student totalmark="+Student.total_mark +
  381.             "<br>sql totalmark="+rs.getInt("totalmark"));
  382.         }
  383.         if(Student.total_mark==imark){
  384.             Student.posAll=tempPos;
  385.             if(mnTest.testPeople>100)
  386.                 Student.posPercent=100*tempPos/mnTest.testPeople;
  387.             else
  388.                 Student.posPercent=tempPos;
  389.         }
  390.         else if(tmark>imark){//分数不同
  391.             tempPos++;
  392.             tmark=imark;
  393.         }
  397.     }
  398.     rs.close();
  399.     stmt.close();
  400.     Student.avgTop10=df.format(f10/i10);
  401.     Student.avgTop30=df.format(f30/i30);
  404.     if(debug){
  405.         out.print("<br>Query student's position: sql="+sql);
  406.     }
  407.     }
  408.     catch(SQLException se){
  409.         out.print("<br> Query student's position sql="+sql);
  410.         out.print("<br>"+se.toString());
  411.     }
  412.     catch(Exception e){
  413.         out.print("<br> Query student's total position sql="+sql);
  414.         out.print("<br>"+e.toString());
  415.     }
  417.     //各科目的成绩单
  419.     sql=" SELECT  test.paper as testpaper,test.testnum as testnum,mn_scores.test_rs,`subject`.`id` AS  `subid`,`subject`.`Name` AS `subname`,  FORMAT(`test`.`mark`,0) AS `totalmark`,  FORMAT(`mn_scores`.`score`,0) AS `score` "+
  420.         " FROM  `mn_scores`  LEFT OUTER JOIN `subject` ON (`mn_scores`.`sub_id` = `subject`.`ID`)"+
  421.         " LEFT JOIN `test` ON (`mn_scores`.`test_id` = `test`.`id`)"+
  422.         " WHERE  (`mn_test_id` = "+mnTest.id+") AND (`stu_id` = '"+Student.id+"')"+
  423.         " ORDER BY `subid`";
  424.     try{
  425.         stmt=con.createStatement();
  426.         rs=stmt.executeQuery(sql);
  427.         String temp=null;
  428.         String [] arrtemp=null;
  429.         String [] tests=null;
  430.         while(rs.next()){
  431.             Subject s=new Subject();
  432.             s.sub_id=rs.getInt("subid");
  433.             s.name=rs.getString("subname");
  434.             s.totalMark=rs.getString("totalmark");
  435.             s.realMark=rs.getString("score");
  436.             s.testnum=rs.getInt("testnum");
  437.             //处理试题信息
  438.             temp=rs.getString("testpaper");
  439.             tests=temp.split("#");
  441.             StringBuffer Answer=new StringBuffer();
  442.             StringBuffer Mark=new StringBuffer();
  443.             StringBuffer Dif=new StringBuffer();
  444.             StringBuffer testIDs=new StringBuffer();
  445.             StringBuffer Rate=new StringBuffer();
  446.             for(i=0;i<s.testnum;i++){
  447.                 //取回试题号
  448.                 arrtemp=tests[i].split("@");
  450.                 testIDs.append(arrtemp[0]+",");//题号
  451.                 Rate.append(T_Question.getCorrectRate(con,Integer.parseInt(arrtemp[0]))+",");
  452.                 Answer.append(arrtemp[1]+",");//答案
  453.     Mark.append(arrtemp[2]+",");
  454.                 Dif.append(arrtemp[3]+",");
  455.             }
  456.             s.arrAnswer=Answer.toString().split(",");
  457.             s.arrDif=Dif.toString().split(",");
  458.             s.arrMark=Mark.toString().split(",");
  459.             s.arrID=testIDs.toString().split(",");
  460.             s.arrRate=Rate.toString().split(",");
  461.             Answer=null;
  462.             Mark=null;
  463.             Dif=null;
  464.             testIDs=null;
  465.             //处理科目考试结果
  466.             temp=rs.getString("test_rs");
  467.             arrtemp=temp.split("#");
  468.             //s.arrAnswer=arrtemp[0].split(",");
  469.             //s.arrMark=arrtemp[1].split(",");
  470.             s.arrSubAnswer=arrtemp[0].split(",");
  471.             s.arrTF=arrtemp[1].split(",");
  472.             //s.arrDif=arrtemp[4].split(",");
  473.             s.arrSubMark=arrtemp[2].split(",");
  477.             subs.addElement(s);
  478.         }
  479. rs.close();
  480.         stmt.close();
  481.         if(debug){
  482.             out.print("<br>subject info sql="+sql);
  483.             out.print("<br>subject info="+subs.toString());
  484.         }
  485.     }
  486.     catch(SQLException se){
  487.         out.print("<br> subject info error sql="+sql);
  488.         out.print("<br>"+se.toString());
  489.     }
  490.     catch(Exception e){
  491.         out.print("<br> subject info error sql="+sql);
  492.         out.print("<br>"+e.toString());
  493.     }
  494.     //科目的平均
  496.     try{
  497.         //分校平均
  498.         sql="SELECT   `UserInfo`.`jh_area`,  `mn_history`.`mn_test_id`,  `mn_scores`.`sub_id`,"+
  499.         "  FORMAT(AVG(`mn_scores`.`score`),2) AS `score_avg`"+
  500.         "  FROM  `mn_history` "+
  501.         "  LEFT OUTER JOIN `mn_scores` ON (`mn_history`.`stu_id` = `mn_scores`.`stu_id`) "+
  502.         "  AND (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`)"+
  503.         "  LEFT OUTER JOIN `UserInfo` ON (`mn_history`.`stu_id` = `UserInfo`.`vcUserNo`) "+
  504.         "  WHERE"+
  505.         "  (`UserInfo`.`jh_area` = '"+Student.jh_area+"') AND "+
  506.         "  (`mn_history`.`mn_test_id` = "+mnTest.id+") "+
  507.         "  GROUP BY  `UserInfo`.`jh_area`,  `mn_history`.`mn_test_id`,  `mn_scores`.`sub_id`"+
  508.         "  ORDER BY  `mn_scores`.`sub_id`";
  511.         stmt=con.createStatement();
  512.         rs=stmt.executeQuery(sql);
  513.         i=0;
  514.         Subject s=null;
  515.         while(rs.next()){
  516.             s=(Subject)subs.elementAt(i);
  517.             s.avgArea=rs.getString("score_avg");
  518.             i++;
  519.         }
  520. rs.close();
  521.         stmt.close();
  522.         if(debug){
  523.             out.print("<br>subject area_avg sql="+sql);
  524.             out.print("<br>subject info="+subs.toString());
  525.         }
  527.         //全体平均
  528.         sql="SELECT  `mn_scores`.`mn_test_id`,  `mn_scores`.`sub_id`,"+
  529.         "  FORMAT(AVG(`mn_scores`.`score`),2) AS `score_avg`"+
  530.         "  FROM  mn_history LEFT OUTER JOIN mn_scores ON(mn_history.stu_id=mn_scores.stu_id) "+
  531.         "  AND (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`)"+
  532.         "  WHERE mn_history.mn_test_id="+mnTest.id+
  533.         "  GROUP BY   `mn_scores`.`mn_test_id`,  `mn_scores`.`sub_id`"+
  534.         "  ORDER BY   `mn_scores`.`sub_id`";
  535.         stmt=con.createStatement();
  536.         rs=stmt.executeQuery(sql);
  537.         i=0;
  538.         s=null;
  539.         while(rs.next()){
  540.             s=(Subject)subs.elementAt(i);
  541.             s.avgTotal=rs.getString("score_avg");
  542.             i++;
  543.         }
  544. rs.close();
  545.         stmt.close();
  546.         if(debug){
  547.             out.print("<br>subject total sql="+sql);
  548.             out.print("<br>subject info="+subs.toString());
  549.         }
  551.     }
  552.     catch(SQLException se){
  553.         out.print("<br> subject total error sql="+sql);
  554.         out.print("<br>"+se.toString());
  555.     }
  556.     catch(Exception e){
  557.         out.print("<br> subject total error sql="+sql);
  558.         out.print("<br>"+e.toString());
  559.     }
  560.     //10% top 30% top
  561.     //
  562.     DecimalFormat df=new DecimalFormat("####.##");
  563.     for(j=0;j<subs.size();j++){
  564.     //每一科目
  565.     Subject s=(Subject)subs.elementAt(j);
  566.     try{
  567.         sql="  SELECT mn_history.mn_test_id,mn_history.stu_id, mn_scores.score, mn_scores.sub_id "+
  568.             "  FROM  mn_history LEFT OUTER JOIN mn_scores ON(mn_history.stu_id=mn_scores.stu_id) "+
  569.             "  AND (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`)"+
  570.             "  WHERE mn_history.mn_test_id="+mnTest.id+
  571.             "  AND  sub_id="+s.sub_id+
  572.             "  ORDER BY mn_scores.score DESC";
  574.         stmt=con.createStatement();
  575.         rs=stmt.executeQuery(sql);
  576.         //top10
  577.         i10=Math.round(mnTest.testPeople *0.1);
  578.         i30=Math.round(mnTest.testPeople *0.3);
  579.         if(i10==0) i10=1;
  580.         if(i30==0) i30=1;
  581.         f10=0;
  582.         f30=0;
  583.         if(debug){
  584.             out.print("<br><br><br>Begin:j="+j+"<br>sub_name="+s.name +
  585.             "<br>f10="+f10+"<br>i30="+i30+"<br>f30="+f30);
  587.         }
  588.         i=0;
  590.         int tempPos=1;
  591.          float fmark=Float.MAX_VALUE;
  593.         float tempf=0;
  594.         float realf=Float.parseFloat(s.realMark);
  595.         if(debug){
  596.             out.print("<br>top10-top30:"+
  597.                 "<br>i10="+i10+
  598.                 "<br>i30="+i30);
  599.         }
  600.         while(rs.next()){
  601.             tempf=rs.getFloat("score");
  603.             if(debug){
  604.                 out.print("<br>sub_real_mark="+realf+
  605.                 "<br>rs:score="+tempf);
  606.             }
  607.             i++;
  609.             if(i<=i10)
  610.                 f10+=tempf;
  611.             if(i<=i30)
  612.                 f30+=tempf;
  614.             if(tempf==realf){
  615.                         s.posAll=String.valueOf(tempPos);
  616.                         if(mnTest.testPeople<=100)
  617.                             s.posPercent=s.posAll;
  618.                         else
  619.                             s.posPercent=String.valueOf(100*tempPos/mnTest.testPeople);
  620.             }
  621.             else if(fmark>tempf){
  622.                 tempPos++;
  623.                 fmark=tempf;
  624.            }
  625.         }
  626.         if(debug){
  627.             out.print("<br>end:i10="+i10+"<br>f10="+f10+"<br>i30="+i30+
  628.                 "<br>f30="+f30+"<br>posall="+s.posAll);
  629.         }
  630.         rs.close();
  631.         stmt.close();
  632.         df=new DecimalFormat("####.00");
  633.         s.avgTop10=df.format(f10/i10);
  634.         s.avgTop30=df.format(f30/i30);
  637.         if(debug){
  638.             out.print("<br>avgTop10="+s.avgTop10+"<br>avgTop30="+s.avgTop30);
  639.             out.print("<br>subject top10-30 sql="+sql);
  640.         }
  642.     }
  643.     catch(SQLException se){
  644.         out.print("<br> subject info error sql="+sql);
  645.         out.print("<br>"+se.toString());
  646.     }
  647.     catch(Exception e){
  648.         out.print("<br> subject info error sql="+sql);
  649.         out.print("<br>"+e.toString());
  650.     }
  653.     }//end for
  656.     //更新历史记录
  657.     //先将这次查询的结果存入mn_history
  658.     try{
  659.         sql=" select * from mn_history where mn_test_id="+mnTest.id+
  660.             " and stu_id='"+Student.id+"'";
  661.         stmt=con.createStatement();
  662.         rs=stmt.executeQuery(sql);
  663.         if(rs.next()){
  664.             rs.close();
  665.             stmt.close();
  666.             StringBuffer sb=new StringBuffer();
  667.             for(i=0;i<subs.size();i++){
  668.                 Subject s=(Subject)subs.elementAt(i);
  669.                 sb.append(s.name+":"+s.realMark+"#");
  670.                 }
  673.             sql=" update mn_history set totalmark="+Student.total_mark+","+
  674.                 " submark='"+sb.toString()+"',test_date='"+Student.test_date+"',"+
  675.                 " sub_num="+mnTest.sub_num+","+
  676.                 " totalpeople="+mnTest.testPeople+","+
  677.                 " position="+Student.posAll+","+
  678.                 " top10avg="+Student.avgTop10+","+
  679.                 " top30avg="+Student.avgTop30+
  680.                 " where stu_id='"+Student.id+"' and mn_test_id="+mnTest.id;
  682.             stmt=con.createStatement();
  683.             stmt.executeUpdate(sql);
  685.             if(debug) out.println("<br>update mn_history sql="+sql);
  686.             stmt.close();
  688.         }
  689.         else{
  690.             //将新记录插入数据库
  691.             rs.close();
  692.             stmt.close();
  693.             StringBuffer sb=new StringBuffer();
  694.             for(i=0;i<subs.size();i++){
  695.                 Subject s=(Subject)subs.elementAt(i);
  696.                 sb.append(s.name+":"+s.realMark+"#");
  697.                 }
  698.             sql=" insert into mn_history(stu_id,mn_test_id,totalmark,submark,test_date,sub_num,"+
  699.                 " position,top10avg,top30avg,testpeople) "+
  700.                 " values('"+Student.id+"',"+mnTest.id+","+Student.total_mark+",'"+
  701.                     sb.toString()+"','"+Student.test_date+"',"+mnTest.sub_num+","+
  702.                     Student.posAll+","+Student.avgTop10+","+Student.avgTop30+","+mnTest.testPeople+")";
  703.             stmt=con.createStatement();
  704.             stmt.executeUpdate(sql);
  705.             stmt.close();
  706.         }
  708.     }catch(SQLException se){
  709.         out.print("<br> insert into mn_history sql="+sql);
  710.         out.print("<br>"+se.toString());
  711.     }
  712.     catch(Exception e){
  713.         out.print("<br> insert into mn_history sql="+sql);
  714.         out.print("<br>"+e.toString());
  715.     }
  717.     //从mn_history中选取记录 stu_id,mn_test_id,totalmark,submark,test_date
  718.      try{
  719.  
  720.   sql="SELECT   MAX(`mn_history`.`sub_num`) AS `maxsub` FROM  `mn_history`"+
  721. " WHERE  (stu_id = '"+Student.id+"')";
  722. stmt=con.createStatement();
  723.         rs=stmt.executeQuery(sql);
  724.         
  725.         if(rs.next())
  726.           maxHisSubNum=rs.getInt("maxsub");
  727. else
  728. maxHisSubNum=0;
  729. rs.close();
  730. stmt.close();
  731.         sql=" SELECT   `mn_test`.`sub_num`,`mn_test`.`testpeople`,`mn_history`.`totalpeople`,  "+
  732.             " `mn_history`.`mn_test_id`,  `mn_history`.`totalmark`,  `mn_history`.`position`,"+
  733.             " `mn_history`.`top10avg`,  `mn_history`.`top30avg`,  `mn_history`.`submark`,"+
  734.             " DATE_FORMAT(`mn_history`.`test_date`,"%Y-%m-%e") AS `test_date`, "+
  735.             " `mn_history`.`stu_id` "+
  736.             " FROM  `mn_history`  LEFT OUTER JOIN `mn_test` ON (`mn_history`.`mn_test_id` = `mn_test`.`id`)"+
  737.             " WHERE  (`mn_history`.`stu_id` = '"+Student.id+"')"+" AND (`mn_test`.`grade_note` = '"+gradenote +"')"+
  738.             " ORDER BY  `test_date` DESC";
  739.         stmt=con.createStatement();
  740.         rs=stmt.executeQuery(sql);
  741.         hisRS=new Vector();
  742.         if(debug)
  743.             out.print("<br> query mn_history sql="+sql);
  744.         String submarks;
  746.         while(rs.next()){
  747.         //构造一条历史记录/
  749.             History h=new History();
  751.             h.sub_num=rs.getInt("sub_num");
  752.             h.testdate=rs.getString("test_date");
  753.             h.mn_test_id=rs.getString("mn_test_id");
  754.             h.stu_id=rs.getString("stu_id");
  755.             h.totalmark=rs.getInt("totalmark");
  756.             submarks=rs.getString("submark");
  757.             h.sub_marks=submarks.split("#");
  759.             if(rs.getInt("testpeople")==rs.getInt("totalpeople")){
  760.                 //模拟考试的总人数没有变化
  761.                 h.top10avg=rs.getString("top10avg");
  762.                 h.top30avg=rs.getString("top30avg");
  763.                 h.position=rs.getString("position");
  764.                 h.testPeople=rs.getInt("totalpeople");
  765.             }
  766.             else{
  767.             //历史排名 //重新求排名
  768.             h.testPeople=rs.getInt("testpeople");
  769.             i10=Math.round(h.testPeople *0.1);//top10
  770.             i30=Math.round(h.testPeople *0.3);
  771.             if(i10==0) i10=1;
  772.             if(i30==0) i30=1;
  773.             f10=0;
  774.             f30=0;
  775.         try{
  776.             sql=" SELECT mn_history.stu_id,mn_history.mn_test_id,  FORMAT(SUM(mn_scores.score),0) AS totalmark"+
  777.                 " FROM  mn_history LEFT OUTER JOIN mn_scores ON(mn_history.stu_id=mn_scores.stu_id) "+
  778.                 " AND (`mn_history`.`mn_test_id` = `mn_scores`.`mn_test_id`)"+
  779.                 " WHERE mn_history.mn_test_id="+h.mn_test_id+
  780.                 " GROUP BY mn_history.stu_id,mn_history.mn_test_id"+
  781.                 " ORDER BY  totalmark desc";
  782.             Statement tempstmt=con.createStatement();
  783.             ResultSet temprs=tempstmt.executeQuery(sql);
  785.             i=0;
  786.             int imark=0;
  787.             int tempPos=1;
  788.             float fmark=0;
  789.             int tmark=Integer.MAX_VALUE;
  790.             while(temprs.next()){
  791.                 i++;
  792.                 imark=temprs.getInt("totalmark");
  793.                 fmark=temprs.getFloat("totalmark");
  795.                 if(i<=i10)
  796.                     f10+=fmark;
  797.                 if(i<=i30)
  798.                     f30+=fmark;
  799.                 //查找分数的排名
  801.                 if(debug){
  802.                     out.print("<br><br>history student totalmark="+Student.total_mark +
  803.                         "<br>sql totalmark="+temprs.getInt("totalmark"));
  804.                 }
  806.                 if(h.totalmark==imark){
  807.                     h.position=String.valueOf(tempPos);
  808.                     //Student.posAll=tempPos;
  809.                 }
  810.                 else if(tmark>imark){//分数不同
  811.                     tempPos++;
  812.                     tmark=imark;
  813.                 }
  814.             }//end while
  815.             temprs.close();
  816.             tempstmt.close();
  817.             df=new DecimalFormat("####.00");
  818.             h.top10avg=df.format(f10/i10);
  819.             h.top30avg=df.format(f30/i30);
  821.             if(debug){
  822.                 out.print("<br>Query history student's position: sql="+sql);
  823.             }
  824.         }
  825.         catch(SQLException se){
  826.             out.print("<br> Query history student's position sql="+sql);
  827.             out.print("<br>"+se.toString());
  828.         }
  829.         catch(Exception e){
  830.             out.print("<br> Query history student's total position sql="+sql);
  831.             out.print("<br>"+e.toString());
  832.         }
  834.         //将查询回的信息写入数据库
  835.         try{
  836.             sql=" update mn_history set "+
  837.                 " totalpeople="+h.testPeople+","+
  838.                 " position="+h.position+","+
  839.                 " top10avg="+h.top10avg+","+
  840.                 " top30avg="+h.top30avg+
  841.                 " where stu_id='"+Student.id+"' and mn_test_id="+mnTest.id;
  843.             stmt=con.createStatement();
  845.             stmt.executeUpdate(sql);
  846.             if(debug) out.println("<br> update mn_history sql="+sql);
  847.         }
  848.         catch(SQLException se){
  849.             out.print("<br> update history  position sql="+sql);
  850.             out.print("<br>"+se.toString());
  851.         }
  852.         catch(Exception e){
  853.             out.print("<br> update history  position sql="+sql);
  854.             out.print("<br>"+e.toString());
  855.         }
  857.         }//end else
  859.         hisRS.addElement(h);
  861.         }//end while
  864.     }catch(SQLException se){
  865.         out.print("<br> select from mn_history error sql="+sql);
  866.         out.print("<br>"+se.toString());
  867.     }
  868.     catch(Exception e){
  869.         out.print("<br> select from mn_history error sql="+sql);
  870.         out.print("<br>"+e.toString());
  871.     }
  875.     %>
  882. <HTML><HEAD><TITLE>模拟考试成绩查询</TITLE>
  883. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  884. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  885. <style media="print">
  886. .noprint { display: none }
  887. </style>
  888. </HEAD>
  889. <BODY>
  893. <table width="107%" height=440 border=0 align="center" bordercolor=#d3add1>
  894.   <tbody>
  895.       <tr>
  896.         <td height="32" align="center" valign=middle><strong><font size="+2" face="宋体">个人成绩单(表)</font></strong>
  897.         </td>
  898.       </tr>
  899.       <tr>
  900.         <td height="43" align="center" valign=middle><table width="100%" border="0">
  901.           <tr>
  902.             <td width="44%" height="20" nowrap>考试名称:&nbsp;</td>
  903.             <td width="13%">&nbsp;</td>
  904.             <td width="43%" height="20" nowrap>
  905.               <div align="left">共创教育研究院</div></td>
  906.           </tr>
  907.           <tr>
  908.             <td height="20"><%--=Student.jh_area--%>
  909.               <%=mnTest.name%></td>
  910.             <td>&nbsp;</td>
  911.             <td width="43%" height="20" nowrap>
  912.               <div align="left">电话：010-68130545</div></td>
  913.           </tr>
  914.           <tr>
  915.             <td height="20"><em></em><%--=Student.school--%></em></td>
  916.             <td>&nbsp;</td>
  917.             <td width="43%" height="20" nowrap>
  918.               <div align="left">网址：cosoft.org.cn</div></td>
  919.           </tr>
  920.         </table></td>
  921.       </tr>
  922.       <tr>
  923.         <td height="168" align="center" valign="top"><table width="100%" border="1" cellpadding="0" cellspacing="0">
  924.             <tr>
  926.             <td height="24" width="20%">
  927.               <div align="center">所属</div></td>
  928.               <td width="20%"><div align="center">姓名</div></td>
  929.               <td width="20%"><div align="center">学号</div></td>
  930.               <td width="20%"><div align="center">年级</div></td>
  931.               <td width="20%"><div align="center">考试日期</div></td>
  932.             </tr>
  933.             <tr>
  935.             <td height="24" nowrap>
  936.               <div align="center"><%--=Student.jh_area_sch--%><%=Student.school%></div></td>
  937.               <td><div align="center"><%=Student.name%></div></td>
  938.               <td><div align="center"><%=Student.id%></div></td>
  939.               <td><div align="center"><%=Student.grade%></div></td>
  940.               <td><div align="center"><%=Student.test_date%></div></td>
  941.             </tr>
  942.           </table>
  943.           <div align="left"><br>
  944.             成绩和排名:</div>
  945.           <table width="100%" border="1" cellpadding="0" cellspacing="0">
  946.             <tr>
  948.             <td height="24" width="21%">
  949.               <div align="center">成绩</div></td>
  950.               <td width="14%"><div align="center">10%平均</div></td>
  951.               <td width="14%"><div align="center">30%平均</div></td>
  952.               <td width="32%"> <div align="center" width="33%">全部参加人员排名</div></td>
  953.               <td width="19%"> <div align="center" width"33%">100人换算排名</div></td>
  954.             </tr>
  955.             <tr valign="middle">
  957.             <td height="24" nowrap>
  958.               <div align="center"><%=Student.total_mark%>分(满分<%=mnTest.totalMark%>分)</div></td>
  960.             <td nowrap>
  961. <div align="center"><%=Student.avgTop10%>分</div></td>
  962.               <td><div align="center"><%=Student.avgTop30%></div></td>
  964.             <td nowrap>
  965.               <div align="center"><%=Student.posAll%>名(全部参加排名者<%=mnTest.testPeople%>人)</div></td>
  967.             <td nowrap>
  968.               <div align="center"><%=Student.posPercent%></div></td>
  969.             </tr>
  970.           </table>
  971.           <div align="left"><br>
  972.             成绩单:</div>
  973.           <table width="100%" border="1" cellpadding="0" cellspacing="0">
  974.             <tr>
  976.             <td width="12%" height="24">&nbsp;</td>
  978.             <td width="11%" nowrap>
  979. <div align="center">分数</div></td>
  981.             <td width="11%" nowrap>
  982. <div align="center">得分</div></td>
  984.             <!--td width="11%" nowrap>
  985. <div align="center">分校平均</div></td-->
  987.             <td width="11%" nowrap>
  988. <div align="center">全体平均</div></td>
  990.             <td width="11%" nowrap>
  991. <div align="center">10%平均</div></td>
  993.             <td width="11%" nowrap>
  994. <div align="center">30%平均</div></td>
  996.             <td width="11%" nowrap>
  997. <div align="center">总排名</div></td>
  999.             <td width="11%" nowrap>
  1000. <div align="center">100名排名</div></td>
  1001.             </tr>
  1002.             <%
  1003.               for(i=0;i<subs.size();i++){
  1004.                 Subject s=(Subject)subs.elementAt(i);
  1005.               %>
  1006.             <tr valign="middle">
  1008.             <td height="24" nowrap >
  1009.               <div align="center"><%=s.name%></div></td>
  1011.             <td nowrap>
  1012.               <div align="center"><%=s.totalMark%></div></td>
  1014.             <td nowrap>
  1015.               <div align="center"><%=s.realMark%></div></td>
  1017.             <!--td nowrap>
  1018. <div align="center"><%=s.avgArea%></div></td-->
  1020.             <td nowrap>
  1021. <div align="center"><%=s.avgTotal%></div></td>
  1023.             <td nowrap>
  1024. <div align="center"><%=s.avgTop10%></div></td>
  1026.             <td nowrap>
  1027. <div align="center"><%=s.avgTop30%></div></td>
  1029.             <td nowrap>
  1030. <div align="center"><%=s.posAll%></div></td>
  1032.             <td nowrap>
  1033. <div align="center"><%=s.posPercent%></div></td>
  1034.             </tr>
  1035.             <%}%>
  1036.           </table>
  1037.   <div align="left"><br>
  1038.             判分表及难易度：准确率 A(0～20%)、B(21～40%)、C(41～60%)、D(61～80%)、E(81～100%) :</div>
  1040.             <%
  1041.             df=new DecimalFormat("00");
  1042.             for(i=0;i<subs.size();i++){
  1043.                 Subject s=(Subject)subs.elementAt(i);
  1044.                 colwidth=" width=""+String.valueOf(80.00/s.testnum)+"%"";
  1045.          %>
  1055.           <table width="100%" border="1" cellspacing="0" cellpadding="0">
  1056.             <tr>
  1058.             <td width="8%" height="24" nowrap>
  1059.               <div align="center"><strong><font size="+1">科目</font></strong></div></td>
  1061.             <td width="92%" height="24" colspan="<%=s.testnum+1%>">&nbsp;
  1062.             </td>
  1063.             </tr>
  1064.             <tr>
  1065.               <td rowspan="8"  width="8%"><div align="center"><%=s.name%></div></td>
  1067.             <td width="12%" height="20" nowrap>
  1068.               <div align="center">题号</div></td>
  1069.               <%for(j=1;j<=s.testnum;j++)
  1070.                   out.println("<td "+colwidth+"><div align="center">"+df.format(j)+"</div></td>");
  1071.               %>
  1072.             </tr>
  1073.             <tr>
  1075.             <td   height="20" nowrap>
  1076.               <div align="center">正确答案</div></td>
  1077.               <%for(j=0;j<s.arrAnswer.length;j++)
  1078.                   out.println("<td "+colwidth+"><div align="center">"+s.arrAnswer[j]+"</div></td>");
  1079.               %>
  1080.             </tr>
  1081.             <tr>
  1083.             <td   height="20" nowrap>
  1084.               <div align="center">个人答案</div></td>
  1085.               <%for(j=0;j<s.arrSubAnswer.length;j++)
  1086.                   out.println("<td "+colwidth+"><div align="center">"+s.arrSubAnswer[j]+"</div></td>");
  1087.               %>
  1088.             </tr>
  1089.             <tr>
  1091.             <td height="20"  >
  1092.               <div align="center">对错</div></td>
  1093.               <%for(j=0;j<s.arrTF.length;j++)
  1094.                   out.println("<td "+colwidth+"><div align="center">"+s.arrTF[j]+"</div></td>");
  1095.               %>
  1096.             </tr>
  1097.             <tr>
  1099.             <td height="20" nowrap>
  1100.               <div align="center">分值</div></td>
  1101.               <%for(j=0;j<s.arrMark.length;j++)
  1102.                   out.println("<td "+colwidth+"><div align="center">"+s.arrMark[j]+"</div></td>");
  1103.               %>
  1104.             </tr>
  1105.             <tr>
  1107.             <td  height="20" nowrap>
  1108.               <div align="center">得分</div></td>
  1109.                <%for(j=0;j<s.arrSubMark.length;j++)
  1110.                   out.println("<td "+colwidth+"><div align="center">"+s.arrSubMark[j]+"</div></td>");
  1111.               %>
  1112.             </tr>
  1113.             <tr>
  1115.             <td  height="20" nowrap>
  1116.               <div align="center">难易度</div></td>
  1117.               <%for(j=0;j<s.arrDif.length;j++)
  1118.                   out.println("<td "+colwidth+"><div align="center">"+s.arrDif[j]+"</div></td>");
  1119.               %>
  1120.             </tr>
  1121.             <tr>
  1123.             <td  height="20" nowrap>
  1124.               <div align="center">准确率</div></td>
  1125.               <%for(j=0;j<s.arrDif.length;j++)
  1126.                   out.println("<td "+colwidth+"><div align="center">"+s.arrRate[j]+"</div></td>");
  1127.               %>
  1128.             </tr>
  1129.           </table>
  1132.           <%}//end for 科目判分%>
  1134.           <div align="left"><br>
  1135.             历史记录 :</div>
  1136.         <%
  1138.         colwidth=" width=""+String.valueOf(88.00/(maxHisSubNum+4))+"%"";
  1140.         %>
  1141.           <table width="100%" border="1" cellpadding="0" cellspacing="0">
  1142.             <tr>
  1144.             <td width="12%" height="24" nowrap>
  1145.               <div align="center"><strong>考试日期</strong></div></td>
  1146.               <td <%=colwidth%> nowrap><div align="center"><strong>总分</strong></div></td>
  1147.               <td <%=colwidth%> nowrap><div align="center"><strong>10%平均</strong></div></td>
  1148.               <td <%=colwidth%> nowrap><div align="center"><strong>30%平均</strong></div></td>
  1149.               <td <%=colwidth%> nowrap><div align="center"><strong>排名</strong></div></td>
  1150.               <%
  1151.                /*
  1152.     for(i=0;i<subs.size();i++){
  1153.                     out.println("<td "+colwidth+" nowrap><div align="center"><strong>"+
  1154.                         ((Subject)subs.elementAt(i)).name+"</div></td>");
  1155.                 }
  1156. */
  1157. for(i=0;i<maxHisSubNum;i++){
  1158.                     out.println("<td "+colwidth+" nowrap>&nbsp;</td>");
  1159.                 }
  1160.               %>
  1162.             </tr>
  1163.             <%for(i=0;i<hisRS.size();i++){
  1164.                 History h=(History)hisRS.elementAt(i);
  1165.             %>
  1166.             <tr>
  1168.             <td height="20" nowrap>
  1169.               <div align="center"><%=h.testdate%></div></td>
  1170.               <td nowrap>
  1171. <div align="center"><%=h.totalmark%></div></td>
  1172.               <td nowrap>
  1173. <div align="center"><%=h.top10avg%></div></td>
  1174.               <td nowrap>
  1175. <div align="center"><%=h.top30avg%></div></td>
  1176.               <td nowrap>
  1177. <div align="center"><%=h.position%></div></td>
  1178.                 <%for(j=0;j<h.sub_num;j++)
  1179.                 {   String [] submark=h.sub_marks[j].split(":");
  1180.                     //out.println("<td><div align="center">"+submark[1]+"</div></td>");
  1181.                     out.println("<td nowrap><div align="center">"+h.sub_marks[j]+"</div></td>");
  1182.                 }
  1183. for(;j<maxHisSubNum;j++)
  1184. out.println("<td nowrap>&nbsp;</td>");
  1185.                 %>
  1187.             </tr>
  1188.             <%}%>
  1189.           </table>
  1190.           <br><br>
  1191. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  1192.             <tr>
  1193.               <td width="0%">&nbsp;</td>
  1194.               <td width="45%"><div align="right"><img src="<%= graphURLmn %>" width=350 height=250 border=0 ></div></td>
  1195.               <td width="8%">&nbsp;</td>
  1196.               <td width="47%"><img src="<%= graphURLstu %>" width=350 height=250 border=0 ></td>
  1197.             </tr>
  1198.             <tr>
  1199.               <td>&nbsp;</td>
  1200.               <td><div align="right"></div></td>
  1201.               <td>&nbsp;</td>
  1202.               <td>&nbsp;</td>
  1203.             </tr>
  1204.           </table>
  1205.         </td>
  1206.       </tr>
  1207.       <tr>
  1208.         <td align="center" valign=middle></td>
  1209.       </tr>
  1210.     </tbody>
  1211.   </table>
  1212.   </div>
  1213.   <P> </P>
  1214. <P>&nbsp;</P>
  1215. <P>&nbsp;</P>
  1217. </BODY></HTML>
  1219. <%
  1220. }
  1221. }
  1222. catch(Exception e){
  1223.     System.out.print(e.toString());
  1224. }
  1225. finally{
  1226.     DBCon.dropConnection();
  1227. }
  1228. %>