springboot 整合sharding-jdbc以及mybatis实现分库分表（附源码）

1.自定义数据库配置连接

基于yml文件配置

spring:
  datasource:
    master01:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://192.168.186.128:3306/test_db01?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
      username: master
      password: 123456@cP
    master02:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://192.168.186.128:3306/test_db02?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
      username: master
      password: 123456@cP
    slave01:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://192.168.186.128:3307/test_db01?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
      username: root
      password: 123456@cP
    slave02:
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://192.168.186.128:3307/test_db02?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
      username: root
      password: 123456@cP

2.Sharding配置

分库策略

 // 配置单库分表策略
 shardingRuleConfig.getTableRuleConfigs