paginationhibernatedaosupport.java

评分系统,acegi+JSF+spring+hibernate,可上传附件

package com.sgm.partybranch.persistence;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
 * This class expand the HibernateDaoSupport to support pagination when
 * searching results.
 * 
 * @author Administrator
 * @param <T>
 * 
 */

public class PaginationHibernateDaoSupport extends HibernateDaoSupport {

	/**
	 * just find by hql and can pagination
	 * 
	 * @param hql
	 * @param offset
	 *            the first result on the page in List
	 * @param pageSize
	 * @return
	 */
	public List findByPage(final String hql, final Integer offset,
			final Integer pageSize) {
		List list = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				List result = null;
				if (offset != null && pageSize != null) {
					result = session.createQuery(hql).setFirstResult(offset)
							.setMaxResults(pageSize).list();
				} else {
					result = session.createQuery(hql).list();
				}
				return result;
			}
		});
		return list;
	}

	/**
	 * 
	 * @param hql
	 * @param value
	 *            the first param
	 * @param offset
	 * @param pageSize
	 * @return
	 */
	public List findByPage(final String hql, final Object value,
			final Integer offset, final Integer pageSize) {
		List list = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				List result = null;
				Query query = session.createQuery(hql).setParameter(0, value);
				if (offset != null && pageSize != null) {
					query.setFirstResult(offset).setMaxResults(pageSize);
				} 
				result=query.list();
				return result;
			}
		});
		return list;
	}

	/**
	 * 
	 * @param hql
	 * @param values
	 * @param offset
	 * @param pageSize
	 * @return
	 */
	public List findByPage(final String hql, final Object[] values,
			final Integer offset, final Integer pageSize) {
		List list = getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session.createQuery(hql);
				for (int i = 0; i < values.length; i++) {
					query.setParameter(i, values[i]);
				}
				List result = null;
				if (offset != null && pageSize != null) {
					result = query.setFirstResult(offset).setMaxResults(
							pageSize).list();
				} else {
					result = query.list();
				}
				return result;
			}
		});
		return list;
	}

}