SpringMVC+Mybatis多静态数据源配置

项目结构：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
            http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/tx 
            http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-3.0.xsd
            ">

    <context:property-placeholder location="classpath:jdbc.properties" />

    <!-- 注入数据库事物 -->
    <tx:annotation-driven transaction-manager="transactionManager" />

    <!-- 数据库详细信心 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close" p:driverClass="${app.jdbc.driverClassName}"
        p:jdbcUrl="${app.jdbc.url}" p:user="${app.jdbc.username}" p:password="${app.jdbc.password}"
        p:acquireIncrement="10" p:idleConnectionTestPeriod="60" p:maxPoolSize="100"
        p:maxStatements="100" />

    <!-- 数据库事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
        p:dataSource-ref="dataSource" />

    <!-- 定义数据库连接实体 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- <property name="configLocation" value="classpath:sqlmap-config.xml" />  -->
    </bean>

    <!-- ORM存储文件 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>  
        <property name="basePackage" value="mapper" />
    </bean>

    <!-- 备份数据库配置 -->
    <tx:annotation-driven transaction-manager="transactionManager1" />

    <!-- Declare a datasource that has pooling capabilities -->
    <bean id="dataSource1" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close" p:driverClass="${app.jdbc.driverClassName}"
        p:jdbcUrl="${app.jdbc.url1}" p:user="${app.jdbc.username}" p:password="${app.jdbc.password}"
        p:acquireIncrement="10" p:idleConnectionTestPeriod="60" p:maxPoolSize="100"
        p:maxStatements="100" />

    <!-- Declare a transaction manager -->
    <bean id="transactionManager1"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
        p:dataSource-ref="dataSource1" />

    <!-- define the SqlSessionFactory, notice that configLocation is not needed when you use MapperFactoryBean -->
    <bean id="sqlSessionFactory1" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource1" />
        <!-- <property name="configLocation" value="classpath:sqlmap-config.xml" />  -->
    </bean>

    <!-- scan for mappers and let them be autowired -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory1"/>  
        <property name="basePackage" value="mapper1" />
    </bean>

</beans>

2个数据源可公用一个实体类库，.xml文件及数据接口需放到不同的文件夹中，否则会报错（2个单独的进程同时更改一个文件不报错才怪），2个数据源均单独的事物控制互不影响。


不建议采用程序控制的方法实现静态数据源的更换，每次数据交互的时候都需要判断。因为2个数据源指向的同一段代码，即同一个数据库缓存SQLSessionFactory，所以2个数据库无法同时操作。