介绍
基于shardingsphere-jdbc进行单库分表
1. maven项目依赖
<dependencies>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.1.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
</dependencies>
2.application.yml配置
spring:
application:
name: jdbc-myabtis-db
profiles:
include: jdbc
mybatis:
mapper-locations: classpath*:/mappers/*-mapper.xml
type-aliases-package: com.lance.sharding.db.domain
configuration:
default-fetch-size: 20
default-statement-timeout: 30
map-underscore-to-camel-case: true
us