📄 addmodify.asp
字号:
<!--#include file="a25175_top.asp"-->
<link href="../25175css_pro.css" rel="stylesheet" type="text/css">
<!--#include file="../Function.asp"-->
<!--#include file="a25175_conn.asp"-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
function checkdata() {
if (document.frm.class1.value=='') {
window.alert ("请输入班级名称！")
return false}
return true
}
</script>
</head>
<body>
<table width="970" height="605" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="188" rowspan="4" valign="top"></td>
</tr>
<tr>
<td width="589" height="50" align="center" valign="top"><form onSubmit="return checkdata()" action="addclassok.asp" method="post" name="frm" id="frm" >
<table width="90%" border="0" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr>
<td height="25" colspan="3" align="center">添加班级</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="25%" align="right">班级院别：</td>
<td height="25"><select name="DEPART" size="1" id="DEPART" style="BORDER-RIGHT: rgb(126,126,126) 1px solid; BORDER-TOP: rgb(126,126,126) 1px solid; BORDER-LEFT: rgb(126,126,126) 1px solid; BORDER-BOTTOM: rgb(126,126,126) 1px solid; BACKGROUND-COLOR: rgb(255,255,255); width: 120px; font-size: 12px; color: #000000">
<option selected>请您选择教师院别</option>
<%
strsql="select * from department order by showid"
set rs=db.execute(strsql)
do while not rs.eof
response.Write "<option select>"&rs("department")&"</option>"
rs.movenext
loop
%>
</select></td>
<td> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right">班级名称：</td>
<td width="51%" height="25"><input name="CLASS1" type="text" id="CLASS1" size="17"></td>
<td width="25%"><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form></td>
<td></td>
</tr>
<tr>
<td height="50" align="center" valign="top"><form onSubmit="return checkdata()" action="" method="post" name="frm1" id="frm1" >
<table width="90%" border="0" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr>
<td height="25" colspan="3" align="center">班级查询</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="25%" align="right">班级院别：</td>
<td width="51%" height="25"><select name="DEPARTment" size="1" id="DEPARTment" style="BORDER-RIGHT: rgb(126,126,126) 1px solid; BORDER-TOP: rgb(126,126,126) 1px solid; BORDER-LEFT: rgb(126,126,126) 1px solid; BORDER-BOTTOM: rgb(126,126,126) 1px solid; BACKGROUND-COLOR: rgb(255,255,255); width: 120px; font-size: 12px; color: #000000">
<option selected>请您选择教师院别</option>
<%
strsql="select * from department order by showid"
set rs=db.execute(strsql)
do while not rs.eof
response.Write "<option select>"&rs("department")&"</option>"
rs.movenext
loop
%>
</select></td>
<td width="25%"><input name="Submit2" type="submit" id="Submit2" value="开始查询"></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td height="400" align="center" valign="top"><%
department=request("department")
if department<>"" then%>
<table width="90%" border="0" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr align="center" bgcolor="#6699CC">
<td width="17%" height="25">序号</td>
<td width="23%">班级名称：</td>
<td width="26%">所属院别：</td>
<td width="17%"> </td>
<td width="17%"> </td>
</tr>
<%
strsql="select * from CLASS WHERE department='"&department&"' order by id"
set rs=db.execute(strsql)
j=1
do while not rs.eof
CLASSNAME=rs("CLASSNAME")
department=rs("department")
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="25"><%=j%></td>
<td><%=CLASSNAME%></td>
<td><%=department%></td>
<td><a href=CLASSMODIFY.asp?ID=<%=rs("ID")%> target="_self">修改</a></td>
<td><a href=CLASSDEL.asp?ID=<%=rs("ID")%> target="_self">删除</a></td>
</tr>
<%
j=j+1
rs.movenext
loop
%>
</table>
<%end if%>
<%
response.Write "【"&admin&"】<br>【"&adminpassword&"】<br>【"&password&"】"
%> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -