?? user.asp
字號:
<!--#include file="conn.asp"-->
<%
if session("admin")="" then
response.Redirect"login.asp"
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>無標題文檔</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
}
-->
</style>
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<%
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from Member order by id desc"
rs.open sql,conn,1,1
%>
<body>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" height="30" align="center" bgcolor="#00CCFF" class="c">編號</td>
<td width="20%" height="30" align="center" bgcolor="#00CCFF" class="c">用戶名</td>
<td width="20%" height="30" align="center" bgcolor="#00CCFF" class="c">主域名</td>
<td width="20%" height="30" align="center" bgcolor="#00CCFF" class="c">修改</td>
<td width="20%" height="30" align="center" bgcolor="#00CCFF" class="c">刪除</td>
</tr>
<%if rs.bof and rs.eof then%>
<tr>
<td height="30" colspan="5" align="center" class="kj">暫無用戶信息</td>
</tr>
<%
response.end
else
dim page_no
if request.querystring("page_no")="" then
page_no=1
else
page_no=cint(request.querystring("page_no"))
end if
rs.pagesize=17
rs.absolutepage=page_no
%>
<%
dim i
i=rs.pagesize
do while not rs.eof and i>0
i=i-1
%>
<tr>
<td width="20%" height="30" align="center" class="xian"><%=rs("id")%></td>
<td width="20%" height="30" align="center" class="xian"><%=rs("UserName")%></td>
<td width="20%" height="30" align="center" class="xian"><%=rs("MainUrl")%></td>
<td width="20%" height="30" align="center" class="xian"><a href="edituser.asp?id=<%=rs("id")%>">修改</a></td>
<td width="20%" height="30" align="center" class="xian"><a href="deluser.asp?id=<%=rs("id")%>">刪除</a></td>
</tr>
<%
rs.movenext
loop
end if
%>
<tr>
<td height="30" colspan="5" align="center" class="xian">
<%for i=1 to rs.pagecount
if i=page_no then
response.write i&" "
else
response.write "<a href='user.asp?page_no="&i&"'>"&i&"</a> "
end if
next
%></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -