Return number of rows affected by SQL UPDATE statement in Java

Question

I'm using a MySQL database and accessing it through Java.

PreparedStatement prep1 = this.connection.prepareStatement("UPDATE user_table 
                                                               SET Level = 'Super' 
                                                             WHERE Username = ?");
prep1.setString(1, username);

The update statement above works fine however I'd like to get the number of rows affected with this statement. Is this possible please?

Answer 1

That number is returned when you run the query:

int rows = prep1.executeUpdate(); 
System.out.printf("%d row(s) updated!", rows); 

Answer 2

Calling executeUpdate() on your PreparedStatement should return an int, the number of updated records.

Answer 3

If it is necessary to know how many rows will be affected without executing it, you will have to run a SELECT statement first.