page.inc
<%
Sub ShowPageBar(TotalPage,CurPage,strUrl)
‘ Ã¥ÂÂæ°TotalPage:Ã¥Â
¨é¨页æ°;CurPage:å½ÂÃ¥ÂÂ页æ°;strUrl:翻页使ç¨çÂÂè¿ÂæÂ¥å°åÂÂ.
DIM strPage
CurPage=GetValidPageNO(TotalPage,CurPage)
Response.Write “<TABLE WIDTH=”100%”>”
Response.Write “<tr><td width=”100%” align=”right”>”
Response.Write “页æ°4 & CurPage & “/” & TotalPage & “à”
IF InStr(strUrl,”?”)=0 THEN
strPage=”?Page=”
ELSE
strPage=”&Page=”
END IF
IF Curpage>1 THEN
Response.Write “<a href=” & strUrl &strPage&”1>第ä¸Â页</a>”
ELSE
Response.Write “第ä¸Â页”
END IF
IF CurPage>=2 THEN
Response.Write “<a href=” & strUrl & strPage &CurPage-1&”>ä¸Âä¸Â页</a>”
ELSE
Response.Write “ä¸Âä¸Â页”
END IF
IF cInt(CurPage)<cInt(TotalPage) THEN
Response.Write “<a href=” & strUrl & strPage &CurPage+1&”>ä¸Âä¸Â页</a>”
ELSE
Response.Write “ä¸Âä¸Â页”
END IF
IF cInt(CurPage) <>cInt(TotalPage) THEN
Response.Write “<a href=” & strUrl & strPage & TotalPage&”>æÂÂæ«页</a>”
ELSE
Response.Write “æÂÂæ«页”
END IF
Response.Write “</td></tr></table>”
END SUB
Function GetValidPageNo(PageCount,CurPage)
Dim iPage
iPage=CurPage
IF cInt(CurPage)<1 THEN
iPage= 1
END IF
IF cInt(iPage) > cInt(PageCount) THEN
iPage= PageCount
END IF
GetValidPageNo=iPage
END Function
%>
çÂÂçÂÂå¼Âç¨è¿Â个å½æ°çÂÂä¾ÂÃ¥ÂÂï¼Âxml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /??
chunfeng.asp
<!–#include Virtual=”page.inc”–>
<%
SET objConn=Server.CreateObject(“ADODB.CONNECTION”)
SET objRst=Server.CreateObject(“ADODB.RECORDSET”)
objConn.Open Application(“dsn”)
strSQL=”select * from è¦Â使ç¨çÂÂæ¥询
objRst.Open strSQL,objConn,adOpenStatic
‘ æÂÂå¼Âæ°æ®记å½Â.
objRst.PageSize=20
‘ 设置åÂÂ页çÂÂæ°æ®记å½Âæ°
iPageCount=objRst.PageCount
‘ å®Âä¹ÂäºÂä¸Â个页ç Âæ°éÂÂçÂÂÃ¥ÂÂéÂÂ.
If Len(Request.QueryString(“Page”))=0 Then
CurPage=1
Else
CurPage=CInt(Request.Querystring(“Page”))
End If
‘ å¾Âå°å½ÂÃ¥ÂÂçÂÂ页ç Â.
objRst.AbsolutePage=CurPage
‘ 设置记å½ÂéÂÂä¸ÂçÂÂå½ÂÃ¥ÂÂ页.
‘ å¼Âå§Âè°Âç¨æ¾示翻页çÂÂå½æ°,æ¾示页æ°æ Â.
‘ å½æ°åÂÂÃ¥ÂÂ:ShowPageBar(TotalPage,CurPage,strUrl) .
strUrl=”chunfeng.asp”
‘ å®Âä¹Âè¿ÂæÂ¥çÂÂURL,å¯以ç¨æÂÂ们èª己çÂÂ页é¢å°åÂÂ.
ShowPageBar iPageCount,CurPage,strUrl
‘ è°Âç¨å®ÂæÂÂ.
—————————————————————————————————————-
è¿ÂéÂÂæ¾示èª己çÂÂÃ¥ÂÂ
容
—————————————————————————————————————-
ÃÂ
objConn.Close
SET objRst=NOTHING
SET objConn=NOTHING
%>
ÃÂ
ÃÂ