分页

最新推荐文章于 2025-12-05 20:44:21 发布

转载最新推荐文章于 2025-12-05 20:44:21 发布 · 442 阅读

文章标签：

#string #table #sql #import #null #tools

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;



     }