<%
sqlnew="select id,BigClassName,product_name,dateandtime,sx from product_info where id>0"
if BigClassName<>"" then
sqlnew=sqlnew & " and BigClassName='" & BigClassName & "' "
end if
sqlnew=sqlnew & " order by sx asc"
set rs=server.CreateObject("adodb.recordset")
rs.open sqlnew,conn,1,1
%>
<%
if rs.recordcount=0 then
%>
<% else
rs.PageSize =20
iCount=rs.RecordCount
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
%>
<%
for i=1 to x
%>
<% if trim(rs("BigClassName"))<>"" then response.write "["&rs("BigClassName")&"]" %>
"><%= rs("product_name") %> <%=rs("dateandtime")%> |
<% rs.movenext
next
%>
<%
call PageControl(iCount,maxpage,page,"border=0 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(" " & vbCrLf )
Response.Write("" & vbCrLf )
Response.Write(" " & vbCrLf )
End Sub
%>
|