Search code examples
javamysqlsqlprepared-statementrowcount

Return number of rows affected by SQL UPDATE statement in Java

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?

Solution

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