page_number.java

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

package javabean;

import java.sql.*;


public class Page_Number {
	int rowcount=1;//总行数
	int pagesize=1;//一页的记录数
	int pagecount=1;//总的页数


	
	private static Connection con;
	
	public Page_Number(Connection con){
		this.con=con;
	}
	
	
	public void setRowcount(String str)
	{
		try
		{
			PreparedStatement ps=null;
			ResultSet rs=null;
			rs=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY).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;
	}
}