set rs2= Server.CreateObject("adodb.recordset")
str= "select * from album order by id desc "
rs2.open str,conn,1,3
nCurrPage=Request("CurrPage")
nCurrType=Request("CurrType")
if IsNull(nCurrType) or IsEmpty(nCurrType) or nCurrType="" then
nCurrType=0
else
nCurrType=Cint(nCurrType)
end if
if IsNull(nCurrPage) or IsEmpty(nCurrPage) or nCurrPage="" then
nCurrPage=1 '默认显示第一页
else
nCurrPage=Cint(nCurrPage)
end if
dim npagesize,nrow
npagesize=5
if not rs2.eof then
rs2.pagesize=npagesize
end if
if ncurrpage>rs2.pagecount then
ncurrpage=rs2.pagecount
end if
>">上一页</a>
<%end if
if nCurrPage<rs2.PageCount then%>
<a href="<%=request.ServerVariables("script_name")%>?CurrType=<%=nCurrType%>&CurrPage=<%=nCurrPage+1%>&id=<%=rs2