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

Statement.executeUpdate() or execute() followed by getUpdateCount() will return the number of rows matched, not updated, according to the JDBC spec. If you want the updated count, you can specify useAffectedRows=true as a non-standard URL option. More information is available here.