shardingsphere+mybatis-plus-mysql 按月分表

水深无声 2024-04-01 08:56 40阅读 0赞

### shardingsphere5.1.1+mybatis-plus3.5.1+mysql 按月分表 ###

> 需求：实现单表的按月分表，添加的时候，没有该月的表，可以自动创建分表

### 实现效果： ###

![在这里插入图片描述][f67c95d66c6d4a809c70c52053d84c00.png]

### POM依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.5</version>
            </dependency>
            
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.5.1</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.21</version>
            </dependency>
            <dependency>
                <groupId>org.apache.shardingsphere</groupId>
                <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
                <version>5.1.1</version>
            </dependency>

### 源码地址 ###

[https://gitee.com/liulisuiyue\_admin/parent-plteform/tree/master/shardingsphere][https_gitee.com_liulisuiyue_admin_parent-plteform_tree_master_shardingsphere]

[f67c95d66c6d4a809c70c52053d84c00.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/2847aef2c88a4023a2078c761391b3cb.png
[https_gitee.com_liulisuiyue_admin_parent-plteform_tree_master_shardingsphere]: https://gitee.com/liulisuiyue_admin/parent-plteform/tree/master/shardingsphere