jbqk.asp

实训的小作品 关于后台SQL知识的 简单制作！

<!--#include file="../data/const.asp"-->
<%
XH=session("user")
if XH="" then
  Server.Transfer "../login.asp"
end if
session("zpxh")=xh
Set rs=Server.CreateObject ("ADODB.RecordSet")
str="select * from 学生信息表视图 where 学号='" & xh & "'"
set rs=dbconn.execute(str)

if dbconn.Errors.Count<>0 then
%>
  <script language="vbscript">
    alert "提交过程中发生错误，请重新提交！"
    history.back()
 </script>
<%
  response.end
end if
%>

<!--#include virtual="../header.asp" -->
<br>
<table border="0" align="center" width="98%">
  <tr>
    <td>您当前的位置：个人信息</td>
  </tr>
</table>
<br>  
<table cellspacing="0" bordercolor="#cccccc" bordercolordark="#FFFFFF" align="center" border="1" id="mytable">
  <caption><b>个人基本情况表</b></caption>
  <tr height="25"> 
    <th width="8%"><div align="center">学号</div></th>
    <td width="23%"><%=rs("学号")%>&nbsp;</td>
    <th width="8%"><div align="center">姓名</div></th>
    <td width="28%"><%=rs("姓名")%>&nbsp;</td>
    <th width="9%"><div align="center">性别</div></th>
    <td width="9%"><%=rs("性别")%>&nbsp;</td>
    <% if isnull(rs("照片")) then %>
      <td width="15%" rowspan="6" align="center">&nbsp;</td>
    <% else %>
      <td width="15%" rowspan="6" align="center"><img width="100" height="120" src="showphoto.asp">&nbsp;</td>
    <% end if %>
  </tr>
  <tr height="25"> 
    <th><div align="center">籍贯</div></th>
    <td><%=rs("籍贯")%>&nbsp;</td>
    <th><div align="center">出生日期</div></th>
    <td><%=rs("出生年月")%>&nbsp;</td>
    <th><div align="center">民族</div></th>
    <td><%=rs("民族")%>&nbsp;</td>
  </tr>
  <tr height="25"> 
    <th><div align="center">身份证号</div></th>
    <td><%=rs("身份证号")%>&nbsp;</td>
    <th><div align="center">政治面貌</div></th>
    <td><%=rs("政治面貌")%>&nbsp;</td>
    <th><div align="center">&nbsp;</div></th>
    <td>&nbsp;</td>
  </tr>
  <tr height="25"> 
    <th><div align="center">学院</div></th>
    <td><%=rs("学院")%>&nbsp;</td>
    <th><div align="center">系部</div></th>
    <td><%=rs("系部")%>&nbsp;</td>
    <th><div align="center">专业</div></th>
    <td><%=rs("专业")%>&nbsp;</td>
  </tr>
  <tr height="25"> 
    <th><div align="center">班名</div></th>
    <td><%=rs("班级")%>&nbsp;</td>
    <th><div align="center">入学年级</div></th>
    <td><%=rs("年级")%>&nbsp;</td>
    <th><div align="center">入学日期</div></th>
    <td><%=rs("入学日期")%>&nbsp;</td>
  </tr>
  <tr height="25"> 
    <th><div align="center">家庭地址</div></th>
    <td><%=rs("家庭地址")%>&nbsp;</td>
    <th><div align="center">邮政编号</div></th>
    <td><%=rs("邮政编号")%>&nbsp;</td>
    <th><div align="center">联系电话</div></th>
    <td><%=rs("联系电话")%>&nbsp;</td>
  </tr>
</table>
<br>

<!--#include virtual="../footer.asp" -->