To change data (perform an insert, update, or delete)
you use the
executeUpdate() is similar to the
executeQuery() used to issue a select,
however it doesn't return a
instead it returns the number of records affected by the insert,
update, or delete statement.
Example 5-2. Simple Delete Example
This example will issue a simple delete and print out the number of rows deleted.
int foovalue = 500; PreparedStatement st = db.prepareStatement("DELETE FROM mytable where columnfoo = ?"); st.setInt(1, foovalue); int rowsDeleted = st.executeUpdate(); System.out.println(rowsDeleted + " rows deleted"); st.close();