mybatis plus 批量保存_mybatis_plus+sharding.jdbc+swagger 实现多数据源+单库分表

一.源码保存路径

mybatis_plus + sharding.jdbc + swagger 实现多数据源 + 单库分表

二.项目说明

将resources文件夹下的sharding1.sql 和sharding2.sql分别在2个不同库中执行,并更改相应的数据库配置然后运行。

http://localhost:8888/swagger-ui.html#!

先调用:/v1/loudong/ld/add接口插入

db1中loudong表的数据

db2中loudong_0表的数据

db2中loudong_1表的数据

然后调用/v1/loudong/lds 接口查询

{
  "list1": [
    {
      "id": 0,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 1,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 2,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 3,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    }
  ],
  "list2_count": 4,
  "list1_count": 4,
  "list2": [
    {
      "id": 0,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 1,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 2,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    },
    {
      "id": 3,
      "city": "深圳",
      "region": "宝安",
      "name": "李四",
      "ldNum": "A",
      "unitNum": "2"
    }
  ]