簡單的ASP分頁代碼(測試正確)第2/2頁
更新時間:2007年03月03日 00:00:00 作者:
'根據(jù)實際從庫中獲得數(shù)據(jù)并顯示數(shù)據(jù)
'-------------------------------------------
'data=rs("data")
'response.write"DATA:"&data
'-------------------------------------------
rs.movenext
next
call PageControl(iCount,maxpage,page,"border=0 align=center","<p align=center>")
end if
rs.close
set rs=nothing
Sub PageControl(iCount,pagecount,page,table_style,font_style)
'生成上一頁下一頁鏈接
Dim query, a, x, temp
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")
query = Split(Request.ServerVariables("QUERY_STRING"), "&")
For Each x In query
a = Split(x, "=")
If StrComp(a(0), "page", vbTextCompare) <> 0 Then
temp = temp & a(0) & "=" & a(1) & "&"
End If
Next
Response.Write("<table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=#f1f1f1>" & vbCrLf )
Response.Write("<form method=get onsubmit=""document.location = '" & action & "?" & temp & "Page='+ this.page.value;return false;""><TR bgcolor=#f1f1f1>" & vbCrLf )
Response.Write("<TD align=center height=35>" & vbCrLf )
Response.Write(font_style & vbCrLf )
if page<=1 then
Response.Write ("首 頁 " & vbCrLf)
Response.Write ("上一頁 " & vbCrLf)
else
Response.Write("<A HREF=" & action & "?" & temp & "Page=1>首 頁</A> " & vbCrLf)
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page-1) & ">上一頁</A> " & vbCrLf)
end if
if page>=pagecount then
Response.Write ("下一頁 " & vbCrLf)
Response.Write ("尾 頁 " & vbCrLf)
else
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page+1) & ">下一頁</A> " & vbCrLf)
Response.Write("<A HREF=" & action & "?" & temp & "Page=" & pagecount & ">尾 頁</A> " & vbCrLf)
end if
Response.Write(" 頁次:" & page & "/" & pageCount & "頁" & vbCrLf)
Response.Write(" 共有" & iCount & "個記錄" & vbCrLf)
Response.Write(" 轉(zhuǎn)到" & "<INPUT CLASS=wenbenkuang TYEP=TEXT NAME=page SIZE=2 Maxlength=5 VALUE=" & page & ">" & "頁" & vbCrLf & "<INPUT CLASS=go-wenbenkuang type=submit value=GO>")
Response.Write("</TD>" & vbCrLf )
Response.Write("</TR></form>" & vbCrLf )
Response.Write("</table>" & vbCrLf )
End Sub
%>
本代碼絕對無錯!
相關文章
用Command對象和RecordSet對象向數(shù)據(jù)庫增加記錄哪一個更好
用Command對象和RecordSet對象向數(shù)據(jù)庫增加記錄哪一個更好...2006-06-06asp rs.open sql,conn,3,1中3,1代表什么?
這篇文章主要介紹了ASP中conn,1,1和 conn,2,3 conn,3,2等的含義需要的朋友可以參考下2007-07-07asp Chr 函數(shù) 數(shù)字轉(zhuǎn)字母的方法
asp Chr 函數(shù) 數(shù)字轉(zhuǎn)字母的方法...2007-08-08