Sharding JDBC如何分库分表？看完你就会了

Sharding JDBC的操作分为配置使用、读写分离、分库分表以及应用等，今天我们主要来了解一下关于分库分表的操作，如果你对此感兴趣的话，那我们就开始吧。

 

环境准备

pom.xml

<parent>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-parent</artifactId>

    <version>2.1.3.RELEASE</version></parent>

<properties>

    <java.version>1.8</java.version>

    <sharding.version>3.1.0</sharding.version></properties>

<dependencies>

    <dependency>

        <groupId>io.shardingsphere</groupId>

        <artifactId>sharding-jdbc-core</artifactId>

        <version>${sharding.version}</version>

    </dependency>

 

    <dependency>

        <groupId>io.shardingsphere</groupId>

        <artifactId>sharding-jdbc-spring-boot-starter</artifactId>

        <version>${sharding.version}</version>

    </dependency>

 

    <dependency>

        <groupId>com.alibaba</groupId>

        <artifactId>druid</artifactId>

        <version>1.1.10</version>

    </dependency>

 

    <dependency>

        <groupId>org.mybatis</groupId>

        <artifactId>mybatis</artif