servicemapping.java~2~

采用web2.0技术,采用动态标签,sql语句全部存储在数据库里面.开发速度快.

package com.sztheater.framework.util;
import java.sql.*;
import java.util.*;
public class ServiceMapping {
	private static HashMap m_service_map   = null;//保存业务映射关系
	/*
	* 取得业务执行信息
	* @param busi_id     业务编码
	* @return 业务执行信息
	*/
	public static synchronized HashMap getServiceInfo(Connection conn,
                String service_id,String Action_ID){
		if(conn==null ) return null;
		if(service_id==null || service_id.trim().equals("")) return null;

		HashMap   hashServ  = null;
		String    strSQL    = null;
		String    s_service_id = null;
		String    service_type = null;
		if(Action_ID==null) Action_ID = "";
		service_id   = service_id.trim();
		Action_ID    = Action_ID.trim();
		s_service_id = service_id;
		if(m_service_map==null) {
			m_service_map = new HashMap();
		}
		if(Action_ID.equals("psql")) service_id = "psql";

		hashServ = (HashMap)m_service_map.get(service_id);
		if(hashServ!=null) return hashServ;

		if(Action_ID.equals("psql")){
			hashServ = new HashMap();
			hashServ.put("service_id"   ,service_id);
			hashServ.put("service_desc" ,"动态SQL服务");
			hashServ.put("class_name"   ,"com.sztheater.framework.util.ParseSQLBusi");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}
		if(service_id.equals("login")){
			hashServ = new HashMap();
			hashServ.put("service_id"   ,service_id);
			hashServ.put("service_desc" ,"会员登录");
			hashServ.put("class_name"   ,"com.sztheater.biz.system.Login");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}
		if(service_id.equals("portal_enable")){
			hashServ = new HashMap();
			hashServ.put("service_id"   ,service_id);
			hashServ.put("service_desc" ,"会员激活");
			hashServ.put("class_name"   ,"com.sztheater.biz.register.CRegister");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}
		if(service_id.equals("sys_login")){
			hashServ = new HashMap();
			hashServ.put("service_id"   ,service_id);
			hashServ.put("service_desc" ,"系统登录");
			hashServ.put("class_name"   ,"com.sztheater.biz.system.SysLogin");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}
		if(service_id.equals("DtreeMenu")){
			hashServ = new HashMap();
			hashServ.put("service_id"   ,service_id);
			hashServ.put("service_desc" ,"系统菜单");
			hashServ.put("class_name"   ,"com.sztheater.biz.system.DtreeMenu");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}


		if(service_id.equals("DICT")){
			hashServ = new HashMap();
			hashServ.put("service_id"  ,service_id     );
			hashServ.put("service_desc","字典服务" );
			hashServ.put("class_name"  ,"com.sztheater.framework.system.StaticDict");
			m_service_map.put(service_id,hashServ);
			return hashServ;
		}
		if(service_id.startsWith("ST_")) s_service_id = "TAB_SERV";
		strSQL  = "select distinct service_id,service_desc,class_name,service_type \n"
				+ "from tsm_service \n"
				+ "where service_id='"+service_id+"'";

		Statement  stmt        = null;
		ResultSet  RSTemp      = null;
		String     service_desc= null;
		String     class_name  = null;
		try{
			stmt     = conn.createStatement();
			RSTemp   = stmt.executeQuery( strSQL);
			while (RSTemp != null && RSTemp.next()) {
				service_id   = RSTemp.getString("service_id"  );
				class_name   = RSTemp.getString("class_name"  );
				service_desc = RSTemp.getString("service_desc");
				service_type = RSTemp.getString("service_type");
				if(service_id  ==null) service_id   = "";
				if(class_name  ==null) class_name   = "";
				if(service_desc==null) service_desc = "";
				if(service_type==null) service_type = "";

				service_id   = service_id.trim();
				class_name   = class_name.trim();
				service_desc = service_desc.trim();
				service_type = service_type.trim();
				if(class_name.equals("")) continue;
				if(service_desc.equals("")) service_desc = service_id;

				hashServ = new HashMap();
				hashServ.put("service_id"   ,service_id   );
				hashServ.put("service_desc" ,service_desc );
				hashServ.put("class_name"   ,class_name   );
				hashServ.put("service_type" ,service_type );
				m_service_map.put(service_id,hashServ);
			}
		}catch(Exception e){
			System.out.println("依据["+service_id+"]取得服务异常\n" + e.getMessage());
		}finally{
			try{
				if(stmt!=null) stmt.close();
			}catch(Exception e){
			}
			try{
				if(RSTemp!=null) RSTemp.close();
			}catch(Exception e){
				System.out.println("依据["+service_id+"]取得服务异常\n" + e.getMessage());
			}
			stmt   = null;
			RSTemp = null;
		}
		hashServ = (HashMap)m_service_map.get(service_id);
		if(hashServ!=null) return hashServ;
		if(s_service_id.equals("TAB_SERV")){
			hashServ = new HashMap();
			hashServ.put("service_id"  ,"TAB_SERV"     );
			hashServ.put("service_desc","单表服务" );
			hashServ.put("class_name"  ,"com.sztheater.framework.util.TabServBusi");
			m_service_map.put("TAB_SERV",hashServ);
			return hashServ;
		}
		return null;
	}
}