⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admincourse.jsp

📁 JSP做的在线选课系统,ACCESS数据库.
💻 JSP
字号:
<%@ page language = "java" contentType = "text/html;charset=gb2312"%>
<%@ page import = "java.sql.*, java.io.*" %>
<jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
<%
	String titlelist[];
	titlelist = new String[99999];
	String strSQL = "select couid ,couname from course ";
	ResultSet rs = subject.executeQuery(strSQL);
	int length = 0;
	while(rs.next())
	{
			String id = rs.getString("couid");
			String title = rs.getString("couname").trim();
			titlelist[length] = title;
			length++;
	}
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("_notes/ccc");
body,td,th {
	color: #FFFFFF;
	font-weight: bold;
	font-size: 12px;
}
a:link {
	color: #FFFFFF;
}
a:visited {
	color: #FFFFFF;
}
-->
</style>
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >

<br>
<br>
<TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  <TR> 
    <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
    <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  </TR>
  <TR> 
    <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
    <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  </TR>
  <TR> 
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
        <tr> 
          <td width="231" valign="bottom"> 
            <div align="center">
              <p><br>
              </p>
              <p>【课程管理】</p>
              <p align="center"> 再这里您可以添加<br>
              或删除课程的信息 <br>
              <br>
              <br>
              </p>
              <table width="200" border="1">
                <tr>
                  <td><div align="center"><a href="adminteacher.jsp">【教师<strong>管理</strong>】</a></div></td>
                </tr>
                <tr>
                  <td><div align="center"><a href="adminstudent.jsp">【学生管理】</a></div></td>
                </tr>
              </table>
              <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
          </div>          </td>
        </tr>
      </table>
    </TD>
    <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
    <TD COLSPAN=5 ROWSPAN=2> 
      <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
        <tr> 
          <td width="510"> 
            <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
              <tr> 
                <td width="510" height="78"> 
                  <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
                </td>
              </tr>
              <tr> 
                <td valign="top">                  <div align="left"><a href="index1.htm">首页</a>&gt;<a href="index3.jsp">后台管理</a>&gt;课程管理<br>
                  <br>
                  <br>
                  <br>
                  <table width="500" border="1" bordercolor="#006666">
                    <tr>
                      <td width="250"><div align="center">添加新的课程</div></td>
                      <td width="234"><div align="center">删改已有课程</div></td>
                    </tr>
                    <tr>
                      <td height="248"><div align="center">
                        <form name="form1" method="post" action="admincourse2.jsp">
                          <table width="250" border="0" bordercolor="#006666">
                            <tr bordercolor="#006666">
                              <td height="28" background="images/bg.gif" class="bbb">
                                <div align="right">课程编号</div></td>
                              <td colspan="2" background="images/bg.gif">
                                  <div align="left">
                                    <input name="couid" type="text" id="couid">
                                  </div></td>
                            </tr>
                            <tr bordercolor="#006666">
                              <td height="28" background="images/bg.gif" class="bbb">
                                <div align="right">课程名称</div></td>
                              <td colspan="2" background="images/bg.gif">
                                <input name="couname" type="text" id="couname">
</td>
                            </tr>
                            <tr bordercolor="#006666">
                              <td height="28" background="images/bg.gif" class="bbb">
                                <div align="right">学分</div></td>
                              <td colspan="2" background="images/bg.gif">
                                <table width="174" height="28" border="0" cellpadding="0" cellspacing="0">
                                  <tr>
                                    <td width="69" align="left">
                                        <div align="left">                                        </div>
                                        <div align="left"><span class="bbb">
                                            <select name="coumark" id="coumark">
                                              <option value="1" selected>一学分</option>
                                              <option value="2">二学分</option>
                                              <option value="3">三学分</option>
                                              <option value="4">四学分</option>
                                            </select>
                                        </span> </div></td>
                                    <td width="33" class="bbb"><div align="right"></div></td>
                                    <td width="72" class="bbb">&nbsp;</td>
                                  </tr>
                              </table>                                </td>
                            </tr>
                            <tr bordercolor="#006666">
                              <td height="28" background="images/bg.gif" class="bbb">
                                <div align="right">备注</div></td>
                              <td colspan="2" bordercolor="#006666" background="images/bg.gif">
                                <textarea name="couback" rows="3" id="couback"></textarea></td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td>
                                <div align="right">
                                  <input name="tijiao" type="submit" id="tijiao" value="提交">
                                </div></td>
                              <td bordercolor="#006666"><div align="left">
                                <input name="chongzhi" type="reset" id="chongzhi" value="重置">
                              </div></td>
                            </tr>
                          </table>
                          </form>
                        </div></td>
                      <td><form name="form2" method="post" action="admincourse3.jsp">
                        <table width="250" border="0">
                          <tr>
                            <td width="90">删改的课程:</td>
                            <td colspan="2" valign="top"><select name="select">
                            <option value="0" selected>选择课程</option>
                            <% for (int i = 0; i < length; i++)
							  		out.print("<option>" + titlelist[i].trim() + "</option>");
							  %>
                            </select></td>
                          </tr>
                          <tr>
                            <td>
                              <p><br>
                                <br>
                                <br>
                                <br>
                                <br>
                                <br>
                                </p></td>
                            <td colspan="2">&nbsp;</td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                            <td colspan="2">&nbsp;</td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                            <td colspan="2">&nbsp;</td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                            <td width="110">
                              <div align="left">
                                <input type="submit" name="Submit" value="修改/删除">
</div></td>
                            <td width="36">&nbsp;</td>
                          </tr>
                        </table>
                      </form></td>
                    </tr>
                  </table>
                  <br>
                </div></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </TD>
    <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  </TR>
  <TR> 
    <TD> 
      <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
        <tr> 
          <td width="231" height="222" valign="top"><div align="center">
            <p><font color="#2DFFFF" size="5"> </font></p>
              <table width="200" border="1">
                <tr>
                  <td><div align="center"><a href="admintc.jsp">【课程分配】</a></div></td>
                </tr>
                <tr>
                  <td><div align="center"><a href="adminscore.jsp">【成绩录入】</a></div></td>
                </tr>
               
              </table>
              <br>
              <br>
              <table width="200" border="0">
                <tr>
                  <td><div align="center"><a href="adminlyb.jsp">查看留言</a></div></td>
                </tr>
              </table>
              <p align="center"><br>
              <a href="index1.htm" class="ccc">[退出系统]</a></p>
              </div>
          </td>
        </tr>
      </table>
    </TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  </TR>
  <TR> 
    <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  </TR>
</TABLE>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -