package bookutil;
import java.sql.*;
import java.util.ArrayList;
public class RecordDiv {
  public int cur_page=1;
  public int total_page=1;
  public int size_page=5;
  public RecordDiv() {
  }
  public ArrayList recordPage(String sql,int pagesize,String curpage){
    ResultSet rs=null;
    int rec_pos=1;
    ArrayList al=new ArrayList();
    size_page=pagesize;
    if(sql==null||sql.length()==0||pagesize<=0){
      return al;
    }
    //total page
    try{
      rs.last();
      total_page=(rs.getRow()+size_page-1)/size_page;
      cur_page=Integer.parseInt(curpage);
    }catch(Exception e){
      System.out.println(e.toString());
      cur_page=1;
    }
    //check teference curpage
    if(cur_page<=0)cur_page=1;
    if(cur_page>total_page)cur_page=total_page;
    //orientation record position in rs
    rec_pos=(cur_page-1)*pagesize+1;
    try{
      rs.absolute(rec_pos);
      ResultSetMetaData md=rs.getMetaData();
      int col_count=md.getColumnCount();
      for(int j=0;rs.next()&&j<size_page;j++){
        ArrayList in_al=new ArrayList();
        for(int i=1;i<=col_count;i++){
          in_al.add(rs.getString(i));
        }
        al.add(in_al);
      }
    }catch(Exception e){
      System.out.println(e.toString());
    }
    //copy the just page to ArrayList al


    return al;
  }
}