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();