<%
<!--#include file="conn.asp"-->

Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
//建立驅(qū)動(dòng)
conn.open connstr//管理數(shù)據(jù)庫
sqlzlb = "select * from formtable"
rs.PageSize = 20 '這里設(shè)定每頁顯示的記錄數(shù)
rs.CursorLocation = 3
rs.Open sqlzlb,conn,0,2,1
TotalNumber = rs.RecordCount '顯示記錄總數(shù)
pre = true
last = true
page = trim(Request.QueryString("page"))

if len(page) = 0 then
intpage = 1
pre = false
else
if cint(page) =< 1 then
intpage = 1
pre = false
else
if cint(page) >= rs.PageCount then
intpage = rs.PageCount
last = false
else
intpage = cint(page)
end if
end if
end if
if not rs.eof then
rs.AbsolutePage = intpage
end if
%>
<!--循環(huán)開始-->
<% 
for i=1 to rs.PageSize
if rs.EOF or rs.BOF then exit for
%>
...............您的輸出內(nèi)容.............
..........................................
<% 
rs.movenext
next
%>
<!--循環(huán)體結(jié)束
分頁部分：-->
<table width="99%" border="1" cellpadding="2" cellspacing="2" borderColorLight=#808080 borderColorDark=#ffffff>
<tr>
<%if rs.pagecount > 0 then%>
<td width="13%" align="left">當(dāng)前頁<%=intpage%>/<%=rs.PageCount%>/共<%=TotalNumber>個(gè)信息</td>
<%else%>
<td width="41%" align="left">當(dāng)前頁0/0</td><%end if%>
<td width="46%" align="right"> <a href="list_zlb.asp?page=1">首頁</a>| 
<%if pre then%>
<a href="list_zlb.asp?page=<%=intpage -1%>">上頁</a>| <%end if%>
<%if last then%>
<a href="list_zlb.asp?page=<%=intpage +1%>">下頁</a> |<%end if%>
<a href="list_zlb.asp?page=<%=rs.PageCount%>">尾頁</a>|轉(zhuǎn)到第
<select name="sel_page" onchange="javascript:location=this.options[this.selectedIndex].value;">
<%
for i = 1 to rs.PageCount
if i = intpage then%>
<option value="list_zlb.asp?page=<%=i%>" selected><%=i%></option>
<%else%>
<option value="list_zlb.asp?page=<%=i%>"><%=i%></option>
<%
end if
next
%>
</select>頁</font> 
</td>
</tr>
</table>