|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.message.TraceObject
org.h2.jdbc.JdbcResultSet
public class JdbcResultSet
Represents a result set.
Column labels are case-insensitive, quotes are not supported. The first column has the column index 1.
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.
| Field Summary |
|---|
| Fields inherited from class org.h2.message.TraceObject |
|---|
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID |
| 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 |
| Method Summary | |
|---|---|
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. use getBigDecimal(int) |
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. use getBigDecimal(String) |
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. |
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.lang.Object |
getObject(int columnIndex)
Returns a column value as a Java object. |
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. |
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. |
int |
getRow()
Gets the current row number. |
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.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. |
java.io.InputStream |
getUnicodeStream(java.lang.String columnLabel)
Deprecated. |
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 |
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 |
void |
updateArray(int columnIndex,
java.sql.Array x)
[Not supported] |
void |
updateArray(java.lang.String columnLabel,
java.sql.Array x)
[Not supported] |
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 |
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(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 |
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 |
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 |
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. |
| Methods inherited from class org.h2.message.TraceObject |
|---|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Method Detail |
|---|
public boolean next()
throws java.sql.SQLException
next in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.ResultSetjava.sql.SQLException
public boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.ResultSetjava.sql.SQLException
public int findColumn(java.lang.String columnLabel)
throws java.sql.SQLException
findColumn in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public void close()
throws java.sql.SQLException
close in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Statement getStatement()
throws java.sql.SQLException
getStatement in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
getWarnings in interface java.sql.ResultSetjava.sql.SQLException
public void clearWarnings()
throws java.sql.SQLException
clearWarnings in interface java.sql.ResultSetjava.sql.SQLException
public java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.lang.String getString(java.lang.String columnLabel)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is closed
public int getInt(int columnIndex)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public int getInt(java.lang.String columnLabel)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is closed
public java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(java.lang.String columnLabel)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Time getTime(java.lang.String columnLabel)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.lang.Object getObject(int columnIndex)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.lang.Object getObject(java.lang.String columnLabel)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public boolean getBoolean(int columnIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public boolean getBoolean(java.lang.String columnLabel)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte getByte(int columnIndex)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte getByte(java.lang.String columnLabel)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public short getShort(int columnIndex)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public short getShort(java.lang.String columnLabel)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public long getLong(int columnIndex)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public long getLong(java.lang.String columnLabel)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public float getFloat(int columnIndex)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public float getFloat(java.lang.String columnLabel)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public double getDouble(int columnIndex)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public double getDouble(java.lang.String columnLabel)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel,
int scale)
throws java.sql.SQLException
getBigDecimal(String)
getBigDecimal in interface java.sql.ResultSetcolumnLabel - the column labelscale - the scale of the returned value
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
getBigDecimal(int)
getBigDecimal in interface java.sql.ResultSetcolumnIndex - (1,2,...)scale - the scale of the returned value
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLException
public java.io.InputStream getUnicodeStream(java.lang.String columnLabel)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.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.ResultSetjava.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.ResultSetjava.sql.SQLException
public java.sql.Ref getRef(int columnIndex)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Ref getRef(java.lang.String columnLabel)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Date getDate(int columnIndex,
java.util.Calendar calendar)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnIndex - (1,2,...)calendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(java.lang.String columnLabel,
java.util.Calendar calendar)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnLabel - the column labelcalendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Time getTime(int columnIndex,
java.util.Calendar calendar)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnIndex - (1,2,...)calendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Time getTime(java.lang.String columnLabel,
java.util.Calendar calendar)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnLabel - the column labelcalendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar calendar)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnIndex - (1,2,...)calendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel,
java.util.Calendar calendar)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnLabel - the column labelcalendar - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Blob getBlob(int columnIndex)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Blob getBlob(java.lang.String columnLabel)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte[] getBytes(int columnIndex)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte[] getBytes(java.lang.String columnLabel)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.InputStream getBinaryStream(java.lang.String columnLabel)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Clob getClob(int columnIndex)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Clob getClob(java.lang.String columnLabel)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Array getArray(int columnIndex)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Array getArray(java.lang.String columnLabel)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.InputStream getAsciiStream(java.lang.String columnLabel)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.io.Reader getCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public java.net.URL getURL(java.lang.String columnLabel)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public void updateNull(int columnIndex)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException - if the result set is closed or not updatable
public void updateNull(java.lang.String columnLabel)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the result set is closed or not updatable
public void updateBoolean(int columnIndex,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBoolean(java.lang.String columnLabel,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if result set is closed or not updatable
public void updateByte(int columnIndex,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateByte(java.lang.String columnLabel,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBytes(int columnIndex,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBytes(java.lang.String columnLabel,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateShort(int columnIndex,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateShort(java.lang.String columnLabel,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateInt(int columnIndex,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateInt(java.lang.String columnLabel,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateLong(int columnIndex,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateLong(java.lang.String columnLabel,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateFloat(int columnIndex,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateFloat(java.lang.String columnLabel,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateDouble(int columnIndex,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateDouble(java.lang.String columnLabel,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateString(int columnIndex,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateString(java.lang.String columnLabel,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateDate(int columnIndex,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateDate(java.lang.String columnLabel,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateTime(int columnIndex,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateTime(java.lang.String columnLabel,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateAsciiStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
columnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed
public void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
columnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x)
throws java.sql.SQLException
columnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
long length)
throws java.sql.SQLException
columnLabel - the column labelx - the valuelength - the number of characters
java.sql.SQLException - if the result set is closed or not updatable
public void updateObject(int columnIndex,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the valuescale - is ignored
java.sql.SQLException - if the result set is closed or not updatable
public void updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnLabel - the column labelx - the valuescale - is ignored
java.sql.SQLException - if the result set is closed or not updatable
public void updateObject(int columnIndex,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateObject(java.lang.String columnLabel,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateRef(int columnIndex,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public void updateRef(java.lang.String columnLabel,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public void updateBlob(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBlob(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the valuelength - the length
java.sql.SQLException - if the result set is closed or not updatable
public void updateBlob(int columnIndex,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBlob(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
columnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateBlob(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
columnLabel - the column labelx - the valuelength - the length
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(int columnIndex,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetcolumnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
columnIndex - (1,2,...)x - the valuelength - the length
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(java.lang.String columnLabel,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetcolumnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(java.lang.String columnLabel,
java.io.Reader x)
throws java.sql.SQLException
columnLabel - the column labelx - the value
java.sql.SQLException - if the result set is closed or not updatable
public void updateClob(java.lang.String columnLabel,
java.io.Reader x,
long length)
throws java.sql.SQLException
columnLabel - the column labelx - the valuelength - the length
java.sql.SQLException - if the result set is closed or not updatable
public void updateArray(int columnIndex,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public void updateArray(java.lang.String columnLabel,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public java.lang.String getCursorName()
throws java.sql.SQLException
getCursorName in interface java.sql.ResultSetjava.sql.SQLException
public int getRow()
throws java.sql.SQLException
getRow in interface java.sql.ResultSetjava.sql.SQLException
public int getConcurrency()
throws java.sql.SQLException
getConcurrency in interface java.sql.ResultSetjava.sql.SQLException
public int getFetchDirection()
throws java.sql.SQLException
getFetchDirection in interface java.sql.ResultSetjava.sql.SQLException
public int getFetchSize()
throws java.sql.SQLException
getFetchSize in interface java.sql.ResultSetjava.sql.SQLException
public void setFetchSize(int rows)
throws java.sql.SQLException
setFetchSize in interface java.sql.ResultSetrows - the number of rows
java.sql.SQLException
public void setFetchDirection(int direction)
throws java.sql.SQLException
setFetchDirection in interface java.sql.ResultSetdirection - the new fetch direction
java.sql.SQLException - Unsupported Feature if the method is called for a
forward-only result set
public int getType()
throws java.sql.SQLException
getType in interface java.sql.ResultSetjava.sql.SQLException - if the column is not found or if the result set is
closed
public boolean isBeforeFirst()
throws java.sql.SQLException
isBeforeFirst in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean isAfterLast()
throws java.sql.SQLException
isAfterLast in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean isFirst()
throws java.sql.SQLException
isFirst in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean isLast()
throws java.sql.SQLException
isLast in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public void beforeFirst()
throws java.sql.SQLException
beforeFirst in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public void afterLast()
throws java.sql.SQLException
afterLast in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean first()
throws java.sql.SQLException
first in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean last()
throws java.sql.SQLException
last in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public boolean absolute(int rowNumber)
throws java.sql.SQLException
absolute in interface java.sql.ResultSetrowNumber - 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 if the value is too small it is moved
before the first row.
java.sql.SQLException - if the result set is closed
public boolean relative(int rowCount)
throws java.sql.SQLException
relative in interface java.sql.ResultSetrowCount - 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 if the value is too small it is moved
before the first row.
java.sql.SQLException - if the result set is closed
public boolean previous()
throws java.sql.SQLException
previous in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed
public void moveToInsertRow()
throws java.sql.SQLException
moveToInsertRow in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed or is not updatable
public void moveToCurrentRow()
throws java.sql.SQLException
moveToCurrentRow in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed or is not updatable
public boolean rowUpdated()
throws java.sql.SQLException
rowUpdated in interface java.sql.ResultSetjava.sql.SQLException
public boolean rowInserted()
throws java.sql.SQLException
rowInserted in interface java.sql.ResultSetjava.sql.SQLException
public boolean rowDeleted()
throws java.sql.SQLException
rowDeleted in interface java.sql.ResultSetjava.sql.SQLException
public void insertRow()
throws java.sql.SQLException
insertRow in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed or if not on the insert
row, or if the result set it not updatable
public void updateRow()
throws java.sql.SQLException
updateRow in interface java.sql.ResultSetjava.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 updatable
public void deleteRow()
throws java.sql.SQLException
deleteRow in interface java.sql.ResultSetjava.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 updatable
public void refreshRow()
throws java.sql.SQLException
refreshRow in interface java.sql.ResultSetjava.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 row
public void cancelRowUpdates()
throws java.sql.SQLException
cancelRowUpdates in interface java.sql.ResultSetjava.sql.SQLException - if the result set is closed or if the current row is
the insert row
public int getHoldability()
throws java.sql.SQLException
java.sql.SQLException - if the connection is closed
public boolean isClosed()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.String toString()
toString in class java.lang.Object
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||