package qiangjun.com.dao;

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;

import qiangjun.com.entity.Test;
import qiangjun.com.util.PageControl;

public class TestDao extends HibernateDaoSupport implements TestIDao{

	@SuppressWarnings("unchecked")
	public List<Test> queryAllInfo(final PageControl page) {
		final int start = page.getStart() - 1;
		final int num = page.getInt_num();
		
		return (List<Test>)getHibernateTemplate().execute(new HibernateCallback() {
			
			public Object doInHibernate(Session session) throws HibernateException,
					SQLException {
				String hql = " from Test ";
				Query query = session.createQuery(hql);
				query.setFirstResult(start);
				query.setMaxResults(num);
				List<Test> list = query.list();
				return list;
			}
		});
	}

	public int queryInfoNum() {
		return (Integer)getHibernateTemplate().execute(new HibernateCallback() {
			
			public Object doInHibernate(Session session) throws HibernateException,
					SQLException {
				String hql = " select count(*) from Test ";
				Query query = session.createQuery(hql);
				List list = query.list();
				int count = 0;
				if(!list.isEmpty()) {
					count = Integer.parseInt(list.get(0)+"");
				}
				return count;
			}
		});
	}

	
	
}