pagination.java

来自「有关医院方向的开发」· Java 代码 · 共 36 行

package com.woyi.page;

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

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

import com.woyi.page.PageInfo;
import com.woyi.page.PageInfoImpl;

public class Pagination extends HibernateDaoSupport{
	
	public PageInfo page(final int pageNo,final int pageSize,final String findHql,String countHql){
		List pageData = getHibernateTemplate().executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {

				return session.createQuery(findHql)
						.setFirstResult((pageNo-1)*pageSize)
						.setMaxResults(pageSize)
						.list();
			}			
		});
		int totalResult = 0;
		List count = this.getHibernateTemplate().find(countHql);
		if(count.size()>0){
			totalResult = (Integer)count.get(0);
		}
		PageInfo pageInfo = new PageInfoImpl(pageData,totalResult,pageSize,pageNo);
		return pageInfo;
	}
}