<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="750" border="0" cellspacing="2" cellpadding="2" align="center">
<tr align="center">
<td>&nbsp;</td>
</tr>
<tr>
<td>
<table width="740" border="0" cellspacing="1" cellpadding="1" align="center">
<tr align="center" bgcolor="#cccccc">
<td><b>標(biāo)題</b></td>
<td><b>作者</b></td>
<td><b>類(lèi)型</b></td>
<td><b>點(diǎn)擊</b></td>
<td><b>加入時(shí)間</b></td>
</tr>
<%
int i;
int ipage=5; //分頁(yè)單位
int allpage; //總頁(yè)數(shù)
int pages; //接受的頁(yè)碼變數(shù)
int cpage=1; //當(dāng)前頁(yè)
int spage; //開(kāi)始頁(yè)
int allcol=0;
vector v=null;

//資料庫(kù)連接聲明
connection conn=null;
 java.lang.string sql,pagesql;
 java.sql.resultset rs,pagers;
 statement statement=null;
 string kmsdb="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=dbname";
 class.forname("com.microsoft.jdbc.sqlserver.sqlserverdriver");
    conn = drivermanager.getconnection(kmsdb, "user", "pwd");
 
 pagesql = "select count(*) from  authors";

//取總文章數(shù)
statement = conn.createstatement();
pagers = statement.executequery(pagesql);
 while(pagers.next())
  {
  allcol = pagers.getint(1);
  system.out.println(allcol);

  }
 
//獲得總頁(yè)面數(shù)
allpage = (int)math.ceil((allcol + ipage-1) / ipage);
//判斷參數(shù)pages是否空
if (request.getparameter("pages")==null) {
pages=1;
} else {
pages = new integer(request.getparameter("pages")).intvalue();
system.out.println(pages);
}
//判斷當(dāng)前頁(yè)
if(pages > allpage || pages == 0)
{cpage = 1;}
else
{
cpage = pages;
}
//判斷起始頁(yè)
sql = "select top "+ipage+" au_id,au_lname,au_fname,address,phone from authors where au_id not in (select top "+(cpage-1)*ipage+" au_id from authors order by au_id desc)order by au_id desc";
rs = statement.executequery(sql);
while (rs.next())
{
 au_id=rs.getstring("au_id");
 au_lname=rs.getstring("au_lname");
 au_fname=rs.getstring("au_fname");
 phone=rs.getstring("phone");
 address=rs.getstring("address");

%> 
 <td width="300"><%= au_id %></a></td>
 <td width="300"><%= au_lname %></a></td>
 <td width="300"><%= au_fname %></a></td>
 <td width="300"><%= phone %></a></td>
 <td width="300"><%= address %></a></td>
</tr>
<%    
}%>
<tr bgcolor="#cccccc">
<td colspan="5" align="right" valign="middle">共 <%= allcol %>條記錄 共 <%= allpage %>頁(yè) <% if (cpage>1) { %><a href="fy.jsp?pages=<%= cpage-1 %>"><img src="http://www.survivalescaperooms.com/htmldata/2005-03-09/images/prev.gif" border="0"></a><% } if (cpage<allpage) { %><a href="fy.jsp?pages=<%= cpage+1 %>"><img src="http://www.survivalescaperooms.com/htmldata/2005-03-09/images/next.gif" border="0"></a><% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%><a href="fy.jsp?pages=<%= i %>"><%= i %></a>&nbsp;<% }} %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>