|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectfr.cnes.sitools.datasource.jdbc.dbexplorer.DBResultSet
public class DBResultSet
Encapsulation of a result set with its database connection in order to release it after use. TODO DESIGN AbstractResultSet > AbstractResultSet générique (XMLDBResultSet, DBSQLResultSet) > implements closable
Field Summary |
---|
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
DBResultSet(java.sql.ResultSet localResultSet,
java.sql.Statement stat,
java.sql.Connection conn)
Complete constructor |
Method Summary | ||
---|---|---|
boolean |
absolute(int row)
|
|
void |
afterLast()
|
|
void |
beforeFirst()
|
|
void |
cancelRowUpdates()
|
|
void |
clearWarnings()
|
|
void |
close()
|
|
void |
deleteRow()
|
|
int |
findColumn(java.lang.String columnLabel)
|
|
boolean |
first()
|
|
java.sql.Array |
getArray(int columnIndex)
|
|
java.sql.Array |
getArray(java.lang.String columnLabel)
|
|
java.io.InputStream |
getAsciiStream(int columnIndex)
|
|
java.io.InputStream |
getAsciiStream(java.lang.String columnLabel)
|
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
|
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
|
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel)
|
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel,
int scale)
|
|
java.io.InputStream |
getBinaryStream(int columnIndex)
|
|
java.io.InputStream |
getBinaryStream(java.lang.String columnLabel)
|
|
java.sql.Blob |
getBlob(int columnIndex)
|
|
java.sql.Blob |
getBlob(java.lang.String columnLabel)
|
|
boolean |
getBoolean(int columnIndex)
|
|
boolean |
getBoolean(java.lang.String columnLabel)
|
|
byte |
getByte(int columnIndex)
|
|
byte |
getByte(java.lang.String columnLabel)
|
|
byte[] |
getBytes(int columnIndex)
|
|
byte[] |
getBytes(java.lang.String columnLabel)
|
|
java.io.Reader |
getCharacterStream(int columnIndex)
|
|
java.io.Reader |
getCharacterStream(java.lang.String columnLabel)
|
|
java.sql.Clob |
getClob(int columnIndex)
|
|
java.sql.Clob |
getClob(java.lang.String columnLabel)
|
|
int |
getConcurrency()
|
|
java.lang.String |
getCursorName()
|
|
java.sql.Date |
getDate(int columnIndex)
|
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
|
|
java.sql.Date |
getDate(java.lang.String columnLabel)
|
|
java.sql.Date |
getDate(java.lang.String columnLabel,
java.util.Calendar cal)
|
|
double |
getDouble(int columnIndex)
|
|
double |
getDouble(java.lang.String columnLabel)
|
|
int |
getFetchDirection()
|
|
int |
getFetchSize()
|
|
float |
getFloat(int columnIndex)
|
|
float |
getFloat(java.lang.String columnLabel)
|
|
int |
getHoldability()
|
|
int |
getInt(int columnIndex)
|
|
int |
getInt(java.lang.String columnLabel)
|
|
long |
getLong(int columnIndex)
|
|
long |
getLong(java.lang.String columnLabel)
|
|
java.sql.ResultSetMetaData |
getMetaData()
|
|
java.io.Reader |
getNCharacterStream(int columnIndex)
|
|
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel)
|
|
java.sql.NClob |
getNClob(int columnIndex)
|
|
java.sql.NClob |
getNClob(java.lang.String columnLabel)
|
|
java.lang.String |
getNString(int columnIndex)
|
|
java.lang.String |
getNString(java.lang.String columnLabel)
|
|
java.lang.Object |
getObject(int columnIndex)
|
|
|
getObject(int columnIndex,
java.lang.Class<T> type)
Retrieves the value of the designated column in the current row of this ResultSet object and will
convert from the SQL type of the column to the requested Java data type, if the conversion is supported. |
|
java.lang.Object |
getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
|
|
java.lang.Object |
getObject(java.lang.String columnLabel)
|
|
|
getObject(java.lang.String columnLabel,
java.lang.Class<T> type)
Retrieves the value of the designated column in the current row of this ResultSet object and will
convert from the SQL type of the column to the requested Java data type, if the conversion is supported. |
|
java.lang.Object |
getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
|
|
java.sql.Ref |
getRef(int columnIndex)
|
|
java.sql.Ref |
getRef(java.lang.String columnLabel)
|
|
int |
getRow()
|
|
java.sql.RowId |
getRowId(int columnIndex)
|
|
java.sql.RowId |
getRowId(java.lang.String columnLabel)
|
|
short |
getShort(int columnIndex)
|
|
short |
getShort(java.lang.String columnLabel)
|
|
java.sql.SQLXML |
getSQLXML(int columnIndex)
|
|
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel)
|
|
java.sql.Statement |
getStatement()
|
|
java.lang.String |
getString(int columnIndex)
|
|
java.lang.String |
getString(java.lang.String columnLabel)
|
|
java.sql.Time |
getTime(int columnIndex)
|
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
|
|
java.sql.Time |
getTime(java.lang.String columnLabel)
|
|
java.sql.Time |
getTime(java.lang.String columnLabel,
java.util.Calendar cal)
|
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
|
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
|
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel)
|
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel,
java.util.Calendar cal)
|
|
int |
getType()
|
|
java.io.InputStream |
getUnicodeStream(int columnIndex)
|
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnLabel)
|
|
java.net.URL |
getURL(int columnIndex)
|
|
java.net.URL |
getURL(java.lang.String columnLabel)
|
|
java.sql.SQLWarning |
getWarnings()
|
|
void |
insertRow()
|
|
boolean |
isAfterLast()
|
|
boolean |
isBeforeFirst()
|
|
boolean |
isClosed()
|
|
boolean |
isFirst()
|
|
boolean |
isLast()
|
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
|
|
boolean |
last()
|
|
void |
moveToCurrentRow()
|
|
void |
moveToInsertRow()
|
|
boolean |
next()
|
|
boolean |
previous()
|
|
void |
refreshRow()
|
|
boolean |
relative(int rows)
|
|
boolean |
rowDeleted()
|
|
boolean |
rowInserted()
|
|
boolean |
rowUpdated()
|
|
void |
setFetchDirection(int direction)
|
|
void |
setFetchSize(int rows)
|
|
|
unwrap(java.lang.Class<T> iface)
|
|
void |
updateArray(int columnIndex,
java.sql.Array x)
|
|
void |
updateArray(java.lang.String columnLabel,
java.sql.Array x)
|
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x)
|
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
|
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
|
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
|
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
|
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
|
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
|
|
void |
updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
|
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x)
|
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
|
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
|
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
|
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
|
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
|
|
void |
updateBlob(int columnIndex,
java.sql.Blob x)
|
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream)
|
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
|
|
void |
updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
|
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
|
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length)
|
|
void |
updateBoolean(int columnIndex,
boolean x)
|
|
void |
updateBoolean(java.lang.String columnLabel,
boolean x)
|
|
void |
updateByte(int columnIndex,
byte x)
|
|
void |
updateByte(java.lang.String columnLabel,
byte x)
|
|
void |
updateBytes(int columnIndex,
byte[] x)
|
|
void |
updateBytes(java.lang.String columnLabel,
byte[] x)
|
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x)
|
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
|
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
|
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
|
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
int length)
|
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
|
|
void |
updateClob(int columnIndex,
java.sql.Clob x)
|
|
void |
updateClob(int columnIndex,
java.io.Reader reader)
|
|
void |
updateClob(int columnIndex,
java.io.Reader reader,
long length)
|
|
void |
updateClob(java.lang.String columnLabel,
java.sql.Clob x)
|
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader)
|
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
|
|
void |
updateDate(int columnIndex,
java.sql.Date x)
|
|
void |
updateDate(java.lang.String columnLabel,
java.sql.Date x)
|
|
void |
updateDouble(int columnIndex,
double x)
|
|
void |
updateDouble(java.lang.String columnLabel,
double x)
|
|
void |
updateFloat(int columnIndex,
float x)
|
|
void |
updateFloat(java.lang.String columnLabel,
float x)
|
|
void |
updateInt(int columnIndex,
int x)
|
|
void |
updateInt(java.lang.String columnLabel,
int x)
|
|
void |
updateLong(int columnIndex,
long x)
|
|
void |
updateLong(java.lang.String columnLabel,
long x)
|
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x)
|
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
|
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
|
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
|
|
void |
updateNClob(int columnIndex,
java.sql.NClob nClob)
|
|
void |
updateNClob(int columnIndex,
java.io.Reader reader)
|
|
void |
updateNClob(int columnIndex,
java.io.Reader reader,
long length)
|
|
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
|
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
|
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
|
|
void |
updateNString(int columnIndex,
java.lang.String nString)
|
|
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString)
|
|
void |
updateNull(int columnIndex)
|
|
void |
updateNull(java.lang.String columnLabel)
|
|
void |
updateObject(int columnIndex,
java.lang.Object x)
|
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scaleOrLength)
|
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x)
|
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scaleOrLength)
|
|
void |
updateRef(int columnIndex,
java.sql.Ref x)
|
|
void |
updateRef(java.lang.String columnLabel,
java.sql.Ref x)
|
|
void |
updateRow()
|
|
void |
updateRowId(int columnIndex,
java.sql.RowId x)
|
|
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
|
|
void |
updateShort(int columnIndex,
short x)
|
|
void |
updateShort(java.lang.String columnLabel,
short x)
|
|
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
|
|
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
|
|
void |
updateString(int columnIndex,
java.lang.String x)
|
|
void |
updateString(java.lang.String columnLabel,
java.lang.String x)
|
|
void |
updateTime(int columnIndex,
java.sql.Time x)
|
|
void |
updateTime(java.lang.String columnLabel,
java.sql.Time x)
|
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
|
|
void |
updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
|
|
boolean |
wasNull()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DBResultSet(java.sql.ResultSet localResultSet, java.sql.Statement stat, java.sql.Connection conn)
localResultSet
- ResultSetstat
- Statementconn
- SQL ConnectionMethod Detail |
---|
public final boolean absolute(int row) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
java.sql.SQLException
public final void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
public final void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public final void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
public final void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public final void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
public final void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
public final int findColumn(java.lang.String columnLabel) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Array getArray(java.lang.String columnLabel) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getAsciiStream(java.lang.String columnLabel) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final java.math.BigDecimal getBigDecimal(java.lang.String columnLabel, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final java.math.BigDecimal getBigDecimal(java.lang.String columnLabel) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getBinaryStream(java.lang.String columnLabel) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Blob getBlob(java.lang.String columnLabel) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean getBoolean(int columnIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean getBoolean(java.lang.String columnLabel) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public final byte getByte(int columnIndex) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
java.sql.SQLException
public final byte getByte(java.lang.String columnLabel) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
java.sql.SQLException
public final byte[] getBytes(int columnIndex) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
java.sql.SQLException
public final byte[] getBytes(java.lang.String columnLabel) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.Reader getCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Clob getClob(java.lang.String columnLabel) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
java.sql.SQLException
public final int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Date getDate(java.lang.String columnLabel) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public final double getDouble(int columnIndex) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
java.sql.SQLException
public final double getDouble(java.lang.String columnLabel) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
java.sql.SQLException
public final int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public final int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public final float getFloat(int columnIndex) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
java.sql.SQLException
public final float getFloat(java.lang.String columnLabel) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
java.sql.SQLException
public final int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
public final int getInt(int columnIndex) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
java.sql.SQLException
public final int getInt(java.lang.String columnLabel) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
java.sql.SQLException
public final long getLong(int columnIndex) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
java.sql.SQLException
public final long getLong(java.lang.String columnLabel) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
getNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.String getNString(int columnIndex) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
getNString
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.Object getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.Object getObject(java.lang.String columnLabel) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Ref getRef(java.lang.String columnLabel) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public final int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
getRowId
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
getSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public final short getShort(int columnIndex) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
java.sql.SQLException
public final short getShort(java.lang.String columnLabel) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
java.sql.SQLException
public final java.lang.String getString(java.lang.String columnLabel) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Time getTime(java.lang.String columnLabel) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.Timestamp getTimestamp(java.lang.String columnLabel) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
public final java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public final java.net.URL getURL(java.lang.String columnLabel) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.io.InputStream getUnicodeStream(java.lang.String columnLabel) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public final java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public final void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isFirst() throws java.sql.SQLException
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
public final boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
public final void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
public final void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
public final void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean relative(int rows) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
public final void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public final void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public final <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
public final void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateArray(java.lang.String columnLabel, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(java.lang.String columnLabel, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBoolean(java.lang.String columnLabel, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateByte(java.lang.String columnLabel, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateBytes(java.lang.String columnLabel, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(java.lang.String columnLabel, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateDate(java.lang.String columnLabel, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateDouble(java.lang.String columnLabel, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateFloat(java.lang.String columnLabel, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateInt(java.lang.String columnLabel, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateLong(java.lang.String columnLabel, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateNClob
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNString(java.lang.String columnLabel, java.lang.String nString) throws java.sql.SQLException
updateNString
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateNull(java.lang.String columnLabel) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateObject(int columnIndex, java.lang.Object x, int scaleOrLength) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateObject(java.lang.String columnLabel, java.lang.Object x, int scaleOrLength) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateObject(java.lang.String columnLabel, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateRef(java.lang.String columnLabel, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
updateRowId
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
updateSQLXML
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateShort(java.lang.String columnLabel, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateTime(java.lang.String columnLabel, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final void updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public final boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of this ResultSet
object and will
convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the
conversion is not supported or null is specified for the type, a SQLException
is thrown.
At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of
appropriate user defined SQL types to a Java type which implements SQLData
, or Struct
. Additional
conversions may be supported and are vendor defined.
T
- Class representing the Java data type to convert the designated column to.columnIndex
- the first column is 1, the second is 2, ...type
- Class representing the Java data type to convert the designated column to.
type
holding the column value
java.sql.SQLException
- if conversion is not supported, type is null or another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if a conversion error occurs
java.sql.SQLException
- if the JDBC driver does not support this methodpublic <T> T getObject(java.lang.String columnLabel, java.lang.Class<T> type) throws java.sql.SQLException
Retrieves the value of the designated column in the current row of this ResultSet
object and will
convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the
conversion is not supported or null is specified for the type, a SQLException
is thrown.
At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of
appropriate user defined SQL types to a Java type which implements SQLData
, or Struct
. Additional
conversions may be supported and are vendor defined.
T
- Class representing the Java data type to convert the designated column to.columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then
the label is the name of the columntype
- Class representing the Java data type to convert the designated column to.
type
holding the column value
java.sql.SQLException
- if conversion is not supported, type is null or another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if a conversion error occurs
java.sql.SQLException
- if the JDBC driver does not support this method
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |