package com.zh.util;
import java.sql.*;
import com.zh.conpool.Condata;
public class page{
	int showpage;
	int pagecount=0;
	int rowcount=0;
	int pagesize;
	String topage;
	String httpfile;
	String sql;
	String str_where="";
	ResultSet rs=null;
	ResultSet rs1=null;
	String countsql;
	String pagesql;
	Condata con=new Condata();
	public void setpagesize(int n){
		this.pagesize=n;
	}
	public ResultSet setQuerysql(String str_table,String str_where,String httpfile,String pages)throws SQLException{
		nowpage=pages;
		ResultSet rst=null;
		httpfile=httpfile;
		str_where=str_where;
		countsql="select count(*) from "+str_table+" "+str_where;
		pagesql="select * from"+str_table+" "str_where" order by id DESC;
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		try{
			rst=query(countsql,pagesql);
		}catch(Exception er){
			er.getMessage();
		}
		return rst;
	}
	public ResultSet query(String countsql,String pagesql)throws SQLException{
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		
		if(topage==null){
			showpage=1;	
		}else{
			showpage=Integer.parseInt(topage);
		}
		if(showpage<1){
			showpage=1;
		}
		rs=con.executeQuery(countsql);
		if(rs.next()){
			rowcount=rs.getInt(1);
		}
		pagecount=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1));
		if(showpage>pagecount){
			showpage=pagecount;
		}
		rs.close();
		rs1=con.executeQuery(pagesql);
		return rs1;
	}
}