mysql 怎么获取当前插入的id

INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2');
SELECT LAST_INSERT_ID();

INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2') RETURNING id;

String sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?)";
try (PreparedStatement pstmt = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
    pstmt.setString(1, "value1");
    pstmt.setString(2, "value2");
    pstmt.executeUpdate();

    try (ResultSet generatedKeys = pstmt.getGeneratedKeys()) {
        if (generatedKeys.next()) {
            long id = generatedKeys.getLong(1);
            System.out.println("Inserted record ID: " + id);
        }
    }
} catch (SQLException e) {
    e.printStackTrace();
}