package cn.jbit.ssh.dao.impl;
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 cn.jbit.ssh.dao.EmpDao;
import cn.jbit.ssh.entity.Emp;
public class EmpDaoImpl extends HibernateDaoSupport implements EmpDao {
/*用hibernate回调方法分页*/
/*切记!回调函数参数必须是常量!*/
/*new后面的属于匿名内部类*/
public List<Emp> findByPage(final int page, final int size) {
HibernateCallback h = new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery("from Emp");
query.setFirstResult((page-1)*size);
query.setMaxResults(size);
return query.list();
}
};
List<Emp> list = getHibernateTemplate().executeFind(h);
return list;
}
}
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 cn.jbit.ssh.dao.EmpDao;
import cn.jbit.ssh.entity.Emp;
public class EmpDaoImpl extends HibernateDaoSupport implements EmpDao {
/*用hibernate回调方法分页*/
/*切记!回调函数参数必须是常量!*/
/*new后面的属于匿名内部类*/
public List<Emp> findByPage(final int page, final int size) {
HibernateCallback h = new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery("from Emp");
query.setFirstResult((page-1)*size);
query.setMaxResults(size);
return query.list();
}
};
List<Emp> list = getHibernateTemplate().executeFind(h);
return list;
}
}