SelectionCourseSystem/src/edson/database/daoImpl/StuDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package edson.database.daoImpl;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate5.HibernateCallback;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.orm.hibernate5.support.HibernateDaoSupport;

import edson.bean.Course;
import edson.bean.Student;
import edson.utils.PageBean;

public class StuDao extends HibernateDaoSupport{

	private String hql,hql_table;
	
	public PageBean findPageSelection(Integer num) {
		hql="select count(*) from Course c where c.is_selection=1";//查询总共记录数
		hql_table="from Course c where c.is_selection=1";//指定表
		return findPageTool(num);
	}
	

	public PageBean<Student> findPageTool(final Integer pagenum) {
		Integer totalRecord;
		
		totalRecord=findTotalRecord(hql,null);
		
		List<Student> cs=this.getHibernateTemplate().execute(new HibernateCallback<List<Student>>() {

			@Override
			public List<Student> doInHibernate(Session session)
					throws HibernateException {
				
				return  session.createQuery(hql_table)
										.setFirstResult((pagenum-1)*6)
										.setMaxResults(6)
										.list();
				
			}
		});
				
				
		
		PageBean pb=new PageBean(pagenum,totalRecord,cs);
		
		return pb;
	}
	
	public Integer findTotalRecord(String hql,Object[] params) {
		List<Long> pageRecord;
		if(params==null || params.length<=0){
			pageRecord=(List<Long>) this.getHibernateTemplate().find(hql);
		}else{
			pageRecord=(List<Long>) this.getHibernateTemplate().find(hql,Integer.valueOf(params[0].toString()));
		}
		if(pageRecord.size()<=0)return null;
		return pageRecord.get(0).intValue();