mybatis中简易的多数据源

首先修改jdbc properties

driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbcUrl=jdbc:sqlserver://:111111;DatabaseName=XF_System_Data

user=11111

password=1111

jdbcUrl2=jdbc:sqlserver://111:6002;DatabaseName=XF_System_Orig_Data

user2=1111111

password2=1111111

2修改jdbcxml

<!-- c3p0-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${driverClass}"/>
        <property name="jdbcUrl" value="${jdbcUrl}"></property>
        <property name="user" value="${user}" />
        <property name="password" value="${password}"/>
    </bean>
<!-- c3p0-->
    <bean id="dataSource2" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${driverClass}"/>
        <property name="jdbcUrl" value="${jdbcUrl2}"></property>
        <property name="user" value="${user2}" />
        <property name="password" value="${password2}"/>
    </bean>

3修改mybatis中的sqlsession....

 <!-- 创建Mybatis SessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:mybatis-config.xml"/>    
    </bean>
    <!-- 配置Mybatis扫描 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="xfhm.core.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
    </bean>
    
    
    
    
   <!-- 创建Mybatis SessionFactory -->
    <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource2" />
        <property name="configLocation" value="classpath:mybatis-config.xml"/>    
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
    <property name="basePackage" value="xfhm.core.daos.picdate" />  
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"></property>  
    </bean>