st_body.asp

职业培训学校学生档案成绩费用管理系统V1.0免费版.rar

<%sub st_body(user_number)
set rs=server.createobject("adodb.recordset")
sql="select * from st_info where user_number='"&user_number&"'"
rs.open sql,conn,1,1
%>
<div align="center">
<table border="1" width="500" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
<tr>
  <td width="100%" colspan="3" align="center">查看学生详细信息</td>
</tr>
<tr>
  <td width="37%" align="right">学号：</td>
  <td width="38%" align="left"><%=rs("user_number")%></td>
  <td width="25%" align="left" rowspan="6" align="center">
  <%
	set rs8=server.createobject("adodb.recordset")
	sql8="select * from INFO where user_id="& rs("id")
	rs8.open sql8,conn,3,3
	%>
	<%if not rs8.eof then%>
	<img border="0" src="upload/<%=rs8("filepath")%>" width="85" height="113">
	<%else%>
	<a href="upload/index.asp?user_id=<%=rs("id")%>">暂无该生图片，点击这里添加</a>
	<%end if
	rs8.close
	set rs8=nothing
  %>
	</td>
</tr>
<tr>
  <td width="37%" align="right">姓名：</td>
  <td width="38%" align="left"><%=rs("user_name")%></td>
</tr>
<tr>
  <td width="37%" align="right">状态：</td>
  <td width="38%" align="left"><%=rs("user_state")%></td>
</tr>
<tr>
  <td width="37%" align="right">入学时间：</td>
  <td width="38%" align="left"><%=rs("in_time")%></td>
</tr>
<tr>
  <td width="37%" align="right">身份证号：</td>
  <td width="38%" align="left"><%=rs("user_idnumber")%></td>
</tr>
<tr>
  <td width="37%" align="right">性别：</td>
  <td width="38%" align="left"><%=rs("user_sex")%></td>
</tr>
<tr>
  <td width="37%" align="right">出生年月：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_time")%></td>
</tr>
<tr>
  <td width="37%" align="right">婚姻情况：</td>
  <td width="63%" align="left" colspan="2"><%=rs("marriage")%></td>
</tr>
<tr>
  <td width="37%" align="right">是否住宿：</td>
  <td width="63%" align="left" colspan="2"><%=rs("lodging")%></td>
</tr>
<tr>
  <td width="37%" align="right">学历：</td>
  <td width="63%" align="left" colspan="2"><%=rs("u_diploma")%></td>
</tr>
<tr>
  <td width="37%" align="right">专业：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_major")%></td>
</tr>
<tr>
  <td width="37%" align="right">班级：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_class")%></td>
</tr>
<tr>
  <td width="37%" align="right">省市：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_city")%></td>
</tr>
<tr>
  <td width="37%" align="right">地县：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_area")%></td>
</tr>
<tr>
  <td width="37%" align="right">地址：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_address")%></td>
</tr>
<tr>
  <td width="37%" align="right">邮编：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_postcode")%></td>
</tr>
<tr>
  <td width="37%" align="right">家庭电话：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_homephone")%></td>
</tr>
<tr>
  <td width="37%" align="right">寝室电话：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_bedroomphone")%></td>
</tr>
<tr>
  <td width="37%" align="right">移动电话：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_mobilephoe")%></td>
</tr>
<tr>
  <td width="37%" align="right">电子邮箱：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_mail")%></td>
</tr>
<tr>
  <td width="37%" align="right">QQ号码：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_qq")%></td>
</tr>
<tr>
  <td width="37%" align="right">是否办证：</td>
  <td width="63%" align="left" colspan="2"><%=rs("certificate")%></td>
</tr>
<tr>
  <td width="37%" align="right">是否就业：</td>
  <td width="63%" align="left" colspan="2"><%=rs("employment")%></td>
</tr>
<tr>
  <td width="37%" align="right" valign="top">高考成绩：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_collogetestach")%></td>
</tr>
<tr>
  <td width="37%" align="right" valign="top">奖惩情况：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_rp")%></td>
</tr>
<tr>
  <td width="37%" align="right" valign="top">备注信息：</td>
  <td width="63%" align="left" colspan="2"><%=rs("user_info")%></td>
</tr>
<tr>
  <td width="100%" align="right" valign="top" colspan="3">
	<p align="center"><a href="mod_info.asp?id=<%=rs("id")%>">编辑该学生信息</a></td>
</tr>
</table>
</div>
<%
rs.close
set rs=nothing
end sub
%>