📄 ziliao.asp
字号:
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.recordset")
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("base\dumm.mdb")
Cnn.Open StrCnn
%>
<%
ne = request("move")
if ne= "next" then
session ("currentpage") = session ("currentpage")+1
ne = ""
end if
if ne = "prev" then
session ("currentpage") = session ("currentpage")-1
ne = ""
end if
if session ("currentpage") = "" then
session ("currentpage") = 1
end if
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="format.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%rs.open "SELECT * FROM 资料 order by 登录时间 desc",cnn,3
rs.pagesize = 13
rs.absolutepage = session ("currentpage")
%>
<tr>
<td width="9%">
<%if session ("currentpage") > 1 then%>
<a href="ziliao.asp?move=prev">上一页</a>
<%end if%>
</td>
<td width="11%"> </td>
<td width="11%">
<%if session ("currentpage") < rs.pagecount then%>
<a href = "ziliao.asp?move=next">下一页
<%end if%>
</a></td>
<td width="20%"> </td>
<td width="8%"> </td>
<td width="17%"> </td>
<td width="14%"> </td>
<td width="10%"> </td>
</tr>
<tr>
<td width="9%">昵称</td>
<td width="11%">密码</td>
<td width="11%">E-mail</td>
<td width="20%">主页</td>
<td width="8%">地区</td>
<td width="17%">ip</td>
<td width="14%">途径</td>
<td width="10%">年龄</td>
</tr>
<%
while not rs.eof and numrows <= rs.pagesize
%>
<tr>
<td width="9%"><%= rs("昵称")%></td>
<td width="11%"><%= rs("密码")%></td>
<td width="11%"><%= rs("mail")%></td>
<td width="20%"><%= rs("个人主页")%></td>
<td width="8%"><%= rs("地区")%></td>
<td width="17%"><%= rs("ip")%></td>
<td width="14%"><%= rs("途径")%></td>
<td width="10%"><%= rs("年龄")%></td>
</tr>
<%rs.movenext
numrows = numrows + 1
wend %>
<%rs.close
cnn.close %>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -