📄 show_stu.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>
<%
id=Trim(Request.QueryString("id"))
openDB
sql="SELECT * FROM stu WHERE id="&id
set rs=conn.execute(sql)
show_id=rs("stu_idnum")
show_name=rs("stu_name")
show_sex=rs("stu_sex")
show_area=rs("stu_area")
show_homeadd=rs("stu_homeadd")
show_minzu=rs("stu_minzu")
show_zhengzhi=rs("stu_zhengzhi")
show_zhiwu=rs("stu_zhiwu")
show_xyname=rs("stu_xyname")
show_xname=rs("stu_xname")
show_time=rs("stu_time")
show_homephone=rs("stu_homephone")
show_mobliephone=rs("stu_mobliephone")
show_info=rs("stu_info")
show_bedadd=rs("stu_bedadd")
show_image=rs("stu_image")
id=rs("id")
closeDB
%>
<form action="modify_user.asp" method="post" name="user">
<table width="507" border="0" cellpadding="0" cellspacing="0" class="style4" align="center">
<!--DWLayoutTable-->
<input name="si" type="hidden" value="<%= id%>">
<tr>
<td height="62" colspan="2" align="right" valign="middle">个人 相片</td>
<td colspan="6" align="right" valign="top">
<% if show_image<>"" then %>
<img src="images/face/<%=show_image%>">
<% end if %></td>
<td colspan="11" valign="top"><!--DWLayoutEmptyCell--> </td>
<td width="22" rowspan="11" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td width="43" height="27" valign="middle" class="style4">ID卡号</td>
<td colspan="7" valign="middle"><input name="id" type="text" size="15" value="<%= show_id %>"></td>
<td colspan="2" valign="middle" class="style4">姓名</td>
<td colspan="5" valign="middle"><input name="username" type="text" size="10" value="<%= show_name %>"></td>
<td colspan="2" valign="middle" class="style4">性别</td>
<td colspan="2" valign="middle"><select name="sex">
<option value="男" <% if show_sex="男" then %>selected<% end if %>>男</option>
<option value="女" <% if show_sex="女" then %>selected<% end if %>>女</option>
</select></td>
</tr>
<tr>
<td height="57" valign="middle">学院</td>
<td colspan="4" valign="middle">
<% if session("ad_sign")="0" then
openDB
sql="SELECT xy_name FROM xueyuan"
set rs=conn.execute(sql)%>
<select name="xueyuan" >
<% while not rs.eof %>
<option value="<%= rs("xy_name") %>" <% if show_xyname=rs("xy_name") then %> selected<% end if %>><%= rs("xy_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td colspan="3" valign="middle"><!--DWLayoutEmptyCell--> </td>
<td colspan="8" valign="middle">
<% openDB
sql="SELECT xy_name,xy_id FROM xueyuan"
set rs=conn.execute(sql)
xy_name=rs("xy_name")
xy_id= rs("xy_id")
sql="SELECT x_name FROM xi WHERE xy_id='"&xy_id&"'"
set myrs=conn.execute(sql)
%> <select name="xi" >
<% while not rs.eof %>
<option value="<%= rs("xy_name") %>">——<%= rs("xy_name") %>——</option>
<% while not myrs.eof%>
<option value="<%= myrs("x_name") %>"<% if show_xname=myrs("x_name") then %> selected<% end if %>><%= 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") %>"></td>
<td colspan="3" valign="middle">系
<% 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" >
<% while not rs.eof %>
<option value="<%= rs("x_name") %>" <% if show_xname=rs("x_name") then %> selected<% end if %>><%= rs("x_name") %></option>
<%
rs.movenext
wend
closeDB
%>
</select> <% end if %> </td>
</tr>
<tr>
<td height="26" colspan="3" valign="middle">入学时间</td>
<td colspan="4" valign="middle"><input name="time" type="text" size="8" value="<%= show_time %>"></td>
<td colspan="2"valign="middle">政治面貌</td>
<td colspan="4" valign="middle">
<%
openDB
sql="SELECT zz_name FROM zhengzhi"
set rs=conn.execute(sql)
%>
<select name="zhengzhi">
<% while not rs.eof %>
<option value="<%= rs("zz_name") %>"<% if show_zhengzhi=rs("zz_name") then %> selected<% end if %>><%= rs("zz_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td colspan="3" valign="middle">担任职务</td>
<td colspan="2" valign="middle"><%
openDB
sql="SELECT zw_name FROM zhiwu"
set rs=conn.execute(sql)
%>
<select name="zhiwu">
<% while not rs.eof %>
<option value="<%= rs("zw_name") %>"<% if show_zhiwu=rs("zw_name") then %> selected<% end if %>><%= rs("zw_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td width="1"> </td>
</tr>
<tr>
<td height="39" colspan="4" valign="middle">生源地</td>
<td colspan="2" valign="middle">
<% openDB
sql="SELECT area_name FROM area"
set rs=conn.execute(sql)
%>
<select name="area">
<% while not rs.eof %>
<option value="<%= rs("area_name") %>"<% if show_area=rs("area_name") then %> selected<% end if %>><%= rs("area_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td colspan="5" valign="middle">民族
<% openDB
sql="SELECT mz_name FROM minzu"
set rs=conn.execute(sql)
%>
<select name="minzu">
<% while not rs.eof %>
<option value="<%= rs("mz_name") %>"<% if show_minzu=rs("mz_name") then %> selected<% end if %>><%= rs("mz_name") %></option>
<% rs.movenext
wend
closeDB %>
</select></td>
<td colspan="8" valign="middle"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="26" colspan="4" valign="middle">家庭详细地址</td>
<td colspan="15" valign="middle"><input type="text" name="homeadd" value="<%= show_homeadd %>"></td>
</tr>
<tr>
<td height="26" colspan="4" valign="middle">家庭联系电话</td>
<td colspan="15" valign="middle"><input type="text" name="homephone" value="<%= show_homephone %>"></td>
</tr>
<tr>
<td height="22" colspan="4" valign="middle">学校住址</td>
<td colspan="8" valign="middle"><input type="text" name="bedadd" value="<%= show_bedadd %>"></td>
<td colspan="2" valign="middle">联系电话</td>
<td colspan="5" valign="middle"><p>
<input name="mobliephone" type="text" size="15" value="<%= show_mobliephone %>">
</p></td>
</tr>
<tr>
<td height="21" colspan="19" valign="middle">备注</td>
</tr>
<tr>
<td height="148" colspan="19" valign="top"><textarea name="info" cols="65" rows="10" ><%= show_info %></textarea></td>
</tr>
<tr>
<td height="27" colspan="19" align="center" valign="middle"><input type="submit" name="Submit" value="修改">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
<tr>
<td height="0"></td>
<td width="19"></td>
<td width="6"></td>
<td width="8"></td>
<td width="50"></td>
<td width="6"></td>
<td width="6"></td>
<td width="23"></td>
<td width="31"></td>
<td width="41"></td>
<td width="6"></td>
<td width="6"></td>
<td width="37"></td>
<td width="41"></td>
<td width="18"></td>
<td width="26"></td>
<td width="23"></td>
<td width="95"></td>
<td></td>
<td></td>
</tr>
</table>
</form>
</body>
</html>
<!--#include file="inc/foot.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -