pagebean.java

图片管理功能：图片的上载及下载

package beans;

import java.util.Collection;
import java.util.ArrayList;
import java.sql.ResultSet;

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: 2006-6-22
 * Time: 8:54:49
 * To change this template use File | Settings | File Templates.
 */
public class PageBean {
    public int curPage;//当前的页值。

      public int maxPage;//最大的页数。

      public int maxRowCount;//最大的行数。

      public static int rowsPerPage = 6; //控制分页的行数。

      public ArrayList<PictureBean> data = new ArrayList<PictureBean>(); //所要显示的数据的集合。
      public ArrayList<UserBean> userdata = new ArrayList<UserBean>();
      public PageBean() {

      }

      public int countMaxPage(){

        if(this.maxRowCount%this.rowsPerPage == 0){

          this.maxPage=this.maxRowCount / this.rowsPerPage;

        }else{

          this.maxPage=this.maxRowCount / this.rowsPerPage + 1;

        }
        return maxPage;
      }


      public void getResult(String sql){
          DataBean db = new DataBean();
          ResultSet rs = null;
         // String sql = "select name,type,pos,detail from pictures";
          try{
            rs = db.selectObj(sql);
            while(rs.next() ){
                PictureBean pb = new PictureBean();
                pb.setPicid(rs.getString(1));
                pb.setPicname(rs.getString(2));
                pb.setPictype(rs.getString(3) );
                pb.setPosition(rs.getString(4) );
                pb.setDescription(rs.getString(5) );
                data.add(pb);
            }
          }catch(Exception e){
              System.out .println(e.getMessage() );
          }
          maxRowCount = data.size() ;

      }
    public ArrayList getPagedRs(int pageNumber){
       ArrayList<PictureBean> pagers = new ArrayList<PictureBean>();
       for(int i = 0 ;i < rowsPerPage ;i ++){
          if(data.size() > (i+(pageNumber-1)*rowsPerPage) )
          pagers.add(data.get(i+(pageNumber-1)*rowsPerPage) );
       }
       return pagers;
    }
     public void getuserResult(String sql){
          DataBean db = new DataBean();
          ResultSet rs = null;
         // String sql = "select name,type,pos,detail from pictures";
          try{
            rs = db.selectObj(sql);
            while(rs.next() ){
                UserBean ub = new UserBean();
                ub.setId(Integer.parseInt(rs.getString(1)) );
                ub.setUsername(rs.getString(2));
                ub.setRegdate(rs.getString(3));
                userdata.add(ub);
            }
          }catch(Exception e){
              System.out .println(e.getMessage() );
          }
          maxRowCount = userdata.size() ;

      }
    public ArrayList getuserPagedRs(int pageNumber){
       ArrayList<UserBean> pagers = new ArrayList<UserBean>();
       for(int i = 0 ;i < rowsPerPage ;i ++){
          if(userdata.size() > (i+(pageNumber-1)*rowsPerPage) )
          pagers.add(userdata.get(i+(pageNumber-1)*rowsPerPage) );
       }
       return pagers;
    }

}