<%
dim page,startPos,endPos
dim url
url = "main.asp?page="
page = cint(request.QueryString("page"))
set conn=Server.CreateObject("ADODB.Connection")
conn.open"provider=microsoft.jet.oledb.4.0;data source="&server.mappath("info.mdb")
set rs=server.createobject("adodb.recordset")
sql = "select * from client"
rs.open sql,conn,1,3
rs.pagesize = 2 '每页有多少数据,这里设置为2主要是方便测试
allpage = rs.pagecount '一共有多少页
if page < 1 then page = 1
if page > allpage then page = allpage
rs.absolutepage=page
response.Write("
" & cstr(rs.recordcount) & "条数据 共" & cstr(allpage) & "页" & "" + vbcrlf)
if page > 1 then
response.Write("
首页" + vbcrlf)
response.Write("
上一页" + vbcrlf)
end if
startPos = page - 3 '该数字可以更改,自己试试看,我就不表达了,意会就行了
endPos = page + 3
if startPos < 1 then
startPos = 1
elseif startPos > 1 then
response.Write("
..." + vbcrlf)
end if
if endPos > allpage then
endPos = allpage
end if
for i = startPos to endPos
if i = page then
response.Write("
" & cstr(i) & "")
else
response.Write("
" & cstr(i) & "" + vbcrlf)
end if
next
if endPos < allpage then
response.Write("
..." + vbcrlf)
end if
if page <> allpage then
response.Write("
下一页" + vbcrlf)
response.Write("
尾页" + vbcrlf)
end if
rs.close
conn.close
%>