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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 其他数据库 > 查看源码
adminscore.jsp
资源名称：08155209833.rar　[点击查看]
上传用户：mkymky1985
上传日期：2014-06-23
资源大小：754k
文件大小：11k
源码类别：

其他数据库

开发平台：

Java

adminscore.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*, java.io.*" %>
  3. <jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
  4. <%
  5. String titlelist[];
  6. titlelist = new String[99999];
  7. String strSQL = "select stuid ,stuname from student ";
  8. ResultSet rs = subject.executeQuery(strSQL);
  9. int length = 0;
  10. while(rs.next())
  11. {
  12. String id = rs.getString("stuid");
  13. String title = rs.getString("stuname").trim();
  14. titlelist[length] = title;
  15. length++;
  16. }
  17. %>
  18. <%
  19. String titlelist1[];
  20. titlelist1 = new String[99999];
  21. String strSQL1 = "select teaid ,teaname from teacher ";
  22. ResultSet rs1 = subject.executeQuery(strSQL1);
  23. int length1 = 0;
  24. while(rs1.next())
  25. {
  26. String id1 = rs1.getString("teaid");
  27. String title1 = rs1.getString("teaname").trim();
  28. titlelist1[length1] = title1;
  29. length1++;
  30. }
  31. %>
  33. <%
  34. String titlelist2[];
  35. titlelist2 = new String[99999];
  36. String strSQL2 = "select couid ,couname from course ";
  37. ResultSet rs2 = subject.executeQuery(strSQL2);
  38. int length2 = 0;
  39. while(rs2.next())
  40. {
  41. String id2 = rs2.getString("couid");
  42. String title2 = rs2.getString("couname").trim();
  43. titlelist2[length2] = title2;
  44. length2++;
  45. }
  46. %>
  48. <html>
  49. <head>
  50. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  51. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  52. <style type="text/css">
  53. <!--
  54. @import url("_notes/ccc");
  55. body,td,th {
  56. color: #FFFFFF;
  57. font-weight: bold;
  58. font-size: 12px;
  59. }
  60. a:link {
  61. color: #FFFFFF;
  62. }
  63. a:visited {
  64. color: #FFFFFF;
  65. }
  66. -->
  67. </style>
  68. </HEAD>
  69. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  71. <br>
  72. <br>
  73. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  74.   <TR> 
  75.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  76.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  77.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  78.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  79.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  80.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  81.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  82.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  83.   </TR>
  84.   <TR> 
  85.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  86.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  87.   </TR>
  88.   <TR> 
  89.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  90.   </TR>
  91.   <TR> 
  92.     <TD> 
  93.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  94.         <tr> 
  95.           <td width="231" valign="bottom"> 
  96.             <div align="center">
  97.               <p><br>
  98.               </p>
  99.               <p>【成绩录入】</p>
  100.               <p align="center"> 在这里您可以对学<br>
  101.               生的成绩进行录入<br>
  102.               <br>
  103.               <br>
  104.               </p>
  105.               <table width="200" border="1">
  106.                 <tr>
  107.                   <td><div align="center"><a href="adminteacher.jsp">【教师<strong>管理</strong>】</a></div></td>
  108.                 </tr>
  109.                 <tr>
  110.                   <td><div align="center"><a href="admincourse.jsp">【课程<strong>管理</strong>】</a></div></td>
  111.                 </tr>
  112.               </table>
  113.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  114.           </div>          </td>
  115.         </tr>
  116.       </table>
  117.     </TD>
  118.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  119.     <TD COLSPAN=5 ROWSPAN=2> 
  120.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  121.         <tr> 
  122.           <td width="510"> 
  123.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  124.               <tr> 
  125.                 <td width="510" height="78"> 
  126.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  127.                 </td>
  128.               </tr>
  129.               <tr> 
  130.                 <td valign="top">                  <div align="left"><a href="index1.htm">首页</a>&gt;<a href="index3.jsp">后台管理</a>&gt;成绩录入<br>
  131.                   <br>
  132.                   <br>
  133.                   <br>
  134.                   <table width="500" border="1" bordercolor="#006666">
  135.                     <tr>
  136.                       <td><div align="center">学生成绩录入</div>                        <div align="center"></div></td>
  137.                       </tr>
  138.                     <tr>
  139.                       <td height="248"><div align="center">
  140.                         <form name="form1" method="post" action="adminscore2.jsp">
  141.                           <table width="253" border="0" bordercolor="#006666">
  142.                             <tr bordercolor="#006666">
  143.                               <td width="67" height="28" background="images/bg.gif" class="bbb">
  144.                                 <div align="right">学生姓名</div></td>
  145.                               <td colspan="2" background="images/bg.gif">
  146.                                     <div align="left">
  147.                                       <select name="select" id="select">
  148.                                        <option value="0" selected>请选择学生</option>
  149.                             <% for (int i = 0; i < length; i++)
  150.    out.print("<option>" + titlelist[i].trim() + "</option>");
  151.   %>
  152.                                       </select>
  153.                                     </div></td>
  154.                             </tr>
  155.                             <tr bordercolor="#006666">
  156.                               <td height="28" background="images/bg.gif" class="bbb">
  157.                                 <div align="right">教师姓名</div></td>
  158.                               <td colspan="2" background="images/bg.gif">
  159.                                   <div align="left">
  160.                                     <select name="select2" id="select2">
  161.                                       <option selected>请选择教师</option>
  162.                                       <% for (int i = 0; i < length1; i++)
  163.    out.print("<option>" + titlelist1[i].trim() + "</option>");
  164.   %>
  165.                                     </select>                              
  166.                                       </div></td>
  167.                             </tr>
  168.                             <tr>
  169.                               <td height="28" background="images/bg.gif" class="bbb">
  170.                                 <div align="right">课程名称</div></td>
  171.                               <td colspan="2" bordercolor="#006666" background="images/bg.gif">
  172.                                   <div align="left">
  173.                                     <select name="select3" id="select3">
  174.                                         <option selected>请选择课程</option><% for (int i = 0; i < length2; i++)
  175.    out.print("<option>" + titlelist2[i].trim() + "</option>");
  176.   %>
  177.                                     </select>
  178.                                   </div></td>
  179.                             </tr>
  180.                             <tr bordercolor="#006666">
  181.                               <td height="28" background="images/bg.gif" class="bbb">
  182.                                 <div align="right">学期</div></td>
  183.                               <td colspan="2" background="images/bg.gif">
  184.                                 <table width="174" height="28" border="0" cellpadding="0" cellspacing="0">
  185.                                   <tr>
  186.                                     <td width="69">
  187.                                       <div align="left">
  188.                                         <select name="select4" id="select4">
  189.                                           <option value="1">第一学年</option>
  190.                                           <option value="2">第二学年</option>
  191.                                           <option value="3">第三学年</option>
  192.                                           <option value="4">第四学年</option>
  193.                                           <option selected>选择学年</option>
  194.                                         </select>
  195. </div>
  196.                                       <div align="right"> </div></td>
  197.                                     <td width="33" class="bbb"><div align="right">成绩</div></td>
  198.                                     <td width="72" class="bbb"><input name="select5" type="text" id="select5" size="4"></td>
  199.                                   </tr>
  200.                               </table></td>
  201.                             </tr>
  202.                             <tr>
  203.                               <td>&nbsp;</td>
  204.                               <td width="65">
  205.                                     <div align="right">
  206.                                       <input name="tijiao" type="submit" id="tijiao" value="提交">
  207.                                     </div></td>
  208.                               <td width="107" bordercolor="#006666"><div align="left">
  209.                                   <input name="chongzhi" type="reset" id="chongzhi" value="重置">
  210.                               </div></td>
  211.                             </tr>
  212.                           </table>
  213.                         </form>
  214.                         </div></td>
  215.                       </tr>
  216.                   </table>
  217.                   <br>
  218.                 </div></td>
  219.               </tr>
  220.             </table>
  221.           </td>
  222.         </tr>
  223.       </table>
  224.     </TD>
  225.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  226.   </TR>
  227.   <TR> 
  228.     <TD> 
  229.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  230.         <tr> 
  231.           <td width="231" height="222" valign="top"><div align="center">
  232.             <p><font color="#2DFFFF" size="5"> </font></p>
  233.               <table width="200" border="1">
  234.                 <tr>
  235.                   <td><div align="center"><a href="admincourse.jsp">【课程分配】</a></div></td>
  236.                 </tr>
  237.                 <tr>
  238.                   <td><div align="center"><a href="adminstudent.jsp">【学生管理】</a></div></td>
  239.                 </tr>
  240.                 
  241.               </table>
  242.               <br>
  243.               <br>
  244.               <table width="200" border="0">
  245.                 <tr>
  246.                   <td><div align="center"><a href="adminlyb.jsp">查看留言</a></div></td>
  247.                 </tr>
  248.               </table>
  249.               <p align="center"><br>
  250.               <a href="index1.htm" class="ccc">[退出系统]</a></p>
  251.               </div>
  252.           </td>
  253.         </tr>
  254.       </table>
  255.     </TD>
  256.   </TR>
  257.   <TR> 
  258.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  259.   </TR>
  260.   <TR> 
  261.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  262.   </TR>
  263. </TABLE>
  264. </BODY>
  265. </HTML>