title: Return number of rows affected by SQL UPDATE statement in Java
body: <p>I'm using a MySQL database and accessing it through Java.  </p>
  
  <pre><code>PreparedStatement prep1 = this.connection.prepareStatement(
          "UPDATE user_table 
          SET Level = 'Super' 
          WHERE Username = ?");
  prep1.setString(1, username);
  </code></pre>
  
  <p>The update statement above works fine however I'd like to get the number of rows affected with this statement. Is this possible please?</p>