springboot整合mybatis+sharding-jdbc实现单库分表存储

最近公司项目要对数据库表做分表功能，今天弄了一天，总算把demo运行起来，存取都没问题了，在这里做下记录，希望能给有需要的小伙伴一点点帮助吧！

 

项目架构：springboot2.3 + mybatis + sharding jdbc +mysql

sharding jdbc :用来实现数据库分库、分表 ，推介去官网看看https://shardingsphere.apache.org/index_zh.html

其它就不做介绍了很基础的东西

1.先来张项目架构图

2. maven的pom文件依赖

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
    </dependency>
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>

    <!--热部署自启动工具-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <scope>runtime</scope>
        <optional>true</optional>
    </dependency>

    <!--mysql数据库驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <!--数据库连接池-->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.22</version>
    </dependency>
    <!--mybatis依赖-->
    <depend