ssh-hibernate中分页的展示

hibernate中分页查询
PageBean相关的实体类

1、pageBean的创建

package com.itheima.bos.utils;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;

/**
 * 封装分页属性
 * @author Lenovo
 *
 */
public class PageBean {
    private int currentPage;//当前页码
    private int pageSize;//每页显示的记录数
    private DetachedCriteria detachedCriteria;//查询条件
    private int total;//总记录数
    private List rows;//当前页需要展示的数据集合
    public int getCurrentPage() {
        return currentPage;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public int getPageSize() {
        return pageSize;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
    public DetachedCriteria getDetachedCriteria() {
        return detachedCriteria;
    }
    public void setDetachedCriteria(DetachedCriteria detachedCriteria) {
        this.detachedCriteria = detachedCriteria;
    }
    public int getTotal() {
        return total;
    }
    public void setTotal(int total) {
        this.total = total;
    }
    public List getRows() {
        return rows;
    }
    public void setRows(List rows) {
        this.rows = rows;
    }

}

2、通用方法中的Dao

    /**
     * 通用的分页查询方法
     */
    @Override
    public void pageQuery(PageBean pageBean) {
        int currentPage=pageBean.getCurrentPage();
        int pageSize=pageBean.getPageSize();
        DetachedCriteria detachedCriteria=pageBean.getDetachedCriteria();
        //查询total
        detachedCriteria.setProjection(Projections.rowCount());//指定hibernate框架发出SQL的形式
        List<Long> countList = (List<Long>) this.getHibernateTemplate().findByCriteria(detachedCriteria);
        Long count=countList.get(0);
        pageBean.setTotal(count.intValue());

        //查询rows
        detachedCriteria.setProjection(null);//设置回来
        int firstResult=(currentPage-1)*pageSize;
        int maxResults=pageSize;
        List rows = this.getHibernateTemplate().findByCriteria(detachedCriteria, firstResult, maxResults);
        pageBean.setRows(rows);

    }

3、Action的实现

/**
     * 查询所有的包括分页查询
     * 返回的格式应该是json
     * @throws IOException 
     */
    public String pageQuery() throws IOException{
        PageBean pageBean=new PageBean();
        pageBean.setCurrentPage(page);
        pageBean.setPageSize(rows);
        //创建离线提交查询对象
        DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Staff.class);
        pageBean.setDetachedCriteria(detachedCriteria);
        staffService.pageQuery(pageBean);
        //使用json-lib将pageBean对象转为json，通过流出流写回页面
        //JSONObject----将单一对象转为json
        //JSONArray----将数组或者集合对象转为json
        JsonConfig jsonConfig=new JsonConfig();
        //指定哪些属性不需要转json
        jsonConfig.setExcludes(new String[]{"currentPage","detachedCriteria","pageSize"});

        String json = JSONObject.fromObject(pageBean,jsonConfig).toString();
        ServletActionContext.getResponse().setContentType("text/json;charset=utf-8");
        ServletActionContext.getResponse().getWriter().print(json);
        return NONE;
    }

4、页面的展示效果