Java Reference
In-Depth Information
second argument. The updateable
ResultSet
object does not
have
to be scrollable,
but, when making changes to a
ResultSet
, we often want to move freely around the
ResultSet
rows, so it seems sensible to make the
ResultSet
scrollable.
Example
Statement statement = connection.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
As usual, there are three types of change that we can carry out on the data in a
database:
updates (of some/all fi elds of a selected row);
insertions (of new data rows);
deletions (of existing database rows).
We shall take each of these in turn, starting with updates…
At the heart of updating via Java methods, there is a set of
updateXXX
methods
(analogous to the
getXXX
methods that we use to retrieve the data from a row
within a
ResultSet
), each of these methods corresponding to one of the data types
that may be held in the database. For example, there are methods
updateString
and
updateInt
to update
String
and
int
data respectively. Each of these methods
takes two arguments:
a string specifying the name of the fi eld to be updated;
a value of the appropriate type that is to be assigned to the fi eld.
There are three steps involved in the process of updating:
position the
ResultSet
cursor at the required row;
call the appropriate
updateXXX
method(s);
call method
updateRow
.
It is this last method that commits the update(s) to the database and must be
called before moving the cursor off the row (or the updates will be discarded).
Example
results.absolute(2);//Move to row 2 of
ResultSet
.
results.updateFloat("balance", 42.55f);
results.updateRow();
(Note here that an 'f' must be appended to the
fl oat
literal, in order to prevent
the compiler from interpreting the value as a
double
.)
For an insertion, the new row is initially stored within a special buffer called the
''insertion row' and there are three steps involved in the process:
call method
moveToInsertRow
;
call the appropriate
updateXXX
method for each fi eld in the row;
call method
insertRow
.
Search WWH ::
Custom Search