chooseclassdao.java

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

package org.hibernate.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.struts2.util.Constants;
import org.struts2.util.Pager;

import org.hibernate.beans.Chooseclass;
import org.hibernate.beans.Classes;




public class ChooseclassDAO extends HibernateDaoSupport{

	public boolean isValid(final String stu_id, final String class_id) {
		List list = (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException {
				List result = session.createCriteria(Chooseclass.class).add(
						Restrictions.eq("student.stuId", stu_id)).add(
						Restrictions.eq("classes.classId", class_id)).list();
				return result;
			}
		});
		if (list.size() > 0) {
			return true;
		} else {
			return false;
		}
	}
	
	public String isFull(final String class_id) {
		List list = (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException {
				List result = session.createCriteria(Chooseclass.class).add(
						Restrictions.eq("classes.classId", class_id)).list();
				return result;
			}
		});
		Classes classes =(Classes)list.get(0);
		if (classes.getSelectNum().equals(classes.getNum())) {
			return classes.getSelectNum();
		} else {
			return "full";
		}
	}

	public Pager findChooseClassList(final String stu_id){
		return this.findChooseClassList(stu_id, Constants.pageSize, Constants.pageNo);
	}
	
	public Pager findChooseClassList(final String stu_id,final int pageSize,final int pageNo){
		
        Session session = getHibernateTemplate().getSessionFactory().openSession();
		
		// set query condition
		Criteria criteria =session.createCriteria(Chooseclass.class).add(
				Restrictions.eq("student.stuId", stu_id));
		
		
		// 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(Constants.pageSize);
		List result = criteria.list();
		
		session.close();

		return new Pager(pageSize, pageNo, rowCount, result);
		
	}
	
	
	public Pager findStudentList(final String class_id){
		
        Session session = getHibernateTemplate().getSessionFactory().openSession();
		
		// set query condition
		List result =session.createCriteria(Chooseclass.class).add(
				Restrictions.eq("classes.classId", class_id)).list();
		
		session.close();
		return new Pager(25,0,0,result);
	}
	
	public void insertChooseclass(Chooseclass chooseclass) {
		getHibernateTemplate().update(chooseclass);
	}
	
	public void updateChooseclass(Chooseclass chooseclass) {
		getHibernateTemplate().update(chooseclass);
	}
	
	public Chooseclass getChooseclass(String stuid) {
		return (Chooseclass) getHibernateTemplate().get(Chooseclass.class,stuid);
	}

	public List getChooseclasses() {
		return getHibernateTemplate().find("from Chooseclass");
	}

	public void deleteChooseclass(String stuid) {
		Object p = getHibernateTemplate().load(Chooseclass.class, new Integer(stuid));
		getHibernateTemplate().delete(p);
	}
}