<% if title<>"" then sql="select * from SoftReview where reviewtitle like '%"&trim(reviewtitle)&"%' order by reviewid desc" else sql="select * from SoftReview order by reviewid desc" end if Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 if rs.eof and rs.bof then response.write "

还 没 有 任 何 文 章

" else totalPut=rs.recordcount if currentpage<1 then currentpage=1 end if if (currentpage-1)*MaxPerPage>totalput then if (totalPut mod MaxPerPage)=0 then currentpage= totalPut \ MaxPerPage else currentpage= totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showpage totalput,MaxPerPage,"reply.asp" showContent showpage totalput,MaxPerPage,"reply.asp" else if (currentPage-1)*MaxPerPage

<%do while not rs.eof%> <% i=i+1 if i>=MaxPerPage then exit do rs.movenext loop %>

ID	最新评论
<%=rs("reviewid")%>	发表人：<%=rs("rname")%> 〔<%=rs("rdate")%>〕评论主题：<%=rs("reviewtitle")%>

<% end sub function showpage(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if response.write "

 " if CurrentPage<2 then response.write "首页 上一页 " else response.write "首页 " response.write "上一页 " end if if n-currentpage<1 then response.write "下一页 尾页" else response.write "" response.write "下一页 尾页" end if response.write " 页次："&CurrentPage&"/"&n&"页 " response.write " 共"&totalnumber&"个主题 "&maxperpage&"个主题/页 " end function sub deleteannounce(id) dim rs,sql set rs=server.createobject("adodb.recordset") sql="delete from SoftReview where reviewid="&cstr(id) conn.execute sql if err.Number<>0 then err.clear response.write "删 除 失 败 !
" else response.write "操作成功！
" end if End sub %>