enrollmentdao.java

来自「加拿大达内科技有限公司配需java程序员的上课时的代码」· Java 代码 · 共 99 行

package com.sd0709.enrollment.data;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.sd0709.enrollment.util.HbnUtil;

public class EnrollmentDAO {
	public List findByNameList(List nameList){
		   Session s = null;
		   Transaction tran = null;
		   String hql = 
			 "from Student s where s.name in (:nlist)";
		   List l = null;
		try {
			s = HbnUtil.getSession();
			   tran = s.beginTransaction();
			   l = s.createQuery(hql)
			             .setParameterList("nlist",nameList)
			             .list();
			   tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			if(tran!=null) tran.rollback();
		}finally{
			HbnUtil.releaseSession(s);
		}
		   return l;
	   }
	 public List findByNamePattern(String namePattern){
		   Session s = null;
		   Transaction tran = null;
		   String hql = 
			 "from Student s where s.name like :p";
		   List l = null;
		try {
			s = HbnUtil.getSession();
			   tran = s.beginTransaction();
			   l = s.createQuery(hql)
			             .setString("p",namePattern)
			             .list();
			   tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			if(tran!=null) tran.rollback();
		}finally{
			HbnUtil.releaseSession(s);
		}
		   return l;
	   }
   public List findByName(String name){
	   Session s = null;
	   Transaction tran = null;
	   String hql = 
		 "from Student s where s.name=:n";
	   List l = null;
	try {
		s = HbnUtil.getSession();
		   tran = s.beginTransaction();
		   l = s.createQuery(hql)
		             .setString("n", name)
		             .list();
		   tran.commit();
	} catch (HibernateException e) {
		e.printStackTrace();
		if(tran!=null) tran.rollback();
	}finally{
		HbnUtil.releaseSession(s);
	}
	   return l;
   }
   public List reportEnrollment(){
	   Session s = null;
	   Transaction tran = null;
	   String hql = 
		 "select " +
		 "new com.sd0709.enrollment.data." +
		 "NamePair(a.name,c.name) " +
		 "from Student a join a.cours c";
	   List l = null;
	try {
		s = HbnUtil.getSession();
		   tran = s.beginTransaction();
		   l = s.createQuery(hql)
		             .list();
		   tran.commit();
	} catch (HibernateException e) {
		e.printStackTrace();
		if(tran!=null) tran.rollback();
	}finally{
		HbnUtil.releaseSession(s);
	}
	   return l;
	}
}