-- 分表1（t_order_0）配置
ALTER TABLE t_order_0 AUTO_INCREMENT = 1; -- 起始值1，步長(zhǎng)10

-- 分表2（t_order_1）配置
ALTER TABLE t_order_1 AUTO_INCREMENT = 11; -- 起始值11，步長(zhǎng)10

-- 分表3（t_order_2）配置
ALTER TABLE t_order_2 AUTO_INCREMENT = 21; -- 起始值21，步長(zhǎng)10

// 根據(jù)訂單ID計(jì)算分表索引
int getTableIndex(Long orderId) {
    return (int)(orderId % 10); // 假設(shè)分10個(gè)表
}

// 插入訂單
void insertOrder(Order order) {
    int tableIndex = getTableIndex(order.getId());
    String tableName = "t_order_" + tableIndex;
    
    // 動(dòng)態(tài)拼接SQL
    String sql = "INSERT INTO " + tableName + "(id, order_no) VALUES (?, ?)";
    jdbcTemplate.update(sql, order.getId(), order.getOrderNo());
}

-- 創(chuàng)建訂單表（主鍵字段為UUID）
CREATE TABLE t_order (
    id CHAR(36) PRIMARY KEY, -- UUID長(zhǎng)度36位
    order_no VARCHAR(50)
);

import java.util.UUID;

public class Order {
    private String id = UUID.randomUUID().toString(); // 生成UUID
    private String orderNo;

    // Getter & Setter
}

// 壓縮UUID為16字節(jié)
public byte[] compressUuid(String uuid) {
    return UUID.fromString(uuid).toString().getBytes(StandardCharsets.UTF_8);
}

public class SnowflakeIdGenerator {
    private final long twepoch = 1288834974657L; // 起始時(shí)間戳（2010-11-04）
    private final long workerIdBits = 5L; // 機(jī)器ID位數(shù)
    private final long datacenterIdBits = 5L; // 數(shù)據(jù)中心ID位數(shù)
    private final long sequenceBits = 12L; // 序列號(hào)位數(shù)
    
    private final long maxWorkerId = ~(-1L << workerIdBits);
    private final long maxDatacenterId = ~(-1L << datacenterIdBits);
    private final long sequenceMask = ~(-1L << sequenceBits);
    
    private long workerId;
    private long datacenterId;
    private long sequence = 0L;
    private long lastTimestamp = -1L;

    public SnowflakeIdGenerator(long workerId, long datacenterId) {
        if (workerId > maxWorkerId || workerId < 0) {
            throw new IllegalArgumentException(String.format("worker Id can't be greater than %d or less than 0", maxWorkerId));
        }
        if (datacenterId > maxDatacenterId || datacenterId < 0) {
            throw new IllegalArgumentException(String.format("datacenter Id can't be greater than %d or less than 0", maxDatacenterId));
        }
        this.workerId = workerId;
        this.datacenterId = datacenterId;
    }

    public synchronized long nextId() {
        long timestamp = timeGen();
        
        if (timestamp < lastTimestamp) {
            throw new RuntimeException(String.format("時(shí)鐘回?fù)? %d ms", lastTimestamp - timestamp));
        }

        if (lastTimestamp == timestamp) {
            sequence = (sequence + 1) & sequenceMask;
            if (sequence == 0) {
                timestamp = tilNextMillis(lastTimestamp);
            }
        } else {
            sequence = 0;
        }

        lastTimestamp = timestamp;
        return (timestamp - twepoch) << (workerIdBits + datacenterIdBits + sequenceBits)
                | (datacenterId << (workerIdBits + sequenceBits))
                | (workerId << sequenceBits)
                | sequence;
    }

    protected long tilNextMillis(long lastTimestamp) {
        long timestamp = timeGen();
        while (timestamp <= lastTimestamp) {
            timestamp = timeGen();
        }
        return timestamp;
    }

    protected long timeGen() {
        return System.currentTimeMillis();
    }
}

SnowflakeIdGenerator idGenerator = new SnowflakeIdGenerator(1, 1);
long orderId = idGenerator.nextId();
System.out.println("生成的ID: " + orderId);

# 啟動(dòng)Redis
redis-server

# 設(shè)置初始值
SET order_id 1000

import redis.clients.jedis.Jedis;

public class RedisIdGenerator {
    private Jedis jedis = new Jedis("localhost");

    public long generateId() {
        return jedis.incr("order_id"); // 原子自增
    }
}

// Redis Cluster客戶端配置
JedisCluster jedisCluster = new JedisCluster(new HostAndPort("192.168.1.101", 6379),
                                             new HostAndPort("192.168.1.102", 6379));

// 1. 添加Maven依賴
<dependency>
    <groupId>com.didi</groupId>
    <artifactId>tinyid-client</artifactId>
    <version>1.0.0</version>
</dependency>

// 2. 配置TinyID
TinyIdClient client = new TinyIdClient("http://tinyid-service.com");

// 3. 生成ID
String businessType = "order";
Long id = client.getId(businessType);

CREATE TABLE tinyid (
    id BIGINT PRIMARY KEY,
    business_type VARCHAR(50),
    max_id BIGINT,
    step INT,
    version INT
);

import java.time.Instant;
import java.util.Random;

public class CombIdGenerator {
    private final Random random = new Random();

    public String generateId() {
        byte[] uuid = new byte[16];
        
        // 前6字節(jié)為時(shí)間戳
        long timestamp = Instant.now().toEpochMilli();
        for (int i = 0; i < 6; i++) {
            uuid[i] = (byte)(timestamp >> (8 * (5 - i)));
        }
        
        // 后10字節(jié)為隨機(jī)數(shù)
        random.nextBytes(uuid);
        
        return bytesToHex(uuid);
    }

    private String bytesToHex(byte[] bytes) {
        StringBuilder sb = new StringBuilder();
        for (byte b : bytes) {
            sb.append(String.format("%02x", b));
        }
        return sb.toString();
    }
}

// 1. 配置ShardingSphere
spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
spring.shardingsphere.sharding.tables.t_order.key-generator.props.worker.id=123

public class CustomKeyGenerator implements KeyGenerator {
    @Override
    public Comparable<?> generateKey() {
        return new SnowflakeIdGenerator(1, 1).nextId();
    }
}

public class ShardIdGenerator {
    private static final int SHARD_COUNT = 8; // 8個(gè)分表
    private static final int GEN_BITS = 3; // 3位基因（2^3=8）

    public long generateShardId(long baseId, int shardIndex) {
        // 基因掩碼：0b00000111
        long mask = (1 << GEN_BITS) - 1;
        
        // 清除低3位基因
        long idWithoutGene = baseId & ~mask;
        
        // 設(shè)置新的基因
        return idWithoutGene | (shardIndex & mask);
    }
}

long shardId = 1234567890123456789L;
int shardIndex = (int)(shardId & ((1 << 3) - 1)); // 提取低3位
String tableName = "t_order_" + shardIndex;

MainKeyGenerator/
├── config/
│   └── shard.properties       # 分片配置
├── service/
│   ├── RedisIdService.java    # Redis生成器
│   ├── SnowflakeService.java  # Snowflake實(shí)現(xiàn)
│   └── TinyIdService.java     # TinyID客戶端
├── model/
│   └── Order.java             # 訂單模型
└── util/
    └── ShardUtil.java         # 分片工具類