如何在java中获取更新的行Id

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // SQL语句
        String sql = "UPDATE mytable SET column1 = ? WHERE id = ?";

        try {
            // 建立数据库连接
            Connection connection = DriverManager.getConnection(url, username, password);

            // 创建PreparedStatement对象
            PreparedStatement statement = connection.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);

            // 设置参数
            statement.setString(1, "new value");
            statement.setInt(2, 1);

            // 执行更新操作
            int rowsAffected = statement.executeUpdate();

            // 获取更新的行ID
            ResultSet generatedKeys = statement.getGeneratedKeys();
            if (generatedKeys.next()) {
                int updatedRowId = generatedKeys.getInt(1);
                System.out.println("Updated row ID: " + updatedRowId);
            }

            // 关闭资源
            generatedKeys.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}