需求:项目里面已经有了一个数据源,现在其中一个模块的数据需要写入到另外一个数据库中,如何让该模块下面的数据能够写入到另外的数据库中去,
jdbc.properties存放数据库访问地址,主要信息如下
数据源1
jdbc.driverClassName = oracle.jdbc.driver.OracleDriver
jdbc.url = jdbc\:oracle\:thin\:@xxx.xxx.xxx.xxx\:port\::orcl
jdbc.username = xxx
jdbc.password = xxx
数据源2
jdbc.url2 = jdbc\:oracle\:thin\:@xxx.xxx.xxx.xxx\:port\:orcl
jdbc.username2 = xxx
jdbc.password2 = xxx
spring初始化扫描jdbc.properties,就会加载对应的数据库信息,spring-context.xml加载数据源如下配置
<context:property-placeholder ignore-unresolvable=“true” location=“classpath:*.properties” />
读取数据源1
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:mapper/**/*.xml" />
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.bidizhaobiao.datamonitor.dao" />
<property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate" />
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />
读取数据源2
<bean id="dataSource2" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url2}" />
<property name="username" value="${jdbc.username2}" />
<property name="password" value="${jdbc.password2}" />
</bean>
<bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource2" />
<property name="mapperLocations" value="classpath:mapper/**/*.xml" />
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<bean id="sqlSessionTemplate2" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory2" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.bidizhaobiao.datamonitor.dao2" />
<property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate2" />
</bean>
<bean id="transactionManager2"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource2" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager2" proxy-target-class="true" />
这里的意思其实读取属性文件,拿到数据库连接信息等,这里我们主要注意这两个地方
<property name="basePackage" value="com.bidizhaobiao.datamonitor.dao" />
<property name="basePackage" value="com.bidizhaobiao.datamonitor.dao2" />
因为这里其实就是mybatis扫描到执行数据库操作时候使用哪个数据源进行操作。比如在dao2包下面的就会使用数据库2,故访问数据1跟数据库2是不能放在同一个包下面的,还有一点注意
public class FieldsInfoDao implements FieldsInfoMapper {
@Resource
SqlSessionTemplate sqlSessionTemplate2;
@Override
public void insert(List<FieldsInfo> list) {
sqlSessionTemplate2.insert("com.bidizhaobiao.datamonitor.dao2.FieldsInfoMapper.batchInsert", list);
}
}
比如这里sqlSessionTemplate2必须要和配置文件的的id一致
总结,其实就是要注意两个数据源的包要分开,还有就是在mybatis操作数据库的时候要注意sqlSessionTemplate跟配置文件的id一致