一.源码保存路径
mybatis_plus + sharding.jdbc + swagger 实现多数据源 + 单库分表
二.项目说明
将resources文件夹下的sharding1.sql 和sharding2.sql分别在2个不同库中执行,并更改相应的数据库配置然后运行。
http://localhost:8888/swagger-ui.html#!
先调用:/v1/loudong/ld/add接口插入
然后调用/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"
}
]