page1.java

企业办公自动化管理系统

/*
 * page1.java
 *
 * Created on 2005年5月18日, 下午5:09
 此javabean用了我一天的时间
 */

/**
 *
 * @author  administrator
 */
package com.zh.util;
import com.zh.conpool.Condata;
import java.sql.*;
public class page1 {
    ResultSet rs=null;
    ResultSet rst=null;
    public int countrows;
    public int pagesize;
    public int countpage;
    public int intpage;
    public String showpage;
    Condata con=new Condata();
    public String filename;
    public String tablename;
    public String filedname;
    String sql;
    String sql1;
    String te1;
    String te2;
    String te3;
    String te4;
    String te5;
    /** Creates a new instance of page1 */
    public page1() {
    }
    public void setPages(int n){
        this.pagesize=n;
    }
     public ResultSet QuerySql(String tablename,String topage,String tempwhere){
        showpage=topage;
        ResultSet rs1;
        sql="select * from "+tablename+"";
        sql1="select * from "+tablename+" "+tempwhere;
        try{
            con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
        try{
            rs1=Query(sql,sql1);
        }catch(Exception e){
            e.getMessage();
        }
        return rs1;
    }
  public ResultSet Query(String sql,String sql1){
     try{
        con.getConnection();
     }catch(Exception e){
        e.getMessage();
     }
     if(showpage==null){
        intpage=1;
     }else{
        intpage=Integer.parseInt(showpage);
        if(intpage<1){
            intpage=1;
        }
        rs=con.executeQuery(sql);
        if(!rs.next()){
            System.out.println("库中没有记录");
        }else{
            rs.last();
            countrows=rs.getRow();
            if((countrows%pagesize)==0){
		countpage=countrows/pagesize;
		}else{
		countpage=(countrows/pagesize+1);
             }
             if(intpage>countpage){
                intpage=countpage;
            }
            rst=con.executeQuery(sql1);
            return rst;
        }
     }

    }
}