pagebean.java

小型宠物医院网站

package Bean;

import java.util.ArrayList;
import DB.DBConnect;
import java.sql.Connection;

public class pageBean {
    public pageBean() {
    }

    public int rowsCount; //一共多少行
    public int rowsPerPage = 4; //每页多少行
    public int pageCount; //一共多少页
    public int currentPage = 1; //当前多少页
    public ArrayList ar; //当前页的数据
//    private String parameter;

 //参数:表名,每页行数,当前页,查询参数
    public pageBean getPageCount(String tablename, int rowsper, int currentpage,String parameter) { //给rowsCount和pageCount赋值
        pageBean pagebean = new pageBean();

        ArrayList ars = new ArrayList();
        pagebean.rowsPerPage = rowsper; //给rowsCount赋值
        ArrayList arr = new ArrayList();
        DBConnect dbc = new DBConnect();
        if (tablename.equals("users")) {
            arr = dbc.getUsers();
        }
        if (tablename.equals("owners")) {
            arr = dbc.getOwners();
        }
        if (tablename.equals("petdoctor")) {
            arr = dbc.getAllDoc();
        }
        if (tablename.equals("petdoctor1")&&!parameter.equals("")) {
            arr=dbc.getDocBySp(Integer.parseInt(parameter));
          // System.out.println("arr:"+arr);
        }
        if (tablename.equals("pets")) {
            arr=dbc.getAllPet();
        }
        if (tablename.equals("pets0")&&!parameter.equals("")) {
            arr=dbc.getPetByType(Integer.parseInt(parameter));
        }

        if (tablename.equals("pets1")&&!parameter.equals("")) {
            arr=dbc.getPetByOwner(Integer.parseInt(parameter));

        }
        if (tablename.equals("record")) {
            arr=dbc.getAllRecord();
        }
        if (tablename.equals("record0")&&!parameter.equals("")) {
           arr=dbc.getRecordByPet(Integer.parseInt(parameter));
        }
        if (tablename.equals("record1")&&!parameter.equals("")) {
          arr=dbc.getRecordByDoc(Integer.parseInt(parameter));
        }
        //未完
        pagebean.rowsCount = arr.size();
        if (pagebean.rowsCount % pagebean.rowsPerPage == 0) {
            pagebean.pageCount = pagebean.rowsCount / pagebean.rowsPerPage;
        } else {
            pagebean.pageCount = (pagebean.rowsCount / pagebean.rowsPerPage) +
                                 1;
        }

        pagebean.currentPage = currentpage;

        for (int j = pagebean.rowsPerPage * pagebean.currentPage - 1;
                     j >= (pagebean.currentPage - 1) * pagebean.rowsPerPage; j--) {
            if (arr.size() > j) {
                ars.add(arr.get(j));
            }

        }
        pagebean.ar = ars;
        return pagebean;
    }

    public ArrayList getCurrentData() {
        return this.ar;
    }


}