1、在spring的配置文件里面,配置多个数据源,我这里配置两个
<bean id="jobDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<bean id="xsDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">2、很重要,新建一个类继承 AbstractRoutingDataSource
public class MultipleDataSource extends AbstractRoutingDataSource { private static ThreadLocal<String> dataSourceKey = new ThreadLocal<String>(); public static void setDataSourceKey(String dataSource) { dataSourceKey.set(dataSource); } @Override protected Object determineCurrentLookupKey() { return dataSourceKey.get(); } }对应的spring配置如下:
<bean id="multipleDataSource" class="com.rapoo.job.support.MultipleDataSource"> <property name="defaultTargetDataSource" ref="jobDataSource"/> <property name="targetDataSources"> <map> <entry key="jobDataSource" value-ref="jobDataSource"/> <entry key="xsDataSource" value-ref="xsDataSource"/> </map> </property> </bean>3、spring事务配置要改下
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="multipleDataSource" /> </bean>4、mybais配置也要改下
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="multipleDataSource" />5、完了之后,想要动态切换数据源,需要用AOP方式拦截执行的数据库操作,自动向 ThreadLocal设置数据源的key,见第2步的
setDataSourceKey和determineCurrentLookupKey方法