?? teacher_list.asp
字號:
<!--#include file="Conn.asp"-->
<!--#include file="Inc/CheckUser.asp"-->
<head>
<link rel="stylesheet" type="text/css" href="Style/style.css">
</head>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center" ID="table4">
<tr style="BACKGROUND-IMAGE: url('Images/title1.gif');">
<td bgcolor="#99A6BF" style="background-image: url('')">
<b>教師名</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')">
<b>性 別</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')">
<b>所屬單位</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')">
<b>所屬專業(yè)</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')">
<b>個人檔案</b></td>
</tr>
<%
Set rs = Server.CreateObject("ADODB.RecordSet")
sql = "Select * From [userinfo] Where userpower = '1'"
rs.Open sql,conn,1,1
dim i,j
dim page,pagecount,show_str,total,content
if rs.BOF or rs.EOF then
total=0
page=0
pagecount=0
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
i = 0
total = rs.RecordCount
rs.pagesize = 10
if request("page") = "" then
page = 1
else
page = request("page")
end if
rs.AbsolutePage = page
pagecount = rs.pagecount
if int(page) >= int(rs.pagecount) then
page = rs.pagecount
end if
if page = 1 then
show_str = ""
else
show_str = " <a href=?page="&page-1&"&action=list>上一頁</a> "
end if
if int(page) >= int(rs.pagecount) then
show_str = show_str&""
else
show_str = show_str&" <a href=?page="&page+1&"&action=list>下一頁</a> "
end if
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("userid")%>
</td>
<td>
<%if rs("sex") = 1 then:Response.Write "男":else:Response.Write "女":end if%>
</td>
<td>
<%=rs("college")%>
</td>
<td>
<%=rs("class")%>
</td>
<td>
<a href="MyProfile.asp?id=<%=rs("id")%>">詳細(xì)信息
</a>
</td>
</tr>
<%
i = i + 1
if i = rs.pagesize then exit do
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="5">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="table5">
<tr>
<td>
</td>
<td>
每頁顯示
<%=rs.PageSize%>
個用戶， 共 <font color="red"><b>
<%=page%>
</b></font>/<%=pagecount%>
頁， 共有 <font color="red"><b>
<%=total%>
</b></font>個用戶，
<%=show_str%>
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -