如何生成序列号

pythonimport uuid

def generate_serial_number():
    # 生成一个UUID并去掉连字符
    unique_id = uuid.uuid4().hex
    # 可以根据需要自定义格式，例如每4位用连字符分隔
    serial_number = '-'.join([unique_id[i:i+4] for i in range(0, len(unique_id), 4)])
    return serial_number

# 示例
print(generate_serial_number())

a1b2-c3d4-e5f6-7890

javaimport java.util.UUID;

public class SerialNumberGenerator {
    public static String generateSerialNumber() {
        String uuid = UUID.randomUUID().toString().replace("-", "");
        // 格式化为每4位用连字符分隔
        StringBuilder sb = new StringBuilder();
        for (int i = 0; i < uuid.length(); i += 4) {
            sb.append(uuid.substring(i, Math.min(i + 4, uuid.length()))).append("-");
        }
        return sb.substring(0, sb.length() - 1); // 去掉最后一个连字符
    }

    public static void main(String[] args) {
        System.out.println(generateSerialNumber());
    }
}

a1b2-c3d4-e5f6-7890

sqlCREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    serial_number VARCHAR(50) UNIQUE,
    product_name VARCHAR(100)
);

sqlINSERT INTO products (serial_number, product_name)
VALUES (CONCAT('PROD-', LPAD(id, 5, '0')), '产品名称');

pythonimport uuid
import time

def generate_custom_serial():
    timestamp = int(time.time())
    random_part = uuid.uuid4().hex[:6]
    serial = f"SN{timestamp}-{random_part}"
    return serial

print(generate_custom_serial())

SN1697052345-abc123

excel="SN" & TEXT(ROW(A1), "0000")

vbaSub GenerateSerialNumbers()
    Dim i As Long
    For i = 1 To 100 '生成100个序列号
        Cells(i, 1).Value = "SN" & Format(i, "0000")
    Next i
End Sub