高效简单的jsp分页代码-jsp-IT落伍者

<%@ page import="javasql*javaio*javautil*" %>
<%@ page language="java" pageEncoding="Big" %>
<%! String au_idau_lnameau_fnamephoneaddresscitystate;%>
<!DOCTYPE HTML PUBLIC "//WC//DTD HTML Transitional//EN">
<HTML>
<HEAD>
<TITLE>ArticleList</TITLE>
<link rel="stylesheet" href="stylecss">
</head>
<body bgcolor="#FFFFFF"><table width="" border="" cellspacing="" cellpadding="" align="center">
<tr>
<td>
<table width="" border="" cellspacing="" cellpadding="" align="center">
<tr align="center">
<td> </td>
</tr>
<tr>
<td>
<table width="" border="" cellspacing="" cellpadding="" align="center">
<tr align="center" bgcolor="#CCCCCC">
<td><b>标题</b></td>
<td><b>作者</b></td>
<td><b>类型</b></td>
<td><b>点击</b></td>
<td><b>加入时间</b></td>
</tr>
<%
int i;
int ipage=; //分页单位
int allpage; //总页数
int pages; //接受的页码变数
int cpage=; //当前页
int spage; //开始页
int allCol=;
Vector v=null;//资料库连接声明
Connection conn=null;
javalangString sqlpagesql;
javasqlResultSet rspagers;
Statement statement=null;
String kmsdb="jdbc:microsoft:sqlserver://:;DatabaseName=DBName";
ClassforName("commicrosoftjdbcsqlserverSQLServerDriver");
conn = DriverManagergetConnection(kmsdb "user" "pwd");

pagesql = "SELECT COUNT(*) FROM Authors";//取总文章数
statement = conncreateStatement();
pagers = statementexecuteQuery(pagesql);
while(pagersnext())
{
allCol = pagersgetInt();
Systemoutprintln(allCol);}

//获得总页面数
allpage = (int)Mathceil((allCol + ipage) / ipage);
//判断参数pages是否空
if (requestgetParameter("pages")==null) {
pages=;
} else {
pages = new Integer(requestgetParameter("pages"))intValue();
Systemoutprintln(pages);
}
//判断当前页
if(pages > allpage || pages == )
{cpage = ;}
else
{
cpage = pages;
}
//判断起始页
sql = "select Top "+ipage+" au_idau_lnameau_fnameaddressphone from authors where au_id not in (select top "+(cpage)*ipage+" au_id from authors order by au_id desc)order by au_id desc";
rs = statementexecuteQuery(sql);
while (rsnext())
{
au_id=rsgetString("au_id");
au_lname=rsgetString("au_lname");
au_fname=rsgetString("au_fname");
phone=rsgetString("phone");
address=rsgetString("address");%>
<td width=""><%= au_id %></a></td>
<td width=""><%= au_lname %></a></td>
<td width=""><%= au_fname %></a></td>
<td width=""><%= phone %></a></td>
<td width=""><%= address %></a></td>
</tr>
<%
}%>
<tr bgcolor="#CCCCCC">
<td colspan="" align="right" valign="middle">共 <%= allCol %>条记录共 <%= allpage %>页 <% if (cpage>) { %><a href="fyjsp?pages=<%= cpage %>"><img src="% } if (cpage<allpage) { %><a href="fyjsp?pages=<%= cpage+ %>"><img src="% } %> / <% for (i=;i<=allpage;i++) { if (i != pages) {%><a href="fyjsp?pages=<%= i %>"><%= i %></a> <% }} %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>