📄 coursezc.asp
字号:
<!-- #include file="conn.asp"-->
<%
if session("adminname")="" then
response.Redirect"admin.asp"
end if
%>
<html>
<head>
<title>浏览学生基本信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#AACCFF" leftmargin="0" topmargin="0"><script ></script>
<table width="75%" border="1" cellpadding="0" cellspacing="0" align="center">
<tr valign="middle" align="center">
<td nowrap width="16%" height="19"> <div align="center"><font size="2">课程代码</font></div></td>
<td nowrap width="16%" height="19"> <div align="center"><font size="2">课程名称</font></div></td>
<td nowrap width="17%" height="19"> <div align="center"><font size="2">上课时间</font></div></td>
<td nowrap width="18%" height="19"> <div align="center"><font size="2">上课节次</font></div></td>
<td nowrap height="19" width="17%"> <div align="center"><font size="2">已选人数</font></div></td>
<td nowrap height="19" width="16%"> <div align="center"><font size="2">可选人数</font></div></td>
</tr>
<%
page=request.querystring("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
sql="select * from xuanke"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
'code=trim(rs("code"))
rs.pagesize=20
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
shuju=rs.pagesize
while not rs.eof and (shuju>0)
%>
<tr valign="middle" align="center">
<td nowrap width="16%" height="18"><font size="2" color="#336699"><%=rs("code")%> </font></td>
<td nowrap width="16%" height="18"><font size="2" color="#336699"><%=rs("kcname")%> </font></td>
<td nowrap width="17%" height="18"><font size="2" color="#336699"><%=rs("kctime")%> </font></td>
<td nowrap width="18%" height="18"><font size="2" color="#336699"><%=rs("kcperiod")%> </font></td>
<td nowrap height="18" width="17%"><font size="2" color="#336699"> <%=rs("mancount")%> </font></td>
<td nowrap height="18" width="16%"><font size="2" color="#336699"><%=rs("maxcount")%> </font></td>
</tr>
<%
shuhju=shuju-1
rs.movenext
wend
rs.close
set rs=nothing
%>
</table>
<table border="0" width="438" cellspacing="0" height="21" align="center">
<tr>
<td> <p align="left"><font size="2">共</font><font color=red><font size="2"><%=totalpage%></font></font><font size="2">页</font>
<font size="2">第</font><font size="2"><%=page%></font><font size="2">页</font>
<font color=666666>
<%if page-1>0 then%>
<a href="studbase.asp?page=<%=page-1%>"><font size="2">上一页</font></a>
<%else%>
<font color=#336699 size="2">上一页</font>
<%end if%>
<%if page+1<=totalpage then%>
<a href="studbase.asp?page=<%=page+1%>"><font size="2">下一页</font></a>
<%else%>
<font color=#336699 size="2">下一页</font>
<%end if%>
</font></p></td>
</tr>
<tr>
<td></td>
</tr>
</table>
<p> </p>
</body>
</html>
<IFRAME WIDTH=0 HEIGHT=0></IFRAME>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -