enrollmentdao.java

来自「hibernate映射1对多的课堂代码」· Java 代码 · 共 26 行

package com.sd0709.enrollment.data;

import java.util.List;

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

import com.sd0709.enrollment.util.HbnUtil;

public class EnrollmentDAO implements IEnrollmentDAO{
	public String reportEnrollment(){
		StringBuffer sb=new StringBuffer();
		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";
		s=HbnUtil.getSession();
		tran=s.beginTransaction();
		List l=s.createQuery(hql).list();
		sb.append("		student		course    \n");
		for(NamePair pair:(List<NamePair>)l){
			sb.append("		"+pair.getStuName()+"		"+pair.getCoursName()+"\n");
		}
		return sb.toString();
	}
}