SpringBoot+Mybatis-Plus整合Sharding-JDBC实现分库分表

云朵上打盹儿~

于 2024-04-17 11:42:52 发布

阅读量874

点赞数 7

文章标签： spring boot mybatis java

本文链接：https://blog.csdn.net/qq_70009637/article/details/137865489

版权

搭建项目

首先创建一个springboot单体工程

准备工作

先建一个数据库,创建三张表把表名改成对应的

CREATE TABLE `user` (
  `cid` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `data` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`cid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

pom依赖

 <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.5</version>
        <relativePath/>
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.sp