springboot3.0+shardingsphere5.2 最简单的分库分表

Mnysljj

于 2024-05-25 19:15:43 发布

阅读量1k

点赞数 5

文章标签： java spring boot

本文链接：https://blog.csdn.net/qq_43957369/article/details/139202047

版权

#先看表结构
两个数据库test1,test2 每个库有4张sys_user表分别命名sys_user_0-4

#maven依赖

 <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
            <version>5.2.1</version>
        </dependency>
        
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.5</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
            <scope>runtime</scope>