Mybatis配置多个数据源

1.编写2个以上数据源
<bean id="dataSource1" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.data1.driverClassName}" />
        <property name="jdbcUrl" value="${jdbc.data1.url}" />
        <property name="user" value="${jdbc.data1.username}" />
        <property name="password" value="${jdbc.data1.password}" />
    </bean>
    
    <bean id="dataSource2" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.data2.driverClassName}" />
        <property name="jdbcUrl" value="${jdbc.data2.url}" />
        <property name="user" value="${jdbc.data2.username}" />
        <property name="password" value="${jdbc.data2.password}" />
    </bean>
2.创建MultipleDataSource类用于切换数据源 需要 extends org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource

package com.data.db;

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

public class MultipleDataSource extends AbstractRoutingDataSource {
    private static final ThreadLocal<String> dataSourceKey = new InheritableThreadLocal<String>();

    public static void setDataSourceKey(String dataSource) {
        dataSourceKey.set(dataSource);
    }

    @Override
    protected Object determineCurrentLookupKey() {
        return dataSourceKey.get();
    }
}
3.配置
<bean id="dataSource" class="com.data.db.MultipleDataSource">
        <property name="defaultTargetDataSource" ref="dataSource1"/>
        <property name="targetDataSources">
            <map>
                <entry key="data1" value-ref="dataSource1"/>
                <entry key="data2" value-ref="dataSource2"/>
            </map>
        </property>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mapperLocations" value="classpath:com/data/mapper/*.xml" />
    </bean>

4.调用
在访问数据操作前调用

MultipleDataSource.setDataSourceKey(data2)
List<User> users = userMapper.selectUser();