pageservice.java

封装的JAVA分页类 可直接调用

package org.dk.bean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Pageservice {
	private Integer pageSize;//分页大小
	private Integer pageCount;//分页行数
	private Integer rowsCount;//记录行数
	private Integer curPage;//当前页号
	private ResultSet  rs;//记录集
	
	/**返回当前页号*/
	public Integer getCurPage() {
		return curPage;
	}
	/**返回分页行总数*/
	public Integer getPageCount() {
		if(rowsCount==0)return 0;
		if(pageSize==0)return 1;
		double tmpD=(double)rowsCount/pageSize;
		int tmpI=(int)tmpD;
		if(tmpD>tmpI) tmpI++;
		return tmpI;
	}
	
	/**返回分页大小*/
	public Integer getPageSize() {
		return pageSize;
	}
	/**设置分页大小*/
	public void setPageSize(Integer pageSize) {
		this.pageSize = pageSize;
	}
	/**返回记录行总数*/
	public Integer getRowsCount() {
		return rowsCount;
	}
	public void setRowsCount(Integer rowsCount) {
		this.rowsCount = rowsCount;
	}
	/**返回记录集*/
	public ResultSet getRs() {
		return rs;
	}
	/**设置记录集*/
	public void setRs(ResultSet rs) throws  SQLException  {
		if(rs!=null)
		{
			try{
				rs.last();
			}catch(SQLException ex)
			{
				ex.printStackTrace();
			}
			setRowsCount(rs.getRow());
			rs.beforeFirst();
			this.rs = rs;
		}
	}
	/**返回当前页记录行数*/
	public Integer getPageRowsCount() {
		if(pageSize==0)return 0;
		if(getPageCount()==0)return 0;
		if(curPage!=getPageCount())return pageSize;
		return rowsCount-(getPageCount()-1)*pageSize;
	}
	/**转到指定页*/
	public void gotoPage(int page){
		if(rs==null)
			return ;
		if(page<1)
			page=1;
		if (page > getPageCount())
	        page = getPageCount();
	    int row = (page - 1) * pageSize + 1;
	    try {
	        rs.absolute(row);
	        curPage = page;
	    }
	    catch (java.sql.SQLException e) {
	    }
	}
	/**转到当前页的第一条记录*/
	public void pageFirst() throws java.sql.SQLException {
	    int row=(curPage-1)*pageSize+1;
	    rs.absolute(row);
	}
	/**转到当前页的最后一条记录*/
	public void pageLast() throws java.sql.SQLException {
	    int row=(curPage-1)*pageSize+getPageRowsCount();
	    rs.absolute(row);
	}  
	/***返回pagebean*/
}