Mybatis-plus配置多数据源

最新推荐文章于 2024-08-07 18:30:28 发布

skr养成记

最新推荐文章于 2024-08-07 18:30:28 发布

阅读量307

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qq_41335337/article/details/117655478

版权

Mybatis-Plus Spring Boot 动态数据源多数据源 @DS注解

关键词由CSDN通过智能技术生成

java 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

Mybatis-plus配置双数据源

引入依赖

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

添加配置

spring:
  datasource:
#    platform: mysql
#    url: jdbc:mysql://192.168.233.128:3306/hyspring?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
#    username: root
#    password: root
#    driver-class-name: com.mysql.cj.jdbc.Driver
#    initialization-mode: never
    dynamic:
      primary: admin
      strict: false
      datasource:
        admin:
          platform: mysql
          url: jdbc:mysql://192.168.233.128:3306/hyspring?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
          username: root
          password: root
          driver-class-name: com.mysql.cj.jdbc.Driver
          initialization-mode: never
        news:
          platform: mysql
          url: jdbc:mysql://192.168.233.128:3306/hynews?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
          username: root
          password: root
          driver-class-name: com.mysql.cj.jdbc.Driver
          initialization-mode: never

在对应的mapper上添加@DS注解,括号里边对应yml文件的名称，如果不加@DS注解，默认使用主数据源

package com.hyspring.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hyspring.entity.News;

@DS("news")
public interface NewsMapper extends BaseMapper<News> {
}