📄 th.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<title>教师情况浏览</title>
</head>
<body background="imags/032.gif">
<p align="center"><font face="隶书" size="6"><b><font size="7" color="#006699">师资情况浏览</font></b></font></p>
<p align="center"><img src="imags/line121.gif" width="600" height="8"></p>
<div align="center"></div>
<div align="center">
<table border="1" width="72%" height="45" cellpadding="1" cellspacing="0" bordercolor="#003300">
<tr>
<th width="20%" height="20"><font color="#0000FF">系名</font></th>
<th width="20%" height="20"><font color="#0000FF">教师名</font></th>
<th width="21%" height="20"><font color="#0000FF">性别</font></th>
<th width="33%" height="20"><font color="#0000FF">电话</font></th>
</tr>
<%
'set conn=server.createobject("adodb.connection")
'connstr="DBQ="+server.mappath("tyydb.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
'conn.open connstr
set rs=server.createobject("adodb.recordset")
sql="select * from 教师"
set rs=conn.execute(sql)
do while not rs.eof
xiname=rs("xiname")
teachername=rs("teachername")
sex=rs("sex")
teleph=rs("teleph")
%>
<tr>
<td width="20%" height="20" align="center"><%=rs("xiname")%></td>
<td width="20%" height="20" align="center"><%=rs("teachername")%></td>
<td width="21%" height="20" align="center"><%=rs("sex")%></td>
<td width="33%" height="20" align="center"><%=rs("teleph")%></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<p> </p>
<p><a href="index1.asp"><img src="imags/00003.gif" width="77" height="25" border="0"></a></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -