Spring Boot整合Mybatis实现多数据源
1 maven依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
2 spring boot配置文件
spring:
profiles:
active: oracle
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
url: jdbc:mysql://49.232.23.221:3306/multi_datasource
mybatis:
mapper-location: classpath*:com/lcc/mybatis/mapper/*.xml
configuration:
database-id: mysql
spring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@localhost:1521:orcl
username: root
password: root
mybatis:
mapper-location: classpath*:com/lcc/mybatis/mapper/*.xml
configuration:
database-id: oracle
3 映射文件
<select id="isExist" resultType="java.lang.Integer" databaseId="mysql">
sql语句
</select>
<select id="isExist" resultType="java.lang.Integer" databaseId="oracle">
sql语句
</select>