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

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

其他数据库

开发平台：

Java

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