如何创建插入但随后返回插入数据的事务

import java.sql.*;

public class TransactionExample {
    public static void main(String[] args) {
        Connection connection = null;
        try {
            // 1. 连接数据库
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 2. 开启事务
            connection.setAutoCommit(false);

            // 3. 执行插入操作
            String insertQuery = "INSERT INTO mytable (column1, column2) VALUES (?, ?)";
            PreparedStatement statement = connection.prepareStatement(insertQuery);
            statement.setString(1, "value1");
            statement.setString(2, "value2");
            statement.executeUpdate();

            // 4. 提交事务
            connection.commit();

            // 5. 返回插入数据
            String selectQuery = "SELECT * FROM mytable WHERE column1 = ?";
            PreparedStatement selectStatement = connection.prepareStatement(selectQuery);
            selectStatement.setString(1, "value1");
            ResultSet resultSet = selectStatement.executeQuery();
            if (resultSet.next()) {
                String column1Value = resultSet.getString("column1");
                String column2Value = resultSet.getString("column2");
                System.out.println("Inserted data: column1=" + column1Value + ", column2=" + column2Value);
            }

        } catch (SQLException e) {
            e.printStackTrace();
            if (connection != null) {
                try {
                    // 出现异常时回滚事务
                    connection.rollback();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        } finally {
            if (connection != null) {
                try {
                    // 关闭数据库连接
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}