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

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

教育系统应用

开发平台：

WORD

modify_test_free.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
  3. <%@ page import="java.sql.*"%>
  4. <%@ page import="jinghua.*"%>
  5. <%@ page import="java.util.*"%>
  6. <%@ page import = "java.io.PrintWriter" %>
  7. <%@ page import = "jinghua.chart.servlet.WebHitChart" %>
  8. <%@ page import = "jinghua.chart.servlet.WebHitDataSet" %>
  9. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  10. </jsp:useBean>
  11. <%!Connection con;
  12. boolean debug=true;
  13. class Test{
  14.     String id;
  15.     String name;
  16.     String grade;
  17.     String time;
  18.     String totalMark;
  19.     String testclass;
  20. int testnum;
  22.     public String toString(){
  23.         String temp="";
  24.         temp="<br> id="+id+"<br> name="+name;
  25.         return temp;
  26.    }
  27. };
  31. Statement stmt=null;
  32. ResultSet rs=null;
  33. String sql="";
  36. %>
  37. <%
  38. String [] question=null;
  39. ArrayList testSet=new ArrayList();
  40. String testname=null;
  41. String paper=null;
  42. String testIDs=null;
  43. Test test=new Test();
  44. StringBuffer sb=null;
  45. try{
  46.     con=DBCon.getConnection();
  48. test.id=request.getParameter("testID");
  50. if(test.id==null)
  51. throw new Exception("页面缺少调用参数！");
  54. sql="SELECT  `test`.`paper`,`test`.`testnum`,  `test`.`title`,  `test`.`date`,  `test`.`mark`"+
  55. "  FROM  `test` WHERE  (`test`.`id` = "+test.id+")";
  56.     stmt=con.createStatement();
  57.     rs=stmt.executeQuery(sql);
  58.     if(rs.next()){
  59.         test.name=rs.getString("title");
  60. test.time=rs.getString("date");
  61. test.totalMark=String.valueOf(rs.getFloat("mark"));
  62.         paper=rs.getString("paper");
  63. test.testclass="单元测试";
  64. test.testnum=rs.getInt("testnum");
  65.     }
  66.     rs.close();
  67.     stmt.close();
  69. if(paper==null)
  70.      throw new Exception("没有查询到试卷内容!");
  71. if(paper.equals(""))
  72.      throw new Exception("没有查询到试卷内容!");
  74.  question=paper.split("#");
  75.      sb=new StringBuffer();
  76.      //585@A@5@A#586@B@6@B#587@C@7@C#588@D@8@E#
  77.     for(int j=0;j<question.length;j++){
  78.         sb.append(question[j].substring(0,question[j].indexOf("@"))+",");
  79.     }
  80.     paper=sb.toString().substring(0,sb.toString().length()-1);
  81. sql="select ID,QuestText,Tip,Mark,Answer from question "+
  82. " where id in ("+paper+") order by id";
  84.     if(debug) out.println("<br>test paper="+paper+
  85. "<br>test sql="+sql);
  86. //试题记录集
  87.     stmt=con.createStatement();
  88.     rs=stmt.executeQuery(sql);
  90. %>
  93. <script language="JavaScript">
  94. function gotestpaper(){
  96. document.myform.method = "POST";
  97.     document.myform.action = "modify_test.jsp";
  98.     document.myform.target="_self";
  99.     document.myform.submit();
  100. }
  101. function del_check()
  102. {
  103. var count = myform.elements.length;
  104. var noSelect = true;
  105.   for(var i=0;i<count;i++)
  106.   {
  107.      if(myform.elements[i].checked)
  108.      {
  109.              noSelect = false;
  110.       break;
  111. }
  112.    }
  113. if(noSelect == true)
  114. {
  115.     alert("您还没有选择要删除的试题");
  116.     return(false);
  117.  }
  118.    else
  119.    {
  120.          if(confirm("将删除所有选择的试题吗？"))
  121.          {
  122.                 document.myform.method = "POST";
  123.                 document.myform.action = "unit_test_quest_del.jsp";
  124.                 document.myform.target="_self";
  125.                 document.myform.submit();
  126.          }
  127.          else
  128.          {
  129.                 document.myform.method = "GET";
  130.                 document.myform.action = "";
  131. }
  132.      }
  133.      return false;
  134. }
  135. function add_check()
  136. {
  137. document.myform.method = "POST";
  138.     document.myform.action = "unit_test_quest_add.jsp";
  139.     document.myform.target="_self";
  140.     document.myform.submit();
  141.         
  142.     return false;
  143. }
  144. function deactive_check()
  145. {
  146. var count = myform.elements.length;
  147. var noSelect = true;
  148.   for(var i=0;i<count;i++)
  149.   {
  150.      if(myform.elements[i].checked)
  151.      {
  152.              noSelect = false;
  153.       break;
  154. }
  155.    }
  156. if(noSelect == true)
  157. {
  158.     alert("您还没有选择要注销的试卷!");
  159.     return(false);
  160.  }
  161.    else
  162.    {
  163.          if(confirm("注销所有选择的试卷吗？"))
  164.          {
  165.                 document.myform.method = "POST";
  166.                 document.myform.action = "test_deactivde.jsp";
  167.                 document.myform.target="_self";
  168.                 document.myform.submit();
  169.          }
  170.          else
  171.          {
  172.                 document.myform.method = "GET";
  173.                 document.myform.action = "";
  174. }
  175.          }
  176.          return false;
  177. }
  178. function subform(stract)
  179. {
  180. switch (stract){
  181. case "del":
  182.             del_check();
  183. break;
  184. case "add":
  185.             add_check();
  186. break;
  187. case "deactive":
  188. deactive_check();
  189. break;
  191. }
  192. }
  194. </script>
  195. <HTML>
  196. <HEAD>
  197. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  198. <TITLE>共创学堂-模拟考试成绩查询</TITLE>
  199. <SCRIPT language=JavaScript>
  200. <!--
  202. function SymError()
  203. {
  204.   return true;
  205. }
  207. window.onerror = SymError;
  210. //-->
  211. </SCRIPT>
  214. <!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
  215. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
  216. href="../errorpad/style/style.css" type=text/css rel=stylesheet>
  219. <META content="MSHTML 6.00.2462.0" name=GENERATOR>
  220. <link rel="stylesheet" type="text/css" href="../css.css">
  221. </HEAD>
  222. <BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
  224. <CENTER>
  226. <TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
  227.   <TBODY>
  228.   <TR>
  229.           <TD><IMG height=27 src="../errorpad/images/test_pop_01.gif" width=102></TD>
  230.           <TD align=right><IMG height=27 src="../errorpad/images/test_pop_02.gif"
  231.       width=134></TD>
  232.         </TR></TBODY></TABLE>
  233.   <strong><font color="#3366FF" size="+2" face="黑体">自由测试试卷修改</font></strong> 
  234.   <!--begin test -->
  235.   <FORM action=Query_unit_test_mark.jsp method=post name=myform target="_self" id="myform" onSubmit="return CheckForm(this)">
  236.     <TABLE width=100% height="60" border=0 cellPadding=0 cellSpacing=0>
  237.       <TBODY>
  238.         <TR>
  239.           <TD height="75"  align=middle> <table width="600" height="62" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
  240.               <tr> 
  241.                 <td height="58" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"><b><font color="#FFFFFF"> 
  242.                   </font></b> 
  243.                   <div align="center">
  244. <table width="100%" border="0">
  245.                       <tr> 
  246.                         <td width="35%">&nbsp;</td>
  247.                         <td width="16%"><input name="errDel" type="button" class="s03" id="errDel" value="删 除" border="0" onClick=subform("del")></td>
  248.                         <td width="15%"><input name="errAscRate" type="button" class="s03" id="errAscRate2" value="添 加" border="0" onClick=subform("add")></td>
  249.                         <td width="24%"> <input name="goback" type="button" class="s03" id="goback"  onClick="gotestpaper()" value="返回"></td>
  250.                         <td width="10%">&nbsp;</td>
  251.                       </tr>
  252.                     </table>
  253.                     
  254.                   </div>
  255.                   </td>
  256.               </tr>
  257.             </table></TD>
  258.         </TR>
  260.       </TBODY>
  261.     </TABLE>
  265.     <TABLE width=600 border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
  266.       <TBODY>
  267.         <TR>
  268.           <td width="587" height=30 bgColor=#E3E3E3 class=l> 
  269.             <table width="100%" border="0" cellspacing="0" bgcolor="#FFFDE8">
  270.               <tr bgcolor="#FFFDE8"> 
  271.                 <td width="47" height="20" nowrap background="../images/admin_bg_1.gif"> 
  272.                   <div align="center"></div></td>
  273.                 <td width="197" height="30" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
  274.                   <div align="left"><strong>试卷名称</strong></div></td>
  275.                 <td width="138" nowrap background="../images/admin_bg_1.gif"> 
  276.                   <div align="center"><strong>考试发布时间</strong></div></td>
  277.                 <td width="117" nowrap background="../images/admin_bg_1.gif"> 
  278.                   <div align="center"><strong>考试类型</strong></div></td>
  279.                 <td width="93" nowrap background="../images/admin_bg_1.gif"> 
  280.                   <div align="left"><strong>总分</strong></div></td>
  281.               </tr>
  282.             </table></td>
  283.         </TR>
  285.             <TR>
  286.           <td width="587" height=22 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
  287.               <tr>
  288.                 <td width="43" height="20" nowrap><div align="center"> </div></td>
  289.                 <td width="201" nowrap> <div align="left"><%=test.name%></div></td>
  290.                 <td width="136" nowrap><div align="center"><%=test.time%></div></td>
  291.                 <td width="118" nowrap><div align="center"><%=test.testclass%></div></td>
  292.                 <td width="94" nowrap> <div align="left"><%=test.totalMark%></div></td>
  293.               </tr>
  294.             </table></td>
  295.         </TR>
  299.       </TBODY>
  300.     </TABLE>
  302.     <br>
  303.     <table  width="600" height="82" border="1" cellspacing="1" bordercolor="#799AE1" id="AutoNumber1" style="border-collapse: collapse">
  304.       <tr class="trh">
  305.         <td width="52" height="30" align="center" nowrap background="../images/admin_bg_1.gif"> 
  306.           <font color="#FFFFFF"><b>序号</b></font></td>
  307.         <td width="535" height="30" align="center" nowrap background="../images/admin_bg_1.gif"> 
  308.           <p align="center"><font color="#FFFFFF"> <b>单项选择题（共<%=test.testnum%>&nbsp;题,<%=test.totalMark%>分）</b></font></td>
  309.       </tr>
  310.       <% int testNumber=0;
  312. while(rs.next()){%>
  313.       <tr class="trh1">
  314.         <td width="52"   height="35" align="center" nowrap bgcolor="#FFFFFF">　 
  315.           <center>
  316.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  317.               <tr>
  318.                 <td bgcolor="#FFFFFF"> 
  319.                   <div align="center">
  320.                     <input name="id" type="checkbox" id="id" value="<%=rs.getInt("ID")%>">
  321.                     <%out.print(testNumber+1);%>
  322.                     . </div></td>
  323.               </tr>
  324.               <tr>
  325.                 <td bgcolor="#FFFFFF">
  326. <div align="center">(<%=rs.getInt("Mark")%>分)</div></td>
  327.               </tr>
  328.             </table>
  329.           </center>
  330.           &nbsp;</td>
  331.         <td width="535" height="35" align="left" bgcolor="#FFFFFF"><br>
  332.           <%
  333. out.print("题目:<br>"+rs.getString("QuestText"));
  334. out.print("答案:&nbsp;&nbsp;"+rs.getString("Answer"));
  335. out.print("<br>提示：<br>"+""+rs.getString("Tip"));
  336. testNumber++;
  337. %>
  338.         </td>
  339.       </tr>
  340.       <%}
  341.     rs.close();
  342.     stmt.close();
  343.     %>
  345.     </table>
  346.     <p>
  347.     <input name="testID" type="hidden" id="testID" value="<%=test.id%>">
  349. </FORM>
  351.   <!--end test -->
  352.   <!--begin bottom -->
  353.   <!--end bottom -->
  354. </CENTER>
  355. </BODY>
  356. </HTML>
  358. <%}
  359. catch(SQLException se){
  360.     out.println("<br>sql="+sql);
  361.     out.println("<br>"+se.toString());
  362. }
  363. catch(Exception e){
  364.     out.print(e.toString());
  365. }
  366. finally{
  367.     DBCon.dropConnection();
  368. }
  369. %>