Transaction transaction = connection.beginTransaction().get();
PreparedStatement statement = connection.prepareStatement("UPDATE table SET column = ? WHERE id = ?");
statement.setString(1, "value");
statement.setInt(2, 1);
UpdateResult result = statement.execute().get();
transaction.commit().get();
transaction.rollback().get();
PreparedStatement statement = connection.prepareStatement("INSERT INTO table (column1, column2) VALUES (?, ?)");
statement.setString(1, "value1");
statement.setString(2, "value2");
UpdateResult result = statement.execute().get();
PreparedStatement statement = connection.prepareStatement("UPDATE table SET column = ? WHERE id = ?");
statement.setString(1, "new value");
statement.setInt(2, 1);
UpdateResult result = statement.execute().get();
PreparedStatement statement = connection.prepareStatement("DELETE FROM table WHERE id = ?");
statement.setInt(1, 1);
UpdateResult result = statement.execute().get();
