|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.ResultSetImpl
com.mysql.jdbc.UpdatableResultSet
public class UpdatableResultSet
A result set that is updatable.
Field Summary | |
---|---|
protected SingleByteCharsetConverter |
charConverter
|
protected PreparedStatement |
inserter
PreparedStatement used to insert data |
protected static byte[] |
STREAM_DATA_MARKER
Marker for 'stream' data when doing INSERT rows |
protected PreparedStatement |
updater
PreparedStatement used to delete data |
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
protected |
UpdatableResultSet(java.lang.String catalog,
Field[] fields,
RowData tuples,
ConnectionImpl conn,
StatementImpl creatorStmt)
Creates a new ResultSet object. |
Method Summary | |
---|---|
boolean |
absolute(int row)
JDBC 2.0 Move to an absolute row number in the result set. |
void |
afterLast()
JDBC 2.0 Moves to the end of the result set, just after the last row. |
void |
beforeFirst()
JDBC 2.0 Moves to the front of the result set, just before the first row. |
void |
cancelRowUpdates()
JDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row. |
protected void |
checkRowPos()
Ensures that the cursor is positioned on a valid row and that the result set is not closed |
protected void |
checkUpdatability()
Is this ResultSet updateable? |
void |
deleteRow()
JDBC 2.0 Delete the current row from the result set and the underlying database. |
boolean |
first()
JDBC 2.0 Moves to the first row in the result set. |
protected void |
generateStatements()
Figure out whether or not this ResultSet is updateable, and if so, generate the PreparedStatements to support updates. |
int |
getConcurrency()
JDBC 2.0 Return the concurrency of this result set. |
void |
insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and the database. |
boolean |
isAfterLast()
JDBC 2.0 Determine if the cursor is after the last row in the result set. |
boolean |
isBeforeFirst()
JDBC 2.0 Determine if the cursor is before the first row in the result set. |
boolean |
isFirst()
JDBC 2.0 Determine if the cursor is on the first row of the result set. |
boolean |
isLast()
JDBC 2.0 Determine if the cursor is on the last row of the result set. |
(package private) boolean |
isUpdatable()
|
boolean |
last()
JDBC 2.0 Moves to the last row in the result set. |
void |
moveToCurrentRow()
JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row. |
void |
moveToInsertRow()
JDBC 2.0 Move to the insert row. |
boolean |
next()
A ResultSet is initially positioned before its first row, the first call to next makes the first row the current row; the second call makes the second row the current row, etc. |
boolean |
prev()
The prev method is not part of JDBC, but because of the architecture of this driver it is possible to move both forward and backward within the result set. |
boolean |
previous()
JDBC 2.0 Moves to the previous row in the result set. |
void |
realClose(boolean calledExplicitly)
Closes this ResultSet, releasing all resources. |
void |
refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in the database. |
boolean |
relative(int rows)
JDBC 2.0 Moves a relative number of rows, either positive or negative. |
boolean |
rowDeleted()
JDBC 2.0 Determine if this row has been deleted. |
boolean |
rowInserted()
JDBC 2.0 Determine if the current row has been inserted. |
boolean |
rowUpdated()
JDBC 2.0 Determine if the current row has been updated. |
protected void |
setResultSetConcurrency(int concurrencyFlag)
Sets the concurrency type of this result set |
protected void |
syncUpdate()
Reset UPDATE prepared statement to value in current row. |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value. |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value. |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value. |
void |
updateBlob(int columnIndex,
java.sql.Blob blob)
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob blob)
|
void |
updateBoolean(int columnIndex,
boolean x)
JDBC 2.0 Update a column with a boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x)
JDBC 2.0 Update a column with a boolean value. |
void |
updateByte(int columnIndex,
byte x)
JDBC 2.0 Update a column with a byte value. |
void |
updateByte(java.lang.String columnName,
byte x)
JDBC 2.0 Update a column with a byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
void |
updateBytes(java.lang.String columnName,
byte[] x)
JDBC 2.0 Update a column with a byte array value. |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
JDBC 2.0 Update a column with a character stream value. |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
JDBC 2.0 Update a column with a character stream value. |
void |
updateClob(int columnIndex,
java.sql.Clob clob)
|
void |
updateDate(int columnIndex,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value. |
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value. |
void |
updateDouble(int columnIndex,
double x)
JDBC 2.0 Update a column with a Double value. |
void |
updateDouble(java.lang.String columnName,
double x)
JDBC 2.0 Update a column with a double value. |
void |
updateFloat(int columnIndex,
float x)
JDBC 2.0 Update a column with a float value. |
void |
updateFloat(java.lang.String columnName,
float x)
JDBC 2.0 Update a column with a float value. |
void |
updateInt(int columnIndex,
int x)
JDBC 2.0 Update a column with an integer value. |
void |
updateInt(java.lang.String columnName,
int x)
JDBC 2.0 Update a column with an integer value. |
void |
updateLong(int columnIndex,
long x)
JDBC 2.0 Update a column with a long value. |
void |
updateLong(java.lang.String columnName,
long x)
JDBC 2.0 Update a column with a long value. |
void |
updateNull(int columnIndex)
JDBC 2.0 Give a nullable column a null value. |
void |
updateNull(java.lang.String columnName)
JDBC 2.0 Update a column with a null value. |
void |
updateObject(int columnIndex,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value. |
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value. |
void |
updateRow()
JDBC 2.0 Update the underlying database with the new contents of the current row. |
void |
updateShort(int columnIndex,
short x)
JDBC 2.0 Update a column with a short value. |
void |
updateShort(java.lang.String columnName,
short x)
JDBC 2.0 Update a column with a short value. |
void |
updateString(int columnIndex,
java.lang.String x)
JDBC 2.0 Update a column with a String value. |
void |
updateString(java.lang.String columnName,
java.lang.String x)
JDBC 2.0 Update a column with a String value. |
void |
updateTime(int columnIndex,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value. |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Methods inherited from interface java.sql.ResultSet |
---|
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
protected static final byte[] STREAM_DATA_MARKER
protected SingleByteCharsetConverter charConverter
protected PreparedStatement inserter
protected PreparedStatement updater
Constructor Detail |
---|
protected UpdatableResultSet(java.lang.String catalog, Field[] fields, RowData tuples, ConnectionImpl conn, StatementImpl creatorStmt) throws java.sql.SQLException
catalog
- the database in use when we were createdfields
- an array of Field objects (basically, the ResultSet MetaData)tuples
- actual row dataconn
- the Connection that created us.creatorStmt
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!Method Detail |
---|
public boolean absolute(int row) throws java.sql.SQLException
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
absolute
in interface java.sql.ResultSet
absolute
in class ResultSetImpl
row
- DOCUMENT ME!
java.sql.SQLException
- if a database-access error occurs, or row is 0, or result
set type is TYPE_FORWARD_ONLY.public void afterLast() throws java.sql.SQLException
Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
afterLast
in interface java.sql.ResultSet
afterLast
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.public void beforeFirst() throws java.sql.SQLException
Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
beforeFirst
in interface java.sql.ResultSet
beforeFirst
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLYpublic void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
cancelRowUpdates
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.protected void checkRowPos() throws java.sql.SQLException
ResultSetImpl
checkRowPos
in class ResultSetImpl
java.sql.SQLException
- if the result set is not in a valid state for traversalprotected void checkUpdatability() throws java.sql.SQLException
java.sql.SQLException
- DOCUMENT ME!public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
deleteRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.
java.sql.SQLException
- if the ResultSet is not updatable or some other error occurspublic boolean first() throws java.sql.SQLException
Moves to the first row in the result set.
first
in interface java.sql.ResultSet
first
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.protected void generateStatements() throws java.sql.SQLException
java.sql.SQLException
- DOCUMENT ME!
NotUpdatable
- DOCUMENT ME!public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
getConcurrency
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurspublic void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
insertRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, if called when not on
the insert row, or if all non-nullable columns in the
insert row have not been given a valuepublic boolean isAfterLast() throws java.sql.SQLException
Determine if the cursor is after the last row in the result set.
isAfterLast
in interface java.sql.ResultSet
isAfterLast
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs.public boolean isBeforeFirst() throws java.sql.SQLException
Determine if the cursor is before the first row in the result set.
isBeforeFirst
in interface java.sql.ResultSet
isBeforeFirst
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs.public boolean isFirst() throws java.sql.SQLException
Determine if the cursor is on the first row of the result set.
isFirst
in interface java.sql.ResultSet
isFirst
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs.public boolean isLast() throws java.sql.SQLException
Determine if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
isLast
in interface java.sql.ResultSet
isLast
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs.boolean isUpdatable()
public boolean last() throws java.sql.SQLException
Moves to the last row in the result set.
last
in interface java.sql.ResultSet
last
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.public void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
moveToCurrentRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or the result set is
not updatable
java.sql.SQLException
- if the ResultSet is not updatable or some other error occurspublic void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
moveToInsertRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or the result set is
not updatable
NotUpdatable
- DOCUMENT ME!public boolean next() throws java.sql.SQLException
If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read
next
in interface java.sql.ResultSet
next
in class ResultSetImpl
java.sql.SQLException
- if a database access error occurspublic boolean prev() throws java.sql.SQLException
If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read
prev
in class ResultSetImpl
java.sql.SQLException
- if a database access error occurspublic boolean previous() throws java.sql.SQLException
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
previous
in interface java.sql.ResultSet
previous
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or result set type is
TYPE_FORWAR_DONLY.public void realClose(boolean calledExplicitly) throws java.sql.SQLException
realClose
in interface ResultSetInternalMethods
realClose
in class ResultSetImpl
calledExplicitly
- was this called from close()?
java.sql.SQLException
- if an error occurs.public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
refreshRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.
NotUpdatable
- DOCUMENT ME!public boolean relative(int rows) throws java.sql.SQLException
Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
relative
in interface java.sql.ResultSet
relative
in class ResultSetImpl
rows
- DOCUMENT ME!
java.sql.SQLException
- if a database-access error occurs, or there is no current
row, or result set type is TYPE_FORWARD_ONLY.public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
rowDeleted
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.deletesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
rowInserted
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.insertsAreDetected(int)
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
rowUpdated
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.updatesAreDetected(int)
protected void setResultSetConcurrency(int concurrencyFlag)
setResultSetConcurrency
in class ResultSetImpl
concurrencyFlag
- the type of concurrency that this ResultSet should support.protected void syncUpdate() throws java.sql.SQLException
java.sql.SQLException
- DOCUMENT ME!public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
updateAsciiStream
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
updateAsciiStream
in class ResultSetImpl
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
updateBigDecimal
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
updateBigDecimal
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
updateBinaryStream
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
updateBinaryStream
in class ResultSetImpl
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateBlob(int columnIndex, java.sql.Blob blob) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
updateBlob
in class ResultSetImpl
java.sql.SQLException
ResultSet.updateBlob(int, Blob)
public void updateBlob(java.lang.String columnName, java.sql.Blob blob) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
updateBlob
in class ResultSetImpl
java.sql.SQLException
ResultSet.updateBlob(String, Blob)
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
updateBoolean
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
updateBoolean
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
updateByte
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
updateByte
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
updateBytes
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
updateBytes
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
updateCharacterStream
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
updateCharacterStream
in class ResultSetImpl
columnName
- the name of the columnreader
- the new column valuelength
- of the stream
java.sql.SQLException
- if a database-access error occurspublic void updateClob(int columnIndex, java.sql.Clob clob) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
updateClob
in class ResultSetImpl
java.sql.SQLException
ResultSet.updateClob(int, Clob)
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
updateDate
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
updateDate
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
updateDouble
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
updateDouble
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
updateFloat
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
updateFloat
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
updateInt
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
updateInt
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
updateLong
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
updateLong
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
updateNull
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if a database-access error occurspublic void updateNull(java.lang.String columnName) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
updateNull
in class ResultSetImpl
columnName
- the name of the column
java.sql.SQLException
- if a database-access error occurspublic void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
updateObject
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
updateObject
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuescale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.
java.sql.SQLException
- if a database-access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
updateObject
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
updateObject
in class ResultSetImpl
columnName
- the name of the columnx
- the new column valuescale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.
java.sql.SQLException
- if a database-access error occurspublic void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
updateRow
in class ResultSetImpl
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row
NotUpdatable
- DOCUMENT ME!public void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
updateShort
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
updateShort
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
updateString
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
updateString
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
updateTime
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
updateTime
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
updateTimestamp
in class ResultSetImpl
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurspublic void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
updateTimestamp
in class ResultSetImpl
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database-access error occurs
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |