//处理最后一页的特殊情况
try{
intid=rs.getInt
(1);
StringcategoryName=rs.getString
(2);
//中文处理
categoryName=newString(categoryName.getBytes("ISO8859_1"),"GB2312");
intparentID=rs.getInt(3);
intlayer=rs.getInt(4);
Stringbz=rs.getString(5);
//中文处理
bz=newString(bz.getBytes("ISO8859_1"),"GB2312");
//封装信息到实体中
Categorycategory=newCategory();
category.setId(id);
category.setCategoryName(categoryName);
category.setParentID(parentID);
category.setLayer(layer);
category.setBz(bz);
list.add(category);
rs.next();
}catch(UnsupportedEncodingExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
// if(rs!
=null)
// pstm.close();
// if(pstm!
=null)
// pstm.close();
// if(con!
=null)
// con.close();
rs.close();
pstm.close();
con.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
returnlist;
}
publicvoidsetSumRecord(intsumRecord){
this.sumRecord=sumRecord;
}
publicintgetPageRecord(){
returnpageRecord;
}
publicvoidsetPageRecord(intpageRecord){
this.pageRecord=pageRecord;
}
//计算总页码数
publicintgetPageNum(){
if(sumRecord%pageRecord==0)
{
pageNum=sumRecord/pageRecord;
}else
{
pageNum=sumRecord/pageRecord+1;
}
System.out.println("总页数"+pageNum+"总记录条数"+sumRecord+"每页显示的记录数"+pageRecord);
returnpageNum;
}
publicvoidsetPageNum(intpageNum){
this.pageNum=pageNum;
}
publicintgetShowPage(){
returnshowPage;
}
publicvoidsetShowPage(intshowPage){
this.showPage=showPage;
}
}
附数据库连接类:
DBCon.java
packagecom.myutil;
importjava.sql.*;
//数据库驱动加载及连接
publicclassDBCon{
intx;
publicstaticConnectiongetConn(){
Connectioncon=null;
Stringdriver;
Stringurl;
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url="jdbc:
microsoft:
sqlserver:
//localhost:
1433;databaseName=bookManager";
try{
Class.forName(driver);
con=DriverManager.getConnection(url,"sa","*****");
}catch(Exceptione){
e.printStackTrace();
}finally{
returncon;
}
}
//数据源方式连接
publicstaticConnectiongetConn2(){
Connectioncon=null;
Stringdriver;
Stringurl;
driver="sun.jdbc.odbc.JdbcOdbcDriver";
url="jdbc:
odbc:
book";
try{
Class.forName(driver);
con=DriverManager.getConnection(url);
}catch(Exceptione){
e.printStackTrace();
}finally{
returncon;
}
}
publicstaticvoidmain(Stringargs[]){
getConn2();
}
}
----------------------------------------------------------------------------------------------------------------------
(2)Servlet
PageServlet.java
packagecom.servlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.bean.PageDivide;
publicclassPageServletextendsH