一小时读懂Sharding JDBC之分库分表

作为轻量级java框架，sharding JDBC在Java的jdbc层提供了额外的服务，可以理解为增强版的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>