spring,mybatis配多个数据库

我会带着你远行 2022-09-21 14:26 162阅读 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" />
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    		
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		
    		<property name="maxActive" value="${dbcp.maxActive}" />
    		<property name="maxIdle" value="${dbcp.maxIdle}" />
    		<property name="defaultAutoCommit" value="false" />
    		
    		<property name="timeBetweenEvictionRunsMillis" value="3600000" />
    		<property name="minEvictableIdleTimeMillis" value="3600000" />
    	</bean>
    	
    	
    	<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>
    	
    	
    	<bean id="dataSource1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    		
    		<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}" />
    		
    		<property name="maxActive" value="${ho.dbcp.initialSize}" />
    		<property name="maxIdle" value="${ho.dbcp.maxIdle}" />
    		<property name="defaultAutoCommit" value="false" />
    		
    		<property name="timeBetweenEvictionRunsMillis" value="3600000" />
    		<property name="minEvictableIdleTimeMillis" value="3600000" />
    	</bean>
    	
    	
    	<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>
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="com.erpto.cle.dao" />
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    	</bean>	
    	
    	
    	<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>