?? 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 + -