|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectcom.ibm.as400.access.AS400JDBCArrayResultSet
public class AS400JDBCArrayResultSet extends Object implements ResultSet
AS400JDBCArrayResultSet is a JDBC ResultSet that contains Array data. This is a client-side only object. This is used to navigating through returned data from IBM i DB2 using Toolbox JDBC. No updates will be functional nor will they be sent back to the host server. Note that this ResultSet is limited in its functionality since it is not tied back to a cursor in the database. Its primary purpose is for retrieving data back from the database.
| Modifier and Type | Field and Description |
|---|
| 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 |
| Modifier and Type | Method and Description |
|---|---|
boolean |
absolute(int row)
Positions the cursor to an absolute row number. |
void |
afterLast()
Positions the cursor after the last row. |
void |
beforeFirst()
Sets cursor position before the first row. |
void |
cancelRowUpdates()
Cancels all pending updates that have been made since the last call to updateRow(). |
void |
clearWarnings()
Clears all warnings that have been reported for the result set. |
void |
close()
Closes this ResultSet |
void |
deleteRow()
Deletes the current row from the result set and the database. |
int |
findColumn(String columnName)
Returns the column index for the specified column name. |
boolean |
first()
Positions the cursor to the first row. |
Array |
getArray(int column)
Returns the value of a column as an Array object. |
Array |
getArray(String columnName)
Returns the value of a column as an Array object. |
InputStream |
getAsciiStream(int column)
Returns the value of a column as a stream of ASCII characters. |
InputStream |
getAsciiStream(String columnName)
Returns the value of a column as a stream of ASCII characters. |
BigDecimal |
getBigDecimal(int column)
Returns the value of a column as a BigDecimal object. |
BigDecimal |
getBigDecimal(int column,
int scale)
Deprecated. Use getBigDecimal(int) instead. |
BigDecimal |
getBigDecimal(String columnName)
Returns the value of a column as a BigDecimal object. |
BigDecimal |
getBigDecimal(String columnName,
int scale)
Deprecated. Use getBigDecimal(int) instead. |
InputStream |
getBinaryStream(int column)
Returns the value of a column as a stream of uninterpreted bytes. |
InputStream |
getBinaryStream(String columnName)
Returns the value of a column as a stream of uninterpreted bytes. |
Blob |
getBlob(int column)
Returns the value of a column as a Blob object. |
Blob |
getBlob(String columnName)
Returns the value of a column as a Blob object. |
boolean |
getBoolean(int column)
Returns the value of a column as a Java boolean value. |
boolean |
getBoolean(String columnName)
Returns the value of a column as a Java boolean value. |
byte |
getByte(int column)
Returns the value of a column as a Java byte value. |
byte |
getByte(String columnName)
Returns the value of a column as a Java byte value. |
byte[] |
getBytes(int column)
Returns the value of a column as a Java byte array. |
byte[] |
getBytes(String columnName)
Returns the value of a column as a Java byte array. |
Reader |
getCharacterStream(int column)
Returns the value of a column as a character stream. |
Reader |
getCharacterStream(String columnName)
Returns the value of a column as a character stream. |
Clob |
getClob(int column)
Returns the value of a column as a Clob object. |
Clob |
getClob(String columnName)
Returns the value of a column as a Clob object. |
int |
getConcurrency()
Returns the result set concurrency. |
String |
getCursorName()
Returns the name of the SQL cursor in use by the result set. |
Date |
getDate(int column)
Returns the value of a column as a java.sql.Date object using the default calendar. |
Date |
getDate(int column,
Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default. |
Date |
getDate(String columnName)
Returns the value of a column as a java.sql.Date object using the default calendar. |
Date |
getDate(String columnName,
Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default. |
double |
getDouble(int column)
Returns the value of a column as a Java double value. |
double |
getDouble(String columnName)
Returns the value of a column as a Java double value. |
int |
getFetchDirection()
Returns the fetch direction. |
int |
getFetchSize()
Returns the fetch size. |
float |
getFloat(int column)
Returns the value of a column as a Java float value. |
float |
getFloat(String columnName)
Returns the value of a column as a Java float value. |
int |
getInt(int column)
Returns the value of a column as a Java int value. |
int |
getInt(String columnName)
Returns the value of a column as a Java int value. |
long |
getLong(int column)
Returns the value of a column as a Java long value. |
long |
getLong(String columnName)
Returns the value of a column as a Java long value. |
ResultSetMetaData |
getMetaData()
Returns the ResultSetMetaData object that describes the result set's columns. |
Object |
getObject(int column)
Returns the value of a column as a Java Object. |
Object |
getObject(int column,
Map map)
Returns the value of a column as a Java Object. |
Object |
getObject(String columnName)
Returns the value of a column as a Java Object. |
Object |
getObject(String columnName,
Map map)
Returns the value of a column as a Java Object. |
Ref |
getRef(int column)
Returns the value of a column as a Ref object. |
Ref |
getRef(String columnName)
Returns the value of a column as a Ref object. |
int |
getRow()
Retrieves the current row number. |
short |
getShort(int column)
Returns the value of a column as a Java short value. |
short |
getShort(String columnName)
Returns the value of a column as a Java short value. |
Statement |
getStatement()
Returns the statement for this result set. |
String |
getString(int column)
Returns the value of a column as a String object. |
String |
getString(String columnName)
Returns the value of a column as a String object. |
Time |
getTime(int column)
Returns the value of a column as a java.sql.Time object using the default calendar. |
Time |
getTime(int column,
Calendar calendar)
Returns the value of a column as a java.sql.Time object using the default calendar. |
Time |
getTime(String columnName)
Returns the value of a column as a java.sql.Time object using the default calendar. |
Time |
getTime(String columnName,
Calendar calendar)
Returns the value of a column as a java.sql.Time object using the default calendar. |
Timestamp |
getTimestamp(int column)
Returns the value of a column as a java.sql.Timestamp object using the default calendar. |
Timestamp |
getTimestamp(int column,
Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. |
Timestamp |
getTimestamp(String columnName)
Returns the value of a column as a java.sql.Timestamp object using the default calendar. |
Timestamp |
getTimestamp(String columnName,
Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. |
int |
getType()
Returns the result set type. |
InputStream |
getUnicodeStream(int column)
Deprecated. Use getCharacterStream(int) instead. |
InputStream |
getUnicodeStream(String columnName)
Deprecated. Use getCharacterStream(String) instead. |
URL |
getURL(int column)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
URL |
getURL(String columnName)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
SQLWarning |
getWarnings()
Returns the first warning reported for the result set. |
void |
insertRow()
Inserts the contents of the insert row into the result set and the database. |
boolean |
isAfterLast()
Indicates if the cursor is positioned after the last row. |
boolean |
isBeforeFirst()
Indicates if the cursor is positioned before the first row. |
boolean |
isFirst()
Indicates if the cursor is positioned on the first row. |
boolean |
isLast()
Indicates if the cursor is positioned on the last row. |
boolean |
last()
Positions the cursor to the last row. |
void |
moveToCurrentRow()
Positions the cursor to the current row. |
void |
moveToInsertRow()
Positions the cursor to the insert row. |
boolean |
next()
Positions the cursor to the next row. |
boolean |
previous()
Positions the cursor to the previous row. |
void |
refreshRow()
Refreshes the current row from the database. |
boolean |
relative(int rows)
Positions the cursor to a relative row number. |
boolean |
rowDeleted()
Indicates if the current row has been deleted. |
boolean |
rowInserted()
Indicates if the current row has been inserted. |
boolean |
rowUpdated()
Indicates if the current row has been updated. |
void |
setFetchDirection(int direction)
Sets the direction in which the rows in a result set are processed. |
void |
setFetchSize(int rows)
Sets the number of rows to be fetched from the database when more rows are needed. |
void |
updateArray(int column,
Array x)
Updates the value of a column as an Array object. |
void |
updateArray(String columnName,
Array x)
Updates the value of a column as an Array object. |
void |
updateAsciiStream(int column,
InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
void |
updateAsciiStream(String columnName,
InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
void |
updateBigDecimal(int column,
BigDecimal x)
Updates a column in the current row using a BigDecimal value. |
void |
updateBigDecimal(String columnName,
BigDecimal x)
Updates a column in the current row using a BigDecimal value. |
void |
updateBinaryStream(int column,
InputStream x,
int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
void |
updateBinaryStream(String columnName,
InputStream x,
int length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
void |
updateBlob(int column,
Blob x)
Updates a column in the current row using a Java Blob value. |
void |
updateBlob(String columnName,
Blob x)
Updates a column in the current row using a Java Blob value. |
void |
updateBoolean(int column,
boolean x)
Updates a column in the current row using a Java boolean value. |
void |
updateBoolean(String columnName,
boolean x)
Updates a column in the current row using a Java boolean value. |
void |
updateByte(int column,
byte x)
Updates a column in the current row using a Java byte value. |
void |
updateByte(String columnName,
byte x)
Updates a column in the current row using a Java byte value. |
void |
updateBytes(int column,
byte[] x)
Updates a column in the current row using a Java byte array value. |
void |
updateBytes(String columnName,
byte[] x)
Updates a column in the current row using a Java byte array value. |
void |
updateCharacterStream(int column,
Reader x,
int length)
Updates a column in the current row using a Reader value. |
void |
updateCharacterStream(String columnName,
Reader x,
int length)
Updates a column in the current row using a Reader value. |
void |
updateClob(int column,
Clob x)
Updates a column in the current row using a Java Clob value. |
void |
updateClob(String columnName,
Clob x)
Updates a column in the current row using a Java Clob value. |
void |
updateDate(int column,
Date x)
Updates a column in the current row using a java.sql.Date value. |
void |
updateDate(String columnName,
Date x)
Updates a column in the current row using a java.sql.Date value. |
void |
updateDouble(int column,
double x)
Updates a column in the current row using a Java double value. |
void |
updateDouble(String columnName,
double x)
Updates a column in the current row using a Java double value. |
void |
updateFloat(int column,
float x)
Updates a column in the current row using a Java float value. |
void |
updateFloat(String columnName,
float x)
Updates a column in the current row using a Java float value. |
void |
updateInt(int column,
int x)
Updates a column in the current row using a Java int value. |
void |
updateInt(String columnName,
int x)
Updates a column in the current row using a Java int value. |
void |
updateLong(int column,
long x)
Updates a column in the current row using a Java long value. |
void |
updateLong(String columnName,
long x)
Updates a column in the current row using a Java long value. |
void |
updateNull(int column)
Updates a column in the current row using SQL NULL. |
void |
updateNull(String columnName)
Updates a column in the current row using SQL NULL. |
void |
updateObject(int column,
Object x)
Updates a column in the current row using an Object value. |
void |
updateObject(int column,
Object x,
int scale)
Updates a column in the current row using an Object value. |
void |
updateObject(String columnName,
Object x)
Updates a column in the current row using an Object value. |
void |
updateObject(String columnName,
Object x,
int scale)
Updates a column in the current row using an Object value. |
void |
updateRef(int column,
Ref x)
Updates the value of an SQL REF output parameter as a Ref value. |
void |
updateRef(String columnName,
Ref x)
Updates the value of an SQL REF output parameter as a Ref value. |
void |
updateRow()
Cancels all pending updates that have been made since the last call to updateRow(). |
void |
updateShort(int column,
short x)
Updates a column in the current row using a Java short value. |
void |
updateShort(String columnName,
short x)
Updates a column in the current row using a Java short value. |
void |
updateString(int column,
String x)
Updates a column in the current row using a String value. |
void |
updateString(String columnName,
String x)
Updates a column in the current row using a String value. |
void |
updateTime(int column,
Time x)
Updates a column in the current row using a java.sql.Time value. |
void |
updateTime(String columnName,
Time x)
Updates a column in the current row using a java.sql.Time value. |
void |
updateTimestamp(int column,
Timestamp x)
Updates a column in the current row using a java.sql.Timestamp value. |
void |
updateTimestamp(String columnName,
Timestamp x)
Updates a column in the current row using a java.sql.Timestamp value. |
boolean |
wasNull()
Indicates if the last column read has the value of SQL NULL. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Methods inherited from interface java.sql.Wrapper |
|---|
isWrapperFor, unwrap |
| Method Detail |
|---|
public void close()
throws SQLException
close in interface ResultSetSQLException - If an error occurs.
public boolean isBeforeFirst()
throws SQLException
isBeforeFirst in interface ResultSetSQLException - If the result set is not open.
public boolean isAfterLast()
throws SQLException
isAfterLast in interface ResultSetSQLException - If the result set is not open.
public boolean isFirst()
throws SQLException
isFirst in interface ResultSetSQLException - If the result set is not open.
public boolean isLast()
throws SQLException
isLast in interface ResultSetSQLException - If the result set is not open.
public void beforeFirst()
throws SQLException
beforeFirst in interface ResultSetSQLException - If the result set is not open.
public void afterLast()
throws SQLException
afterLast in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
or an error occurs.
public boolean first()
throws SQLException
first in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
or an error occurs.
public boolean last()
throws SQLException
last in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
or an error occurs.
public boolean previous()
throws SQLException
previous in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
or an error occurs.
public boolean next()
throws SQLException
next in interface ResultSetSQLException - If the result set is not open,
or an error occurs.
public boolean absolute(int row)
throws SQLException
absolute in interface ResultSetrow - The absolute row number. If the absolute row
number is positive, this positions the cursor
with respect to the beginning of the result set.
If the absolute row number is negative, this
positions the cursor with respect to the end
of result set.SQLException - If the result set is not open,
the result set is not scrollable,
the row number is 0,
or an error occurs.
public boolean relative(int rows)
throws SQLException
Attempting to move beyond the first row positions the cursor before the first row. Attempting to move beyond the last row positions the cursor after the last row.
relative in interface ResultSetrows - The relative row number. If the relative row
number is positive, this positions the cursor
after the current position. If the relative
row number is negative, this positions the
cursor before the current position. If the
relative row number is 0, then the cursor
position does not change.SQLException - If the result set is not open,
the result set is not scrollable,
the cursor is not positioned on a valid row,
or an error occurs.
public int getConcurrency()
throws SQLException
getConcurrency in interface ResultSetSQLException - If the result set is not open.
public int getType()
throws SQLException
getType in interface ResultSetSQLException - If the result set is not open.
public int getFetchDirection()
throws SQLException
getFetchDirection in interface ResultSetSQLException - If the result is not open.
public void setFetchDirection(int direction)
throws SQLException
setFetchDirection in interface ResultSetdirection - The fetch direction for processing rows.
Valid values are:
SQLException - If the result set is not open,
the result set is scrollable
and the input value is not
ResultSet.FETCH_FORWARD,
or the input value is not valid.
public int getFetchSize()
throws SQLException
getFetchSize in interface ResultSetSQLException - If the result is not open.
public void setFetchSize(int rows)
throws SQLException
setFetchSize in interface ResultSetrows - The number of rows. This must be greater than
or equal to 0 and less than or equal to the
maximum rows limit. The default is the
statement's fetch size.SQLException - If the result set is not open
or the input value is not valid.
public String getCursorName()
throws SQLException
getCursorName in interface ResultSetSQLException - If the result is not open.
public ResultSetMetaData getMetaData()
throws SQLException
getMetaData in interface ResultSetSQLException - If an error occurs.
public Statement getStatement()
throws SQLException
getStatement in interface ResultSetSQLException - If an error occurs.
public SQLWarning getWarnings()
throws SQLException
getWarnings in interface ResultSetSQLException - If an error occurs.
public void clearWarnings()
throws SQLException
clearWarnings in interface ResultSetSQLException - If an error occurs.
public int findColumn(String columnName)
throws SQLException
findColumn in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open
or the column name is not found.
public int getRow()
throws SQLException
getRow in interface ResultSetSQLException - If the result set is not open.
public boolean wasNull()
throws SQLException
wasNull in interface ResultSetSQLException - If the result set is not open.
public boolean getBoolean(int column)
throws SQLException
getBoolean in interface ResultSetcolumn - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public boolean getBoolean(String columnName)
throws SQLException
getBoolean in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public byte getByte(int column)
throws SQLException
getByte in interface ResultSetcolumn - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public byte getByte(String columnName)
throws SQLException
getByte in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public short getShort(int column)
throws SQLException
getShort in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public short getShort(String columnName)
throws SQLException
getShort in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public int getInt(int column)
throws SQLException
getInt in interface ResultSetcolumn - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.
public int getInt(String columnName)
throws SQLException
getInt in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.
public long getLong(int column)
throws SQLException
getLong in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public long getLong(String columnName)
throws SQLException
getLong in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public float getFloat(int column)
throws SQLException
getFloat in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public float getFloat(String columnName)
throws SQLException
getFloat in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public double getDouble(int column)
throws SQLException
getDouble in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.
public double getDouble(String columnName)
throws SQLException
getDouble in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.
public BigDecimal getBigDecimal(int column)
throws SQLException
getBigDecimal in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public BigDecimal getBigDecimal(String columnName)
throws SQLException
getBigDecimal in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public BigDecimal getBigDecimal(int column,
int scale)
throws SQLException
getBigDecimal in interface ResultSetcolumn - The column index (1-based).scale - The number of digits after the decimal.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the scale is not valid, or the
requested conversion is not valid.getBigDecimal(int)
public BigDecimal getBigDecimal(String columnName,
int scale)
throws SQLException
getBigDecimal in interface ResultSetcolumnName - The column name.scale - The number of digits after the decimal.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the scale is not valid, or the
requested conversion is not valid.getBigDecimal(int)
public Date getDate(int column)
throws SQLException
getDate in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Date getDate(String columnName)
throws SQLException
getDate in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Time getTime(int column)
throws SQLException
getTime in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Time getTime(String columnName)
throws SQLException
getTime in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Timestamp getTimestamp(int column)
throws SQLException
getTimestamp in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Timestamp getTimestamp(String columnName)
throws SQLException
getTimestamp in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Date getDate(int column,
Calendar calendar)
throws SQLException
getDate in interface ResultSetcolumn - The column index (1-based).calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.
public Date getDate(String columnName,
Calendar calendar)
throws SQLException
getDate in interface ResultSetcolumnName - The column name.calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.
public Time getTime(int column,
Calendar calendar)
throws SQLException
getTime in interface ResultSetcolumn - The column index (1-based).calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Time getTime(String columnName,
Calendar calendar)
throws SQLException
getTime in interface ResultSetcolumnName - The column name.calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Timestamp getTimestamp(int column,
Calendar calendar)
throws SQLException
getTimestamp in interface ResultSetcolumn - The column index (1-based).calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.
public Timestamp getTimestamp(String columnName,
Calendar calendar)
throws SQLException
getTimestamp in interface ResultSetcolumnName - The column name.calendar - The calendar.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.
public byte[] getBytes(int column)
throws SQLException
This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.
getBytes in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public byte[] getBytes(String columnName)
throws SQLException
This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.
getBytes in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public String getString(int column)
throws SQLException
getString in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public String getString(String columnName)
throws SQLException
getString in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public InputStream getBinaryStream(int column)
throws SQLException
getBinaryStream in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public InputStream getBinaryStream(String columnName)
throws SQLException
getBinaryStream in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public InputStream getAsciiStream(int column)
throws SQLException
getAsciiStream in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public InputStream getAsciiStream(String columnName)
throws SQLException
getAsciiStream in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public InputStream getUnicodeStream(int column)
throws SQLException
getUnicodeStream in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.getCharacterStream(int)
public InputStream getUnicodeStream(String columnName)
throws SQLException
getUnicodeStream in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.getCharacterStream(String)
public Reader getCharacterStream(int column)
throws SQLException
getCharacterStream in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Reader getCharacterStream(String columnName)
throws SQLException
getCharacterStream in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Blob getBlob(int column)
throws SQLException
getBlob in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Blob getBlob(String columnName)
throws SQLException
getBlob in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Clob getClob(int column)
throws SQLException
getClob in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Clob getClob(String columnName)
throws SQLException
getClob in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Array getArray(int column)
throws SQLException
getArray in interface ResultSetcolumn - The column index (1-based).SQLException
public Array getArray(String columnName)
throws SQLException
getArray in interface ResultSetcolumnName - The column name.SQLException
public Ref getRef(int column)
throws SQLException
getRef in interface ResultSetcolumn - The column index (1-based).SQLException - Always thrown because DB2 for IBM i does not support structured types.
public Ref getRef(String columnName)
throws SQLException
getRef in interface ResultSetcolumnName - The column name.SQLException - Always thrown because DB2 for IBM i does not support structured types.
public URL getURL(int column)
throws SQLException
getURL in interface ResultSetcolumn - The column index (1-based).SQLException - If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.
public URL getURL(String columnName)
throws SQLException
getURL in interface ResultSetcolumnName - The column name.SQLException - If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.
public Object getObject(int column)
throws SQLException
getObject in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Object getObject(String columnName)
throws SQLException
getObject in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public Object getObject(int column,
Map map)
throws SQLException
getObject in interface ResultSetcolumn - The column index (1-based).map - The type map. This is not used.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the type map is null, or the
requested conversion is not valid.
public Object getObject(String columnName,
Map map)
throws SQLException
getObject in interface ResultSetcolumnName - The column name.map - The type map. This is not used.SQLException - If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the type map is null, or the
requested conversion is not valid.
public void updateNull(int column)
throws SQLException
updateNull in interface ResultSetcolumn - The column index (1-based).SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateNull(String columnName)
throws SQLException
updateNull in interface ResultSetcolumnName - The column name.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateByte(int column,
byte x)
throws SQLException
updateByte in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateByte(String columnName,
byte x)
throws SQLException
updateByte in interface ResultSetcolumnName - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBoolean(int column,
boolean x)
throws SQLException
updateBoolean in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBoolean(String columnName,
boolean x)
throws SQLException
updateBoolean in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateShort(int column,
short x)
throws SQLException
updateShort in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateShort(String columnName,
short x)
throws SQLException
updateShort in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateInt(int column,
int x)
throws SQLException
updateInt in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateInt(String columnName,
int x)
throws SQLException
updateInt in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateLong(int column,
long x)
throws SQLException
updateLong in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateLong(String columnName,
long x)
throws SQLException
updateLong in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateFloat(int column,
float x)
throws SQLException
updateFloat in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateFloat(String columnName,
float x)
throws SQLException
updateFloat in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateDouble(int column,
double x)
throws SQLException
updateDouble in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateDouble(String columnName,
double x)
throws SQLException
updateDouble in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBigDecimal(int column,
BigDecimal x)
throws SQLException
updateBigDecimal in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBigDecimal(String columnName,
BigDecimal x)
throws SQLException
updateBigDecimal in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateDate(int column,
Date x)
throws SQLException
updateDate in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateDate(String columnName,
Date x)
throws SQLException
updateDate in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateTime(int column,
Time x)
throws SQLException
updateTime in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateTime(String columnName,
Time x)
throws SQLException
updateTime in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateTimestamp(int column,
Timestamp x)
throws SQLException
updateTimestamp in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateTimestamp(String columnName,
Timestamp x)
throws SQLException
updateTimestamp in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBytes(int column,
byte[] x)
throws SQLException
updateBytes in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBytes(String columnName,
byte[] x)
throws SQLException
updateBytes in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateString(int column,
String x)
throws SQLException
updateString in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public void updateString(String columnName,
String x)
throws SQLException
updateString in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public void updateBinaryStream(int column,
InputStream x,
int length)
throws SQLException
updateBinaryStream in interface ResultSetcolumn - column indexx - the new column valuelength - the length of the streamSQLException - if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
public void updateBinaryStream(String columnName,
InputStream x,
int length)
throws SQLException
updateBinaryStream in interface ResultSetcolumnName - column indexx - the new column valuelength - the length of the streamSQLException - if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
public void updateAsciiStream(int column,
InputStream x,
int length)
throws SQLException
updateAsciiStream in interface ResultSetcolumn - x - the new column valuelength - the length of the streamSQLException - if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
public void updateAsciiStream(String columnName,
InputStream x,
int length)
throws SQLException
updateAsciiStream in interface ResultSetcolumnName - x - the new column valuelength - the length of the streamSQLException - if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
public void updateCharacterStream(int column,
Reader x,
int length)
throws SQLException
updateCharacterStream in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.length - The length.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.
public void updateCharacterStream(String columnName,
Reader x,
int length)
throws SQLException
updateCharacterStream in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.length - The length.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.
public void updateBlob(int column,
Blob x)
throws SQLException
updateBlob in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateBlob(String columnName,
Blob x)
throws SQLException
updateBlob in interface ResultSetcolumnName - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateClob(int column,
Clob x)
throws SQLException
updateClob in interface ResultSetcolumn - The column index (1-based).x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateClob(String columnName,
Clob x)
throws SQLException
updateClob in interface ResultSetcolumnName - The column name.x - The column value.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.
public void updateArray(int column,
Array x)
throws SQLException
updateArray in interface ResultSetcolumn - The column index (1-based).x - The column value or null if the value is SQL NULL.SQLException
public void updateArray(String columnName,
Array x)
throws SQLException
updateArray in interface ResultSetcolumnName - The column index (1-based).x - The column value or null if the value is SQL NULL.SQLException
public void updateRef(int column,
Ref x)
throws SQLException
updateRef in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException
public void updateRef(String columnName,
Ref x)
throws SQLException
updateRef in interface ResultSetcolumnName - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException
public void updateObject(int column,
Object x)
throws SQLException
updateObject in interface ResultSetcolumn - The column index (1-based).x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public void updateObject(String columnName,
Object x)
throws SQLException
updateObject in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public void updateObject(int column,
Object x,
int scale)
throws SQLException
updateObject in interface ResultSetcolumn - The column index.x - The column value or null to update
the value to SQL NULL.scale - The scale.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public void updateObject(String columnName,
Object x,
int scale)
throws SQLException
updateObject in interface ResultSetcolumnName - The column name.x - The column value or null to update
the value to SQL NULL.scale - The scale.SQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.
public boolean rowUpdated()
throws SQLException
rowUpdated in interface ResultSetSQLException - If an error occurs.
public boolean rowInserted()
throws SQLException
rowInserted in interface ResultSetSQLException - If an error occurs.
public boolean rowDeleted()
throws SQLException
rowDeleted in interface ResultSetSQLException - If an error occurs.
public void insertRow()
throws SQLException
insertRow in interface ResultSetSQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on the insert row,
a column that is not nullable was not specified,
or an error occurs.
public void updateRow()
throws SQLException
updateRow in interface ResultSetSQLException - If the result set is not open
or the result set is not updatable.
public void deleteRow()
throws SQLException
deleteRow in interface ResultSetSQLException - If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the cursor is positioned on the insert row,
or an error occurs.
public void refreshRow()
throws SQLException
refreshRow in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
the cursor is not positioned on a row,
the cursor is positioned on the
insert row or an error occurs.
public void cancelRowUpdates()
throws SQLException
cancelRowUpdates in interface ResultSetSQLException - If the result set is not open
or the result set is not updatable.
public void moveToInsertRow()
throws SQLException
moveToInsertRow in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
the result set is not updatable,
or an error occurs.
public void moveToCurrentRow()
throws SQLException
moveToCurrentRow in interface ResultSetSQLException - If the result set is not open,
the result set is not scrollable,
or an error occurs.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||