This section describes how to delete existing data rows with DELETE statements.
DELETE statements are used less frequently in database applications. They are used only when you want to
remove data rows from a table permanently. DELETE statements should include a WHERE clause to identify the data rows
to be deleted.
UPDATE statements should be executed with the executeUpdate() method.
The Java tutorial program below shows you how to update
/**
* DerbyDeleteRows.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class DerbyDeleteRows {
public static void main(String [] args) {
Connection con = null;
try {
con = DriverManager.getConnection(
"jdbc:derby://localhost/TestDB");
Statement sta = con.createStatement();
// deleting multiple rows
int count = sta.executeUpdate(
"DELETE FROM Profile WHERE ID in (1, 3, 5, 7)");
System.out.println("Number of rows deleted: "+count);
// getting the data back
ResultSet res = sta.executeQuery("SELECT * FROM Profile");
System.out.println("List of Profiles: ");
while (res.next()) {
System.out.println(
" "+res.getInt("ID")
+ ", "+res.getString("FirstName")
+ ", "+res.getString("LastName")
+ ", "+res.getFloat("Point")
+ ", "+res.getDate("BirthDate")
+ ", "+res.getTimestamp("ModTime"));
}
res.close();
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
