📄 studentdetail.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>学生个人信息</title>
<style type="text/css">
<!--
.style1 {
font-family: "华文行楷";
font-size: 24px;
font-weight: bold;
color: #003399;
}
a:link {
color: #003399;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #003399;
}
a:hover {
text-decoration: none;
color: #003399;
}
a:active {
text-decoration: none;
color: #003399;
}
-->
</style>
</head>
<body>
<!--#include virtual="../inc/head.htm"-->
<p>
<%
nick=Request("name")
Set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("db/info.mdb")
conn.Open
strSql="select * from studentdetail where snick='" & nick & "'"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.open strSql,conn,1,3
%>
<table width="70%" border="0" align="center">
<tr>
<th colspan="2" scope="col"><span class="style1"><%=nick%>的个人信息</span></th>
</tr>
<tr>
<td width="19%">真实姓名：</td>
<td width="81%"><%=rs("sname")%></td>
</tr>
<tr>
<td>性别：</td>
<td><%=rs("sex")%></td>
</tr>
<tr>
<td>年龄：</td>
<td><%=rs("age")%></td>
</tr>
<tr>
<td>学习程度：</td>
<td><%=rs("grade")%></td>
</tr>
<tr>
<td>邮箱：</td>
<td><%=rs("email")%></td>
</tr>
<tr>
<td>电话：</td>
<td><%=rs("tele")%></td>
</tr>
<tr>
<td>住址：</td>
<td><%=rs("address")%></td>
</tr>
<tr>
<td>寻找家教情况：</td>
<td><%=rs("state")%></td>
</tr>
<tr>
<td>辅导科目一：</td>
<td><%=rs("tutorship1")%></td>
</tr>
<tr>
<td>辅导科目二：</td>
<td><%=rs("tutorship2")%></td>
</tr>
<tr>
<td>备注：</td>
<td><%=rs("demo")%></td>
</tr>
</table>
<p></body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -