Spring多数据源配置以及动态切换实现

问题描述

 这篇文章主要是结合自己的经验，总结下多数据源配置实现的方式！

一：首先是配置数据源

1、使用xml的bean节点来配置

<bean id="dataSource"
		class="com.framework.datasourceRoute.DynamicDataSource">
		<property name="targetDataSources">
			<map>
				<entry key="master" value-ref="master"></entry>
				<entry key="slave" value-ref="slave"></entry>
			</map>
		</property>
		<property name="defaultTargetDataSource" ref="master"></property>
	</bean>
 
	<bean id="master" class="com.alibaba.druid.pool.DruidDataSource"
		destroy-method="close">
		<property name="url" value="${master.ds.jdbcUrl}" />
		<property name="username" value="${master.ds.user}" />
		<!-- <property name="password" value="${master.ds.password}" /> -->
		<property name="password" value="DB.mring-coop.PassWord" />
		<property name="initialSize" value="${master.ds.initialSize}" />
		<property name="minIdle" value="${master.ds.minIdle}" />
		<property name="maxActive" value="${master.ds.maxActive}" />
		<property name="maxWait" value="${master.ds.maxWait}" />
		<property name="timeBetweenEvictionRunsMillis" value="${master.ds.timeBetweenEvictionRunsMillis}" />
		<property name="minEvictableIdleTimeMillis" value="${master.ds.minEvictableIdleTimeMillis}" />
		<property name="validationQuery" value="${master.ds.validationQuery}" />
		<property name="testWhileIdle" value="${master.ds.testWhileIdle}" />
		<property name="testOnBorrow" value="${master.ds.testOnBorrow}" />
		<property name="testOnReturn" value="${master.ds.testOnReturn}" />
 
	</bean>
 
 
	<bean id="slave" class="com.alibaba.druid.poo