使用dynamic-datasource实现使用多个数据库
简介:
在项目中经常会调用多个数据库,比如读写分离。
dynamic-datasource-spring-boot-starter 是一个基于springboot的快速集成多数据源的启动器
文档地址:
[https://www.kancloud.cn/tracy5546/dynamic-datasource/2264611]:
示例
说明:从两个库读取相同的表,显示两个库中表的内容
技术:
springboot,mybatis-plus,dynamic-datasource
步骤:
依赖:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--dynamic-datasource-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.0.0</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- sqlServer -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>${sqlserver-version}</version>
</dependency>
<!-- velocity 模板引擎, Mybatis Plus 代码生成器需要 -->
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>${velocity.version}</version>
</dependency>
<!--mybatis-plus 持久层-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus.version}</version>
</dependency>
配置数据源
spring:
datasource:
dynamic:
primary: master #设置默认的数据源或者数据源组,默认值即为master
strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
datasource:
master:
url: jdbc:mysql://xx.xx.xx.xx:3306/dynamic
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver # 3.2.0开始支持SPI可省略此配置
slave_1:
url: jdbc:mysql://xx.xx.xx.xx:3307/dynamic
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
slave_2:
url: ENC(xxxxx) # 内置加密,使用请查看详细文档
username: ENC(xxxxx)
password: ENC(xxxxx)
driver-class-name: com.mysql.jdbc.Driver
#......省略
#以上会配置一个默认库master,一个组slave下有两个子库slave_1,slave_2
# 多主多从 纯粹多库(记得设置primary) 混合配置
spring: spring: spring:
datasource: datasource: datasource:
dynamic: dynamic: dynamic:
datasource: datasource: datasource:
master_1: mysql: master:
master_2: oracle: slave_1:
slave_1: sqlserver: slave_2:
slave_2: postgresql: oracle_1:
slave_3: h2: oracle_2:
使用@DS(“库名”)切换数据源
1.可以用到server的实现类上
2.也可以用在方法上
@Service
public class TestserviceImpl implements Itestservice {
@Autowired(required = false)
private TestDao testDao;
@Override
@DS("db1")
public List<Test> getDo() {
return testDao.getDo();
}
}
3.同时存在就近原则 方法上注解 优先于 类上注解。
后面正常步骤,使用mybatis查数据库了
dao层
@Mapper
public interface TestDao {
List<Test> getDo() ;
}
mapper
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zcl.source.demo.dao.TestDao">
<resultMap id="BaseResultMap" type="com.zcl.source.demo.domain.Test">
<id column="id" jdbcType="INTEGER" property="id"/>
<result column="a" jdbcType="VARCHAR" property="a"/>
<result column="b" jdbcType="VARCHAR" property="b"/>
</resultMap>
<select id="getDo" resultType="com.zcl.source.demo.domain.Test">
select * from test
</select>
</mapper>
b" jdbcType="VARCHAR" property="b"/>
</resultMap>
<select id="getDo" resultType="com.zcl.source.demo.domain.Test">
select * from test
</select>
</mapper>