∟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) 2007 by Dr. Herong Yang. 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:
