<%@ page contentType="text/html;charset=gb2312" import="java.sql.*,java.util.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String strConn = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=wapcomm";
Connection objConn = DriverManager.getConnection(strConn,"sa","");
Statement objStm = objConn.createStatement();
ResultSet objRs;
String strSql;
int intPageSize = 20;
int intRecordCount = 0;
int intPageCount = 0;
strSql = "SELECT COUNT(*) FROM T_news_list";
objRs = objStm.executeQuery(strSql);
objRs.next();
intRecordCount = objRs.getInt(1);
intPageCount = (int)Math.ceil((intRecordCount + intPageSize-1) / intPageSize);
int intPage;
try
{
intPage = Integer.parseInt(request.getParameter("Page"));
}
catch(Exception e)
{
intPage =1;
}
if(intPage<1) intPage=1;
if(intPage>intPageCount) intPage = intPageCount;
strSql = "SELECT TOP "+ intPageSize +" news_ID,title FROM T_news_list WHERE news_id NOT IN (SELECT TOP " + intPageSize * (intPage-1) + " news_id FROM T_news_list ORDER BY news_ID DESC) ORDER BY news_ID DESC";
objRs = objStm.executeQuery(strSql);
while(objRs.next())
{
out.println(objRs.getString(1) + "." + "<a href=#>" + objRs.getString(2) + "</a><br/>");
}
objRs.close();
objStm.close();
objConn.close();
%>
<br>
<a href="?Page=1">首頁(yè)</a>
<a href="?Page=<%=intPage-1%>">上頁(yè)</a>
<a href="?Page=<%=intPage+1%>">下頁(yè)</a>
<a href="?Page=<%=intPageCount%>">未頁(yè)</a>
共<%=intRecordCount%>個(gè) <%=intPageSize%>個(gè)/頁(yè) 頁(yè)次：<%=intPage%>/<%=intPageCount%>
本站僅提供存儲服務(wù)，所有內容均由用戶(hù)發(fā)布，如發(fā)現有害或侵權內容，請
點(diǎn)擊舉報。
