Historical version. PostgreSQL 7.3 has reached end of support. See the current manual.
5.4. Performing Updates
To change data (perform an insert, update, or delete)
you use the executeUpdate() method.
executeUpdate() is similar to the
executeQuery() used to issue a select,
however it doesn't return a ResultSet,
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();
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.