📄 tadd2.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<link href="_notes/bbb.css" rel="stylesheet" type="text/css">
<SCRIPT LANGUAGE="JavaScript">
<!--
function isValid(){
if(document.form1.name.value=="")
{
window.alert("请填写科目名！");
document.form1.name.focus();
return false;
}
}
// -->
</SCRIPT>
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
<%@page language="java" import="java.sql.*"%>
<%@page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<jsp:useBean id="db1" scope="page" class="exam.exam"/>
<%
String dep=request.getParameter("give");
String sql1="select depname from departmen where dep='"+dep+"'";
ResultSet rs=db1.executeQuery(sql1);
rs.next();
String depname=rs.getString("depname");
rs.close();
%>
<br>
<br>
<TABLE WIDTH=750 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
<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">
<div align="center">
<p> </p>
<p> </p>
<p> </p>
<p><font color="#2DFFFF" size="5"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="133" height="35">
<param name="movie" value="back2.swf">
<param name="quality" value="high">
<param name="BGCOLOR" value="#99CCCC">
<embed src="back2.swf" width="133" height="35" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" bgcolor="#99CCCC">
</embed>
</object> </font></p>
<p> <a href="tadd.jsp">添加资源</a></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>
<div align="center">
<table width="380" height="64" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<%
String sql="select sbnum,sbname from subject where dep='"+dep+"'";
ResultSet rs0=db.executeQuery(sql);
if(rs0.next())
{
%>
<p><span class="bbb">[<font color="#cc6666"><%=depname%></font>]现有的科目如下</span></p>
<p>
<select name="name">
<%
ResultSet rs1=db.executeQuery(sql);
while(rs1.next())
{
int num=rs1.getInt("sbnum");
String name=rs1.getString("sbname");
%>
<option value="<%=num%>"><%=name%></option>
<%}%>
</select>
</p>
<% rs1.close();
} else { %>
<p><span class="bbb">[<font color="#cc6666"><%=depname%></font>]目前还没有科目，请添加!</span></p>
<p>
<!-- *****************************************************/ -->
</p>
<!--*****************************************************/-->
<%
rs0.close();
}%>
</td>
</tr>
</table>
<table width="382" height="109" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<div align="center" class="bbb">请添加新的科目 </div>
<form name="form1" method="post" action="tadd3.jsp" onSubmit="return isValid();">
<div align="center">
<input type="text" name="name">
<input type="submit" name="Submit" value="提交">
<input type="hidden" name="dep" value="<%=dep%>">
</div>
</form>
</td>
</tr>
</table>
</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">
<div align="center">
<p> <a href="tinsert1.jsp">添加管理员</a></p>
<p> <a href="tdelete1.jsp">删除管理员</a></p>
<p> </p>
<p class="bbb"> </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=749 height=20></TD>
</TR>
</TABLE>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -