% dim rs,sql dim totalPut dim CurrentPage, TotalPages if not isempty(request("page")) then currentPage=cint(request("page")) else currentPage=1 end if set rs = server.createobject("adodb.recordset") %>
| q | 信息标题 | 作者 | 提交日期 | 阅读次数 | |||||
|
<%
sql="select * from article order by articleid desc"
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 showContent showpage totalput,MaxPerPage,"index.asp" else if (currentPage-1)*MaxPerPage<%=i+1%> |
" target="_blank"><%=rs("title")%> |
<%if not isnull(rs("writer")) then%>
<%=rs("writer")%>
<%else%>
不详
<%end if%>
|
<%if rs("dateandtime")=date() then%>
<%=year(rs("dateandtime"))%>-<%=month(rs("dateandtime"))%>-<%=day(rs("dateandtime"))%>
<%else%>
<%=year(rs("dateandtime"))%>-<%=month(rs("dateandtime"))%>-<%=day(rs("dateandtime"))%>
<%end if%>
|
<%=rs("hits")%> |
| ||||
| q | 信息标题 | 作者 | 提交日期 | 阅读次数 | |||||
|
<%
sql="select * from article order by articleid desc"
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 showContent showpage totalput,MaxPerPage,"index.asp" else if (currentPage-1)*MaxPerPage<%=i+1%> |
" target="_blank"><%=rs("title")%> |
<%if not isnull(rs("writer")) then%>
<%=rs("writer")%>
<%else%>
不详
<%end if%>
|
<%if rs("dateandtime")=date() then%>
<%=year(rs("dateandtime"))%>-<%=month(rs("dateandtime"))%>-<%=day(rs("dateandtime"))%>
<%else%>
<%=year(rs("dateandtime"))%>-<%=month(rs("dateandtime"))%>-<%=day(rs("dateandtime"))%>
<%end if%>
|
<%=rs("hits")%> |
| ||||