|
||||||||||
| 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 Connection| Method Detail |
|---|
public final boolean absolute(int row)
throws java.sql.SQLException
absolute in interface java.sql.ResultSetjava.sql.SQLException
public final void afterLast()
throws java.sql.SQLException
afterLast in interface java.sql.ResultSetjava.sql.SQLException
public final void beforeFirst()
throws java.sql.SQLException
beforeFirst in interface java.sql.ResultSetjava.sql.SQLException
public final void cancelRowUpdates()
throws java.sql.SQLException
cancelRowUpdates in interface java.sql.ResultSetjava.sql.SQLException
public final void clearWarnings()
throws java.sql.SQLException
clearWarnings in interface java.sql.ResultSetjava.sql.SQLException
public final void close()
throws java.sql.SQLException
close in interface java.sql.ResultSetjava.sql.SQLException
public final void deleteRow()
throws java.sql.SQLException
deleteRow in interface java.sql.ResultSetjava.sql.SQLException
public final int findColumn(java.lang.String columnLabel)
throws java.sql.SQLException
findColumn in interface java.sql.ResultSetjava.sql.SQLException
public final boolean first()
throws java.sql.SQLException
first in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Array getArray(int columnIndex)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Array getArray(java.lang.String columnLabel)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getAsciiStream(java.lang.String columnLabel)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final java.math.BigDecimal getBigDecimal(java.lang.String columnLabel,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final java.math.BigDecimal getBigDecimal(java.lang.String columnLabel)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getBinaryStream(java.lang.String columnLabel)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Blob getBlob(int columnIndex)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Blob getBlob(java.lang.String columnLabel)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetjava.sql.SQLException
public final boolean getBoolean(int columnIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetjava.sql.SQLException
public final boolean getBoolean(java.lang.String columnLabel)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetjava.sql.SQLException
public final byte getByte(int columnIndex)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetjava.sql.SQLException
public final byte getByte(java.lang.String columnLabel)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetjava.sql.SQLException
public final byte[] getBytes(int columnIndex)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetjava.sql.SQLException
public final byte[] getBytes(java.lang.String columnLabel)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.Reader getCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Clob getClob(int columnIndex)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Clob getClob(java.lang.String columnLabel)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetjava.sql.SQLException
public final int getConcurrency()
throws java.sql.SQLException
getConcurrency in interface java.sql.ResultSetjava.sql.SQLException
public final java.lang.String getCursorName()
throws java.sql.SQLException
getCursorName in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final java.sql.Date getDate(java.lang.String columnLabel)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLException
public final double getDouble(int columnIndex)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetjava.sql.SQLException
public final double getDouble(java.lang.String columnLabel)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetjava.sql.SQLException
public final int getFetchDirection()
throws java.sql.SQLException
getFetchDirection in interface java.sql.ResultSetjava.sql.SQLException
public final int getFetchSize()
throws java.sql.SQLException
getFetchSize in interface java.sql.ResultSetjava.sql.SQLException
public final float getFloat(int columnIndex)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetjava.sql.SQLException
public final float getFloat(java.lang.String columnLabel)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetjava.sql.SQLException
public final int getHoldability()
throws java.sql.SQLException
getHoldability in interface java.sql.ResultSetjava.sql.SQLException
public final int getInt(int columnIndex)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetjava.sql.SQLException
public final int getInt(java.lang.String columnLabel)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetjava.sql.SQLException
public final long getLong(int columnIndex)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetjava.sql.SQLException
public final long getLong(java.lang.String columnLabel)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.Reader getNCharacterStream(int columnIndex)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.Reader getNCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.NClob getNClob(int columnIndex)
throws java.sql.SQLException
getNClob in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.NClob getNClob(java.lang.String columnLabel)
throws java.sql.SQLException
getNClob in interface java.sql.ResultSetjava.sql.SQLException
public final java.lang.String getNString(int columnIndex)
throws java.sql.SQLException
getNString in interface java.sql.ResultSetjava.sql.SQLException
public final java.lang.String getNString(java.lang.String columnLabel)
throws java.sql.SQLException
getNString in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final java.lang.Object getObject(int columnIndex)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final java.lang.Object getObject(java.lang.String columnLabel)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Ref getRef(int columnIndex)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Ref getRef(java.lang.String columnLabel)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public final int getRow()
throws java.sql.SQLException
getRow in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.RowId getRowId(int columnIndex)
throws java.sql.SQLException
getRowId in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.RowId getRowId(java.lang.String columnLabel)
throws java.sql.SQLException
getRowId in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.SQLXML getSQLXML(int columnIndex)
throws java.sql.SQLException
getSQLXML in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
throws java.sql.SQLException
getSQLXML in interface java.sql.ResultSetjava.sql.SQLException
public final short getShort(int columnIndex)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetjava.sql.SQLException
public final short getShort(java.lang.String columnLabel)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Statement getStatement()
throws java.sql.SQLException
getStatement in interface java.sql.ResultSetjava.sql.SQLException
public final java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in interface java.sql.ResultSetjava.sql.SQLException
public final java.lang.String getString(java.lang.String columnLabel)
throws java.sql.SQLException
getString in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final java.sql.Time getTime(java.lang.String columnLabel)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final java.sql.Timestamp getTimestamp(java.lang.String columnLabel)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public final int getType()
throws java.sql.SQLException
getType in interface java.sql.ResultSetjava.sql.SQLException
public final java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public final java.net.URL getURL(java.lang.String columnLabel)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.io.InputStream getUnicodeStream(java.lang.String columnLabel)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLException
public final java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
getWarnings in interface java.sql.ResultSetjava.sql.SQLException
public final void insertRow()
throws java.sql.SQLException
insertRow in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isAfterLast()
throws java.sql.SQLException
isAfterLast in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isBeforeFirst()
throws java.sql.SQLException
isBeforeFirst in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isClosed()
throws java.sql.SQLException
isClosed in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isFirst()
throws java.sql.SQLException
isFirst in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isLast()
throws java.sql.SQLException
isLast in interface java.sql.ResultSetjava.sql.SQLException
public final boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
isWrapperFor in interface java.sql.Wrapperjava.sql.SQLException
public final boolean last()
throws java.sql.SQLException
last in interface java.sql.ResultSetjava.sql.SQLException
public final void moveToCurrentRow()
throws java.sql.SQLException
moveToCurrentRow in interface java.sql.ResultSetjava.sql.SQLException
public final void moveToInsertRow()
throws java.sql.SQLException
moveToInsertRow in interface java.sql.ResultSetjava.sql.SQLException
public final boolean next()
throws java.sql.SQLException
next in interface java.sql.ResultSetjava.sql.SQLException
public final boolean previous()
throws java.sql.SQLException
previous in interface java.sql.ResultSetjava.sql.SQLException
public final void refreshRow()
throws java.sql.SQLException
refreshRow in interface java.sql.ResultSetjava.sql.SQLException
public final boolean relative(int rows)
throws java.sql.SQLException
relative in interface java.sql.ResultSetjava.sql.SQLException
public final boolean rowDeleted()
throws java.sql.SQLException
rowDeleted in interface java.sql.ResultSetjava.sql.SQLException
public final boolean rowInserted()
throws java.sql.SQLException
rowInserted in interface java.sql.ResultSetjava.sql.SQLException
public final boolean rowUpdated()
throws java.sql.SQLException
rowUpdated in interface java.sql.ResultSetjava.sql.SQLException
public final void setFetchDirection(int direction)
throws java.sql.SQLException
setFetchDirection in interface java.sql.ResultSetjava.sql.SQLException
public final void setFetchSize(int rows)
throws java.sql.SQLException
setFetchSize in interface java.sql.ResultSetjava.sql.SQLException
public final <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
unwrap in interface java.sql.Wrapperjava.sql.SQLException
public final void updateArray(int columnIndex,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public final void updateArray(java.lang.String columnLabel,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public final void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateAsciiStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.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.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBinaryStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.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.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBlob(int columnIndex,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBlob(int columnIndex,
java.io.InputStream inputStream)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBoolean(int columnIndex,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBoolean(java.lang.String columnLabel,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLException
public final void updateByte(int columnIndex,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLException
public final void updateByte(java.lang.String columnLabel,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBytes(int columnIndex,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLException
public final void updateBytes(java.lang.String columnLabel,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLException
public final void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.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.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateClob(int columnIndex,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateClob(java.lang.String columnLabel,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateDate(int columnIndex,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLException
public final void updateDate(java.lang.String columnLabel,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLException
public final void updateDouble(int columnIndex,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLException
public final void updateDouble(java.lang.String columnLabel,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLException
public final void updateFloat(int columnIndex,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLException
public final void updateFloat(java.lang.String columnLabel,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLException
public final void updateInt(int columnIndex,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLException
public final void updateInt(java.lang.String columnLabel,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLException
public final void updateLong(int columnIndex,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLException
public final void updateLong(java.lang.String columnLabel,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNClob(int columnIndex,
java.sql.NClob nClob)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNString(int columnIndex,
java.lang.String nString)
throws java.sql.SQLException
updateNString in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNString(java.lang.String columnLabel,
java.lang.String nString)
throws java.sql.SQLException
updateNString in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNull(int columnIndex)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLException
public final void updateNull(java.lang.String columnLabel)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLException
public final void updateObject(int columnIndex,
java.lang.Object x,
int scaleOrLength)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public final void updateObject(int columnIndex,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.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.ResultSetjava.sql.SQLException
public final void updateObject(java.lang.String columnLabel,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public final void updateRef(int columnIndex,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public final void updateRef(java.lang.String columnLabel,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public final void updateRow()
throws java.sql.SQLException
updateRow in interface java.sql.ResultSetjava.sql.SQLException
public final void updateRowId(int columnIndex,
java.sql.RowId x)
throws java.sql.SQLException
updateRowId in interface java.sql.ResultSetjava.sql.SQLException
public final void updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
throws java.sql.SQLException
updateRowId in interface java.sql.ResultSetjava.sql.SQLException
public final void updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
updateSQLXML in interface java.sql.ResultSetjava.sql.SQLException
public final void updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
updateSQLXML in interface java.sql.ResultSetjava.sql.SQLException
public final void updateShort(int columnIndex,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLException
public final void updateShort(java.lang.String columnLabel,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLException
public final void updateString(int columnIndex,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLException
public final void updateString(java.lang.String columnLabel,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLException
public final void updateTime(int columnIndex,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLException
public final void updateTime(java.lang.String columnLabel,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLException
public final void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public final void updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public final boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.ResultSetjava.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 method
public <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 | |||||||||