To change data (perform an INSERT, UPDATE, or DELETE) you use the
executeUpdate() method. This method is similar to the method executeQuery()
used to issue a SELECT statement, but it doesn't return a ResultSet; instead
it returns the number of rows affected by the INSERT, UPDATE, or DELETE
statement. Example 5.3, “Deleting Rows in JDBC”
illustrates the usage.
Example 5.3. Deleting Rows in JDBC
This example will issue a simple DELETE statement and print out the number of
rows deleted.
int foovalue = 500;
PreparedStatement st = conn.prepareStatement("DELETE FROM mytable WHERE columnfoo = ?");
st.setInt(1, foovalue);
int rowsDeleted = st.executeUpdate();
System.out.println(rowsDeleted + " rows deleted");
st.close();