1. Java JDBC
2. JDBC Overview
3. JDBC Driver Types
4. JDBC Connection
5. JDBC: Query the Database
6. JDBC: Update the Database
7. JDBC Statement
8. JDBC ResultSet
9. JDBC PreparedStatement
10. JDBC Batch Updates
11. JDBC: Transactions
12. JDBC: CallableStatement
13. JDBC: DatabaseMetaData

• Updating Records
• Deleting Records

In order to update the database you need to use a Statement. But, instead of calling the executeQuery() method, you call the executeUpdate() method.

There are two types of updates you can perform on a database:

1. Update record values
2. Delete records

The executeUpdate() method is used for both of these types of updates.

Updating Records

Here is an update record value example:

Statement statement = connection.createStatement();

String    sql       = "update people set name='John' where id=123";

int rowsAffected    = statement.executeUpdate(sql);

The rowsAffected returned by the statement.executeUpdate(sql) call, tells how many records in the database were affected by the SQL statement.

Deleting Records

Here is a delete record example:

Statement statement = connection.createStatement();

String    sql       = "delete from people where id=123";

int rowsAffected    = statement.executeUpdate(sql);

Again, the rowsAffected returned by the statement.executeUpdate(sql) call, tells how many records in the database were affected by the SQL statement.