package com.tarena.ebank.view;

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

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

public class Test4 {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
	Session s=null;
	try {
		s=HbnUtil.getSessionFactory().openSession();
		s.beginTransaction();
		String hql="from Account a "+"where a.actNo=:ACTNO";
		Account a=(Account)s.createQuery(hql).setString("ACTNO", "act-0010").uniqueResult();
		  System.out.print(a.getActNo()+"  "+a.getBal());
		  s.getTransaction().commit();
	} catch (HibernateException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
		s.getTransaction().rollback();
	}finally{
		s.close();
		HbnUtil.release();
	}
	
	}

}