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

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

其他数据库

开发平台：

Java

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