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

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

教育系统应用

开发平台：

WORD

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