shardingSphere的精确分片和复杂分片的应用。
订单表实际表DDL如下:
CREATE TABLE `t_order_06` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
`regdate` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
Maven依赖
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.0.0-RC1</version>
</dependency>
自定义单一字段精确分区算法
public class MyPreciseShardingAlgorithm implements PreciseShardingAlgorithm<java.util.Date> {
@Override
public String doSharding(Collection<String> collection, PreciseShardingValue<Date> preci