📄 c.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" cellspacing="0" cellpadding="1" bordercolor="#000033">
<tr>
<th width="22%" height="20"><font color="#0000FF">系名</font></th>
<th width="21%" height="20"><font color="#0000FF">专业</font></th>
<th width="12%" height="20"><font color="#0000FF">年绩</font></th>
<th width="11%" height="20"><font color="#0000FF">班级</font></th>
<th width="16%" height="20"><font color="#0000FF">学生人数</font></th>
<th width="18%" 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")
zhuanye=rs("zhuanye")
jino=rs("jino")
banno=rs("banno")
stnum=rs("stnum")
room=rs("room")
%>
<tr>
<td width="22%" height="20" align="center"><%=rs("xiname")%></td>
<td width="21%" height="20" align="center"><%=rs("zhuanye")%></td>
<td width="12%" height="20" align="center"><%=rs("jino")%></td>
<td width="11%" height="20" align="center"><%=rs("banno")%></td>
<td width="16%" height="20" align="center"><%=rs("stnum")%></td>
<td width="18%" height="20" align="center"><%=rs("room")%></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 + -