package dao.hibernate;

import java.util.Collection;

import javax.servlet.http.HttpServletRequest;

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

import web.breakpage.Page;
import web.breakpage.PagerHandle;

import dao.IPageDao;

public class PageDaoImp implements IPageDao
{
	private SessionFactory sf;
	private HibernateTemplate template;
	
	public SessionFactory getSf()
	{
		return sf;
	}

	public void setSf(SessionFactory sf)
	{
		this.sf = sf;
        //通過session工廠得到hibernate模版
		template = new HibernateTemplate(sf);
	}

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

	public int getCount(String hql)
	{
		SessionFactory sf = template.getSessionFactory();
		Session s = sf.openSession();
		try 
	     {
		      Integer rows=(Integer) s.createQuery(hql).list().get(0);
		      s.flush();
		      s.close();
		      return rows.intValue();
	     } 
	     catch (HibernateException ex) 
	     {
	    	ex.printStackTrace();
	        return 0;
	     }
	}

	public Page getPage(HttpServletRequest request, String hql,int pageSize)
	{
		Page p = null;
		int totalRows = this.getCount(hql);
		p = PagerHandle.getPager(request, totalRows,pageSize);
		return p;
	}
	
	public Page getPage(HttpServletRequest request,int count,int pageSize)
	{
		Page p = null;
		int totalRows = count;
		p = PagerHandle.getPager(request, totalRows,pageSize);
		return p;
	}
}