sysconfutil.java

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

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

import com.rainbow.mas.SessionFactory;
import com.rainbow.mas.web.dto.*;
import org.hibernate.*;
import java.util.*;
import org.apache.log4j.*;

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

	public static synchronized String getValue(String paramSection, String paramName) {
		Session s = SessionFactory.currentSession();
		Transaction tx = s.beginTransaction();
		String value=null;
		try {
			tx = s.beginTransaction();

			List list = s.createQuery(
				"from SystemConfig item where item.paramSection='"+paramSection+"' and item.paramName='" + paramName+"'"
				).list();

			if ( list.size()==1 ) {
				SystemConfig sysconf = (SystemConfig) list.get(0);
				value=sysconf.getParamValue();
				logger.debug("Value:"+value);
			}
			tx.commit();
		}
		catch (Exception e) {
			if (tx!=null) tx.rollback();
		}
		finally {
			s.close();
		}
		return value;
	
	}
	
	public static synchronized void setValue(String paramSection, String paramName,String paramValue) {
		Session s = SessionFactory.currentSession();
		Transaction tx = s.beginTransaction();
		try {
			tx = s.beginTransaction();
			
			List list = s.createQuery(
					"from SystemConfig item where item.paramSection='"+paramSection+"' and item.paramName='" + paramName+"'"
			).list();
			
			if ( list.size()==1 ) {
				SystemConfig sysconf = (SystemConfig) list.get(0);
				sysconf.setParamValue(paramValue);
			}
			tx.commit();
		}
		catch (Exception e) {
			if (tx!=null) tx.rollback();
		}
		finally {
			s.close();
		}
		
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		String loadorder=SysConfUtil.getValue("SELF", "ServiceLoadOrder");
		String endpoint=SysConfUtil.getValue("SELF", "ServiceManagerEndpoint");
	}

}