Hibernate分页

写了一个公共类:

package Util;

import java.util.*;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

/**
 * 这个是用于Hibernate分页的公共库,构造方法必须要有表名
 * @author chj
 *
 */
public class PagingUtil {

    private static SessionFactory sf = null;
    private String tableName = "";
    private int pageSize = 5;        //每页显示数据量,默认为5
    private int pageno = 1;        //当前页数,默认首页
    private int pagecount = -1;    //总页数
    private int datacount = -1;    //数量总数
    
    public PagingUtil(String tableName){
        this.tableName = tableName;
        if(sf == null){
            sf = new AnnotationConfiguration().configure().buildSessionFactory();
        }
        calPagecount();
    }
    
    public PagingUtil(String tableName,int pageSize){
        this.tableName = tableName;
        this.pageSize = pageSize;
        if(sf == null){
            sf = new AnnotationConfiguration().configure().buildSessionFactory();
        }
        calPagecount();
    }
    
    private static Session getSession(){
        return sf.getCurrentSession();
    }
    
    /**
     * 算出数据总量和总页数
     */
    public void calPagecount(){
        Session s = this.getSession();
        s.beginTransaction();
        try{
            Query q = s.createQuery("from " + this.tableName);
            List l = (List)q.list();
            System.out.println(l.size());
            this.datacount = l.size();
            if(datacount%pageSize == 0){
                this.pagecount = datacount/pageSize;
            }else{
                this.pagecount = datacount/pageSize + 1;
            }
            s.getTransaction().commit();
        }catch(Exception e){
            s.getTransaction().rollback();
        }
    }

    /**
     * 获取某页的数据
     * @param pageno
     * @return
     */
    public List getPagingResults(int pageno){
        this.pageno = pageno;
        List l = new ArrayList();
        Session s = this.getSession();
        s.beginTransaction();
        try{
            Query q = s.createQuery("from " + this.tableName);
            q.setFirstResult((this.pageno-1)*this.pageSize).setMaxResults(this.pageSize);
            l = (List)q.list();
            /*if(l.size() <= 0){
                l = null;
            }*/
            s.getTransaction().commit();
        }catch(Exception e){
            s.getTransaction().rollback();
            return l;
        }
        return l;
    }
    
    /**
     * 返回表名
     * @return
     */
    public String getTableName() {
        return tableName;
    }

    /**
     * 设置表名
     * @param tableName
     */
    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    /**
     * 返回每页显示数据数
     * @return
     */
    public int getPageSize() {
        return pageSize;
    }

    /**
     * 设置每页显示数据数
     * @param pageSize
     */
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    /**
     * 返回当前页码
     * @return
     */
    public int getPageno() {
        return pageno;
    }

    /**
     * 设置当前页码
     * @param pageno
     */
    public void setPageno(int pageno) {
        this.pageno = pageno;
    }

    /**
     * 返回总页数
     * @return
     */
    public int getPagecount() {
        return pagecount;
    }

    /**
     * 返回数据总数
     * @return
     */
    public int getDatacount() {
        return datacount;
    }

    /**
     * 是否有上一页
     * @return
     */
    public boolean hasPre(){
        
        return (pageno-1)>0;
    }
    
    /**
     * 是否有下一页
     * @return
     */
    public boolean hasNext(){
        
        return (pageno+1)<=pagecount;
    }
}

在构造方法中传入表名和每页显示数(默认为5),然后就可以通过getPagingResults(int pageno)方法来获得某一页的数据,返回一个list对象.

例如:

PagingUtil my = new PagingUtil("_group where uid="+uuid);
    List<_group> gs = (List<_group>)my.getPagingResults(Integer.parseInt(pageno));

 如果是想用模糊搜索,也可以,看下面的例子:

                PagingUtil testp = new PagingUtil("file where filename like '%123%' or swfname like '%.swf%'", 3);
        List<file> us = testp.getPagingResults(1);
        for(int i=0;i<us.size();i++){
            System.out.println(us.get(i).getFilename());
        }