classdao.java

这是我自己做的一个选课系统

package org.hibernate.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.beans.Classes;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;


import org.struts2.util.Constants;
import org.struts2.util.Pager;

public class ClassDAO extends HibernateDaoSupport{

	public void insertClass(Classes classes) {
		getHibernateTemplate().saveOrUpdate(classes);
	}

	public void updateClass(Classes classes) {
		getHibernateTemplate().update(classes);
	}
	
	public Classes getClass(String classid) {
		return (Classes) getHibernateTemplate().get(Classes.class,classid);
	}

	public List getClasses() {
		return getHibernateTemplate().find("from Classes");
	}

	public void deleteClass(String classid) {
		Object p = getHibernateTemplate().load(Classes.class, classid);
		getHibernateTemplate().delete(p);
	}
	
	/**
	 * if not pageSize and pageNo parameters, use default parameters
	 */
	public Pager findAllClassPager() {
		return findAllClassPager( Constants.pageSize, Constants.pageNo);
	}
	
	/**
	 * when have pageSize and pageNo parameters
	 */
	public Pager findAllClassPager(final int pageSize,final int pageNo) {		
		Session session = getHibernateTemplate().getSessionFactory().openSession();
		
		// set query condition
		Criteria criteria = session.createCriteria(Classes.class);
		
		
		// get total count
		int rowCount = ((Integer) criteria.setProjection(
				Projections.rowCount()).uniqueResult()).intValue();
		criteria.setProjection(null);
		
		// get current page list
		int startIndex = pageSize * (pageNo - 1);
		//criteria.addOrder(Order.asc("className"));
		criteria.setFirstResult(startIndex);
		criteria.setFetchSize(pageSize);
		List result = criteria.list();
		
		session.close();

		return new Pager(pageSize, pageNo, rowCount, result);
	}
	
	
	public Pager findTeacherClassPager(final String teacher_id){
		
		Session session = getHibernateTemplate().getSessionFactory().openSession();
		
		List result = session.createCriteria(Classes.class).add(
				Restrictions.eq("teacher.teacherId", teacher_id)).list();
		session.close();
		return new Pager(25, 0, 0,result);
	}
	
	
	
}