springboot+jpa+sharding-jdbc分表

最新推荐文章于 2025-05-21 01:07:43 发布

原创

最新推荐文章于 2025-05-21 01:07:43 发布 · 3.7k 阅读

3 ·

CC 4.0 BY-SA版权

本文介绍了如何使用SpringBoot结合Sharding-JDBC进行分库分表操作，包括引入依赖、建立数据表、实现分表算法以及配置类的详细步骤。通过示例展示了分表算法的equal、in和between操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 引入依赖：

<dependency>
<groupId>com.dangdang</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>1.5.4</version>
</dependency>

2. 建立数据表：tabe_0,table_1,table_2...

3. 实现分表算法

import java.util.Collection;
import java.util.LinkedHashSet;

import com.dangdang.ddframe.rdb.sharding.api.ShardingValue;
import com.dangdang.ddframe.rdb.sharding.api.strategy.table.SingleKeyTableShardingAlgorithm;
import com.google.common.collect.Range;

public final class JdbcSharingConfig implements SingleKeyTableShardingAlgorithm<Long> {

   /**
* doEqualSharding =
* @param tableNames 实际物理表名
* @param shardingValue [logicTableName="t_order", columnName="order_id", value=20]
*
* select * from t_order from t_order where order_id = 11
* └── SELECT * FROM t_order_1 WHERE order_id = 11
* select * from t_order from t_order where order_id = 44
* └── SELECT * FROM t_order_0 WHERE order_id = 44
*
* select * from t_order from t_order where order_id = 11
* └── SELECT * FROM t_order_1 WHERE order_id = 11
* select * from t_order from t_order where order_id = 44
* └── SELECT * FROM t_order_0 WHERE order_id = 44
*/
public String doEqualSharding(final Collection<String> tableNames, final ShardingValue<Long> shardingValue) {

   int index = (int)(shardingValue.getValue() % 450);
   String indexStr = "";
   if(index >= 300)
&n