Deleting Rows from the Database

You use the SQL DELETE statement to delete existing rows from a table. You can use the executeUpdate() method defined in the Statement class or the execute() method defined in the PreparedStatement class.

The following example illustrates how to delete customer #5 from the customers table:

 myStatement.executeUpdate("DELETE FROM customers " +  "WHERE customer_id = 5"); 

Once this statement has completed, the row for customer #5 will have been removed from the customers table.