文章目录
1 Sharding-JDBC简介
是轻量级的java框架,是增强版的JDBC驱动,
2 Sharding-JDBC
Sharding-JDBC 不是做分库分表
主要目的是简化对分库分表之后相关数据操作
主要做两个功能 数据分片和读写分离
3 Sharding-JDBC实现水平分表
3.1 搭建环境
3.1.1 总体概览
SpringBoot + MybaitsPlus + Sharding-JDBC + Druid 连接池
3.1.2 创建SpringBoot工程
pom.xml 如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.1.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.ccb</groupId>
<artifactId>shardingsphere</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>shardingsphere</name>
<description>Sharding sphere project for Spring Boot</description>
<properties>
<java.version>1.8.251</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test