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