数据库多数据源配置与实现

数据库多数据源配置与实现

前言

配置以指定数据源选择

一、依赖引用

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>

二、配置文件

这里以yml为例

spring:
  datasource:
    dynamic:
      # 默认数据源:master
      primary: master
      # 数据源配置
      datasource:
      # 数据源：master
        master:
          driverClassName: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://alibaba.mysql.rds.aliyuncs.com:3306/ewtp_aidc?autoReconnect=true&rewriteBatchedStatements=true&socketTimeout=1&connectTimeout=1
          username: account
          password: passcode
      # 数据源：slave（从库数据源）
        slave:
          driverClassName: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://antgroup.mysql.rds.aliyuncs.com:3306/dataphin_metaportal?autoReconnect=true&rewriteBatchedStatements=true&socketTimeout=1&connectTimeout=1
          username: zhanghu
          password: mima

三、代码实现

@Service
public class AnonymityServiceImpl implements AnonymityService {
    @Resource
    private SomeConverter someConverter;
    @Resource
    private SomeMapper SomeMapper;


    @Override
    @DS("master")
    public Page<Model01> method01(Model01 reqModel) {
        return null;
    }

    @Override
    @DS("slave")
    public Model02  method02(method02reqModel) {
		return null;
    }
}