basedao.java

ssh2注册查询搜索分页实例ssh2注册查询搜索分页实例

/**
 * 
 */
package com.feiling.dao;

import java.util.List;

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

/**
 * @author Administrator
 *
 */
public class BaseDao extends HibernateDaoSupport {
	protected int firstResult;
	protected int maxResult;
	protected String sql;
	public List<?> getDataList(int fResult, int mResult, String hql)
	{
		this.sql = hql;
		this.firstResult = fResult;
		this.maxResult = mResult;
		return this.getHibernateTemplate().executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session){
				Query q = session.createQuery(sql);
				q.setFirstResult(firstResult);
				q.setMaxResults(maxResult);
				return q.list();
			}
			});
	}
	public int getRows(String sql)
	{
		return getHibernateTemplate().find(sql).size();
	}
	public void save(Object object)
	{
		getHibernateTemplate().save(object);
	}
}