SpringMVC配置双数据源

SpringMVC+mybatis配置双数据源

一、首先配置数据源（这里采用的本地数据库）
spring-config.xml

	<!-- Oracle -->
    <bean id="dataSourceOracle" class="org.apache.commons.dbcp.BasicDataSource" >
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="username" value="scott"/>
        <property name="password" value="tiger"/>
        <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
    </bean>

	<!-- Mysql -->
    <bean id="dataSourceMysql" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="username" value="root"/>
        <property name="password" value="1234"/>
        <property name="url" value="jdbc:mysql://127.0.0.1:3806/test?characterEncoding=utf-8"/>
    </bean>

二、新建数据源持有类

package com.asiainfo.walk.fine.mvc.controller;

public class DataSourceSwitch {

    private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();

    public static final String MYSQL="MYSQL";
    public static final String ORACLE="ORACLE";

    /**
     * @Description: 设置数据源类型
     * @param dataSourceType  数据库类型
     * @return void
     * @throws
     */
    public static void setDataSourceType(String dataSourceType) {
        contextHolder.set(dataSourceType);
    }

    /**
     * @Description: 获取数据源类型
     * @return String
     * @throws
     */
    public static String getDataSourceType() {
        return contextHolder.get();
    }

    /**
     * @Description: 清除数据源类型
     * @return void
     * @throws
     */
    public static void clearDataSourceType() {
        contextHolder.remove();
    }
}

三、新建路由类

package com.asiainfo.walk.fine.mvc.controller;

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

public class DataSources extends AbstractRoutingDataSource {

    @Override
    protected Object determineCurrentLookupKey() {
        return DataSourceSwitch.getDataSourceType();
    }

}

四、配置数据源的路由 class路径为路由的路径

    <bean id="dynamicDataSource" class="com.asiainfo.walk.fine.mvc.controller.DataSources">
    	<!-- 注入两个数据源 -->
        <property name="targetDataSources">
            <map key-type="java.lang.String">
                <entry value-ref="dataSourceMysql" key="MYSQL"></entry>
                <entry value-ref="dataSourceOracle" key="ORACLE"></entry>
            </map>
        </property>
        <!-- 默认数据源 -->
        <property name="defaultTargetDataSource" ref="dataSourceOracle">
        </property>
    </bean>

五、配置Spring事物

	<!-- Spring 事务管理器 -->
	<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
        <property name="dataSource" ref="dynamicDataSource"/>
    </bean> 
	
	<!-- Spring 声明使用注解式事务 -->
	<tx:annotation-driven transaction-manager="txManager" />

六、Spring整合mybatis

	<!-- Mybatis's sqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    	<!-- 数据源 -->
        <property name="dataSource" ref="dynamicDataSource"/>
        <!-- mybatis配置文件路径 -->
        <property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>
        <!-- sql文件扫描路径 -->
        <property name="mapperLocations" value="classpath:sql/oracle/**/*.xml"/>
    </bean>

使用方法
在controller层
调用方法之前更换数据源

	@RequestMapping(value ="/queryList")
	public Object queryList(Map<String, Object> params) {
		//设置为 mysql 的数据源
		DataSourceSwitch.setDataSourceType(DataSourceSwitch.MYSQL);
		//调用service层
		List<Map<String,Object>> list = reportManagementService.queryList(params);
		return list;
	}