Spring mvc 动态数据源的配置

数据源的配置

<bean id="dataSource51" class="com.alibaba.druid.pool.DruidDataSource"
destroy-method="close" init-method="init" p:driverClassName="${jdbc.driverClassName}"
p:url="${jdbc.url}" p:connectionProperties="druid.stat.slowSqlMillis=5000;druid.stat.logSlowSql=true"
p:username="${jdbc.username}" p:removeAbandoned="true"
p:removeAbandonedTimeout="3600" p:logAbandoned="true" p:password="${jdbc.password}"
p:minIdle="1" p:maxActive="10" p:poolPreparedStatements="true"
p:maxPoolPreparedStatementPerConnectionSize="20" p:initialSize="1"
p:maxWait="60000" p:testWhileIdle="true" p:validationQuery="select 1"
p:timeBetweenEvictionRunsMillis="60000" p:filters="stat,slf4j">
<description>开发环境配置</description>
</bean>


<!-- 采集数据源 -->
<bean id="cjdataSource" class="com.alibaba.druid.pool.DruidDataSource"
destroy-method="close" init-method="init" p:driverClassName="${cj.jdbc.driverClassName}"
p:url="${cj.jdbc.url}" p:connectionProperties="druid.stat.slowSqlMillis=5000;druid.stat.logSlowSql=true"
p:username="${cj.jdbc.username}" p:removeAbandoned="true"
p:removeAbandonedTimeout="3600" p:logAbandoned="true" p:password="${cj.jdbc.password}"
p:minIdle="1" p:maxActive="10" p:poolPreparedStatements="true"
p:maxPoolPreparedStatementPerConnectionSize="20" p:initialSize="1"
p:maxWait="60000" p:testWhileIdle="true" p:validationQuery="select 1"
p:timeBetweenEvictionRunsMillis="60000" p:filters="stat,slf4j">
<description>开发环境配置</description>
</bean>

动态数据源

<bean id="dynamicDataSource" class="com.aisino.web.util.DynamicDataSource">
<!-- 通过key-value的形式来关联数据源 -->
<property name="targetDataSources">
<map key-type="java.lang.String">
<entry value-ref="cjdataSource" key="cjdataSource"></entry>
<entry value-ref="dataSource51" key="dataSource51"></entry>
</map>
</property>
<property name="defaultTargetDataSource" ref="dataSource51">
</property>
</bean>

DynamicDataSource 类内容

package com.aisino.web.util;


import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;  


public class DynamicDataSource extends AbstractRoutingDataSource {  
      
    //核心方法  
    @Override  
    protected Object determineCurrentLookupKey() {  
        return JdbcContextHolder.getJdbcType();  
    }  
}  

JdbcContextHolder 类内容

package com.aisino.web.util;


public class JdbcContextHolder {  
    //本地线程  
    private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();  
  
    public static void setJdbcType(String jdbcType)  
    {  
        contextHolder.set(jdbcType);  
    }  
    
    public static String getJdbcType()   
    {  
        //获取内容上下文配置  
        return (String) contextHolder.get();  
    }  
  
    public static void clearJdbcType()   
    {  
        //移除内容上下文配置  
        contextHolder.remove();  
    }  
}  

controller中直接设置数据源

JdbcContextHolder.setJdbcType("cjDataSource");