test2.java

hibernate练习的最佳的代码

package com.tarena.ebank.view;

import java.util.ArrayList;
import java.util.List;

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

import com.tarena.ebank.biz.entriy.Account;
import com.tarena.ebank.persist.HbnUtil;

public class Test2 {

	
	public static void main(String[] args) {
		Session s=null;
		try{
		s=HbnUtil.getSessionFactory().openSession();
		s.beginTransaction();
		List params=new ArrayList();
		params.add("act-001");
		  params.add("act-002");
		  params.add("act-003");
		  params.add("act-004");
		  params.add("act-0015");
		  String hql = "from Account a " +
	  		"where a.actNo in (:ACTLIST)";
		  List l=s.createQuery(hql).setParameter("ACTLIST", params).list();
		  StringBuffer sb=new StringBuffer();
		  for(Account a:(List<Account>)l){
			  sb.append(a.getActNo()+"  ");
			  sb.append(a.getBal()+"  ");
			  sb.append(a.getOid()+"\n");
		  }
		  System.out.print(sb.toString());
		  s.getTransaction().commit();
	} catch (HibernateException e) {
		 e.printStackTrace();
	     s.getTransaction().rollback();
	}finally{
		s.close();
		HbnUtil.release();
	}
	  
	  
	  
	  
	  
	  
	  
	  
	  
	}

}