mybatis多数据源配置

最新推荐文章于 2022-09-01 07:55:46 发布

chengxl90

最新推荐文章于 2022-09-01 07:55:46 发布

阅读量243

点赞数

文章标签：多数据源

本文链接：https://blog.csdn.net/chengxl90/article/details/72828415

版权

1：配置多个数据源

	<!-- 数据源1 -->
    <bean id="dwDataSource" parent="parentDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://***.mysql.rds.aliyuncs.com:3306/fmcm_data?useUnicode=true&characterEncoding=utf8" />
        <property name="username" value="***" />
        <property name="password" value="***" />
	</bean>
    <bean id="dwSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">     
        <property name="configLocation" value="classpath:mybatis_configuration_dw.xml" />     
        <property name="dataSource" ref="dwDataSource" />     
    </bean> 
    <bean id="dwTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dwDataSource" />
    </bean>
    
    <!-- 数据源2 -->
    <bean id="pgcDataSource" parent="parentDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://***.mysql.rds.aliyuncs.com:3306/fmcm_pgc?useUnicode=true&characterEncoding=utf8" />
        <property name="username" value="***" />
        <property name="password" value="***" />
	</bean>
    <bean id="pgcSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">     
        <property name="configLocation" value="classpath:mybatis_configuration_pgc.xml" />     
        <property name="dataSource" ref="pgcDataSource" />     
    </bean> 
    <bean id="pgcTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="pgcDataSource" />
    </bean>

2：给不同的dao配置不同的sessionFactory，Dao继承SqlSessionDaoSupport

	<bean id="newsDao" class="cn.cover.worker.dao.server.impl.NewsDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>
	
	<bean id="dwNewsDao" class="cn.cover.worker.dao.server.impl.DwNewsDaoImpl">
    	<property name="sqlSessionFactory" ref="dwSqlSessionFactory"/>
    </bean>
    
    <bean id="dwNewsCmsDao" class="cn.cover.worker.dao.server.impl.DwNewsCmsDaoImpl">
    	<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>