📄 add_yuanxi.asp
字号:
<!--#include file="inc/conn.asp"-->
<!--#include file="inc/head.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加院系</title>
</head>
<body>
<form action="up_add_yuanxi.asp" method="post">
<table width="990" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr>
<td width="222" rowspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="222" height="674"> </td>
</tr>
</table></td>
<td width="526" height="158" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr class="style4">
<td height="23" colspan="7" valign="top" class="style4">选择院系名</td>
</tr>
<tr>
<td width="64" rowspan="2" valign="top" class="style4">学院名</td>
<td width="110" rowspan="2" valign="top" class="style4">
<%openDB
sql="SELECT * FROM xueyuan"
set rs=conn.execute(sql)%>
<select name="xy_name" >
<option selected >选择学院</option>
<% while not rs.eof %>
<option value="<%= rs("xy_id") %>"><%= rs("xy_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td width="56" height="29" valign="top" class="style4">新加院名
<input name="si" type="hidden" value="1"></td>
<td colspan="2" valign="top"><input name="xy_name1" type="text" size="15" ></td>
<td width="56" valign="top" class="style4">编号</td>
<td width="125" valign="top" class="style4"><input name="xy_id1" type="text" size="10" ></td>
</tr>
<tr>
<td height="35" valign="top">管理员名</td>
<td colspan="2" valign="top"><input name="adminname" type="text" id="adminname" size="15"></td>
<td valign="top">密码</td>
<td valign="top"><span class="style1">
<input name="passwd" type="password" id="passwd" size="10" >
</span></td>
</tr>
<tr>
<td height="37" valign="top" class="style4">系名</td>
<td colspan="2" valign="top" class="style4"><input name="xi_name" type="text" size="15"></td>
<td width="66" valign="top" class="style4">编号</td>
<td colspan="3" valign="top" class="style4"><input name="xi_id" type="text" ></td>
</tr>
<tr align="center">
<td height="34" colspan="7" valign="top" class="style4"><input type="submit" name="Submit" value="添加"></td>
</tr>
<tr>
<td height="1"></td>
<td></td>
<td></td>
<td></td>
<td width="49"></td>
<td></td>
<td></td>
</tr>
</table></td>
<td width="242" rowspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="242" height="674"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="28" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="td">
<!--DWLayoutTable-->
<tr>
<td width="179" height="28" valign="top" class="style4">院系列表</td>
<td width="347" valign="top"><span style="color: #FF0000">执行删除院系操作是会连学生一起删除<br>
执行删除院操作是会连系一起删除</span><br></td>
</tr>
</table></td>
</tr>
<tr>
<td height="488" valign="top" class="style4">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr>
<td height="15" colspan="5" valign="top" ><hr></td>
</tr>
<%
openDB
sql="SELECT * FROM xueyuan"
set rs1=conn.execute(sql)
while not rs1.eof
xy_id= rs1("xy_id")
sql="SELECT x_name,x_id FROM xi WHERE xy_id='"&xy_id&"'"
set rs2=conn.execute(sql)
sql="select * FROM admin WHERE ad_lev='"&xy_id&"'"
set myrs=conn.execute(sql)
%>
<tr>
<td width="37" height="21" valign="top" class="style4"><%= rs1("xy_id") %></td>
<td colspan="2" valign="top" class="style4"><a href= "show_yuanxi.asp?id=<%=rs1("xy_name")%>"><%= rs1("xy_name") %></a></td>
<td width="166" valign="top"><% if not myrs.eof then %><%= myrs("ad_name") %><% else %><a href= "add_admin.asp?id=<%=rs1("xy_id")%>">添加管理员<% end if %></a></td>
<td width="88" valign="top"><a href= "del_yuanxi.asp?id=<%=rs1("xy_name")%>">删除</a></td>
</tr><% while not rs2.eof %>
<tr>
<td height="22" valign="top"><!--DWLayoutEmptyCell--> </td>
<td width="88" valign="top"><%= rs2("x_id") %></td>
<td colspan="2" valign="top"><a href= "show_yuanxi.asp?id=<%=rs2("x_name")%>"><%= rs2("x_name") %></a></td>
<td valign="top"><a href= "del_yuanxi.asp?id=<%=rs2("x_name")%>">删除</a></td>
</tr>
<% rs2.movenext
wend %>
<tr>
<td height="15" colspan="5" valign="top"><hr></td>
</tr>
<tr>
<td height="1"></td>
<td></td>
<td width="147"></td>
<td></td>
<td></td>
</tr>
<% rs1.movenext
wend
closeDB %>
</table></td>
</tr>
</table>
</form>
</body>
</html>
<!--#include file="inc/foot.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -