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

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

教育系统应用

开发平台：

WORD

stu_test_mn.jsp：源码内容
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  4. <%@ page contentType="text/html; charset=gb2312" language="java"%>
  5. <%@ page import="java.sql.*" %>
  6. <%@ page import="jinghua.*"%>
  7. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  8. </jsp:useBean>
  9. <%!Connection con;
  10. boolean debug=false;
  11. String studentID="";
  12. String gradenote="";
  13. Statement stmt=null;
  14. ResultSet rs=null;
  15. String sql="";
  16. %>
  17. <%
  19. try{
  20.     studentID=(String)session.getAttribute("studentID");
  21.     if(studentID==null){
  22.         throw new Exception();
  23.     }
  24. }catch(Exception e){
  25.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  26.    Tools.showJS("window.open('../login.jsp','_self')",out);
  27. }
  29. try{
  30.     con=DBCon.getConnection();
  31.     //获取学生的年级信息
  32.     //sql="select id,gradenote,grade.Name as gn "+
  33.     //"from student  INNER JOIN grade ON (student.gradenote = grade.note) "+
  34.     //" where stuid='"+studentID+"'";
  35.     sql="select id,gradenote from UserInfo where vcUserNo='"+studentID+"'";
  37.     try{
  38.         stmt=con.createStatement();
  39.         rs=stmt.executeQuery(sql);
  40.         if(rs.next()){
  41.             gradenote=rs.getString("gradenote");
  42.             rs.close();
  43.             stmt.close();
  44.         }
  45.         if(debug){
  46.             out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
  47.         }
  48.     }
  49.     catch(SQLException se){
  50.         out.print("<br> query student error sql="+sql);
  51.         out.print("<br>"+se.toString());
  52.     }
  53.     catch(Exception e){
  54.         out.print("<br> query student error sql="+sql);
  55.         out.print("<br>"+e.toString());
  56.     }
  58. %>
  59. <HTML><HEAD><TITLE>共创学堂</TITLE>
  60. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  61. <LINK
  62. href="style/style.css" type=text/css rel=stylesheet>
  63. <SCRIPT src="js/html.js"></SCRIPT>
  65. <SCRIPT src="js/gnb_menus_layer.js"></SCRIPT>
  67. <SCRIPT src="js/menu.js"></SCRIPT>
  69. <SCRIPT src="js/jumpmenu.js"></SCRIPT>
  71. <SCRIPT src="js/Valid.js"></SCRIPT>
  73. <META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
  74. <BODY bgColor=#ffffff text=#000000 vlink="#0000FF">
  75. <CENTER>
  76. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  77.   <TBODY>
  78.   <TR>
  79.       <TD vAlign=bottom align=right width=160><A
  80.       href="http://jsptestonline.cosoft.org.cn/"><IMG height=45 src="images/logo.gif"
  81.       width=160></A></TD>
  82.     <TD align=right>
  83.       <TABLE cellSpacing=0 cellPadding=0 width=260 border=0>
  84.         <TBODY>
  85.         <TR>
  86.             <TD vAlign=bottom width=7 bgColor=#b2aeb8><IMG height=18
  87.             src="images/pic_top_y.gif" width=7></TD>
  88.           <TD align=right bgColor=#b2aeb8>
  89.             <TABLE height=18 cellSpacing=0 cellPadding=0 width=240 border=0>
  90.               <TBODY>
  91.               <TR>
  92.                   <TD><IMG height=11 src="images/ico_t_mail.gif"
  93.                 width=13></TD>
  94.                 <TD><A class=black
  95.                   href="http://jsptestonline.cosoft.org.cn/help/use/use_004.jsp">在线咨询</A></TD>
  96.                   <TD><IMG height=15 src="images/ico_t_help.gif"
  97.                 width=13></TD>
  98.                 <TD><A class=black
  99.                   href="http://jsptestonline.cosoft.org.cn/help/buy/buy_001.jsp">申请服务</A></TD>
  100.                   <TD><IMG height=13 src="images/ico_t_lc.gif"
  101.                 width=14></TD>
  102.                 <TD><A class=black
  103.                   href="http://jsptestonline.cosoft.org.cn/help/product/pro_001.jsp">产品介绍</A></TD>
  104.                   <TD width=10><IMG height=10 src="images/blank.gif"
  105.                   width=10></TD>
  106.                 </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  107.       <TABLE height=12 cellSpacing=0 cellPadding=0 width=100 border=0>
  108.         <TBODY>
  109.         <TR>
  110.             <TD><IMG height=1 src="images/blank.gif"
  111.         width=618></TD>
  112.           </TR></TBODY></TABLE>
  113.       <TABLE cellSpacing=0 cellPadding=0>
  114.         <TBODY>
  115.         <TR>
  116.           <TD>
  117.             <TABLE style="PADDING-BOTTOM: 1px" cellSpacing=0 cellPadding=0
  118.             border=0>
  119.               <TBODY>
  120.               <TR>
  121.                         <TD id=gnb_link_www
  122.                 onmouseover="javascript:showSubMenuLayer('www')"
  123.                 style="POSITION: relative"
  124.                 onmouseout="javascript:hideSubMenuLayer('www')" align=middle
  125.                 width=40><SPAN class=gnbMenu><A id=gnb_link_text_www
  126.                   style="POSITION: relative"
  127.                   href="http://jsptestonline.cosoft.org.cn/index.jsp">首页</A></SPAN></TD>
  128.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  129.                 width=1></TD>
  130.                         <TD id=gnb_link_senior
  131.                 onmouseover="javascript:showSubMenuLayer('senior')"
  132.                 style="POSITION: relative"
  133.                 onmouseout="javascript:hideSubMenuLayer('senior')" align=middle
  134.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_senior
  135.                   style="FONT-WEIGHT: bold; COLOR: #b77bb4; POSITION: relative"
  136.                   href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A></SPAN></TD>
  137.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  138.                 width=1></TD>
  139.                         <TD id=gnb_link_junior
  140.                 onmouseover="javascript:showSubMenuLayer('junior')"
  141.                 style="POSITION: relative"
  142.                 onmouseout="javascript:hideSubMenuLayer('junior')" align=middle
  143.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_junior
  144.                   style="POSITION: relative"
  145.                   href="http://jsptestonline.cosoft.org.cn/junior/index.jsp">中考通</A></SPAN></TD>
  146.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  147.                 width=1></TD>
  148.                         <TD id=gnb_link_exercises
  149.                 onmouseover="javascript:showSubMenuLayer('exercises')"
  150.                 style="POSITION: relative"
  151.                 onmouseout="javascript:hideSubMenuLayer('exercises')"
  152.                 align=middle width=70><SPAN class=gnbMenu><A
  153.                   id=gnb_link_text_exercises style="POSITION: relative"
  154.                   href="http://jsptestonline.cosoft.org.cn/exercises/index.jsp">共创题库</A></SPAN></TD>
  155.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  156.                 width=1></TD>
  157.                         <TD id=gnb_link_community
  158.                 onmouseover="javascript:showSubMenuLayer('community')"
  159.                 style="POSITION: relative"
  160.                 onmouseout="javascript:hideSubMenuLayer('community')"
  161.                 align=middle width=70><SPAN class=gnbMenu><A
  162.                   id=gnb_link_text_community style="POSITION: relative"
  163.                   href="http://jsptestonline.cosoft.org.cn/community/index.jsp">学员社区</A></SPAN></TD>
  164.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  165.                 width=1></TD>
  166.                         <TD id=gnb_link_myjh
  167.                 onmouseover="javascript:showSubMenuLayer('myjh')"
  168.                 style="POSITION: relative"
  169.                 onmouseout="javascript:hideSubMenuLayer('myjh')" align=middle
  170.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_myjh
  171.                   style="POSITION: relative"
  172.                   href="http://jsptestonline.cosoft.org.cn/myjh/index.jsp">我的共创</A></SPAN></TD>
  173.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  174.                 width=1></TD>
  175.                         <TD id=gnb_link_help
  176.                 onmouseover="javascript:showSubMenuLayer('help')"
  177.                 style="POSITION: relative"
  178.                 onmouseout="javascript:hideSubMenuLayer('help')" align=middle
  179.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_help
  180.                   style="POSITION: relative"
  181.                   href="http://jsptestonline.cosoft.org.cn/help/index.jsp">服务中心</A></SPAN></TD>
  182.                       </TR></TBODY></TABLE></TD>
  183.             <TD><IMG height=10 src="images/blank.gif"
  184.         width=10></TD>
  185.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  186.   <TABLE cellSpacing=0 cellPadding=0 width="100%"
  187. background=images/bg_top_senior.gif border=0>
  188.     <TBODY>
  189.     <TR>
  190.     <TD align=right height=6>
  191.       <TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
  192.         <TBODY>
  193.         <TR>
  194.             <TD><IMG style="MARGIN-LEFT: 345px" height=6
  195.             src="images/menu_other.gif"
  196.   width=66></TD>
  197.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  198. <TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#d3add1 border=0>
  199.   <TBODY>
  200.   <TR>
  201.       <TD align=middle><IMG height=1 src="images/blank.gif"
  202.   width=778></TD>
  203.     </TR>
  204.   <TR>
  205.     <TD align=right height=26>
  206.       <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  207.         <TBODY>
  208.         <TR>
  209.             <TD style="COLOR: #ffffff" noWrap><IMG height=10
  210.             src="images/blank.gif" width=20><SPAN
  211.             style="FONT-WEIGHT: bold; COLOR: #ffffff">高考通</SPAN></TD>
  212.             <TD style="COLOR: #ffffff" noWrap width=466><IMG height=11
  213.             src="images/ico_bit.gif" width=9><A class=white
  214.             href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A>　 <IMG
  215.             height=11 src="images/ico_bit.gif" width=9><A class=white
  216.             href="http://jsptestonline.cosoft.org.cn/senior/none_g3.jsp">高考通高三</A>　 <IMG
  217.             height=11 src="images/ico_bit.gif" width=9><A class=white
  218.             href="http://jsptestonline.cosoft.org.cn/senior/none_g2.jsp">高考通高二</A>　 <IMG
  219.             height=11 src="images/ico_bit.gif" width=9><A class=white
  220.             href="http://jsptestonline.cosoft.org.cn/senior/none_g1.jsp">高考通高一</A>　 </TD>
  221.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  222. <TABLE cellSpacing=0 cellPadding=0 width=770 border=0>
  223.   <TBODY>
  224.   <TR>
  225.     <TD width=620>依靠共创，学习倍感轻松</TD>
  226.     <TD align=right width=150></TD></TR></TBODY></TABLE>
  227.   <table width="770" border="0" cellspacing="0" cellpadding="0">
  228.     <tr>
  229.       <td><img src="images/temp.gif" width="770" height="144"></td>
  230.     </tr>
  231.   </table>
  232.   <!--begin 内容区 -->
  233.   <table width="770" border="0" cellspacing="0" cellpadding="0">
  234.     <tr valign="top" align="center">
  235.       <td width="178" class=bd_menul> <br>
  236.         <table border="0" cellspacing="0" cellpadding="0">
  237.           <tr>
  238.             <td>
  239. <a href="stu_test_free.jsp">
  240.               <img src="images/bt_test_free.gif" width="97" height="43" border="0" onClick="Open_free_test()"></a></td>
  241.           </tr>
  242.   <tr>
  243.             <td>&nbsp;</td>
  244.           </tr>
  245.   <tr>
  246.             <td><a href="stuUnit.jsp"><img src="images/bt_test_01.gif" width="97" height="43" border="0"></a></td>
  247.           </tr>
  248.           <tr>
  249.             <td>&nbsp;</td>
  250.           </tr>
  251.           <tr>
  252.             <td><a href="stu_test_mn.jsp"><img src="images/bt_test_05.gif" width="105" height="46" border="0"></a></td>
  253.           </tr>
  254.           <tr>
  255.             <td>&nbsp;</td>
  256.           </tr>
  257.           <tr>
  258.             <td><a href="QueryMark_Type.jsp"><img src="images/bt_test_03.gif" width="97" height="43" border="0"></a></td>
  259.           </tr>
  260.           <tr>
  261.             <td>&nbsp;</td>
  262.           </tr>
  263.           <tr>
  264.             <td><a href="stu_04.html"><img src="images/bt_test_04.gif" width="97" height="43" border="0"></a></td>
  265.           </tr>
  266.   <tr>
  267.             <td>&nbsp;</td>
  268.           </tr>
  269.           <tr>
  270.             <td><a href="../errorpad/errorpad.jsp" target="_self"><img src="images/bt_test_errorpad.gif" width="97" height="43" border="0"></a></td>
  271.           </tr>
  272.         </table>
  273.       <p>&nbsp;</p></td>
  274.       <td> <br>
  275.         <br>
  277.         <table width="540" border="0" cellspacing="1" cellpadding="2" bgcolor="#d3add1">
  278.         <%
  279. //查询该年级(gradenote)的模拟考试信息
  280. //正在进行的模拟考试
  281. sql="select * from mn_test where  status=2 and grade_note='"+gradenote+"' and "+
  282.     "begin_date<=CURRENT_DATE  order by begin_date";
  283. stmt=con.createStatement();
  284. rs=stmt.executeQuery(sql);
  285. while(rs.next()){
  286. %>
  287.     <tr bgcolor="#FFFFFF">
  288.             <td colspan="5">
  289.             <a href="mn_test.jsp?mn_testID=<%=rs.getInt("id")%>&stuID=<%=studentID%>"
  290.                         title="<%=rs.getString("name")%>"
  291.    target="_blank">★ <%=rs.getString("name")%>
  292.   </a>
  294.             &nbsp;</td>
  295.           </tr>
  296. <%
  298. }
  299. rs.close();
  300. stmt.close();
  301. //未来进行的模拟考试
  302. sql="select * from mn_test where status=2 and grade_note='"+gradenote+"' and "+
  303.     "begin_date>CURRENT_DATE  order by begin_date";
  304. stmt=con.createStatement();
  305. rs=stmt.executeQuery(sql);
  306. while(rs.next()){
  307. %>
  308.           <tr bgcolor="#FFFFFF">
  309.             <td colspan="5">★ <%=rs.getString("name")%></td>
  310.           </tr>
  311. <%
  313. }
  314. rs.close();
  315. stmt.close();
  316. %>
  317.         </table>
  319.   </td>
  320.     </tr>
  321.   </table>
  322.   <!--end 内容区 -->
  323.   <!--begin bottom -->
  324.   <TABLE
  325. style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
  326. cellSpacing=0 cellPadding=0 width="100%" border=0>
  327.   <TBODY>
  328.   <TR>
  329.     <TD align=middle colSpan=2 height=30>
  330.       <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
  331.         <TBODY>
  332.         <TR>
  333.           <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
  334.             target=_blank>关于我们</A> | <A
  335.             href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
  336.             target=_blank>联系方式</A> | 网站地图 | <A
  337.             href="http://jsptestonline.cosoft.org.cn/about/service.html"
  338.             target=_blank>服务条款</A> | <A
  339.             href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
  340.             target=_blank>隐私权保护</A> | <A
  341.             href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
  342.             target=_blank>版权声明</A></TD>
  343.           <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
  344.             target=_blank>共创教育机构</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--end bottom --></CENTER></BODY></HTML>
  345. <%}
  346. catch(Exception e){
  347.     System.out.print(e.toString());
  348. }
  349. finally{
  350.     DBCon.dropConnection();
  351. }
  352. %>