svcutil.java

DbService数据库接口,测试规范?菘饨涌?测试规范数据库接口,测试规范

package com.rainbow.mas.plugin.dbplugin.util;

import java.util.List;

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.rainbow.mas.SessionFactory;
import com.rainbow.mas.web.dto.ServiceBaseInfo;

public class SvcUtil {
	static Logger logger= LogManager.getLogger(SvcUtil.class);

	public static synchronized ServiceBaseInfo getSvc(String name) {
		Session s = SessionFactory.currentSession();
		Transaction tx = s.beginTransaction();
		ServiceBaseInfo svc = null;
		try {
			tx = s.beginTransaction();

			List list = s.createQuery(
				"from ServiceBaseInfo item where item.name='"+name+"'").list();

			if ( list.size()==1 ) {
				svc = (ServiceBaseInfo) list.get(0);
			}
			tx.commit();
		}
		catch (Exception e) {
			if (tx!=null) tx.rollback();
		}
		finally {
			s.close();
		}
		return svc;
	
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}