# springboot-sharding-demo1

**Repository Path**: sunli1103_admin/springboot-sharding-demo1

## Basic Information

- **Project Name**: springboot-sharding-demo1
- **Description**: springboot sharding 时间分片demo
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 5
- **Created**: 2020-06-16
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### sharding-jdbc分库分表开发包

```maven
<dependency>
    <groupId>io.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>3.1.0</version>
</dependency>
```


### 按月分表规则

```java
public class USerTablePreciseShardingAlgorithm implements PreciseShardingAlgorithm<Date>{
    @Override
    public String doSharding(Collection<String> availableTargetNames, PreciseShardingValue<Date> preciseShardingValue) {
        StringBuffer tableName = new StringBuffer();
        tableName.append(preciseShardingValue.getLogicTableName())
                .append("_").append(DateUtil.date2Str(preciseShardingValue.getValue(), DateUtil.YEAR_MONTH_NUMBER));
        return tableName.toString();
    }
}
```


### 测试按月分表规则

![输入图片说明](https://images.gitee.com/uploads/images/2020/0616/231805_491e7356_1712191.png "屏幕截图.png")


### properties文件中添加配置项

```properties
sharding.jdbc.data-source.names=test0

sharding.jdbc.data-source.test0.type=com.zaxxer.hikari.HikariDataSource
sharding.jdbc.data-source.test0.driver-class-name=com.mysql.cj.jdbc.Driver
sharding.jdbc.data-source.test0.jdbc-url=jdbc:mysql://localhost:3306/test0?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
sharding.jdbc.data-source.test0.username=root
sharding.jdbc.data-source.test0.password=111111

# 水平拆分的数据库（表） 配置分库 + 分表策略 行表达式分片策略
# 分库策略
sharding.jdbc.config.sharding.default-data-source-name=test0

sharding.jdbc.config.sharding.tables.t_user.table-strategy.standard.sharding-column=create_time
sharding.jdbc.config.sharding.tables.t_user.table-strategy.standard.precise-algorithm-class-name=com.example.sharding.demo.config.USerTablePreciseShardingAlgorithm

# 打印执行的数据库以及语句 默认值: false，注意：仅配置读写分离时不会打印日志！！！
sharding.jdbc.data-source.props.sql.show=true
sharding.jdbc.config.props.sql.show=true
```


测试结果

![输入图片说明](https://images.gitee.com/uploads/images/2020/0616/231830_a6958051_1712191.png "屏幕截图.png")