【Spring Data教程】2.SpringBoot整合dynamic-datasource配置多数据源

前言

上篇讲到了使用Spring Jdbc 自定义配置多数据源，简单的业务场景可以处理，复制的情况不方便处理，如：配置主从、读写、多主多从情况。dynamic-datasource就是解决这个问题的，当然解决多数据源的问题绰绰有余了。

Dynamic-datasource复杂的条件配置

详细参考：https://www.kancloud.cn/tracy5546/dynamic-datasource/2264611

环境搭建

pom.xml依赖

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.4.2</version>
</parent>

<dependencies>
    <!-- jdbc -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <!-- mysql -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <!-- spring boot 单元测试依赖 -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
    </dependency>
</dependencies>

yml配置

spring:
  datasource:
    dynamic:
      primary: data1 #设置默认的数据源或者数据源组
      strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
      datasource:
        data1:
          url: jdbc:mysql://192.168.126.156:3306/test
          username: root
          password: 123456
          driver-class-name: com.mysql.jdbc.Driver # 3.2.0开始支持SPI可省略此配置
        data2:
          url: jdbc:mysql://192.168.126.157:3306/test
          username: root
          password: 123456
          driver-class-name: com.mysql.jdbc.Driver

测试类

import com.baomidou.dynamic.datasource.annotation.DS;
import com.terry.App;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

@SpringBootTest(classes = App.class)
public class TestJdbcTemplate {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    // @DS("data1") 没有则是默认数据源
    public void test1(){
        List<Map<String, Object>> users = jdbcTemplate.queryForList(" SELECT * FROM user ");
        System.out.println("数据库1数据：" + users);
    }

    @DS("data2")
    public void test2(){
        List<Map<String, Object>> roles = jdbcTemplate.queryForList(" SELECT * FROM role ");
        System.out.println("数据库2数据：" + roles);
    }

    @Test
    public void queryTest(){
        test1();
        test2();
    }
}

测试成功，打印日志如下：

2022-05-28 15:01:38.274  INFO 5928 --- [           main] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource - add a datasource named [data2] success
2022-05-28 15:01:38.274  INFO 5928 --- [           main] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource - add a datasource named [data1] success
2022-05-28 15:01:38.274  INFO 5928 --- [           main] c.b.d.d.DynamicRoutingDataSource         : dynamic-datasource initial loaded [2] datasource,primary datasource named [data1]
2022-05-28 15:01:38.429  INFO 5928 --- [           main] com.terry.test.TestJdbcTemplate          : Started TestJdbcTemplate in 2.789 seconds (JVM running for 3.762)
数据库1数据：[{id=1, name=1}]
数据库2数据：[{user_id=1}]