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

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

教育系统应用

开发平台：

WORD

admin_mn_test.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" %>
  2. <%@ page import="java.sql.*" %>
  3. <%@ page import="java.io.*"%>
  4. <%@ page import="jinghua.*"%>
  7. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  8. </jsp:useBean>
  9. <%!
  10. Connection con=null;
  11. PreparedStatement pstmt=null;
  12. ResultSet rs=null;
  13. %>
  15. <%
  16. try{
  17.     con=DBCon.getConnection();
  18. String sql="SELECT   `mn_test`.`id`,  `mn_test`.`name`,  `grade`.`Name` AS `gn` "+
  19. "FROM  `mn_test`  INNER JOIN `grade` ON (`mn_test`.`grade_note` = `grade`.`note`) "+
  20. "ORDER BY  `mn_test`.`grade_note`,  `mn_test`.`id`";
  21.     pstmt=con.prepareStatement(sql);
  22.     rs=pstmt.executeQuery();
  23. %>
  26. <head>
  28. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  29. <title>系统管理 |增加模拟考试</title>
  30. <link rel="stylesheet" type="text/css" href="../css.css">
  32. <style type="text/css">
  33. <!--td { text-decoration: none; font-size: 10pt}
  34. a { text-decoration: none; color: #000000}
  35. a:hover { text-decoration: underline; color: #336699}
  36. .font14 {
  37. font-size: 14px;
  38. line-height: 18px;
  39. }
  40. .l20 {  line-height: 20px; font-size: 13px}
  41. boder2 {  border-color: black #6B90C5 #6B90C5; border-style: solid; border-top-width: 0px; border-right-width: 2px; border-bottom-width: 2px; border-left-width: 2px}
  42. .boder2 {
  43. border-top-width: 0px;
  44. border-right-width: 1px;
  45. border-bottom-width: 1px;
  46. border-left-width: 1px;
  47. border-top-style: solid;
  48. border-right-style: solid;
  49. border-bottom-style: solid;
  50. border-left-style: solid;
  51. border-top-color: black;
  52. border-right-color: #000000;
  53. border-bottom-color: #000000;
  54. border-left-color: #000000;
  55. }
  56. .boder1 {  border: 1px solid #000000}
  57. .font12 {  font-size: 12px; line-height: 18px}
  58. -->
  59. </style>
  60. </head>
  61. <script language="javaScript">
  62. <!--
  64. Now = new Date();
  65. NowDay = Now.getDate();
  66. NowMonth = Now.getMonth();
  67. NowYear = Now.getYear();
  68. if (NowYear < 2000) NowYear += 1900; //for Netscape
  70. //function for returning how many days there are in a month including leap years
  71. function DaysInMonth(WhichMonth, WhichYear)
  72. {
  73.   var DaysInMonth = 31;
  74.   if (WhichMonth == "04" || WhichMonth == "06" || WhichMonth == "09" || WhichMonth == "11") DaysInMonth = 30;
  75.   if (WhichMonth == "02") {
  76.    DaysInMonth = 28;
  77.    if (WhichMonth == "02" && (WhichYear/4) == Math.floor(WhichYear/4)) {
  78.    if ((WhichYear/100) != Math.floor(WhichYear/100)) {
  79.    DaysInMonth = 29;
  80.    }else{
  81.    if ((WhichYear/400) == Math.floor(WhichYear/400)) {
  82.    DaysInMonth = 29;
  83.    }
  84.    }
  85.    }
  86.   }
  87.   return DaysInMonth;
  88. }
  90. //function to change the available days in a months
  91. function ChangeOptionDays(Which)
  92. {
  93.   DaysObject = eval("document.forms['myform']." + Which + "day");
  94.   MonthObject = eval("document.forms['myform']." + Which + "month");
  95.   YearObject = eval("document.forms['myform']." + Which + "year");
  97.   Month = MonthObject[MonthObject.selectedIndex].text;
  98.   Year = YearObject[YearObject.selectedIndex].text;
  100.   DaysForThisSelection = DaysInMonth(Month, Year);
  101.   CurrentDaysInSelection = DaysObject.length;
  102.   if (CurrentDaysInSelection > DaysForThisSelection)
  103.   {
  104.     for (i=0; i<(CurrentDaysInSelection-DaysForThisSelection); i++)
  105.     {
  106.       DaysObject.options[DaysObject.options.length - 1] = null
  107.     }
  108.   }
  109.   if (DaysForThisSelection > CurrentDaysInSelection)
  110.   {
  111.     for (i=0; i<(DaysForThisSelection-CurrentDaysInSelection); i++)
  112.     {
  113.       NewOption = new Option(DaysObject.options.length + 1);
  114.       DaysObject.add(NewOption);
  115.     }
  116.   }
  117.     if (DaysObject.selectedIndex < 0) DaysObject.selectedIndex == 0;
  118. }
  119. function ChangeOptionDays1(Which)
  120. {
  121.   DaysObject = eval("document.forms['myform']." + Which + "day1");
  122.   MonthObject = eval("document.forms['myform']." + Which + "month1");
  123.   YearObject = eval("document.forms['myform']." + Which + "year1");
  125.   Month = MonthObject[MonthObject.selectedIndex].text;
  126.   Year = YearObject[YearObject.selectedIndex].text;
  128.   DaysForThisSelection = DaysInMonth(Month, Year);
  129.   CurrentDaysInSelection = DaysObject.length;
  130.   if (CurrentDaysInSelection > DaysForThisSelection)
  131.   {
  132.     for (i=0; i<(CurrentDaysInSelection-DaysForThisSelection); i++)
  133.     {
  134.       DaysObject.options[DaysObject.options.length - 1] = null
  135.     }
  136.   }
  137.   if (DaysForThisSelection > CurrentDaysInSelection)
  138.   {
  139.     for (i=0; i<(DaysForThisSelection-CurrentDaysInSelection); i++)
  140.     {
  141.       NewOption = new Option(DaysObject.options.length + 1);
  142.       DaysObject.add(NewOption);
  143.     }
  144.   }
  145.     if (DaysObject.selectedIndex < 0) DaysObject.selectedIndex == 0;
  146. }
  147. //function to set options to today
  148. function SetToToday(Which)
  149. {
  150.   DaysObject = eval("document.forms['myform']." + Which + "Day");
  151.   MonthObject = eval("document.forms['myform']." + Which + "Month");
  152.   YearObject = eval("document.forms['myform']." + Which + "Year");
  155.   YearObject[0].selected = true;
  157.   MonthObject[NowMonth].selected = true;
  159.   ChangeOptionDays(Which);
  161.   DaysObject[NowDay-1].selected = true;
  162. }
  163. function checkdata(){
  164.     if( myform.selgrade.selectedIndex == 0) {
  165.         alert("请选择模拟考试的年级信息!")
  166.         return false;
  167.     }
  168.     if(myform.testname.value==""){
  169.         alert("请输入模拟考试的名称！");
  170.         return false;
  171.     }
  172.     return true;
  173. }
  174. function submitit(myform)
  175. {
  177. }
  179. function saveit(myform)
  180. {
  181.   if (confirm("是否保存所有修改？"))
  182.   {
  183.     myform.action="adminnianjisaveedit.asp";
  184.     myform.submit();
  185.   }
  186. }
  188. function delit(myform)
  189. {
  190.   if (confirm("将删除所有选择的模拟考试数据？"))
  191.   {
  192.     myform.action="admin_mn_test_del.jsp";
  193.     myform.submit();
  194.   }
  195. }
  196. //-->
  197. </script>
  198. <body>
  201. <div align="center">
  202.   <center>
  203.     <p align="left">当前位置： 系统管理 &gt; 增加模拟考试</p>
  204.     <table cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="68%" id="AutoNumber2" border="1">
  205.       <form method="POST" action="admin_mn_test_add.jsp" name="myform" onSubmit="return checkdata()">
  206.       <tr class="trh">
  207.       <td width="100%" height="25"  >
  208.       <p align="center"><b>&nbsp;<font color="#FFFFFF">增加模拟考试</font></b></td>
  209.     </tr>
  210.     <tr class="trh1">
  211.       <td width="100%" height="160"  >
  213.         <p align="center">　</p>
  214.             <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#799AE1" width="99%" height="157">
  215.               <tr>
  216.                 <td width="18%" height="31" bordercolor="#799AE1"> <p align="right">年级：</td>
  217.                 <td height="31" bordercolor="#799AE1"> <select name="selgrade" id="select" size="1">
  218.                     <option selected value="temp">未选择</option>
  219.                     <%Tools.showGradeOption(con,out); %>
  220.                   </select></td>
  221.               </tr>
  222.               <tr>
  223.                 <td width="18%" height="31" bordercolor="#799AE1"> <p align="right">考试名称：</td>
  224.                 <td height="31" bordercolor="#799AE1"> <p align="left">
  225.                     <input name="testname" type="text" id="testname" size="40" maxlength="100">
  226.                 </td>
  227.               </tr>
  228.               <tr>
  229.                 <td width="18%" height="31" bordercolor="#799AE1"> <p align="right">考试开始时间：</td>
  230.                 <td height="31" bordercolor="#799AE1"> <select name="dateyear"  onChange=ChangeOptionDays('date') class="boder2">
  231.                     <option value=2003>2003</option>
  232.                     <option value=2004>2004</option>
  233.                     <option value=2005>2005</option>
  234.                     <option value=2006>2006</option>
  235.                     <option value=2007>2007</option>
  236.                     <option value=2008>2008</option>
  237.                     <option value=2009>2009</option>
  238.                     
  239.                   </select>
  240.                   年
  241.                   <select name="datemonth" onChange=ChangeOptionDays('date')  >
  242.                     <option value="1">01</option>
  243.                     <option value="2">02</option>
  244.                     <option value="3">03</option>
  245.                     <option value="4">04</option>
  246.                     <option value="5">05</option>
  247.                     <option value="6">06</option>
  248.                     <option value="7">07</option>
  249.                     <option value="8">08</option>
  250.                     <option value="9">09</option>
  251.                     <option value="10">10</option>
  252.                     <option value="11">11</option>
  253.                     <option value="12">12</option>
  254.                   </select>
  255.                   月
  256.                   <select name="dateday"  onChange=ChangeOptionDays('date') class="boder2">
  257.                     <option value="1">01</option>
  258.                     <option value="2">02</option>
  259.                     <option value="3">03</option>
  260.                     <option value="4">04</option>
  261.                     <option value="5">05</option>
  262.                     <option value="6">06</option>
  263.                     <option value="7">07</option>
  264.                     <option value="8">08</option>
  265.                     <option value="9">09</option>
  266.                     <option value="10">10</option>
  267.                     <option value="11">11</option>
  268.                     <option value="12">12</option>
  269.                     <option value="13">13</option>
  270.                     <option value="14">14</option>
  271.                     <option value="15">15</option>
  272.                     <option value="16">16</option>
  273.                     <option value="17">17</option>
  274.                     <option value="18">18</option>
  275.                     <option value="19">19</option>
  276.                     <option value="20">20</option>
  277.                     <option value="21">21</option>
  278.                     <option value="22">22</option>
  279.                     <option value="23">23</option>
  280.                     <option value="24">24</option>
  281.                     <option value="25">25</option>
  282.                     <option value="26">26</option>
  283.                     <option value="27">27</option>
  284.                     <option value="28">28</option>
  285.                     <option value="29">29</option>
  286.                     <option value="30">30</option>
  287.                     <option value="31">31</option>
  288.                   </select>
  289.                   日 </td>
  290.               </tr>
  291.               <tr>
  292.                 <td width="18%" height="32" bordercolor="#799AE1"><div align="right">
  293.                     <p>考试结束时间：</p>
  294.                   </div></td>
  295.                 <td height="32" bordercolor="#799AE1"> <select name="dateyear1" class="boder2" id="dateyear1"  onChange=ChangeOptionDays1('date')>
  296.                     <option value=2003>2003</option>
  297.                     <option value=2004>2004</option>
  298.                     <option value=2005>2005</option>
  299.                     <option value=2006>2006</option>
  300.                     <option value=2007>2007</option>
  301.                     <option value=2008>2008</option>
  302.                     <option value=2009>2009</option>
  303.                     
  304.                   </select>
  305.                   年
  306.                   <select name="datemonth1" id="datemonth1" onChange=ChangeOptionDays1('date')  >
  307.                     <option value="1">01</option>
  308.                     <option value="2">02</option>
  309.                     <option value="3">03</option>
  310.                     <option value="4">04</option>
  311.                     <option value="5">05</option>
  312.                     <option value="6">06</option>
  313.                     <option value="7">07</option>
  314.                     <option value="8">08</option>
  315.                     <option value="9">09</option>
  316.                     <option value="10">10</option>
  317.                     <option value="11">11</option>
  318.                     <option value="12">12</option>
  319.                   </select>
  320.                   月
  321.                   <select name="dateday1" class="boder2" id="dateday1"  onChange=ChangeOptionDays1('date')>
  322.                     <option value="1">01</option>
  323.                     <option value="2">02</option>
  324.                     <option value="3">03</option>
  325.                     <option value="4">04</option>
  326.                     <option value="5">05</option>
  327.                     <option value="6">06</option>
  328.                     <option value="7">07</option>
  329.                     <option value="8">08</option>
  330.                     <option value="9">09</option>
  331.                     <option value="10">10</option>
  332.                     <option value="11">11</option>
  333.                     <option value="12">12</option>
  334.                     <option value="13">13</option>
  335.                     <option value="14">14</option>
  336.                     <option value="15">15</option>
  337.                     <option value="16">16</option>
  338.                     <option value="17">17</option>
  339.                     <option value="18">18</option>
  340.                     <option value="19">19</option>
  341.                     <option value="20">20</option>
  342.                     <option value="21">21</option>
  343.                     <option value="22">22</option>
  344.                     <option value="23">23</option>
  345.                     <option value="24">24</option>
  346.                     <option value="25">25</option>
  347.                     <option value="26">26</option>
  348.                     <option value="27">27</option>
  349.                     <option value="28">28</option>
  350.                     <option value="29">29</option>
  351.                     <option value="30">30</option>
  352.                     <option value="31">31</option>
  353.                   </select>
  354.                   日 </td>
  355.               </tr>
  356.             </table>
  357.         <p align="center">　</p>
  359.       </td>
  360.     </tr>
  361.     <tr>
  362.           <td width="100%" height="25" bgcolor="#FFFDE8" bordercolor="#799AE1"> <p align="center">
  363.               <input type="submit" value="增 加" name="B1" class="s02">
  364.               <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp; </span>
  365.               <input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
  366.           </td>
  372.  </tr></form>
  373.   </table>
  374.     <p>&nbsp;</p>
  375.     <form name="admin_mn_test_del" method="get" onSubmit="return submitit(this)">
  376.       <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="532" id="AutoNumber1">
  377.         <tr    class="trh"> 
  378.           <td width="27" align="center" bgcolor="#E1E1E1" height="20"><input type=checkbox name=del_all1 value=1 onclick=FanAll(adminbanji)></td>
  379.           <td width="36" align="center" bgcolor="#E1E1E1"><font color="#FFFFFF"><b>序号</b></font></td>
  380.           <td align="center" bgcolor="#E1E1E1" width="118"> <font color="#FFFFFF"> 
  381.             <b>年级</b> </font></td>
  382.           <td align="center" bgcolor="#E1E1E1" width="322"> <font color="#FFFFFF">考试名称</font></td>
  383.         </tr>
  384.         <%
  385.         int i=1;
  386.         while(rs.next()){%>
  387.         <tr   class="trh1"> 
  388.           <td align="center"   width="27"> <input type="checkbox" name="id" value="<%=rs.getInt("id")%>"></td>
  389.           <td align="center" width="36"><%=i%>　</td>
  390.           <td width="118" align="center"><%=""+rs.getString("gn")%>&nbsp; </td>
  391.           <td width="322" align="center"><div align="left"><%=""+rs.getString("name")%>&nbsp;</div></td>
  392.         </tr>
  393.         <%
  394.       i++;
  395.       }
  396.       rs.close();
  397.       pstmt.close();
  398.       %>
  399.         <caption>
  400.         <p align="right"> 
  401.           <input type="submit" value="删除所选项" name="del" onclick="delit(admin_mn_test_del)" class="s02">
  402.         </p>
  403.         </caption>
  404.       </table>
  405.     </form>
  406.     <p>&nbsp;</p>
  407.   </center>
  408. </div>
  410. </body>
  412. </html>
  413. <%
  414. }
  416. catch(Exception e){
  417.     out.print(e.toString());
  418. }
  419. finally{
  420.     DBCon.dropConnection();
  421. }
  422. %>