Consider adding method to execute update on PreparedStatement and check rows updated

[sleberknight]

The use case is when you have a JDBC PreparedStatement and you expect a specific number of rows to be updated, e.g. one for a SQL INSERT. So, instead of:

var count = ps.executeUpdate();
checkState(count == 1, "Insert count should be one, but is: %s", count);

you could write:

updateAndCheckCount(ps, 1, "Insert count should be one, but is: %s", count);

It's trivial, but over time can save time and errors (e.g. by forgetting to check the number of rows updated).

We could also consider adding a similar method for Statement, but it has four overloaded executeUpdate methods, so is it worth adding a method one, two, all, or none of them?

Note that both PreparedStatement and Statement also now (well, since Java 8) have executeLargeUpdate methods when the number of affected rows could possibly exceed Integer.MAX_VALUE. This would add more methods, but I have never once issued a SQL query of any sort that affected more than 2,147,483,647 rows!