pageinfo.java

公司自己开发的工作流引擎

package cn.com.iaspec.workflow.data;

// Imports
import java.io.*;
import java.util.*;

public class PageInfo
    implements Serializable{

  // Fields
  private String DB_TYPE="ORACLE";
  private long longCurPage=1; //当前页
  private long longGotoPage=-1; //欲转到页
  private long longPageTotal; //总页数
  private static long longRowsPerPage=15; //每页记录数
  private long longRowTotal; //总记录数
  private long longRowBegin; //开始记录数
  private long longRowEnd; //结束记录数
  private String strSQLStatement; //查询sql
  private String orderBy=""; //orderby 语句
  private String orderFlag="ASC"; //排序类别 asc 升序，desc 倒序
  private String orderField;

  private ArrayList pageinfolist; //满足条件的数据集合
  private int checkpageinfo=-1; //判断 0=为下一页；1=上一页，-1=是初始法为当前页

  public String getOrderFlag(){
    return orderFlag;
  }

  public String getOrderBy(){
    orderBy="";
    if(this.orderField!=null&&!this.orderField.equals("")){
      if(this.orderFlag==null||this.orderFlag.equals("")){
        this.orderFlag="ASC";
      }
      orderBy=" order by "+orderField+" "+orderFlag;
    }
    return orderBy;
  }

  public long getLongRowBegin(){
    return longRowBegin;
  }

  public String getStrSQLStatement(){
    return strSQLStatement;
  }

  public long getLongCurPage(){
    return longCurPage;
  }

  public long getLongGotoPage(){
    return longGotoPage;
  }

  public long getLongPageTotal(){
    return longPageTotal;
  }

  public long getLongRowsPerPage(){
    return longRowsPerPage;
  }

  public long getLongRowTotal(){
    return longRowTotal;
  }

  public void setLongRowEnd(long longRowEnd){
    this.longRowEnd=longRowEnd;
  }

  public void setOrderFlag(String orderFlag){
    this.orderFlag=orderFlag;
  }

  public void setLongRowBegin(long longRowBegin){
    this.longRowBegin=longRowBegin;
  }

  public void setStrSQLStatement(String strSQLStatement){
    this.strSQLStatement=strSQLStatement;
  }

  public void setLongCurPage(long longCurPage){
    this.longCurPage=longCurPage;
  }

  public void setLongGotoPage(long longGotoPage){
    this.longGotoPage=longGotoPage;
  }

  public void setLongPageTotal(long longPageTotal){
    this.longPageTotal=longPageTotal;
  }

  public void setLongRowsPerPage(long longRowsPerPage){
    this.longRowsPerPage=longRowsPerPage;
  }

  public void setLongRowTotal(long longRowTotal){
    this.longRowTotal=longRowTotal;
  }

  public void setOrderField(String orderField){
    this.orderField=orderField;
  }

  public void setCheckpageinfo(int checkpageinfo){
    this.checkpageinfo=checkpageinfo;
  }

  public void setPageinfolist(ArrayList pageinfolist){
    this.pageinfolist=pageinfolist;
  }

  public long getLongRowEnd(){
    return longRowEnd;
  } // Constructors

  public String getOrderField(){
    return orderField;
  }

  public int getCheckpageinfo(){
    return checkpageinfo;
  }

  public ArrayList getPageinfolist(){
    return pageinfolist;
  }

  public String getSplitBy(){
    String splitBy="";
    long tempLongGotoPage=longGotoPage;
    if(tempLongGotoPage<=0){
      tempLongGotoPage=1;
    }
    splitBy=" where rownum>"+(tempLongGotoPage-1)*this.longRowsPerPage+
        " and rownum<="+tempLongGotoPage*this.longRowsPerPage;
    return splitBy;
  }

  public String getUpperBoundSql(){
    String sql="";
    long tempLongGotoPage=longGotoPage;
    if(tempLongGotoPage<=0){
      tempLongGotoPage=1;
    }
    sql=" where rownum<="+tempLongGotoPage*this.longRowsPerPage;
    return sql;
  }

  public String getLowerBoundSql(){
    String sql="";
    long tempLongGotoPage=longGotoPage;
    if(tempLongGotoPage<=0){
      tempLongGotoPage=1;
    }
    sql=" where min_rownum>"+(tempLongGotoPage-1)*this.longRowsPerPage;
    return sql;
  }

  public PageInfo(){

  }

}