java中mysql怎么分表

public class ShardingUtil {
    private static final int TABLE_COUNT = 4;

    public static String getTableName(long userId) {
        return "user_" + (userId % TABLE_COUNT);
    }
}

long userId = 123456;
String tableName = ShardingUtil.getTableName(userId);
String sql = "SELECT * FROM " + tableName + " WHERE user_id = ?";
// 执行SQL查询

CREATE TABLE user_basic (
    user_id BIGINT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(50)
);

CREATE TABLE user_detail (
    user_id BIGID PRIMARY KEY,
    address VARCHAR(255),
    phone VARCHAR(20)
);

// 插入用户基本信息
String sqlBasic = "INSERT INTO user_basic (user_id, username, email) VALUES (?, ?, ?)";
// 执行SQL插入

// 插入用户详细信息
String sqlDetail = "INSERT INTO user_detail (user_id, address, phone) VALUES (?, ?, ?)";
// 执行SQL插入