spring,mybatis配多个数据库

最新推荐文章于 2022-12-03 22:30:04 发布

咸鱼老罗

最新推荐文章于 2022-12-03 22:30:04 发布

阅读量1.4k

点赞数

分类专栏： JAVA基础 spring mybatis 文章标签： mybatis spring 多数据源配置

本文链接：https://blog.csdn.net/luo4105/article/details/51742654

版权

JAVA基础同时被 3 个专栏收录

40 篇文章 0 订阅

订阅专栏

spring

8 篇文章 0 订阅

订阅专栏

mybatis

6 篇文章 0 订阅

订阅专栏

1.在jdbc配置文件jdbc.properties中写好两个数据库地址

#jdbc settings
jdbc.driver=com.mysql.jdbc.Driver

##########################################################
jdbc.url=jdbc:mysql://ip地址:3306/数据库名?characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc.username=root
jdbc.password=123456

#dbcp settings
dbcp.initialSize=5
dbcp.maxIdle=30
dbcp.maxActive=100
dbcp.maxWait=1000


ho.jdbc.driver=com.mysql.jdbc.Driver
#ho.jdbc.url=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
ho.jdbc.url=jdbc:mysql://ip地址:3306/energy_monit?characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
ho.jdbc.username=root
#ho.jdbc.password=123456
ho.jdbc.password=123456

ho.dbcp.initialSize=5
ho.dbcp.maxIdle=30
ho.dbcp.maxActive=100
ho.dbcp.maxWait=1000

2.在spring文件中配置两个数据源

<!-- 读取文件 -->
	<context:property-placeholder location="classpath:com/erpto/cle/config/jdbc.properties" />
	<!-- 数据源配置1 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<!-- Connection Info -->
		<property name="driverClassName" value="${jdbc.driver}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
		<!-- Connection Pooling Info -->
		<property name="maxActive" value="${dbcp.maxActive}" />
		<property name="maxIdle" value="${dbcp.maxIdle}" />
		<property name="defaultAutoCommit" value="false" />
		<!-- 连接Idle一个小时后超时 -->
		<property name="timeBetweenEvictionRunsMillis" value="3600000" />
		<property name="minEvictableIdleTimeMillis" value="3600000" />
	</bean>
	
	<!-- mapper扫描1 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="mapperLocations" value="classpath*:/com/erpto/cle/config/mybatis/**/*.xml" />
	</bean>
	
	<!-- 数据源配置2 -->
	<bean id="dataSource1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<!-- Connection Info -->
		<property name="driverClassName" value="${ho.jdbc.driver}" />
		<property name="url" value="${ho.jdbc.url}" />
		<property name="username" value="${ho.jdbc.username}" />
		<property name="password" value="${ho.jdbc.password}" />
		<!-- Connection Pooling Info -->
		<property name="maxActive" value="${ho.dbcp.initialSize}" />
		<property name="maxIdle" value="${ho.dbcp.maxIdle}" />
		<property name="defaultAutoCommit" value="false" />
		<!-- 连接Idle一个小时后超时 -->
		<property name="timeBetweenEvictionRunsMillis" value="3600000" />
		<property name="minEvictableIdleTimeMillis" value="3600000" />
	</bean>
	
	<!-- mapper扫描2 -->
	<bean id="sqlSessionFactory1" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource1" />
		<property name="mapperLocations" value="classpath*:/com/erpto/cle/config/mybatis2/**/*.xml" />
	</bean>
	
	<!-- dao包配置1 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.erpto.cle.dao" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	</bean>	
	
	<!-- dao包配置2 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.erpto.cle.dao2" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory1"></property>
	</bean>
	
	<!-- 事务配置 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	
	<!-- 事务配置 -->
	<bean id="transactionManager2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource1"></property>
	</bean>
	
	<!-- 没有配置事务管理器，以后加上  lc 2016-6-14 -->