Section 15.6. Updates, Inserts, Deletes

15.6. Updates, Inserts, Deletes

Not every action on a database returns a ResultSet. Operations that create the tables in a database, or those that modify, insert, or delete rows of data don't return rows of values. For those sorts of SQL statements, we don't call executeQuery()we call executeUpdate() instead. It returns an int giving the number of rows affected by the execution. In the case of a CREATE TABLE operation, it simply returns 0.