pagenumber.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 58 行

package javabean;

import java.sql.*;


//关于分页的处理
public class PageNumber {
	int rowcount=1;//总行数
	int pagesize=1;//一页的记录数
	int pagecount=1;//总的页数
	private Connection con=null;
	private Statement sql=null;
	private ResultSet rs=null;
	private ConnectionPool pool;
	
	public PageNumber(Connection con) throws SQLException
	{
		this.con=con;
		pool=ConnectionPool.getInstance();               //初始化连接池
		//con=pool.getConnection();  //从池中获得一个连接
	}
	public void setRowcount(String str)
	{
		try
		{
			sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=sql.executeQuery(str);
			rs.last();
			this.rowcount=rs.getRow();
		}
		catch(SQLException e){}
		
	}
	public void setPagesize(int n)
	{
		this.pagesize=n;
	}
	public void setPagecount()
	{
		
		int n=(rowcount%pagesize)==0?(rowcount/pagesize):(rowcount/pagesize+1);
		pagecount=n;
	}
	public int getRowcount()
	{
		return this.rowcount;
	}
	public int getPagesize()
	{
		return this.pagesize;
	}
	public int getPagecount()
	{
		return this.pagecount;
	}
}