SpringMVC+Mybatis两个数据源实现（一）

怼烎@ 2023-10-18 16:33 4阅读 0赞

第二篇请移步到[《SpringMVC+Mybatis两个数据源实现（二）》][SpringMVC_Mybatis]

--------------------

#### 一、配置文件结构 ####

首先配置文件的结构是这样的  
![在这里插入图片描述][20190402143818526.]  
下面来看几个关键配置

###### 1. jdbc.properties ######

#============================================================================
    # datasource 1
    #============================================================================
    #数据库连接
    jdbc.driverClass=com.mysql.jdbc.Driver
    #数据库连接url
    jdbc.jdbcUrl=jdbc:mysql://127.0.0.10:3306/device_operlog
    #数据库用户名
    jdbc.user=root
    #数据库密码
    jdbc.password=root
    
    #============================================================================
    # datasource 2
    #============================================================================
    #数据库连接
    jdbc2.driverClass=com.mysql.jdbc.Driver
    #数据库连接url
    jdbc2.jdbcUrl=jdbc:mysql://127.0.0.11:3306/device_operlog
    #数据库用户名
    jdbc2.user=root
    #数据库密码
    jdbc2.password=root

###### 2. spring-mybatis.xml ######

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns:mybatis="http://mybatis.org/schema/mybatis-spring" xmlns:context="http://www.springframework.org/schema/context"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd  
           http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
    	   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
    
    	
    	<context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true" />
    
    	
    	<bean id="dataSource1" class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown">
    		<property name="driverClassName" value="${jdbc.driverClass}" />
    		<property name="jdbcUrl" value="${jdbc.jdbcUrl}" />
    		<property name="username" value="${jdbc.user}" />
    		<property name="password" value="${jdbc.password}" />
    
    		
    		<property name="readOnly" value="false" />
    		
    		<property name="connectionTimeout" value="30000" />
    		
    		<property name="idleTimeout" value="600000" />
    		
    		<property name="maxLifetime" value="1800000" />
    		
    		<property name="maximumPoolSize" value="20" />
    	</bean>
    
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource1" />
    		<property name="configLocation" value="classpath:mybatis-config.xml" />
    		<property name="mapperLocations" value="classpath:mappers/mybatis-display.xml"/>
    	</bean>
    
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    		<property name="basePackage" value="com.xxx.display.dao" />
    	</bean>
    
    	
    	<bean id="dataSource2" class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown">
    		<property name="driverClassName" value="${jdbc2.driverClass}" />
    		<property name="jdbcUrl" value="${jdbc2.jdbcUrl}" />
    		<property name="username" value="${jdbc2.user}" />
    		<property name="password" value="${jdbc2.password}" />
    		<property name="readOnly" value="false" />
    		<property name="connectionTimeout" value="30000" />
    		<property name="idleTimeout" value="600000" />
    		<property name="maxLifetime" value="1800000" />
    		<property name="maximumPoolSize" value="20" />
    	</bean>
    
    	<bean id="sqlSessionFactory1" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource2" />
    		<property name="configLocation" value="classpath:mybatis-config.xml" />
    		<property name="mapperLocations" value="classpath:mappers/mybatis-certificate.xml" />
    	</bean>
    
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="sqlSessionFactoryBeanName"  value="sqlSessionFactory1" />
    		<property name="basePackage" value="com.xxx.certificate.dao" />
    	</bean>
    
    	
    	<context:component-scan base-package="com.xxx.controller,com.xxx.service" />
    </beans>

###### 3. mybatis-config.xml ######

<?xml version="1.0" encoding="UTF-8" ?> 
    <!DOCTYPE configuration      
        PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"      
        "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
    <configuration>
    	<settings>
    		
    		<setting name="cacheEnabled" value="false" />
    		
    		<setting name="lazyLoadingEnabled" value="true" />
    		
    		<setting name="aggressiveLazyLoading" value="false" />
    		
    		<setting name="multipleResultSetsEnabled" value="true" />
    		
    		<setting name="useColumnLabel" value="true" />
    		
    		<setting name="useGeneratedKeys" value="true" />
    		
    		<setting name="autoMappingBehavior" value="FULL" />
    		
    		
    		
    		<setting name="defaultStatementTimeout" value="25000" />
    	</settings>
    	
    </configuration>

这里需要注意，在`spring-mybatis.xml`文件中已经配置了相应的mapper，所以不需要重复配置，如：

否则会报错。

###### 4.mybatis-certificate.xml <省略mybatis-display.xml> ######

![在这里插入图片描述][20190402145344112.]  
这里`namespace`写对应dao的完整包名

--------------------

#### 二 、包结构 ####

![在这里插入图片描述][2019040214400032.]

###### DisplayServiceImpl.java ######

![在这里插入图片描述][2019040214414126.]

###### CeritificateServiceImpl.java ######

![在这里插入图片描述][20190402144119417.]  
分别调用各自的`dao接口`，在`controller`上也是一样的，根据业务不同调用不同的`service`。

附`pom.xml`配置<内容有删减>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<groupId>xxx</groupId>
    	<artifactId>xxx</artifactId>
    	<packaging>war</packaging>
    	<version>0.0.1-SNAPSHOT</version>
    	<properties>
    		<springframework>4.0.6.RELEASE</springframework>
    		<servlet>3.1.0</servlet>
    		<mybatis-version>3.3.1</mybatis-version>
    	</properties>
    
    	<dependencies>
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-api</artifactId>
    			<version>1.7.13</version>
    		</dependency>
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-log4j12</artifactId>
    			<version>1.7.13</version>
    		</dependency>		
    		
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-core</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-web</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-jdbc</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-webmvc</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-aop</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-aspects</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-beans</artifactId>
    			<version>${springframework}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.31</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>${mybatis-version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.2.4</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.zaxxer</groupId>
    			<artifactId>HikariCP-java7</artifactId>
    			<version>2.4.13</version>
    		</dependency>
    	</dependencies>
    	<build>
    		<finalName>xxx</finalName>
    		<plugins>
    			<plugin>
    				<artifactId>maven-compiler-plugin</artifactId>
    				<configuration>
    					<source>1.7</source>
    					<target>1.7</target>
    				</configuration>
    			</plugin>
    			<plugin>
    				<artifactId>maven-war-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>
    </project>

[SpringMVC_Mybatis]: https://blog.csdn.net/tiantang_1986/article/details/90022407
[20190402143818526.]: https://img-blog.csdnimg.cn/20190402143818526.
[20190402145344112.]: https://img-blog.csdnimg.cn/20190402145344112.
[2019040214400032.]: https://img-blog.csdnimg.cn/2019040214400032.
[2019040214414126.]: https://img-blog.csdnimg.cn/2019040214414126.
[20190402144119417.]: https://img-blog.csdnimg.cn/20190402144119417.