teamdao.java

来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· Java 代码 · 共 89 行

/*
 * 创建日期 2005-7-2
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package persistence;

import java.util.List;
import java.util.Set;

import model.Team;

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

/**
 * @author Administrator
 * 
 * TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class TeamDAO extends BaseDAO{
    static Session session=null;
 	static Transaction tx=null;
	/*------------取得一个Team-----------------*/
	public static List getOneTeam() {
	    Team team=null;
	    List list=null;
		try {
			session = HibernateUtil.currentSession(); //开启连接
			tx = session.beginTransaction(); //开启事务
			Query q=session.createQuery("from Team t order by t.teamName");
			list=q.list();
			team=(Team)list.get(0);
			System.out.println(team.getTeamName()+"的学生数量:"+team.getStudents().size());
			team=(Team)list.get(1);
			System.out.println(team.getTeamName()+"的学生数量:"+team.getStudents().size());
			team=(Team)list.get(2);
			System.out.println(team.getTeamName()+"的学生数量:"+team.getStudents().size());
			team=(Team)list.get(3);
			System.out.println(team.getTeamName()+"的学生数量:"+team.getStudents().size());
			team=(Team)list.get(4);
			System.out.println(team.getTeamName()+"的学生数量:"+team.getStudents().size());
			
//			Object stuAndTeam1[]=(Object[]) list.get(0);
//			team=(Team) stuAndTeam1[0];
//			System.out.println(team.getTeamName());
//			System.out.println(team.getStudents().size());
//			team=(Team) q.uniqueResult();
//			team=(Team) session.get(Team.class,"ff80808105416d3b0105416d3eca0002");
			tx.commit();

		} catch (HibernateException e) { //捕捉例外
			e.printStackTrace();
			tx.rollback();
		}finally
		{
			HibernateUtil.closeSession(session);
		}
		return list;

	}
	/*------------取得所有学生-----------------*/
	public static Set getAllStu()  {
	    Team team=null;
	    Set set=null;
		try {
			session = HibernateUtil.currentSession(); //开启连接
			tx = session.beginTransaction(); //开启事务
			team=(Team) session.get(Team.class,"ff80808105384a980105384a9ba60002");
			set=team.getStudents();
			tx.commit();

		} catch (HibernateException e) { //捕捉例外
			e.printStackTrace();
			tx.rollback();
		}finally
		{
			HibernateUtil.closeSession(session);
		}
		return set;

	}


}