📄 add_user.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>学生信息管理系统—<%= session("xy_name") %>-添加学生</title>
</head>
<body>
<form action="up_add_user.asp" method="post">
<table width="990" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="210" height="522" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="210" height="522"> </td>
</tr>
</table></td>
<td width="554" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tab">
<!--DWLayoutTable-->
<tr>
<td width="554" height="32" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" >
<!--DWLayoutTable-->
<tr>
<td width="554" height="32" valign="top" class="td">填写资料</td>
</tr>
</table></td>
</tr>
<tr>
<td height="68" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr>
<td width="32" height="31" valign="top" class="style4">ID</td>
<td width="105"valign="top" class="style4"><input name="id" type="text" size="15">
</td>
<td width="47" valign="top">姓名 </td>
<td width="96" valign="top"><input name="username" type="text" size="10"></td>
<td width="45" valign="top">性别 </td>
<td width="231" valign="top"><select name="sex">
<option selected>男</option>
<option >女</option>
</select></td>
</tr>
<tr>
<td height="39" colspan="1" valign="top" class="style4">院系</td>
<td colspan="5" valign="top" class="style4">
<% if session("ad_sign")="0" then
sql="SELECT xy_name FROM xueyuan"
openDB
set rs=conn.execute(sql)%>
<select name="xueyuan" >
<option value="0" selected >请选择</option>
<% while not rs.eof %>
<option value="<%= rs("xy_name") %>"><%= rs("xy_name") %></option>
<% rs.movenext
wend
closeDB %>
</select>
<select name="xi" >
<option value="0" selected >请选择</option>
<% openDB
sql="SELECT xy_name,xy_id FROM xueyuan"
set rs=conn.execute(sql)
while not rs.eof
xy_name=rs("xy_name")
xy_id= rs("xy_id")
%>
<option value="<%= rs("xy_name") %>">——<%= rs("xy_name") %>——</option>
<%
sql="SELECT x_name FROM xi WHERE xy_id='"&xy_id&"'"
set myrs=conn.execute(sql)
while not myrs.eof%>
<option value="<%= myrs("x_name") %>"><%= myrs("x_name") %></option>
<% myrs.movenext
wend
rs.movenext
wend
closeDB
%>
</select>
<% else %>
<input name="xueyuan" type="text" size="15" readonly="true" value="<%= session("xy_name") %>">
<% openDB
xy_name=session("xy_name")
sql="SELECT xy_id FROM xueyuan where xy_name='"&xy_name&"'"
set rs=conn.execute(sql)
xy_id= rs("xy_id")
closeDB
openDB
sql="SELECT x_name FROM xi WHERE xy_id='"&xy_id&"'"
set rs=conn.execute(sql)
%> <select name="xi" >
<option value="0" selected >请选择</option>
<% while not rs.eof %>
<option value="<%= rs("x_name") %>"><%= rs("x_name") %></option>
<% rs.movenext
wend
closeDB %>
</select> <% end if %></td>
</tr>
<tr>
<td height="0"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="55" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr>
<td width="100" height="33" valign="top">入学时间</td>
<td colspan="2" valign="top"><input name="time" type="text" size="8"></td>
<td width="67" valign="top">民族</td>
<td colspan="3" valign="top"> <% openDB
sql="SELECT mz_name FROM minzu"
set rs=conn.execute(sql)
%>
<select name="minzu">
<% while not rs.eof %>
<option value="<%= rs("mz_name") %>"><%= rs("mz_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
</tr>
<tr>
<td height="39" valign="top"><!--DWLayoutEmptyCell--> </td>
<td width="74" valign="top">职务</td>
<td width="78" valign="top">
<% openDB
sql="SELECT zw_name FROM zhiwu"
set rs=conn.execute(sql) %>
<select name="zhiwu">
<option value="0" selected>请选择</option>
<% while not rs.eof %>
<option value="<%= rs("zw_name") %>"><%= rs("zw_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td valign="top">政治面貌</td>
<td width="82" valign="top">
<%
openDB
sql="SELECT zz_name FROM zhengzhi"
set rs=conn.execute(sql)
%>
<select name="zhengzhi">
<option value="0" selected>请选择</option>
<% while not rs.eof %>
<option value="<%= rs("zz_name") %>"><%= rs("zz_name") %></option>
<% rs.movenext
wend
closeDB %>
</select> </td>
<td width="70" valign="top">生源地</td>
<td width="83" valign="top">
<% openDB
sql="SELECT area_name FROM area"
set rs=conn.execute(sql) %>
<select name="area">
<option value="0" selected>请选择</option>
<% while not rs.eof %>
<option value="<%= rs("area_name") %>"><%= rs("area_name") %></option>
<% rs.movenext
wend
closeDB %>
</select> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="126" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr valign="middle">
<td width="103" height="30" valign="top">学校住址</td>
<td width="451" valign="top"><input type="text" name="bedadd"></td>
</tr>
<tr>
<td height="31" valign="top" class="style4">联系电话</td>
<td valign="top"><input name="mobliephone" type="text"></td>
</tr>
<tr>
<td height="33" valign="top">家庭详细地址</td>
<td valign="top"><input type="text" name="homeadd"></td>
</tr>
<tr>
<td height="32" valign="top">家庭联系电话</td>
<td valign="top"><input type="text" name="homephone"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="241" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="style4">
<!--DWLayoutTable-->
<tr>
<td width="554" height="23" valign="top">备注 </td>
</tr>
<tr>
<td height="194" valign="top"><textarea name="info" cols="65" rows="10"></textarea></td>
</tr>
<tr>
<td height="24" align="center" valign="top"><input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="226" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="226" height="522"> </td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
<!--#include file="inc/foot.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -