分页

package tools; import java.sql.*; import db.DB; public class Page {    private DB db ;    private String table; private int pageSize=0; private int totalItem=0; private int totalPage=0; private String curPage;      public void setDb(DB db) {    this.db = db; } public Page( ) {     db=new DB();     pageSize=5;     } public void setPageSize(int pageSize) {this.pageSize=pageSize;          }      public void setCurPage(String curPage)      {       this.curPage=curPage;            } public int getCurPage() {    if (curPage==null)    return 1; else    return   Integer.valueOf(curPage);}      public int getTotalItem( ) throws SQLException      {     String sql="select   count (*)   from "+table;        System.out.print(sql);        ResultSet rs=db.getResultSet(sql);        int result=0;           if(rs.next()){result=rs.getInt(1); }        totalItem=result;        return totalItem;              }                 public int getTotalPage() throws SQLException {     getTotalItem();     totalPage=(totalItem%pageSize==0)?totalItem/pageSize:totalItem/pageSize+1;     return totalPage;       }                     public   ResultSet getResultSet() throws SQLException      {    int curPage1=0;       if(curPage==null)curPage1=1;       else        curPage1=Integer.parseInt(curPage);                      // String sql="select      *   top "+(curPage-1)*pageSize+"   from "+table;                String sql="select * from "+table +" order by id desc" ;         ResultSet rs= db.getResultSet(sql);         if(curPage1!=1) rs.absolute((curPage1-1)*pageSize);         return rs;                            }           public   ResultSet getResultSetByFullSql(String sql) throws SQLException      {    int curPage1=0;       if(curPage==null)curPage1=1;       else        curPage1=Integer.parseInt(curPage);                                               ResultSet rs= db.getResultSet(sql);         if(curPage1!=1) rs.absolute((curPage1-1)*pageSize);         return rs;                         }           public void setTable(String table) {    this.table = table; }           public void setCloseDb()      {             db.setClose();            }    }