pagedaoimp.java

beijing donggandidai shoufeifanghao

package com.bj.admin.dao.hibernate;


import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.HibernateTemplate;

import com.bj.admin.dao.IPageDAO;




public class PageDAOImp implements IPageDAO{
	
	private SessionFactory sf;
    private HibernateTemplate template;
    
    public void setSf(SessionFactory sf) {
		this.sf = sf;
		template = new HibernateTemplate(sf);
	}
    
    public int getCount(String hql) {
    	
    	int i = template.find(hql).size();
		return i;
	}

	public List findAllPerson(int currow, int pagesize, String hql) {
		  List list = null;
		  SessionFactory sfa = template.getSessionFactory();
		  Session s = sfa.openSession();
	      Query q=s.createQuery(hql);
	      q.setFirstResult(currow);
	      q.setMaxResults(pagesize);
	      list=q.list();
	      s.close();
	      return list;
	}
}