testreport.java

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

package com.sd0709.bank.present;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.sd0709.bank.biz.entity.ActInfo;

public class TestReport{
	public static void main(String[] args) {
		Configuration cfg = null;
		SessionFactory sf = null;
		Session s = null;
		Transaction tran = null;
		try {
			cfg = new Configuration().configure();
			sf = cfg.buildSessionFactory();
			s = sf.openSession();
			tran = s.beginTransaction();
			String hql = 
				"select new com.sd0709.bank.biz.entity." +
				"ActInfo(count(*),sum(a.bal)) " +
				" from Account a where a.usr.uid=?";
			ActInfo info =(ActInfo) s.createQuery(hql)
			                .setString(0, "uid-00001")
			                .uniqueResult();
			System.out.println("num="+info.getNum());
			System.out.println("total bal="+info.getTotalBal());
			tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			if (tran != null)
				tran.rollback();
		} finally {
            if(s!=null && s.isOpen()) s.close();
            if(sf!=null && !sf.isClosed()) sf.close();
		}
	}

}