如何使用NativeQuery插入DB2并获取生成的ID

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DB2NativeQueryExample {
    public static void main(String[] args) {
        // DB2数据库连接信息
        String url = "jdbc:db2://localhost:50000/sample";
        String username = "username";
        String password = "password";

        // 创建数据库连接
        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            // 构建插入SQL语句
            String insertSql = "INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2')";

            // 执行插入SQL语句
            try (Statement statement = connection.createStatement()) {
                // 设置返回生成的ID
                statement.executeUpdate(insertSql, Statement.RETURN_GENERATED_KEYS);

                // 获取生成的ID
                try (ResultSet resultSet = statement.getGeneratedKeys()) {
                    if (resultSet.next()) {
                        int generatedId = resultSet.getInt(1);
                        System.out.println("Generated ID: " + generatedId);
                    }
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}