public final class JdbcResultSet
extends org.h2.message.TraceObject
implements java.sql.ResultSet
Column labels are case-insensitive, quotes are not supported. The first column has the column index 1.
Thread safety: the result set is not thread-safe and must not be used by multiple threads concurrently.
Updatable result sets: Result sets are updatable when the result only contains columns from one table, and if it contains all columns of a unique index (primary key or other) of this table. Key columns may not contain NULL (because multiple rows with NULL could exist). In updatable result sets, own changes are visible, but not own inserts and deletes.
Constructor and Description |
---|
JdbcResultSet(JdbcConnection conn,
JdbcStatement stat,
org.h2.command.CommandInterface command,
org.h2.result.ResultInterface result,
int id,
boolean scrollable,
boolean updatable,
boolean triggerUpdatable) |
Modifier and Type | Method and Description |
---|---|
boolean |
absolute(int rowNumber)
Moves the current position to a specific row.
|
void |
afterLast()
Moves the current position to after the last row, that means after the
end.
|
void |
beforeFirst()
Moves the current position to before the first row, that means resets the
result set.
|
void |
cancelRowUpdates()
Cancels updating a row.
|
void |
clearWarnings()
Clears all warnings.
|
void |
close()
Closes the result set.
|
void |
deleteRow()
Deletes the current row.
|
int |
findColumn(java.lang.String columnLabel)
Searches for a specific column in the result set.
|
boolean |
first()
Moves the current position to the first row.
|
java.sql.Array |
getArray(int columnIndex)
Returns the value of the specified column as an Array.
|
java.sql.Array |
getArray(java.lang.String columnLabel)
Returns the value of the specified column as an Array.
|
java.io.InputStream |
getAsciiStream(int columnIndex)
Returns the value of the specified column as an input stream.
|
java.io.InputStream |
getAsciiStream(java.lang.String columnLabel)
Returns the value of the specified column as an input stream.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Returns the value of the specified column as a BigDecimal.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel)
Returns the value of the specified column as a BigDecimal.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel,
int scale)
Deprecated.
|
java.io.InputStream |
getBinaryStream(int columnIndex)
Returns the value of the specified column as an input stream.
|
java.io.InputStream |
getBinaryStream(java.lang.String columnLabel)
Returns the value of the specified column as an input stream.
|
java.sql.Blob |
getBlob(int columnIndex)
Returns the value of the specified column as a Blob.
|
java.sql.Blob |
getBlob(java.lang.String columnLabel)
Returns the value of the specified column as a Blob.
|
boolean |
getBoolean(int columnIndex)
Returns the value of the specified column as a boolean.
|
boolean |
getBoolean(java.lang.String columnLabel)
Returns the value of the specified column as a boolean.
|
byte |
getByte(int columnIndex)
Returns the value of the specified column as a byte.
|
byte |
getByte(java.lang.String columnLabel)
Returns the value of the specified column as a byte.
|
byte[] |
getBytes(int columnIndex)
Returns the value of the specified column as a byte array.
|
byte[] |
getBytes(java.lang.String columnLabel)
Returns the value of the specified column as a byte array.
|
java.io.Reader |
getCharacterStream(int columnIndex)
Returns the value of the specified column as a reader.
|
java.io.Reader |
getCharacterStream(java.lang.String columnLabel)
Returns the value of the specified column as a reader.
|
java.sql.Clob |
getClob(int columnIndex)
Returns the value of the specified column as a Clob.
|
java.sql.Clob |
getClob(java.lang.String columnLabel)
Returns the value of the specified column as a Clob.
|
int |
getConcurrency()
Gets the result set concurrency.
|
java.lang.String |
getCursorName()
[Not supported] Gets the cursor name if it was defined.
|
java.sql.Date |
getDate(int columnIndex)
Returns the value of the specified column as a java.sql.Date.
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
java.sql.Date |
getDate(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Date.
|
java.sql.Date |
getDate(java.lang.String columnLabel,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
double |
getDouble(int columnIndex)
Returns the value of the specified column as a double.
|
double |
getDouble(java.lang.String columnLabel)
Returns the value of the specified column as a double.
|
int |
getFetchDirection()
Gets the fetch direction.
|
int |
getFetchSize()
Gets the number of rows suggested to read in one step.
|
float |
getFloat(int columnIndex)
Returns the value of the specified column as a float.
|
float |
getFloat(java.lang.String columnLabel)
Returns the value of the specified column as a float.
|
int |
getHoldability()
Returns the current result set holdability.
|
int |
getInt(int columnIndex)
Returns the value of the specified column as an int.
|
int |
getInt(java.lang.String columnLabel)
Returns the value of the specified column as an int.
|
org.h2.value.Value |
getInternal(int columnIndex)
INTERNAL
|
long |
getLong(int columnIndex)
Returns the value of the specified column as a long.
|
long |
getLong(java.lang.String columnLabel)
Returns the value of the specified column as a long.
|
java.sql.ResultSetMetaData |
getMetaData()
Gets the meta data of this result set.
|
java.io.Reader |
getNCharacterStream(int columnIndex)
Returns the value of the specified column as a reader.
|
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel)
Returns the value of the specified column as a reader.
|
java.sql.NClob |
getNClob(int columnIndex)
Returns the value of the specified column as a Clob.
|
java.sql.NClob |
getNClob(java.lang.String columnLabel)
Returns the value of the specified column as a Clob.
|
java.lang.String |
getNString(int columnIndex)
Returns the value of the specified column as a String.
|
java.lang.String |
getNString(java.lang.String columnLabel)
Returns the value of the specified column as a String.
|
java.lang.Object |
getObject(int columnIndex)
Returns a column value as a Java object.
|
<T> T |
getObject(int columnIndex,
java.lang.Class<T> type)
Returns a column value as a Java object of the specified type.
|
java.lang.Object |
getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
java.lang.Object |
getObject(java.lang.String columnLabel)
Returns a column value as a Java object.
|
<T> T |
getObject(java.lang.String columnName,
java.lang.Class<T> type)
Returns a column value as a Java object of the specified type.
|
java.lang.Object |
getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
java.sql.Ref |
getRef(int columnIndex)
[Not supported] Gets a column as a reference.
|
java.sql.Ref |
getRef(java.lang.String columnLabel)
[Not supported] Gets a column as a reference.
|
org.h2.result.ResultInterface |
getResult()
INTERNAL
|
int |
getRow()
Gets the current row number.
|
java.sql.RowId |
getRowId(int columnIndex)
[Not supported] Returns the value of the specified column as a row id.
|
java.sql.RowId |
getRowId(java.lang.String columnLabel)
[Not supported] Returns the value of the specified column as a row id.
|
short |
getShort(int columnIndex)
Returns the value of the specified column as a short.
|
short |
getShort(java.lang.String columnLabel)
Returns the value of the specified column as a short.
|
java.sql.SQLXML |
getSQLXML(int columnIndex)
Returns the value of the specified column as a SQLXML.
|
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel)
Returns the value of the specified column as a SQLXML.
|
java.sql.Statement |
getStatement()
Returns the statement that created this object.
|
java.lang.String |
getString(int columnIndex)
Returns the value of the specified column as a String.
|
java.lang.String |
getString(java.lang.String columnLabel)
Returns the value of the specified column as a String.
|
java.sql.Time |
getTime(int columnIndex)
Returns the value of the specified column as a java.sql.Time.
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
java.sql.Time |
getTime(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Time.
|
java.sql.Time |
getTime(java.lang.String columnLabel,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
Returns the value of the specified column as a java.sql.Timestamp.
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel)
Returns the value of the specified column as a java.sql.Timestamp.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel,
java.util.Calendar calendar)
Returns the value of the specified column as a java.sql.Timestamp.
|
int |
getType()
Get the result set type.
|
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated.
since JDBC 2.0, use getCharacterStream
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnLabel)
Deprecated.
since JDBC 2.0, use setCharacterStream
|
org.h2.value.Value[] |
getUpdateRow()
INTERNAL
|
java.net.URL |
getURL(int columnIndex)
[Not supported]
|
java.net.URL |
getURL(java.lang.String columnLabel)
[Not supported]
|
java.sql.SQLWarning |
getWarnings()
Gets the first warning reported by calls on this object.
|
void |
insertRow()
Inserts the current row.
|
boolean |
isAfterLast()
Checks if the current position is after the last row, that means next()
was called and returned false, and there was at least one row.
|
boolean |
isBeforeFirst()
Checks if the current position is before the first row, that means next()
was not called yet, and there is at least one row.
|
boolean |
isClosed()
Returns whether this result set is closed.
|
boolean |
isFirst()
Checks if the current position is row 1, that means next() was called
once and returned true.
|
boolean |
isLast()
Checks if the current position is the last row, that means next() was
called and did not yet returned false, but will in the next call.
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
Checks if unwrap can return an object of this class.
|
boolean |
last()
Moves the current position to the last row.
|
void |
moveToCurrentRow()
Moves the current position to the current row.
|
void |
moveToInsertRow()
Moves the current position to the insert row.
|
boolean |
next()
Moves the cursor to the next row of the result set.
|
boolean |
previous()
Moves the cursor to the last row, or row before first row if the current
position is the first row.
|
void |
refreshRow()
Re-reads the current row from the database.
|
boolean |
relative(int rowCount)
Moves the current position to a specific row relative to the current row.
|
boolean |
rowDeleted()
Detects if the row was deleted (by somebody else or the caller).
|
boolean |
rowInserted()
Detects if the row was inserted.
|
boolean |
rowUpdated()
Detects if the row was updated (by somebody else or the caller).
|
void |
setFetchDirection(int direction)
[Not supported]
Sets (changes) the fetch direction for this result set.
|
void |
setFetchSize(int rows)
Sets the number of rows suggested to read in one step.
|
java.lang.String |
toString()
INTERNAL
|
<T> T |
unwrap(java.lang.Class<T> iface)
Return an object of this class if possible.
|
void |
updateArray(int columnIndex,
java.sql.Array x)
Updates a column in the current or insert row.
|
void |
updateArray(java.lang.String columnLabel,
java.sql.Array x)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
Updates a column in the current or insert row.
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
Updates a column in the current or insert row.
|
void |
updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
Updates a column in the current or insert row.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateBlob(int columnIndex,
java.sql.Blob x)
Updates a column in the current or insert row.
|
void |
updateBlob(int columnIndex,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateBlob(int columnIndex,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
Updates a column in the current or insert row.
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream x)
Updates a column in the current or insert row.
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Updates a column in the current or insert row.
|
void |
updateBoolean(int columnIndex,
boolean x)
Updates a column in the current or insert row.
|
void |
updateBoolean(java.lang.String columnLabel,
boolean x)
Updates a column in the current or insert row.
|
void |
updateByte(int columnIndex,
byte x)
Updates a column in the current or insert row.
|
void |
updateByte(java.lang.String columnLabel,
byte x)
Updates a column in the current or insert row.
|
void |
updateBytes(int columnIndex,
byte[] x)
Updates a column in the current or insert row.
|
void |
updateBytes(java.lang.String columnLabel,
byte[] x)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
int length)
Updates a column in the current or insert row.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateClob(int columnIndex,
java.sql.Clob x)
Updates a column in the current or insert row.
|
void |
updateClob(int columnIndex,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateClob(int columnIndex,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateClob(java.lang.String columnLabel,
java.sql.Clob x)
Updates a column in the current or insert row.
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateDate(int columnIndex,
java.sql.Date x)
Updates a column in the current or insert row.
|
void |
updateDate(java.lang.String columnLabel,
java.sql.Date x)
Updates a column in the current or insert row.
|
void |
updateDouble(int columnIndex,
double x)
Updates a column in the current or insert row.
|
void |
updateDouble(java.lang.String columnLabel,
double x)
Updates a column in the current or insert row.
|
void |
updateFloat(int columnIndex,
float x)
Updates a column in the current or insert row.
|
void |
updateFloat(java.lang.String columnLabel,
float x)
Updates a column in the current or insert row.
|
void |
updateInt(int columnIndex,
int x)
Updates a column in the current or insert row.
|
void |
updateInt(java.lang.String columnLabel,
int x)
Updates a column in the current or insert row.
|
void |
updateLong(int columnIndex,
long x)
Updates a column in the current or insert row.
|
void |
updateLong(java.lang.String columnLabel,
long x)
Updates a column in the current or insert row.
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateNClob(int columnIndex,
java.sql.NClob x)
Updates a column in the current or insert row.
|
void |
updateNClob(int columnIndex,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateNClob(int columnIndex,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob x)
Updates a column in the current or insert row.
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader x)
Updates a column in the current or insert row.
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader x,
long length)
Updates a column in the current or insert row.
|
void |
updateNString(int columnIndex,
java.lang.String x)
Updates a column in the current or insert row.
|
void |
updateNString(java.lang.String columnLabel,
java.lang.String x)
Updates a column in the current or insert row.
|
void |
updateNull(int columnIndex)
Updates a column in the current or insert row.
|
void |
updateNull(java.lang.String columnLabel)
Updates a column in the current or insert row.
|
void |
updateObject(int columnIndex,
java.lang.Object x)
Updates a column in the current or insert row.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
Updates a column in the current or insert row.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
java.sql.SQLType targetSqlType)
Updates a column in the current or insert row.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
java.sql.SQLType targetSqlType,
int scaleOrLength)
Updates a column in the current or insert row.
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x)
Updates a column in the current or insert row.
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scale)
Updates a column in the current or insert row.
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
java.sql.SQLType targetSqlType)
Updates a column in the current or insert row.
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
java.sql.SQLType targetSqlType,
int scaleOrLength)
Updates a column in the current or insert row.
|
void |
updateRef(int columnIndex,
java.sql.Ref x)
[Not supported]
|
void |
updateRef(java.lang.String columnLabel,
java.sql.Ref x)
[Not supported]
|
void |
updateRow()
Updates the current row.
|
void |
updateRowId(int columnIndex,
java.sql.RowId x)
[Not supported] Updates a column in the current or insert row.
|
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
[Not supported] Updates a column in the current or insert row.
|
void |
updateShort(int columnIndex,
short x)
Updates a column in the current or insert row.
|
void |
updateShort(java.lang.String columnLabel,
short x)
Updates a column in the current or insert row.
|
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
Updates a column in the current or insert row.
|
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
Updates a column in the current or insert row.
|
void |
updateString(int columnIndex,
java.lang.String x)
Updates a column in the current or insert row.
|
void |
updateString(java.lang.String columnLabel,
java.lang.String x)
Updates a column in the current or insert row.
|
void |
updateTime(int columnIndex,
java.sql.Time x)
Updates a column in the current or insert row.
|
void |
updateTime(java.lang.String columnLabel,
java.sql.Time x)
Updates a column in the current or insert row.
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
Updates a column in the current or insert row.
|
void |
updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
Updates a column in the current or insert row.
|
boolean |
wasNull()
Returns whether the last column accessed was null.
|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported
public JdbcResultSet(JdbcConnection conn, JdbcStatement stat, org.h2.command.CommandInterface command, org.h2.result.ResultInterface result, int id, boolean scrollable, boolean updatable, boolean triggerUpdatable)
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
public int findColumn(java.lang.String columnLabel) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic void close() throws java.sql.SQLException
close
in interface java.lang.AutoCloseable
close
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.lang.String getString(java.lang.String columnLabel) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic int getInt(int columnIndex) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic int getInt(java.lang.String columnLabel) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.
getDate
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.
getTime
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Date getDate(java.lang.String columnLabel) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalDate.class)
instead.
getDate
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.sql.Time getTime(java.lang.String columnLabel) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalTime.class)
instead.
getTime
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.lang.Object getObject(java.lang.String columnLabel) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic boolean getBoolean(int columnIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic boolean getBoolean(java.lang.String columnLabel) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic byte getByte(int columnIndex) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic byte getByte(java.lang.String columnLabel) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic short getShort(int columnIndex) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic short getShort(java.lang.String columnLabel) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic long getLong(int columnIndex) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic long getLong(java.lang.String columnLabel) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic float getFloat(int columnIndex) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic float getFloat(java.lang.String columnLabel) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic double getDouble(int columnIndex) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic double getDouble(java.lang.String columnLabel) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closed@Deprecated public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel, int scale) throws java.sql.SQLException
getBigDecimal(String)
getBigDecimal
in interface java.sql.ResultSet
columnLabel
- the column labelscale
- the scale of the returned valuejava.sql.SQLException
- if the column is not found or if the result set is
closed@Deprecated public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
getBigDecimal(int)
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- (1,2,...)scale
- the scale of the returned valuejava.sql.SQLException
- if the column is not found or if the result set is
closed@Deprecated public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
@Deprecated public java.io.InputStream getUnicodeStream(java.lang.String columnLabel) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String columnLabel) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Date getDate(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.
getDate
in interface java.sql.ResultSet
columnIndex
- (1,2,...)calendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalDate.class)
instead.
getDate
in interface java.sql.ResultSet
columnLabel
- the column labelcalendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.sql.Time getTime(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.
getTime
in interface java.sql.ResultSet
columnIndex
- (1,2,...)calendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalTime.class)
instead.
getTime
in interface java.sql.ResultSet
columnLabel
- the column labelcalendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- (1,2,...)calendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(int, Class)
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnLabel, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.ResultSet
columnLabel
- the column labelcalendar
- the calendarjava.sql.SQLException
- if the column is not found or if the result set is
closedgetObject(String, Class)
public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Blob getBlob(java.lang.String columnLabel) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic byte[] getBytes(int columnIndex) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic byte[] getBytes(java.lang.String columnLabel) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.InputStream getBinaryStream(java.lang.String columnLabel) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Clob getClob(java.lang.String columnLabel) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.Array getArray(java.lang.String columnLabel) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.InputStream getAsciiStream(java.lang.String columnLabel) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.Reader getCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(java.lang.String columnLabel) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the result set is closed or not updatablepublic void updateNull(java.lang.String columnLabel) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBoolean(java.lang.String columnLabel, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if result set is closed or not updatablepublic void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateByte(java.lang.String columnLabel, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBytes(java.lang.String columnLabel, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateShort(java.lang.String columnLabel, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateInt(java.lang.String columnLabel, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateLong(java.lang.String columnLabel, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateFloat(java.lang.String columnLabel, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateDouble(java.lang.String columnLabel, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnIndex, value)
with LocalDate
parameter instead.
updateDate
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(int, Object)
public void updateDate(java.lang.String columnLabel, java.sql.Date x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnLabel, value)
with LocalDate
parameter instead.
updateDate
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(String, Object)
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnIndex, value)
with LocalTime
parameter instead.
updateTime
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(int, Object)
public void updateTime(java.lang.String columnLabel, java.sql.Time x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnLabel, value)
with LocalTime
parameter instead.
updateTime
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(String, Object)
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnIndex, value)
with
LocalDateTime
parameter instead.
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(int, Object)
public void updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x) throws java.sql.SQLException
Usage of this method is discouraged. Use
updateObject(columnLabel, value)
with
LocalDateTime
parameter instead.
updateTimestamp
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatableupdateObject(String, Object)
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closedpublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuescale
- is ignoredjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(java.lang.String columnLabel, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuescale
- is ignoredjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(java.lang.String columnLabel, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuetargetSqlType
- the SQL typejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(int columnIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuetargetSqlType
- the SQL typescaleOrLength
- is ignoredjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuetargetSqlType
- the SQL typejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateObject(java.lang.String columnLabel, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuetargetSqlType
- the SQL typescaleOrLength
- is ignoredjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(java.lang.String columnLabel, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBlob(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBlob(java.lang.String columnLabel, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBlob(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateBlob(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(java.lang.String columnLabel, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateClob(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateArray(java.lang.String columnLabel, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
public int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
rows
- the number of rowsjava.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
direction
- the new fetch directionjava.sql.SQLException
- Unsupported Feature if the method is called for a
forward-only result setpublic int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- if the column is not found or if the result set is
closedpublic boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean isFirst() throws java.sql.SQLException
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic boolean absolute(int rowNumber) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
rowNumber
- the row number. 0 is not allowed, 1 means the first row,
2 the second. -1 means the last row, -2 the row before the
last row. If the value is too large, the position is moved
after the last row, if the value is too small it is moved
before the first row.java.sql.SQLException
- if the result set is closedpublic boolean relative(int rowCount) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
rowCount
- 0 means don't do anything, 1 is the next row, -1 the
previous. If the value is too large, the position is moved
after the last row, if the value is too small it is moved
before the first row.java.sql.SQLException
- if the result set is closedpublic boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closedpublic void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed or is not updatablepublic void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed or is not updatablepublic boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed or if not on the insert
row, or if the result set it not updatablepublic void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed, if the current row is
the insert row or if not on a valid row, or if the result set
it not updatablepublic void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed, if the current row is
the insert row or if not on a valid row, or if the result set
it not updatablepublic void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed or if the current row is
the insert row or if the row has been deleted or if not on a
valid rowpublic void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if the result set is closed or if the current row is
the insert rowpublic org.h2.value.Value getInternal(int columnIndex)
columnIndex
- index of a columnpublic java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
public void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
public int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
- if the connection is closedpublic boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(int columnIndex, java.sql.NClob x) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the lengthjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNClob(java.lang.String columnLabel, java.sql.NClob x) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
columnIndex
- (1,2,...)xmlObject
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
columnLabel
- the column labelxmlObject
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic java.lang.String getNString(int columnIndex) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if the result set is
closedpublic java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labeljava.sql.SQLException
- if the column is not found or if the result set is
closedpublic void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- (1,2,...)x
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuejava.sql.SQLException
- if the result set is closed or not updatablepublic void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the column labelx
- the valuelength
- the number of charactersjava.sql.SQLException
- if the result set is closed or not updatablepublic <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
iface
- the classjava.sql.SQLException
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
iface
- the classjava.sql.SQLException
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnIndex
- the column index (1, 2, ...)type
- the class of the returned valuejava.sql.SQLException
- if the column is not found or if the result set is
closedpublic <T> T getObject(java.lang.String columnName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnName
- the column nametype
- the class of the returned valuejava.sql.SQLException
public java.lang.String toString()
toString
in class java.lang.Object
public org.h2.value.Value[] getUpdateRow()
public org.h2.result.ResultInterface getResult()