java数据库mysql分表

CREATE TABLE user (
    id INT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(100),
    password VARCHAR(100),
    address VARCHAR(200),
    phone VARCHAR(20)
);

public String getTableName(int id) {
    int hash = id % 4; // 假设分成4个子表
    return "user_" + hash;
}

public User getUserById(int id) {
    String tableName = getTableName(id);
    String sql = "SELECT * FROM " + tableName + " WHERE id = ?";
    // 执行查询并返回结果
}

CREATE TABLE user_basic (
    id INT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(100),
    password VARCHAR(100)
);

CREATE TABLE user_contact (
    id INT PRIMARY KEY,
    address VARCHAR(200),
    phone VARCHAR(20)
);

public User getUserById(int id) {
    UserBasic userBasic = getUserBasicById(id);
    UserContact userContact = getUserContactById(id);
    User user = new User();
    user.setId(id);
    user.setUsername(userBasic.getUsername());
    user.setEmail(userBasic.getEmail());
    user.setPassword(userBasic.getPassword());
    user.setAddress(userContact.getAddress());
    user.setPhone(userContact.getPhone());
    return user;
}

private UserBasic getUserBasicById(int id) {
    String sql = "SELECT * FROM user_basic WHERE id = ?";
    // 执行查询并返回结果
}

private UserContact getUserContactById(int id) {
    String sql = "SELECT * FROM user_contact WHERE id = ?";
    // 执行查询并返回结果
}