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

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

教育系统应用

开发平台：

WORD

stu_test_free.jsp：源码内容
  1. <%@ page import="java.util.*,
  2.  java.sql.*,
  3.  java.lang.*" %>
  6. <%@ page contentType="text/html; charset=gb2312" language="java"%>
  7. <%@ page import="java.sql.*" %>
  8. <%@ page import="jinghua.*"%>
  9. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  10. </jsp:useBean>
  11. <%!Connection con;
  12. boolean debug=false;
  13. String studentID="";
  14. String gradenote="";
  15. Statement stmt=null;
  16. ResultSet rs=null;
  17. String sql="";
  18. %>
  19. <%
  20. try{
  21.     studentID=(String)session.getAttribute("studentID");
  22.     if(studentID==null){
  23.         throw new Exception();
  24.     }
  25. }catch(Exception e){
  26.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  27.    Tools.showJS("window.open('../login.jsp','_self')",out);
  28. }
  31. try{
  32.     con=DBCon.getConnection();
  33.     //获取学生的年级信息
  34.     //sql="select id,gradenote,grade.Name as gn "+
  35.     //"from student  INNER JOIN grade ON (student.gradenote = grade.note) "+
  36.     //" where stuid='"+studentID+"'";
  37.     sql="select id,gradenote from UserInfo where vcUserNo='"+studentID+"'";
  39.     try{
  40.         stmt=con.createStatement();
  41.         rs=stmt.executeQuery(sql);
  42.         if(rs.next()){
  43.             gradenote=rs.getString("gradenote");
  44.             rs.close();
  45.             stmt.close();
  46.         }
  47.         if(debug){
  48.             out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
  49.         }
  50.     }
  51.     catch(SQLException se){
  52.         out.print("<br> query student error sql="+sql);
  53.         out.print("<br>"+se.toString());
  54.     }
  55.     catch(Exception e){
  56.         out.print("<br> query student error sql="+sql);
  57.         out.print("<br>"+e.toString());
  58.     }
  59.     //--年级，科目，知识点三个下拉列表框联动-->
  60.     out.print(Tools.sub_know(con));
  61.     //out.print(Tools.grade_sub(con));
  67. %>
  81. <!--年级，科目，知识点三个下拉列表框联动-->
  83. <script language="JavaScript">
  86. function changesk(locationid){
  87. document.myform.KnowPoint.length =1;
  88. var locationid=locationid;
  89. var i;
  90. for (i=0;i < gskcount; i++){
  91. if (grade_sub_know[i][1] == locationid){
  92. document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
  93. }
  94. }
  95. }
  98. </script>
  101. <script language="javascript">
  102. function CheckForm(f)
  103. {
  105. if( f.testnumber.value.length<1)
  106. {
  107.     alert("您还有输入测验的试题数!");
  108. return false;
  109. }
  111. if(!isNumberString(f.testnumber.value,"1234567890."))
  112. {
  113.     alert("嘿！您在试题数里填了东西,但怎么不是数字呢？n");
  114.     return false;
  115. }else if(f.testnumber.value<10){
  116.             alert("每次测验至少要有10道试题!!");
  117.             return false;
  118. }else if(f.testnumber.value>100){
  119.             alert("学堂提供最多100道试题的测验!!");
  120.             return false;
  121. }
  124. if( !(f.testorder[0].checked || f.testorder[1].checked||f.testorder[2].checked) ) {
  125. alert("您还没有选择测试顺序!")
  126. return false;
  127. }
  129. return true;
  130. }
  132. function isNumberString (InString,RefString)
  133. {
  134. if(InString.length==0) return (false);
  135. for (Count=0; Count < InString.length; Count++)  {
  136. TempChar= InString.substring (Count, Count+1);
  137. if (RefString.indexOf (TempChar, 0)==-1)
  138. return (false);
  139. }
  140. return (true);
  141. }
  142. </script>
  148. <HTML><HEAD><TITLE>共创学堂</TITLE>
  149. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  150. <LINK
  151. href="style/style.css" type=text/css rel=stylesheet>
  152. <SCRIPT src="js/html.js"></SCRIPT>
  154. <SCRIPT src="js/gnb_menus_layer.js"></SCRIPT>
  156. <SCRIPT src="js/menu.js"></SCRIPT>
  158. <SCRIPT src="js/jumpmenu.js"></SCRIPT>
  160. <SCRIPT src="js/Valid.js"></SCRIPT>
  162. <META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
  163. <BODY bgColor=#ffffff text=#000000 vlink="#0000FF"  >
  164. <CENTER>
  165. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  166.   <TBODY>
  167.   <TR>
  168.       <TD vAlign=bottom align=right width=160><A
  169.       href="http://jsptestonline.cosoft.org.cn/"><IMG height=45 src="images/logo.gif"
  170.       width=160></A></TD>
  171.     <TD align=right>
  172.       <TABLE cellSpacing=0 cellPadding=0 width=260 border=0>
  173.         <TBODY>
  174.         <TR>
  175.             <TD vAlign=bottom width=7 bgColor=#b2aeb8><IMG height=18
  176.             src="images/pic_top_y.gif" width=7></TD>
  177.           <TD align=right bgColor=#b2aeb8>
  178.             <TABLE height=18 cellSpacing=0 cellPadding=0 width=240 border=0>
  179.               <TBODY>
  180.               <TR>
  181.                   <TD><IMG height=11 src="images/ico_t_mail.gif"
  182.                 width=13></TD>
  183.                 <TD><A class=black
  184.                   href="http://jsptestonline.cosoft.org.cn/help/use/use_004.jsp">在线咨询</A></TD>
  185.                   <TD><IMG height=15 src="images/ico_t_help.gif"
  186.                 width=13></TD>
  187.                 <TD><A class=black
  188.                   href="http://jsptestonline.cosoft.org.cn/help/buy/buy_001.jsp">申请服务</A></TD>
  189.                   <TD><IMG height=13 src="images/ico_t_lc.gif"
  190.                 width=14></TD>
  191.                 <TD><A class=black
  192.                   href="http://jsptestonline.cosoft.org.cn/help/product/pro_001.jsp">产品介绍</A></TD>
  193.                   <TD width=10><IMG height=10 src="images/blank.gif"
  194.                   width=10></TD>
  195.                 </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  196.       <TABLE height=12 cellSpacing=0 cellPadding=0 width=100 border=0>
  197.         <TBODY>
  198.         <TR>
  199.             <TD><IMG height=1 src="images/blank.gif"
  200.         width=618></TD>
  201.           </TR></TBODY></TABLE>
  202.       <TABLE cellSpacing=0 cellPadding=0>
  203.         <TBODY>
  204.         <TR>
  205.           <TD>
  206.             <TABLE style="PADDING-BOTTOM: 1px" cellSpacing=0 cellPadding=0
  207.             border=0>
  208.               <TBODY>
  209.               <TR>
  210.                         <TD id=gnb_link_www
  211.                 onmouseover="javascript:showSubMenuLayer('www')"
  212.                 style="POSITION: relative"
  213.                 onmouseout="javascript:hideSubMenuLayer('www')" align=middle
  214.                 width=40><SPAN class=gnbMenu><A id=gnb_link_text_www
  215.                   style="POSITION: relative"
  216.                   href="http://jsptestonline.cosoft.org.cn/index.jsp">首页</A></SPAN></TD>
  217.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  218.                 width=1></TD>
  219.                         <TD id=gnb_link_senior
  220.                 onmouseover="javascript:showSubMenuLayer('senior')"
  221.                 style="POSITION: relative"
  222.                 onmouseout="javascript:hideSubMenuLayer('senior')" align=middle
  223.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_senior
  224.                   style="FONT-WEIGHT: bold; COLOR: #b77bb4; POSITION: relative"
  225.                   href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A></SPAN></TD>
  226.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  227.                 width=1></TD>
  228.                         <TD id=gnb_link_junior
  229.                 onmouseover="javascript:showSubMenuLayer('junior')"
  230.                 style="POSITION: relative"
  231.                 onmouseout="javascript:hideSubMenuLayer('junior')" align=middle
  232.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_junior
  233.                   style="POSITION: relative"
  234.                   href="http://jsptestonline.cosoft.org.cn/junior/index.jsp">中考通</A></SPAN></TD>
  235.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  236.                 width=1></TD>
  237.                         <TD id=gnb_link_exercises
  238.                 onmouseover="javascript:showSubMenuLayer('exercises')"
  239.                 style="POSITION: relative"
  240.                 onmouseout="javascript:hideSubMenuLayer('exercises')"
  241.                 align=middle width=70><SPAN class=gnbMenu><A
  242.                   id=gnb_link_text_exercises style="POSITION: relative"
  243.                   href="http://jsptestonline.cosoft.org.cn/exercises/index.jsp">共创题库</A></SPAN></TD>
  244.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  245.                 width=1></TD>
  246.                         <TD id=gnb_link_community
  247.                 onmouseover="javascript:showSubMenuLayer('community')"
  248.                 style="POSITION: relative"
  249.                 onmouseout="javascript:hideSubMenuLayer('community')"
  250.                 align=middle width=70><SPAN class=gnbMenu><A
  251.                   id=gnb_link_text_community style="POSITION: relative"
  252.                   href="http://jsptestonline.cosoft.org.cn/community/index.jsp">学员社区</A></SPAN></TD>
  253.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  254.                 width=1></TD>
  255.                         <TD id=gnb_link_myjh
  256.                 onmouseover="javascript:showSubMenuLayer('myjh')"
  257.                 style="POSITION: relative"
  258.                 onmouseout="javascript:hideSubMenuLayer('myjh')" align=middle
  259.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_myjh
  260.                   style="POSITION: relative"
  261.                   href="http://jsptestonline.cosoft.org.cn/myjh/index.jsp">我的共创</A></SPAN></TD>
  262.                   <TD><IMG height=7 src="images/pic_top_line.gif"
  263.                 width=1></TD>
  264.                         <TD id=gnb_link_help
  265.                 onmouseover="javascript:showSubMenuLayer('help')"
  266.                 style="POSITION: relative"
  267.                 onmouseout="javascript:hideSubMenuLayer('help')" align=middle
  268.                 width=70><SPAN class=gnbMenu><A id=gnb_link_text_help
  269.                   style="POSITION: relative"
  270.                   href="http://jsptestonline.cosoft.org.cn/help/index.jsp">服务中心</A></SPAN></TD>
  271.                       </TR></TBODY></TABLE></TD>
  272.             <TD><IMG height=10 src="images/blank.gif"
  273.         width=10></TD>
  274.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  275.   <TABLE cellSpacing=0 cellPadding=0 width="100%"
  276. background=images/bg_top_senior.gif border=0>
  277.     <TBODY>
  278.     <TR>
  279.     <TD align=right height=6>
  280.       <TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
  281.         <TBODY>
  282.         <TR>
  283.             <TD><IMG style="MARGIN-LEFT: 345px" height=6
  284.             src="images/menu_other.gif"
  285.   width=66></TD>
  286.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  287. <TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#d3add1 border=0>
  288.   <TBODY>
  289.   <TR>
  290.       <TD align=middle><IMG height=1 src="images/blank.gif"
  291.   width=778></TD>
  292.     </TR>
  293.   <TR>
  294.     <TD align=right height=26>
  295.       <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  296.         <TBODY>
  297.         <TR>
  298.             <TD style="COLOR: #ffffff" noWrap><IMG height=10
  299.             src="images/blank.gif" width=20><SPAN
  300.             style="FONT-WEIGHT: bold; COLOR: #ffffff">高考通</SPAN></TD>
  301.             <TD style="COLOR: #ffffff" noWrap width=466><IMG height=11
  302.             src="images/ico_bit.gif" width=9><A class=white
  303.             href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A>　 <IMG
  304.             height=11 src="images/ico_bit.gif" width=9><A class=white
  305.             href="http://jsptestonline.cosoft.org.cn/senior/none_g3.jsp">高考通高三</A>　 <IMG
  306.             height=11 src="images/ico_bit.gif" width=9><A class=white
  307.             href="http://jsptestonline.cosoft.org.cn/senior/none_g2.jsp">高考通高二</A>　 <IMG
  308.             height=11 src="images/ico_bit.gif" width=9><A class=white
  309.             href="http://jsptestonline.cosoft.org.cn/senior/none_g1.jsp">高考通高一</A>　 </TD>
  310.           </TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  311. <TABLE cellSpacing=0 cellPadding=0 width=770 border=0>
  312.   <TBODY>
  313.   <TR>
  314.     <TD width=620>依靠共创，学习倍感轻松</TD>
  315.     <TD align=right width=150></TD></TR></TBODY></TABLE>
  316.   <table width="770" border="0" cellspacing="0" cellpadding="0">
  317.     <tr>
  318.       <td><img src="images/temp.gif" width="770" height="144"></td>
  319.     </tr>
  320.   </table>
  321.   <!--begin 内容区 -->
  322.   <table width="770" border="0" cellspacing="0" cellpadding="0">
  323.     <tr valign="top" align="center">
  324.       <td width="178" class=bd_menul> <br>
  325.         <table border="0" cellspacing="0" cellpadding="0">
  326.           <tr>
  327.             <td>
  328. <a href="stu_test_free.jsp">
  329.               <img src="images/bt_test_free.gif" width="97" height="43" border="0" onClick="Open_free_test()"></a></td>
  330.           </tr>
  331.   <tr>
  332.             <td>&nbsp;</td>
  333.           </tr>
  334.   <tr>
  335.             <td><a href="stuUnit.jsp"><img src="images/bt_test_01.gif" width="97" height="43" border="0"></a></td>
  336.           </tr>
  337.           <tr>
  338.             <td>&nbsp;</td>
  339.           </tr>
  340.           <tr>
  341.             <td><a href="stu_test_mn.jsp"><img src="images/bt_test_05.gif" width="105" height="46" border="0"></a></td>
  342.           </tr>
  343.           <tr>
  344.             <td>&nbsp;</td>
  345.           </tr>
  346.           <tr>
  347.             <td><a href="QueryMark_Type.jsp"><img src="images/bt_test_03.gif" width="97" height="43" border="0"></a></td>
  348.           </tr>
  349.           <tr>
  350.             <td>&nbsp;</td>
  351.           </tr>
  352.           <tr>
  353.             <td><a href="stu_04.html"><img src="images/bt_test_04.gif" width="97" height="43" border="0"></a></td>
  354.           </tr>
  355.   <tr>
  356.             <td>&nbsp;</td>
  357.           </tr>
  358.           <tr>
  359.             <td><a href="../errorpad/errorpad.jsp" target="_self"><img src="images/bt_test_errorpad.gif" width="97" height="43" border="0"></a></td>
  360.           </tr>
  361.         </table>
  362.       <p>&nbsp;</p></td>
  363.       <td> <p><br>
  364.           <br>
  365.         </p>
  366.         <FORM action="free_test_paper.jsp" method="post" name="myform" target="_blank" id="myform" onSubmit="return CheckForm(this)">
  367.           <table width="422" border="0" cellspacing="0" cellpadding="0" style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; BORDER-LEFT: #cccccc 1px solid; PADDING-TOP: 5px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #f3f3f3">
  368.             <tr>
  369.               <td height="35" colspan="5" align="center" valign="baseline" nowrap><font size="+1"><strong>请选择测验内容&nbsp;
  370.                 </strong></font></td>
  371.     </tr>
  372.     <tr>
  373.               <td width="115" height="43" align="center" valign="baseline" nowrap>
  374.                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  375.                   <tr>
  376.                     <td width="30%" nowrap><div align="center"><strong>&nbsp;</strong></div></td>
  377.                     <td width="70%" nowrap><div align="left"><font size="+1"><strong>科&nbsp;目:</strong></font></div></td>
  378.                   </tr>
  379.                   <tr>
  380.                     <td> <div align="center"> </div></td>
  381.                     <td><div align="left"><font size="+1"><strong>
  382.                         <select name=Subject
  383. size="1" id=select8 onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)">
  384.                           <option value="-1" selected>全 部</option>
  385.                           <%Tools.showGradeSubjectOption(con,gradenote,out);%>
  386.                         </select>
  387.                         </strong></font></div></td>
  388.                   </tr>
  389.                 </table></td>
  390.       <td width="200" align="center" valign="baseline" nowrap >
  391.   <table width="94%" border="0" cellspacing="0" cellpadding="0">
  392.           <tr>
  393.             <td nowrap><strong>知识点:</strong></td>
  394.           </tr>
  395.           <tr>
  396.             <td> <select name=KnowPoint id="select9">
  397.                         <option value="-1" selected>----全 部----</option>
  398.                       </select> </td>
  399.           </tr>
  400.         </table></td>
  401.               <td width="105" colspan="2" align="center" valign="baseline" nowrap>
  402. <table width="92%" border="0" cellspacing="0" cellpadding="0">
  403.           <tr>
  404.             <td nowrap><strong>难易度:</strong></td>
  405.           </tr>
  406.           <tr>
  407.             <td> <select name=hard id="select10">
  408.                 <option value="1" selected>任意</option>
  409.                 <option value="2">容易</option>
  410.                 <option value="3">中等</option>
  411.                 <option value="4">较难</option>
  412.               </select> </td>
  413.           </tr>
  414.         </table></td>
  415.     </tr>
  416.     <tr valign="middle">
  417.               <td height="29" colspan="5" align="center" nowrap> <strong>测试顺序：</strong>
  418.                 <input type="radio" name="testorder" value="1">
  419.         随机顺序
  420.         <input type="radio" name="testorder" value="2">
  421.         从难到易
  422.         <input type="radio" name="testorder" value="3">
  423.         从易到难</td>
  424.     </tr>
  425.     <tr valign="middle">
  426.               <td height="14" colspan="5" align="center" nowrap><font color="#000000"><strong>试题数</strong></font><strong>:</strong>
  427.                 <input name="testnumber" type="text" id="testnumber2" value="10" size="10">
  428.               </td>
  429.     </tr>
  430.     <tr>
  431.               <td height="15" colspan="5" align="center" valign="baseline" nowrap>
  432.                 <input name="testbegin" type="submit" class="s02" id="testbegin2"  value="开 始">
  433.               </td>
  434.     </tr>
  435.   </table>
  436. </FORM></td>
  437.     </tr>
  438.   </table>
  439.   <!--end 内容区 -->
  440.   <!--begin bottom -->
  441.   <TABLE
  442. style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
  443. cellSpacing=0 cellPadding=0 width="100%" border=0>
  444.   <TBODY>
  445.   <TR>
  446.     <TD align=middle colSpan=2 height=30>
  447.       <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
  448.         <TBODY>
  449.         <TR>
  450.           <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
  451.             target=_blank>关于我们</A> | <A
  452.             href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
  453.             target=_blank>联系方式</A> | 网站地图 | <A
  454.             href="http://jsptestonline.cosoft.org.cn/about/service.html"
  455.             target=_blank>服务条款</A> | <A
  456.             href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
  457.             target=_blank>隐私权保护</A> | <A
  458.             href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
  459.             target=_blank>版权声明</A></TD>
  460.           <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
  461.             target=_blank>共创教育机构</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--end bottom --></CENTER></BODY></HTML>
  463. <%            }
  464. catch(Exception e){
  465.     System.out.print(e.toString());
  466. }
  467. finally{
  468.     DBCon.dropConnection();
  469. }
  470. %>