updateXXX() - Updating Column Values for Row Update or Insert

JDBC Tutorials - Herong's Tutorial Examples

∟Derby (Java DB) - ResultSet Objects of Queries

∟updateXXX() - Updating Column Values for Row Update or Insert

This section describes updateXXX() methods used to update column values for the current row for database update or the insert row for inserting a new row.

When a ResultSet object is created with update capability, you can call updateXXX() methods to update column values to prepare for calling updateRow() or insertRow() method store the updated row or a new row to the target table. All updateXXX() methods support two types of parameters to specify a column:

updateXXX(int n, XXX value) - Updates the value of column n. Column 1 is the first column in the ResultSet table.
updateXXX(String name, XXX value) - Updates the value of the column of the specified name.

JDBC supports many updateXXX() methods, one for each Java data type, so that you can set column values directly with the desired Java data types without any conversion. Here is a list of updateXXX() methods:

updateByte() - Updates the value of the specified column as Java byte type.
updateShort() - Updates the value of the specified column as Java short type.
updateInt() - Updates the value of the specified column as Java int type.
updateLong() - Updates the value of the specified column as Java long type.
updateFloat() - Updates the value of the specified column as Java float type.
updateDouble() - Updates the value of the specified column as Java double type.
updateBigDecimal() - Updates the value of the specified column as java.sql.BigDecimal type.
updateBoolean() - Updates the value of the specified column as Java boolean type.
updateString() - Updates the value of the specified column as Java String type.
updateBytes() - Updates the value of the specified column as Java byte[] type.
updateDate() - Updates the value of the specified column as java.sql.Date type.
updateTime() - Updates the value of the specified column as java.sql.Time type.
updateTimestamp() - Updates the value of the specified column as java.sql.Timestamp type.
updateAsciiStream() - Updates the value of the specified column as a stream of ASCII characters.
updateBinaryStream() - Updates the value of the specified column as a stream of bytes.
updateClob() - Updates the value of the specified column as Java Clob type.
updateBlob() - Updates the value of the specified column as Java Blob type.
updateArray() - Updates the value of the specified column as Java Array type.
updateRef() - Updates the value of the specified column as Java Ref type.
updateCharacterStream() - Updates the value of the specified column as java.io.Reader type.
updateObject() - Updates the value of the specified column as Java Object type.

Here is sample program that uses different updateXXX() methods to set column values with different data types:

/* DerbyUpdateMethods.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class DerbyUpdateMethods {
  public static void main(String [] args) {
    Connection con = null;
    try {
      con = DriverManager.getConnection("jdbc:derby://localhost/TestDB");

// Create a Statement for scrollable ResultSet
      Statement sta = con.createStatement(
        ResultSet.TYPE_FORWARD_ONLY,
        ResultSet.CONCUR_UPDATABLE);

// Catch the ResultSet object
      ResultSet res = sta.executeQuery(
        "SELECT * FROM Profile WHERE 1=2");

// Check ResultSet's updatability
      if (res.getConcurrency() == ResultSet.CONCUR_READ_ONLY) {
        System.out.println("ResultSet non-updatable.");
      } else {
        System.out.println("ResultSet updatable.");
      }

// Move the cursor to the insert row
      res.moveToInsertRow();

// Prepare column values in different data types
      String firstName = "Alex";
      String lastName = "King";
      double points = 654.321;
      Date birthDate = Date.valueOf("1966-06-06");
      Timestamp now = new Timestamp(System.currentTimeMillis());

// Set the new first name and last name
      res.updateString("FirstName", firstName);
      res.updateString("LastName", lastName);
      res.updateDouble("Point", points);
      res.updateDate("BirthDate", birthDate);
      res.updateTimestamp("ModTime", now);

// Store the insert into database
      res.insertRow();

// Move the cursor back to the current row
      res.moveToCurrentRow();

      System.out.println("Row inserted ok.");

// Close ResultSet and Statement
      res.close();
      sta.close();

      con.close();
    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
      e.printStackTrace();
    }
  }
}

Note that the Date class used in this program is from the java.sql.* package, not from the java.util.* package. There is no problem with the execution: