1. 概念

1. 水平分库是把同一个表的数据按一定规则拆到不同的数据库中
2. 每个库可以放在不同的服务器上

2. 数据准备

1. 在mysql-server01服务器上创建数据库 course_db0
2. 在mysql-server02服务器上创建数据库 course_db1

注意：
数据先找到database，然后找到自己的table

在这两个库中，分别创建表t_course_0，t_course_1

3. 实体类

@TableName("t_course")
@Data
@ToString
public class Course {
    private Long cid;
    private Long userId;
    private Long corderNo;
    private String cname;
    private String brief;
    private double price;
    private int status;
}

@Mapper
public interface CourseMapper extends BaseMapper<Course> {
}

4 配置文件

注意：
这是自定义的实现方式，不是官网推荐的方式

# 应用名称
spring.application.name=sharding-jdbc
# 打印SQl
spring.shardingsphere.props.sql-show=true

# 定义多个数据源
spring.shardingsphere.datasource.names = db0,db1

#数据源1
spring.shardingsphere.datasource.db0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.db0.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.db0.jdbc-url=jdbc:mysql://127.0.0.1:3306/course_db0?useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.shardingsphere.datasource.db0.username=root
spring.shardingsphere.datasource.db0.password=root

#数据源2
spring.shardingsphere.datasource.db1.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.db1.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.db1.jdbc-url=jdbc:mysql://127.0.0.1:3306/course_db1?useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.shardingsphere.datasource.db1.username=root
spring.shardingsphere.datasource.db1.password=root

#1.配置数据节点 指定t_course逻辑表表的真实分布情况
#1.1先找库，再找表
spring.shardingsphere.rules.sharding.tables.t_course.actual-data-nodes=db$->{0..1}.t_course_$->{0..1}

#2.=========分库策略
#2.1 分片键名称
spring.shardingsphere.rules.sharding.tables.t_course.database-strategy.standard.sharding-column=user_id

#2.2 分片算法
#----分片算法名称
spring.shardingsphere.rules.sharding.tables.t_course.database-strategy.standard.sharding-algorithm-name=table-inline
#----分片算法类型  --> 行表达式分片算法
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.type=INLINE
#---分片算法的属性配置 db0 ,db1
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.props.algorithm-expression=db$->{user_id % 2}


#2.3 分布式序列配置
#---- 分布式序列的列名
spring.shardingsphere.rules.sharding.tables.t_course.key-generate-strategy.column=cid
#--- 分布式序列-算法名称
spring.shardingsphere.rules.sharding.tables.t_course.key-generate-strategy.key-generator-name=alg-snowflake
#--- 分布式序列-算法类型
spring.shardingsphere.rules.sharding.key-generators.alg-snowflake.type=SNOWFLAKE


#================水平分库对应的分表策略
#分片键名称
spring.shardingsphere.rules.sharding.tables.t_course.table-strategy.standard.sharding-column=cid
#2.2 分片算法
#----分片算法名称【自定义名称】
spring.shardingsphere.rules.sharding.tables.t_course.table-strategy.standard.sharding-algorithm-name=inline-hash-mod
#----分片算法类型  --> 先获取cid的hash值，再取模
spring.shardingsphere.rules.sharding.sharding-algorithms.inline-hash-mod.type=INLINE
#---分片算法的属性配置 ---> hash值排除负数
spring.shardingsphere.rules.sharding.sharding-algorithms.inline-hash-mod.props.algorithm-expression=t_course_$->{Math.abs(cid.hashCode()) % 2}

5 测试

@SpringBootTest
public class ShardingsphereJdbcTableApplicationTests {

    @Autowired
    private CourseMapper courseMapper;

    @Test
    public void testInsertCourseTable(){

        for (int i = 100; i < 250; i++) {
            Course course = new Course();
            course.setUserId(1L+i);
            course.setCname("测试水平分库分表" + i);
            course.setCorderNo(1000L+i);
            course.setBrief("测试水平分库分表" + i);
            course.setPrice(100.00);
            course.setStatus(1);

            courseMapper.insert(course);
        }
    }
}

6 测试结果

7 查询所有结果

@Test
    public void testSelectAll(){

        List<Course> courses = courseMapper.selectList(null);
        for (Course cours : courses) {
            System.out.println(cours);
        }
    }

8 条件查询，根据用户id查询

	@Test
    public void testSelectByUserId(){

        QueryWrapper<Course> courseQueryWrapper = new QueryWrapper<>();
        courseQueryWrapper.eq("user_id",106L);
        List<Course> courses = courseMapper.selectList(courseQueryWrapper);
        for (Course cours : courses) {
            System.out.println(cours);
        }
    }

"C:\Program Files\Java\jdk1.8.0_152\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:53565,suspend=y,server=n -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:C:\Users\92340\AppData\Local\JetBrains\IntelliJIdea2021.2\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath "D:\Program Files\JetBrains\IntelliJ IDEA 2021.2.1\lib\idea_rt.jar;D:\mvnrepository\org\junit\platform\junit-platform-launcher\1.6.3\junit-platform-launcher-1.6.3.jar;D:\mvnrepository\org\junit\vintage\junit-vintage-engine\5.6.3\junit-vintage-engine-5.6.3.jar;D:\Program Files\JetBrains\IntelliJ IDEA 2021.2.1\plugins\junit\lib\junit5-rt.jar;D:\Program Files\JetBrains\IntelliJ IDEA 2021.2.1\plugins\junit\lib\junit-rt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\rt.jar;D:\msb\shardingsphere-jdbc-table\target\test-classes;D:\msb\shardingsphere-jdbc-table\target\classes;D:\mvnrepository\org\springframework\boot\spring-boot-starter-web\2.3.7.RELEASE\spring-boot-starter-web-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter\2.3.7.RELEASE\spring-boot-starter-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot\2.3.7.RELEASE\spring-boot-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter-logging\2.3.7.RELEASE\spring-boot-starter-logging-2.3.7.RELEASE.jar;D:\mvnrepository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\mvnrepository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\mvnrepository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;D:\mvnrepository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;D:\mvnrepository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\mvnrepository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\mvnrepository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter-json\2.3.7.RELEASE\spring-boot-starter-json-2.3.7.RELEASE.jar;D:\mvnrepository\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;D:\mvnrepository\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;D:\mvnrepository\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;D:\mvnrepository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;D:\mvnrepository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;D:\mvnrepository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter-tomcat\2.3.7.RELEASE\spring-boot-starter-tomcat-2.3.7.RELEASE.jar;D:\mvnrepository\org\apache\tomcat\embed\tomcat-embed-core\9.0.41\tomcat-embed-core-9.0.41.jar;D:\mvnrepository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;D:\mvnrepository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.41\tomcat-embed-websocket-9.0.41.jar;D:\mvnrepository\org\springframework\spring-web\5.2.12.RELEASE\spring-web-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-beans\5.2.12.RELEASE\spring-beans-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-webmvc\5.2.12.RELEASE\spring-webmvc-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-aop\5.2.12.RELEASE\spring-aop-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-context\5.2.12.RELEASE\spring-context-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-expression\5.2.12.RELEASE\spring-expression-5.2.12.RELEASE.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-jdbc-core-spring-boot-starter\5.1.1\shardingsphere-jdbc-core-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-spring-boot-starter\5.1.1\shardingsphere-sharding-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-core\5.1.1\shardingsphere-sharding-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-api\5.1.1\shardingsphere-sharding-api-5.1.1.jar;D:\mvnrepository\org\apache\groovy\groovy\4.0.1\groovy-4.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-distsql-handler\5.1.1\shardingsphere-sharding-distsql-handler-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-distsql-statement\5.1.1\shardingsphere-sharding-distsql-statement-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sharding-distsql-parser\5.1.1\shardingsphere-sharding-distsql-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-spi\5.1.1\shardingsphere-sql-parser-spi-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-data-pipeline-core\5.1.1\shardingsphere-data-pipeline-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-data-pipeline-spi\5.1.1\shardingsphere-data-pipeline-spi-5.1.1.jar;D:\mvnrepository\org\apache\commons\commons-lang3\3.10\commons-lang3-3.10.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-cluster-mode-repository-zookeeper-curator\5.1.1\shardingsphere-cluster-mode-repository-zookeeper-curator-5.1.1.jar;D:\mvnrepository\org\apache\curator\curator-framework\5.1.0\curator-framework-5.1.0.jar;D:\mvnrepository\org\apache\curator\curator-client\5.1.0\curator-client-5.1.0.jar;D:\mvnrepository\org\apache\zookeeper\zookeeper\3.6.0\zookeeper-3.6.0.jar;D:\mvnrepository\org\apache\zookeeper\zookeeper-jute\3.6.0\zookeeper-jute-3.6.0.jar;D:\mvnrepository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;D:\mvnrepository\io\netty\netty-transport-native-epoll\4.1.55.Final\netty-transport-native-epoll-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-transport-native-unix-common\4.1.55.Final\netty-transport-native-unix-common-4.1.55.Final.jar;D:\mvnrepository\org\apache\curator\curator-recipes\5.1.0\curator-recipes-5.1.0.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-binder\5.1.1\shardingsphere-infra-binder-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-route\5.1.1\shardingsphere-infra-route-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-rewrite\5.1.1\shardingsphere-infra-rewrite-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-merge\5.1.1\shardingsphere-infra-merge-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-system-datetime\5.1.1\shardingsphere-system-datetime-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-datetime-spi\5.1.1\shardingsphere-infra-datetime-spi-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-mode-core\5.1.1\shardingsphere-mode-core-5.1.1.jar;D:\mvnrepository\me\ahoo\cosid\cosid-core\1.8.6\cosid-core-1.8.6.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-spring-boot-starter\5.1.1\shardingsphere-shadow-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-core\5.1.1\shardingsphere-shadow-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-api\5.1.1\shardingsphere-shadow-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-distsql-handler\5.1.1\shardingsphere-shadow-distsql-handler-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-distsql-statement\5.1.1\shardingsphere-shadow-distsql-statement-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-shadow-distsql-parser\5.1.1\shardingsphere-shadow-distsql-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-spring-boot-starter\5.1.1\shardingsphere-db-discovery-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-core\5.1.1\shardingsphere-db-discovery-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-api\5.1.1\shardingsphere-db-discovery-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-distsql-handler\5.1.1\shardingsphere-db-discovery-distsql-handler-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-distsql-statement\5.1.1\shardingsphere-db-discovery-distsql-statement-5.1.1.jar;D:\mvnrepository\com\google\code\gson\gson\2.8.6\gson-2.8.6.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-distsql-parser\5.1.1\shardingsphere-db-discovery-distsql-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-mysql\5.1.1\shardingsphere-db-discovery-mysql-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-db-discovery-opengauss\5.1.1\shardingsphere-db-discovery-opengauss-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-schedule-core\5.1.1\shardingsphere-schedule-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-lite-core\3.0.1\elasticjob-lite-core-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-api\3.0.1\elasticjob-api-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-infra-common\3.0.1\elasticjob-infra-common-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-registry-center\3.0.1\elasticjob-registry-center-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-simple-executor\3.0.1\elasticjob-simple-executor-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-executor-kernel\3.0.1\elasticjob-executor-kernel-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-general\3.0.1\elasticjob-error-handler-general-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-error-handler-spi\3.0.1\elasticjob-error-handler-spi-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-dataflow-executor\3.0.1\elasticjob-dataflow-executor-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-script-executor\3.0.1\elasticjob-script-executor-3.0.1.jar;D:\mvnrepository\org\apache\commons\commons-exec\1.3\commons-exec-1.3.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-http-executor\3.0.1\elasticjob-http-executor-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-rdb\3.0.1\elasticjob-tracing-rdb-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-tracing-api\3.0.1\elasticjob-tracing-api-3.0.1.jar;D:\mvnrepository\org\quartz-scheduler\quartz\2.3.2\quartz-2.3.2.jar;D:\mvnrepository\com\mchange\mchange-commons-java\0.2.15\mchange-commons-java-0.2.15.jar;D:\mvnrepository\org\apache\shardingsphere\elasticjob\elasticjob-lite-lifecycle\3.0.1\elasticjob-lite-lifecycle-3.0.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-spring-boot-starter\5.1.1\shardingsphere-encrypt-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-core\5.1.1\shardingsphere-encrypt-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-api\5.1.1\shardingsphere-encrypt-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-handler\5.1.1\shardingsphere-encrypt-distsql-handler-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-statement\5.1.1\shardingsphere-encrypt-distsql-statement-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-encrypt-distsql-parser\5.1.1\shardingsphere-encrypt-distsql-parser-5.1.1.jar;D:\mvnrepository\commons-codec\commons-codec\1.14\commons-codec-1.14.jar;D:\mvnrepository\org\bouncycastle\bcprov-jdk15on\1.70\bcprov-jdk15on-1.70.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-spring-boot-starter\5.1.1\shardingsphere-readwrite-splitting-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-core\5.1.1\shardingsphere-readwrite-splitting-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-api\5.1.1\shardingsphere-readwrite-splitting-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-handler\5.1.1\shardingsphere-readwrite-splitting-distsql-handler-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-statement\5.1.1\shardingsphere-readwrite-splitting-distsql-statement-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-readwrite-splitting-distsql-parser\5.1.1\shardingsphere-readwrite-splitting-distsql-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-jdbc-spring-boot-starter-infra\5.1.1\shardingsphere-jdbc-spring-boot-starter-infra-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-jdbc-transaction-spring\5.1.1\shardingsphere-jdbc-transaction-spring-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-transaction-core\5.1.1\shardingsphere-transaction-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-transaction-api\5.1.1\shardingsphere-transaction-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-executor\5.1.1\shardingsphere-infra-executor-5.1.1.jar;D:\mvnrepository\io\vertx\vertx-mysql-client\4.2.3\vertx-mysql-client-4.2.3.jar;D:\mvnrepository\io\vertx\vertx-core\4.2.3\vertx-core-4.2.3.jar;D:\mvnrepository\io\netty\netty-common\4.1.55.Final\netty-common-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-buffer\4.1.55.Final\netty-buffer-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-transport\4.1.55.Final\netty-transport-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-handler\4.1.55.Final\netty-handler-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-codec\4.1.55.Final\netty-codec-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-handler-proxy\4.1.55.Final\netty-handler-proxy-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-codec-socks\4.1.55.Final\netty-codec-socks-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-codec-http\4.1.55.Final\netty-codec-http-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-codec-http2\4.1.55.Final\netty-codec-http2-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-resolver\4.1.55.Final\netty-resolver-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-resolver-dns\4.1.55.Final\netty-resolver-dns-4.1.55.Final.jar;D:\mvnrepository\io\netty\netty-codec-dns\4.1.55.Final\netty-codec-dns-4.1.55.Final.jar;D:\mvnrepository\io\vertx\vertx-sql-client\4.2.3\vertx-sql-client-4.2.3.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-parser-spring-boot-starter\5.1.1\shardingsphere-parser-spring-boot-starter-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-parser-core\5.1.1\shardingsphere-parser-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-parser-api\5.1.1\shardingsphere-parser-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-parser\5.1.1\shardingsphere-infra-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-jdbc-core\5.1.1\shardingsphere-jdbc-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-sql92\5.1.1\shardingsphere-sql-parser-sql92-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-engine\5.1.1\shardingsphere-sql-parser-engine-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-statement\5.1.1\shardingsphere-sql-parser-statement-5.1.1.jar;D:\mvnrepository\org\antlr\antlr4-runtime\4.9.2\antlr4-runtime-4.9.2.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-mysql\5.1.1\shardingsphere-sql-parser-mysql-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-postgresql\5.1.1\shardingsphere-sql-parser-postgresql-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-oracle\5.1.1\shardingsphere-sql-parser-oracle-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-sqlserver\5.1.1\shardingsphere-sql-parser-sqlserver-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-sql-parser-opengauss\5.1.1\shardingsphere-sql-parser-opengauss-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-authority-core\5.1.1\shardingsphere-authority-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-authority-api\5.1.1\shardingsphere-authority-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-single-table-core\5.1.1\shardingsphere-single-table-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-single-table-api\5.1.1\shardingsphere-single-table-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-traffic-core\5.1.1\shardingsphere-traffic-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-common\5.1.1\shardingsphere-infra-common-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-spi\5.1.1\shardingsphere-spi-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-traffic-api\5.1.1\shardingsphere-traffic-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-context\5.1.1\shardingsphere-infra-context-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-distsql-parser\5.1.1\shardingsphere-distsql-parser-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-distsql-statement\5.1.1\shardingsphere-distsql-statement-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-federation-optimizer\5.1.1\shardingsphere-infra-federation-optimizer-5.1.1.jar;D:\mvnrepository\org\apache\calcite\calcite-core\1.27.0\calcite-core-1.27.0.jar;D:\mvnrepository\org\apache\calcite\calcite-linq4j\1.27.0\calcite-linq4j-1.27.0.jar;D:\mvnrepository\com\esri\geometry\esri-geometry-api\2.2.0\esri-geometry-api-2.2.0.jar;D:\mvnrepository\org\apache\calcite\avatica\avatica-core\1.18.0\avatica-core-1.18.0.jar;D:\mvnrepository\org\apache\calcite\avatica\avatica-metrics\1.18.0\avatica-metrics-1.18.0.jar;D:\mvnrepository\com\google\protobuf\protobuf-java\3.6.1\protobuf-java-3.6.1.jar;D:\mvnrepository\org\apache\httpcomponents\httpclient\4.5.13\httpclient-4.5.13.jar;D:\mvnrepository\org\apache\httpcomponents\httpcore\4.4.14\httpcore-4.4.14.jar;D:\mvnrepository\com\fasterxml\jackson\dataformat\jackson-dataformat-yaml\2.11.3\jackson-dataformat-yaml-2.11.3.jar;D:\mvnrepository\com\google\uzaygezen\uzaygezen-core\0.2\uzaygezen-core-0.2.jar;D:\mvnrepository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\mvnrepository\com\yahoo\datasketches\sketches-core\0.9.0\sketches-core-0.9.0.jar;D:\mvnrepository\com\yahoo\datasketches\memory\0.9.0\memory-0.9.0.jar;D:\mvnrepository\net\hydromatic\aggdesigner-algorithm\6.0\aggdesigner-algorithm-6.0.jar;D:\mvnrepository\commons-lang\commons-lang\2.4\commons-lang-2.4.jar;D:\mvnrepository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;D:\mvnrepository\org\apache\commons\commons-dbcp2\2.7.0\commons-dbcp2-2.7.0.jar;D:\mvnrepository\org\apache\commons\commons-pool2\2.8.1\commons-pool2-2.8.1.jar;D:\mvnrepository\commons-io\commons-io\2.4\commons-io-2.4.jar;D:\mvnrepository\org\codehaus\janino\commons-compiler\3.1.2\commons-compiler-3.1.2.jar;D:\mvnrepository\org\codehaus\janino\janino\3.1.2\janino-3.1.2.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-memory-mode-core\5.1.1\shardingsphere-memory-mode-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-standalone-mode-core\5.1.1\shardingsphere-standalone-mode-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-api\5.1.1\shardingsphere-standalone-mode-repository-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-standalone-mode-repository-file\5.1.1\shardingsphere-standalone-mode-repository-file-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-cluster-mode-core\5.1.1\shardingsphere-cluster-mode-core-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-cluster-mode-repository-api\5.1.1\shardingsphere-cluster-mode-repository-api-5.1.1.jar;D:\mvnrepository\org\apache\shardingsphere\shardingsphere-infra-federation-executor\5.1.1\shardingsphere-infra-federation-executor-5.1.1.jar;D:\mvnrepository\org\apache\commons\commons-collections4\4.2\commons-collections4-4.2.jar;D:\mvnrepository\com\google\guava\guava\30.0-jre\guava-30.0-jre.jar;D:\mvnrepository\com\google\guava\failureaccess\1.0.1\failureaccess-1.0.1.jar;D:\mvnrepository\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;D:\mvnrepository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;D:\mvnrepository\org\checkerframework\checker-qual\3.5.0\checker-qual-3.5.0.jar;D:\mvnrepository\com\google\errorprone\error_prone_annotations\2.3.4\error_prone_annotations-2.3.4.jar;D:\mvnrepository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\mvnrepository\org\slf4j\jcl-over-slf4j\1.7.30\jcl-over-slf4j-1.7.30.jar;D:\mvnrepository\javax\xml\bind\jaxb-api\2.3.1\jaxb-api-2.3.1.jar;D:\mvnrepository\com\sun\xml\bind\jaxb-core\2.3.0\jaxb-core-2.3.0.jar;D:\mvnrepository\com\sun\xml\bind\jaxb-impl\2.3.0\jaxb-impl-2.3.0.jar;D:\mvnrepository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\mvnrepository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;D:\mvnrepository\com\baomidou\mybatis-plus-boot-starter\3.3.1\mybatis-plus-boot-starter-3.3.1.jar;D:\mvnrepository\com\baomidou\mybatis-plus\3.3.1\mybatis-plus-3.3.1.jar;D:\mvnrepository\com\baomidou\mybatis-plus-extension\3.3.1\mybatis-plus-extension-3.3.1.jar;D:\mvnrepository\com\baomidou\mybatis-plus-core\3.3.1\mybatis-plus-core-3.3.1.jar;D:\mvnrepository\com\baomidou\mybatis-plus-annotation\3.3.1\mybatis-plus-annotation-3.3.1.jar;D:\mvnrepository\com\github\jsqlparser\jsqlparser\3.1\jsqlparser-3.1.jar;D:\mvnrepository\org\mybatis\mybatis\3.5.3\mybatis-3.5.3.jar;D:\mvnrepository\org\mybatis\mybatis-spring\2.0.3\mybatis-spring-2.0.3.jar;D:\mvnrepository\org\springframework\boot\spring-boot-autoconfigure\2.3.7.RELEASE\spring-boot-autoconfigure-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter-jdbc\2.3.7.RELEASE\spring-boot-starter-jdbc-2.3.7.RELEASE.jar;D:\mvnrepository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\mvnrepository\org\springframework\spring-jdbc\5.2.12.RELEASE\spring-jdbc-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-tx\5.2.12.RELEASE\spring-tx-5.2.12.RELEASE.jar;D:\mvnrepository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;D:\mvnrepository\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar;D:\mvnrepository\org\springframework\boot\spring-boot-starter-test\2.3.7.RELEASE\spring-boot-starter-test-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot-test\2.3.7.RELEASE\spring-boot-test-2.3.7.RELEASE.jar;D:\mvnrepository\org\springframework\boot\spring-boot-test-autoconfigure\2.3.7.RELEASE\spring-boot-test-autoconfigure-2.3.7.RELEASE.jar;D:\mvnrepository\com\jayway\jsonpath\json-path\2.4.0\json-path-2.4.0.jar;D:\mvnrepository\net\minidev\json-smart\2.3\json-smart-2.3.jar;D:\mvnrepository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;D:\mvnrepository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;D:\mvnrepository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;D:\mvnrepository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;D:\mvnrepository\org\assertj\assertj-core\3.16.1\assertj-core-3.16.1.jar;D:\mvnrepository\org\hamcrest\hamcrest\2.2\hamcrest-2.2.jar;D:\mvnrepository\org\junit\jupiter\junit-jupiter\5.6.3\junit-jupiter-5.6.3.jar;D:\mvnrepository\org\junit\jupiter\junit-jupiter-api\5.6.3\junit-jupiter-api-5.6.3.jar;D:\mvnrepository\org\apiguardian\apiguardian-api\1.1.0\apiguardian-api-1.1.0.jar;D:\mvnrepository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;D:\mvnrepository\org\junit\platform\junit-platform-commons\1.6.3\junit-platform-commons-1.6.3.jar;D:\mvnrepository\org\junit\jupiter\junit-jupiter-params\5.6.3\junit-jupiter-params-5.6.3.jar;D:\mvnrepository\org\junit\jupiter\junit-jupiter-engine\5.6.3\junit-jupiter-engine-5.6.3.jar;D:\mvnrepository\org\junit\platform\junit-platform-engine\1.6.3\junit-platform-engine-1.6.3.jar;D:\mvnrepository\org\mockito\mockito-core\3.3.3\mockito-core-3.3.3.jar;D:\mvnrepository\net\bytebuddy\byte-buddy\1.10.18\byte-buddy-1.10.18.jar;D:\mvnrepository\net\bytebuddy\byte-buddy-agent\1.10.18\byte-buddy-agent-1.10.18.jar;D:\mvnrepository\org\objenesis\objenesis\2.6\objenesis-2.6.jar;D:\mvnrepository\org\mockito\mockito-junit-jupiter\3.3.3\mockito-junit-jupiter-3.3.3.jar;D:\mvnrepository\org\skyscreamer\jsonassert\1.5.0\jsonassert-1.5.0.jar;D:\mvnrepository\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\mvnrepository\org\springframework\spring-core\5.2.12.RELEASE\spring-core-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-jcl\5.2.12.RELEASE\spring-jcl-5.2.12.RELEASE.jar;D:\mvnrepository\org\springframework\spring-test\5.2.12.RELEASE\spring-test-5.2.12.RELEASE.jar;D:\mvnrepository\org\xmlunit\xmlunit-core\2.7.0\xmlunit-core-2.7.0.jar;D:\mvnrepository\junit\junit\4.13.1\junit-4.13.1.jar;D:\mvnrepository\org\hamcrest\hamcrest-core\2.2\hamcrest-core-2.2.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit5 com.simon.ShardingsphereJdbcTableApplicationTests,testSelectByUserId
Connected to the target VM, address: '127.0.0.1:53565', transport: 'socket'
10:19:36.826 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate]
10:19:36.878 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)]
10:19:36.993 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [com.simon.ShardingsphereJdbcTableApplicationTests] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper]
10:19:37.046 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [com.simon.ShardingsphereJdbcTableApplicationTests], using SpringBootContextLoader
10:19:37.069 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [com.simon.ShardingsphereJdbcTableApplicationTests]: class path resource [com/simon/ShardingsphereJdbcTableApplicationTests-context.xml] does not exist
10:19:37.070 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [com.simon.ShardingsphereJdbcTableApplicationTests]: class path resource [com/simon/ShardingsphereJdbcTableApplicationTestsContext.groovy] does not exist
10:19:37.071 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [com.simon.ShardingsphereJdbcTableApplicationTests]: no resource found for suffixes {-context.xml, Context.groovy}.
10:19:37.074 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [com.simon.ShardingsphereJdbcTableApplicationTests]: ShardingsphereJdbcTableApplicationTests does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
10:19:37.233 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [com.simon.ShardingsphereJdbcTableApplicationTests]
10:19:37.479 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [D:\msb\shardingsphere-jdbc-table\target\classes\com\simon\ShardingsphereJdbcTableApplication.class]
10:19:37.484 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration com.simon.ShardingsphereJdbcTableApplication for test class com.simon.ShardingsphereJdbcTableApplicationTests
10:19:37.825 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [com.simon.ShardingsphereJdbcTableApplicationTests]: using defaults.
10:19:37.826 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]
10:19:37.875 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@b968a76, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@2f9a01c1, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@2611b9a3, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@54227100, org.springframework.test.context.support.DirtiesContextTestExecutionListener@6b5894c8, org.springframework.test.context.transaction.TransactionalTestExecutionListener@1433046b, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@3f446bef, org.springframework.test.context.event.EventPublishingTestExecutionListener@7829b776, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@5778826f, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@5b64c4b7, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@4763c727, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@72445aba, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@61bcd567, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener@1c80e49b]
10:19:37.886 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@4c51bb7 testClass = ShardingsphereJdbcTableApplicationTests, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@83298d7 testClass = ShardingsphereJdbcTableApplicationTests, locations = '{}', classes = '{class com.simon.ShardingsphereJdbcTableApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@295cf707, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@463fd068, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@12299890, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@44a59da3, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@6b1274d2], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true]], class annotated with @DirtiesContext [false] with mode [null].
10:19:37.976 [main] DEBUG org.springframework.test.context.support.TestPropertySourceUtils - Adding inlined properties to environment: {spring.jmx.enabled=false, org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.3.7.RELEASE)

2025-09-12 10:19:38.892  INFO 12124 --- [           main] .ShardingsphereJdbcTableApplicationTests : Starting ShardingsphereJdbcTableApplicationTests on DESKTOP-55SE7QS with PID 12124 (started by 92340 in D:\msb\shardingsphere-jdbc-table)
2025-09-12 10:19:38.900  INFO 12124 --- [           main] .ShardingsphereJdbcTableApplicationTests : No active profile set, falling back to default profiles: default
2025-09-12 10:19:42.779  INFO 12124 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'stringToNoneShardingStrategyConfigurationConverter' of type [org.apache.shardingsphere.spring.boot.converter.StringToNoneShardingStrategyConfigurationConverter] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-09-12 10:19:42.846  INFO 12124 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.shardingsphere-org.apache.shardingsphere.spring.boot.prop.SpringBootPropertiesConfiguration' of type [org.apache.shardingsphere.spring.boot.prop.SpringBootPropertiesConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-09-12 10:19:44.954  INFO 12124 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration' of type [org.apache.shardingsphere.spring.boot.ShardingSphereAutoConfiguration$$EnhancerBySpringCGLIB$$44ab4593] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-09-12 10:19:46.415  INFO 12124 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2025-09-12 10:19:48.003  INFO 12124 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2025-09-12 10:19:48.727  INFO 12124 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2025-09-12 10:19:48.750  INFO 12124 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
2025-09-12 10:19:48.759  INFO 12124 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Start completed.
 _ _   |_  _ _|_. ___ _ |    _ 
| | |\/|_)(_| | |_\  |_)||_|_\ 
     /               |         
                        3.3.1 
2025-09-12 10:19:56.416  WARN 12124 --- [           main] c.b.m.core.metadata.TableInfoHelper      : Warn: Could not find @TableId in Class: com.simon.entity.Course.
2025-09-12 10:19:56.900  INFO 12124 --- [           main] .ShardingsphereJdbcTableApplicationTests : Started ShardingsphereJdbcTableApplicationTests in 18.899 seconds (JVM running for 22.86)
2025-09-12 10:20:00.799  INFO 12124 --- [           main] ShardingSphere-SQL                       : Logic SQL: SELECT  cid,user_id,corder_no,cname,brief,price,status  FROM t_course 
 
 WHERE (user_id = ?)
2025-09-12 10:20:00.799  INFO 12124 --- [           main] ShardingSphere-SQL                       : SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
2025-09-12 10:20:00.799  INFO 12124 --- [           main] ShardingSphere-SQL                       : Actual SQL: db0 ::: SELECT  cid,user_id,corder_no,cname,brief,price,status  FROM t_course_0 
 
 WHERE (user_id = ?) UNION ALL SELECT  cid,user_id,corder_no,cname,brief,price,status  FROM t_course_1 
 
 WHERE (user_id = ?) ::: [106, 106]
Course(cid=1173200764026224641, userId=106, corderNo=1105, cname=测试水平分库分表105, brief=测试水平分库分表105, price=100.0, status=1)
2025-09-12 10:20:00.995  INFO 12124 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2025-09-12 10:20:01.019  INFO 12124 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
2025-09-12 10:20:01.020  INFO 12124 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown initiated...
2025-09-12 10:20:01.023  INFO 12124 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown completed.
2025-09-12 10:20:01.026  INFO 12124 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
Disconnected from the target VM, address: '127.0.0.1:53565', transport: 'socket'
Process finished with exit code 0