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

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

教育系统应用

开发平台：

WORD

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