mybatis中简易的多数据源

来源：互联网发布：好的淘宝零食点知乎编辑：程序博客网时间：2024/06/04 20:10

首先修改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

<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>

   <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....

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       <property name="dataSource" ref="dataSource" />
       <property name="configLocation" value="classpath:mybatis-config.xml"/>
   </bean>
   
   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
       <property name="basePackage" value="xfhm.core.dao"/>
       <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
   </bean>




   
   <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>

0 0