spring之当你在一个模块需要用到两个数据库

nacos配置

spring:
  datasource:
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      datasource:
        # 主库数据源
        master:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://ip:3306/数据库名?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
          username: username
          password: password
        #从库数据源
        secondname: #给从库起一个短名
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://ip:3306/数据库名?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
          username: username
          password: password

spring在代码mapper或者Service层添加注解

以mapper为例(使用从库时添加DS注解，使用主库无需添加)

import com.baomidou.dynamic.datasource.annotation.DS;
@DS("secondname") //nacos里的从库名
public interface tableMapper extends BaseMapper<tablePo> {}