# Jpa-sharding-jdbc

**Repository Path**: pp6688/jpa-sharding-jdbc

## Basic Information

- **Project Name**: Jpa-sharding-jdbc
- **Description**: jpa-sharding-jdbc
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2021-08-30
- **Last Updated**: 2022-10-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Jpa-sharding-jdbc

Sharding-jdbc

## 准备工作

* 6个mysql数据库
  * master1 => slave1,slave2
  * master2 => slave3,slave4
* 一个表
  * c_order

### DDL

* master1
* slave1
* slave2
* master2
* slave3
* slave4

```sql
CREATE TABLE `c_order` (
	`id` BIGINT ( 20 ) not null auto_increment,
	`is_del` bit ( 1 ) not null default 0 comment '是否被删除', 
	`user_id` int(11) not null comment '用户id',
	`company_id` int(11) not null comment '公司id',
	`publish_user_id` int(11) not null comment '公司id',
	`position_id` int(11) not null comment '职位id',
	`resume_type` int(2) not null default 0 comment '简历类型：0附件 1在线',
	`status` VARCHAR ( 256 ) NOT NULL COMMENT '投递状态 投递状态 WAIT-待处理 AUTO_FILTER-⾃动过滤 PREPARE_CONTACT-待沟通 REFUSE-拒绝 ARRANGE_INTERVIEW-通知⾯试',
	`create_time` datetime NOT NULL COMMENT '创建时间',
	`update_time` datetime NOT NULL COMMENT '处理时间',
	PRIMARY KEY ( `id` ),
	KEY `index_userId_positionId` ( `user_id`, `position_id` ),
KEY `idx_userId_operateTime` ( `user_id`, `update_time` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4;
```

### 引入sharding-jdbc

### 导入核心pom

#### parent

```xml
<properties>
  <maven.compiler.source>8</maven.compiler.source>
  <maven.compiler.target>8</maven.compiler.target>
  <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  <shardingsphere.version>4.1.0</shardingsphere.version>
  <springboot.version>2.2.5.RELEASE</springboot.version>
</properties>

<dependencyManagement>
  <dependencies>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
      <version>${springboot.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jpa</artifactId>
      <version>${springboot.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <version>${springboot.version}</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.48</version>
    </dependency>
    <dependency>
      <groupId>org.apache.shardingsphere</groupId>
      <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
      <version>${shardingsphere.version}</version>
    </dependency>
  </dependencies>
</dependencyManagement>

<build>
  <plugins>
    <plugin>
      <groupId>org.apache.maven.plugins</groupId>
      <artifactId>maven-compiler-plugin</artifactId>
      <configuration>
        <source>8</source>
        <target>8</target>
        <testSource>8</testSource>
        <testTarget>8</testTarget>
      </configuration>
      <version>3.8.1</version>
    </plugin>
  </plugins>
</build>
```

#### module

```xml
<dependencies>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
  </dependency>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
  </dependency>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
  </dependency>
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
  </dependency>

  <!-- XA模式 -->
  <dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-transaction-xa-core</artifactId>
    <version>4.0.0-RC2</version>
  </dependency>
  <dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
  </dependency>
</dependencies>
```

## 实现步骤

* 准备6个库
* 执行TestMasterSlave.testAdd
* 执行TestMasterSlave.testSearch
  * 执行前，手动模拟master => slave数据，本地没有搭建主从环境（简化，不是本次关注的重点）