Spring Boot 2项目中集成Sharding-JDBC

在Spring Boot 2项目中集成Sharding-JDBC，可以通过以下步骤实现：

1. **添加依赖**：在项目的`pom.xml`文件中添加Sharding-JDBC的依赖。例如，可以添加以下依赖：

```xml
<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>shardingsphere-jdbc-core</artifactId>
    <version>5.3.0</version>
</dependency>
```

2. **配置数据源**：在`application.yml`或`application.properties`文件中配置数据源信息。例如：

```yaml
spring:
  shardingsphere:
    datasource:
      names: g1,g2
      g1:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/sharding_1?characterEncoding=utf-8&useUnicode=true&useSSL=false&serverTimezone=UTC
        username: root
        password: root
      g2:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/sharding_2?characterEncoding=utf-8&useUnicode=true&useSSL=false&serverTimezone=UTC
        username: root
        password: root
    sharding:
      tables:
        goods:
          actual-data-nodes: g$->{1..2}.goods
          key-generator:
            column: gid
            type: SNOWFLAKE
          database-strategy:
            inline:
              sharding-column: user_id
              algorithm-expression: g$->{user_id % 2 + 1}
      props:
        sql:
          show: true
```

3. **创建实体类和Mapper接口**：创建实体类和Mapper接口，例如：

```java
package com.ws.shardingjdbcdemo.pojo;

import lombok.Data;

@Data
public class Goods {
    private Long gid;
    private String gname;
    private Long userId;
    private String gstatus;
}
```

```java
package com.example.reactboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ws.shardingjdbcdemo.pojo.Goods;
import org.springframework.stereotype.Repository;

@Repository
public interface GoodsMapper extends BaseMapper<Goods> {
}
```

4. **编写测试代码**：编写测试代码来验证分库分表功能，例如：

```java
package com.example.reactboot;

import com.example.reactboot.mapper.GoodsMapper;
import com.ws.shardingjdbcdemo.pojo.Goods;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class ShardingjdbcdemoApplicationTests {

    @Autowired
    GoodsMapper goodsMapper;

    @Test
    void addGoods02() {
        for (int i = 0; i < 10; i++){
            Goods good = new Goods();
            good.setGname("小米手机" + (i+1));
            good.setUserId((i+1)+100L);
            good.setGstatus("已发布");
            goodsMapper.insert(good);
        }
    }
}
```

通过以上步骤，你可以在Spring Boot 2项目中集成Sharding-JDBC，并实现分库分表功能。