spring中将多个jndi转成JdbcTemplate

applicationContext.xml

<jee:jndi-lookup id="mysql" jndi-name="jdbc/mysql"/>
<jee:jndi-lookup id="test" jndi-name="jdbc/test"/>

package example;

import java.util.HashMap;
import java.util.Map;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;

public class DBUtils{

	private static Map<String,JdbcTemplate> map = new HashMap<String,JdbcTemplate>();
	
	static {
		map.put("mysql",  new JdbcTemplate((DataSource) SpringUtils.getBean("mysql")));
		map.put("test",  new JdbcTemplate((DataSource) SpringUtils.getBean("test")));
	}
	
	public static JdbcTemplate getJdbcTemplate(String id){
		return map.get(id);
	}
}

package example;

import java.util.Map;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
import org.springframework.web.context.support.WebApplicationContextUtils;

public class SpringUtils{

	private static ApplicationContext applicationContext;

	static{
		setApplicationContext();
	}
	
	public static void setApplicationContext(){
//		用到RequestContextHolder需要在web.xml配置org.springframework.web.context.request.RequestContextListener
		HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();    
		ServletContext servletContext = request.getSession().getServletContext();  
		applicationContext = WebApplicationContextUtils.getWebApplicationContext(servletContext);
	}

	public static ApplicationContext getApplicationContext() {
		return applicationContext;
	}

	public static Object getBean(String beanId) throws BeansException {
		return applicationContext.getBean(beanId);
	}
	
	public static <E> Map<String, E> getBeansOfType(Class<E> type){
		return applicationContext.getBeansOfType(type);
	}
}

web.xml

<listener>
	<listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
</listener>