📄 showstudent.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%Response.Buffer=true;%>
<!--#include file="conn.asp"-->
<!--#include file="verifyStudent.asp"-->
<%
var rs;
var id = Request.QueryString("studentNo");
rs=Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection=Conn;
rs.Source="SELECT * FROM student WHERE studentNo="+id;
rs.CursorType=0;
rs.CursorLocation=2;
rs.LockType=3;
rs.Open();
%>
<!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">
<!--#include file="link.asp"-->
<title>登陆测试</title>
<style type="text/css">
body{
text-align:center;
}
</style>
</head>
<body>
<div id="mainIndex">
<div id="top"><!--#include file="top.asp"--></div>
<div id="main">
<div align="center"><a href="search_score_result.asp?studentNo=<%=id%>">查看成绩</a></div>
<table border="1" width="763" bordercolor="#ff0000" bgcolor="#00ffff" cellPadding="0" cellSpacing="0">
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">学籍号：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("studentNo")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">姓名：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("name")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">性别：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%=rs("sex")%> </font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">出生年月：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("birthday")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">民族：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("minzu")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">政治面貌：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%=rs("zhengzhimm")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">所在院系：</font></td>
<td height="20" colspan="2"><font size="2" color="#000000"><%=rs("collegeId")%> </font></td>
<td height="20"><font size="2" color="#FF0000">所学专业：</font></td>
<td height="20" colspan="2"><font size="2" color="#000000"><%=rs("professionId")%> </font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">所在班级：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("classId")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">班级学号：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("studentNo")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">培养方式：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%=rs("peiyangfs")%> </font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">学制：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("xuezhi")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">入学年份：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("ruxuenianfen")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">学历：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%=rs("xueli")%> </font></td>
</tr>
<tr>
<td height="20" width="126"><font size="2" color="#FF0000">外语语种：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("waiyu")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">外语水平：</font></td>
<td height="20" width="126"><font size="2" color="#000000"><%=rs("waiyushuiping")%> </font></td>
<td height="20" width="126"><font size="2" color="#FF0000">身体状况：</font></td>
<td height="20" width="130"><font size="2" color="#000000"><%=rs("shentizz")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">在读情况：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%=rs("zaiduqk")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">家庭住址：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%=rs("address")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">联系电话：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%=rs("phoneNum")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">EMAIL：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%=rs("email")%> </font></td>
</tr>
<tr>
<td height="20"><font size="2" color="#FF0000">个人主页：</font></td>
<td height="20" colspan="5"><font size="2" color="#000000"><%=rs("homePage")%> </font></td>
</tr>
<tr>
<td height="200"><font size="2" color="#FF0000">大学期间奖惩情况：</font></td>
<td height="200" colspan="5"><font size="2" color="#000000"><%=rs("huojiangqk")%> </font></td>
</tr>
</table>
</div>
</div>
<%
rs.Close();
rs=null;
Conn.Close();
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -