<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
    <version>5.5.0</version> <!-- 建議使用最新穩(wěn)定版 -->
</dependency>
<!-- 還需要添加數(shù)據(jù)庫(kù)驅(qū)動(dòng)和JPA/MyBatis等依賴 -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

spring:
  shardingsphere:
    # 開(kāi)啟 SQL 日志，便于調(diào)試
    props:
      sql-show: true
    # 1. 定義真實(shí)數(shù)據(jù)源
    datasource:
      names: ds0, ds1
      # 第一個(gè)數(shù)據(jù)源
      ds0:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/ds0?useSSL=false
        username: root
        password: your_password
      # 第二個(gè)數(shù)據(jù)源
      ds1:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3307/ds1?useSSL=false # 注意端口或地址不同
        username: root
        password: your_password

    # 2. 定義規(guī)則
    rules:
      # 分片規(guī)則
      sharding:
        tables:
          # 配置 t_order 表的規(guī)則
          t_order:
            # 數(shù)據(jù)節(jié)點(diǎn)：邏輯表 t_order 映射到 ds0 和 ds1 的 t_order_0 和 t_order_1 表
            actual-data-nodes: ds$->{0..1}.t_order_$->{0..1}
            # 分庫(kù)策略
            database-strategy:
              standard:
                sharding-column: user_id # 分庫(kù)鍵
                sharding-algorithm-name: database_inline # 分庫(kù)算法名稱
            # 分表策略
            table-strategy:
              standard:
                sharding-column: order_id # 分表鍵
                sharding-algorithm-name: table_inline # 分表算法名稱
        # 3. 定義分片算法
        sharding-algorithms:
          # 數(shù)據(jù)庫(kù)分片算法：基于 user_id 取模
          database_inline:
            type: INLINE
            props:
              algorithm-expression: ds$->{user_id % 2}
          # 表分片算法：基于 order_id 取模
          table_inline:
            type: INLINE
            props:
              algorithm-expression: t_order_$->{order_id % 2}

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "t_order") // 使用邏輯表名
public class Order {
    @Id
    private Long orderId;
    private Long userId;
    private String description;

    // Getters and Setters
}

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface OrderRepository extends JpaRepository<Order, Long> {
}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class OrderService {

    @Autowired
    private OrderRepository orderRepository;

    public void createOrders() {
        for (int i = 0; i < 10; i++) {
            Order order = new Order();
            order.setOrderId((long) i);
            order.setUserId((long) (i % 4)); // 模擬不同的用戶
            order.setDescription("Order for user " + order.getUserId());
            orderRepository.save(order);
        }
    }
}