ResultSetWrapper (TIBCO Spotfire Server 10.1)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.spotfire.ws.im.ds.sql
Class ResultSetWrapper

java.lang.Object
  com.spotfire.ws.im.ds.sql.ResultSetWrapper

public class ResultSetWrapper
extends Object
extends Object

Use this class for creating wrapper classes around the ResultSet interface. The subclass can override the methods that need to show a different behaviour than the wrapped object.

Since:: 7.2
See Also:: SQLRuntime.executeQuery(java.lang.String)

Field Summary
`protected ResultSet`	`m_resultSet` The wrapped `ResultSet`.

Constructor Summary
`ResultSetWrapper(ResultSet rs)` Creates a new `ResultSetWrapper` instance.

Method Summary
`boolean`	`absolute(int row)`
`void`	`afterLast()`
`void`	`beforeFirst()`
`void`	`cancelRowUpdates()`
`void`	`clearWarnings()`
`void`	`close()`
`void`	`deleteRow()`
`int`	`findColumn(String columnName)`
`boolean`	`first()`
`Array`	`getArray(int i)`
`Array`	`getArray(String colName)`
`InputStream`	`getAsciiStream(int columnIndex)`
`InputStream`	`getAsciiStream(String columnName)`
`BigDecimal`	`getBigDecimal(int columnIndex)`
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`BigDecimal`	`getBigDecimal(String columnName)`
`BigDecimal`	`getBigDecimal(String columnName, int scale)` Deprecated.
`InputStream`	`getBinaryStream(int columnIndex)`
`InputStream`	`getBinaryStream(String columnName)`
`Blob`	`getBlob(int i)`
`Blob`	`getBlob(String colName)`
`boolean`	`getBoolean(int columnIndex)`
`boolean`	`getBoolean(String columnName)`
`byte`	`getByte(int columnIndex)`
`byte`	`getByte(String columnName)`
`byte[]`	`getBytes(int columnIndex)`
`byte[]`	`getBytes(String columnName)`
`Reader`	`getCharacterStream(int columnIndex)`
`Reader`	`getCharacterStream(String columnName)`
`Clob`	`getClob(int i)`
`Clob`	`getClob(String colName)`
`int`	`getConcurrency()`
`String`	`getCursorName()`
`Date`	`getDate(int columnIndex)`
`Date`	`getDate(int columnIndex, Calendar cal)`
`Date`	`getDate(String columnName)`
`Date`	`getDate(String columnName, Calendar cal)`
`double`	`getDouble(int columnIndex)`
`double`	`getDouble(String columnName)`
`int`	`getFetchDirection()`
`int`	`getFetchSize()`
`float`	`getFloat(int columnIndex)`
`float`	`getFloat(String columnName)`
`int`	`getHoldability()`
`int`	`getInt(int columnIndex)`
`int`	`getInt(String columnName)`
`long`	`getLong(int columnIndex)`
`long`	`getLong(String columnName)`
`ResultSetMetaData`	`getMetaData()`
`Reader`	`getNCharacterStream(int columnIndex)`
`Reader`	`getNCharacterStream(String columnName)`
`NClob`	`getNClob(int columnIndex)`
`NClob`	`getNClob(String columnName)`
`String`	`getNString(int columnIndex)`
`String`	`getNString(String columnName)`
`Object`	`getObject(int columnIndex)`
`Object`	`getObject(int i, Map map)`
`Object`	`getObject(String columnName)`
`Object`	`getObject(String colName, Map map)`
`Ref`	`getRef(int i)`
`Ref`	`getRef(String colName)`
`int`	`getRow()`
`RowId`	`getRowId(int columnIndex)`
`RowId`	`getRowId(String columnName)`
`short`	`getShort(int columnIndex)`
`short`	`getShort(String columnName)`
`SQLXML`	`getSQLXML(int columnIndex)`
`SQLXML`	`getSQLXML(String columnName)`
`Statement`	`getStatement()`
`String`	`getString(int columnIndex)`
`String`	`getString(String columnName)`
`Time`	`getTime(int columnIndex)`
`Time`	`getTime(int columnIndex, Calendar cal)`
`Time`	`getTime(String columnName)`
`Time`	`getTime(String columnName, Calendar cal)`
`Timestamp`	`getTimestamp(int columnIndex)`
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)`
`Timestamp`	`getTimestamp(String columnName)`
`Timestamp`	`getTimestamp(String columnName, Calendar cal)`
`int`	`getType()`
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated.
`InputStream`	`getUnicodeStream(String columnName)` Deprecated.
`URL`	`getURL(int columnIndex)`
`URL`	`getURL(String columnName)`
`SQLWarning`	`getWarnings()`
`void`	`insertRow()`
`boolean`	`isAfterLast()`
`boolean`	`isBeforeFirst()`
`boolean`	`isClosed()`
`boolean`	`isFirst()`
`boolean`	`isLast()`
`boolean`	`isWrapperFor(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)`
`Object`	`unwrap(Class iface)`
`void`	`updateArray(int columnIndex, Array x)`
`void`	`updateArray(String columnName, Array x)`
`void`	`updateAsciiStream(int columnIndex, InputStream inputStream)`
`void`	`updateAsciiStream(int columnIndex, InputStream inputStream, int length)`
`void`	`updateAsciiStream(int columnIndex, InputStream inputStream, long length)`
`void`	`updateAsciiStream(String columnName, InputStream inputStream)`
`void`	`updateAsciiStream(String columnName, InputStream inputStream, int length)`
`void`	`updateAsciiStream(String columnName, InputStream inputStream, long length)`
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)`
`void`	`updateBigDecimal(String columnName, BigDecimal x)`
`void`	`updateBinaryStream(int columnIndex, InputStream inputStream)`
`void`	`updateBinaryStream(int columnIndex, InputStream inputStream, int length)`
`void`	`updateBinaryStream(int columnIndex, InputStream inputStream, long length)`
`void`	`updateBinaryStream(String columnName, InputStream inputStream)`
`void`	`updateBinaryStream(String columnName, InputStream inputStream, int length)`
`void`	`updateBinaryStream(String columnName, InputStream inputStream, long length)`
`void`	`updateBlob(int columnIndex, Blob x)`
`void`	`updateBlob(int columnIndex, InputStream inputStream)`
`void`	`updateBlob(int columnIndex, InputStream inputStream, long length)`
`void`	`updateBlob(String columnName, Blob x)`
`void`	`updateBlob(String columnName, InputStream inputStream)`
`void`	`updateBlob(String columnName, InputStream inputStream, long length)`
`void`	`updateBoolean(int columnIndex, boolean x)`
`void`	`updateBoolean(String columnName, boolean x)`
`void`	`updateByte(int columnIndex, byte x)`
`void`	`updateByte(String columnName, byte x)`
`void`	`updateBytes(int columnIndex, byte[] x)`
`void`	`updateBytes(String columnName, byte[] x)`
`void`	`updateCharacterStream(int columnIndex, Reader reader)`
`void`	`updateCharacterStream(int columnIndex, Reader reader, int length)`
`void`	`updateCharacterStream(int columnIndex, Reader reader, long length)`
`void`	`updateCharacterStream(String columnName, Reader reader)`
`void`	`updateCharacterStream(String columnName, Reader reader, int length)`
`void`	`updateCharacterStream(String columnName, Reader reader, long length)`
`void`	`updateClob(int columnIndex, Clob x)`
`void`	`updateClob(int columnIndex, Reader reader)`
`void`	`updateClob(int columnIndex, Reader reader, long length)`
`void`	`updateClob(String columnName, Clob x)`
`void`	`updateClob(String columnName, Reader reader)`
`void`	`updateClob(String columnName, Reader reader, long length)`
`void`	`updateDate(int columnIndex, Date x)`
`void`	`updateDate(String columnName, Date x)`
`void`	`updateDouble(int columnIndex, double x)`
`void`	`updateDouble(String columnName, double x)`
`void`	`updateFloat(int columnIndex, float x)`
`void`	`updateFloat(String columnName, float x)`
`void`	`updateInt(int columnIndex, int x)`
`void`	`updateInt(String columnName, int x)`
`void`	`updateLong(int columnIndex, long x)`
`void`	`updateLong(String columnName, long x)`
`void`	`updateNCharacterStream(int columnIndex, Reader reader)`
`void`	`updateNCharacterStream(int columnIndex, Reader reader, long length)`
`void`	`updateNCharacterStream(String columnName, Reader reader)`
`void`	`updateNCharacterStream(String columnName, Reader reader, long length)`
`void`	`updateNClob(int columnIndex, NClob x)`
`void`	`updateNClob(int columnIndex, Reader reader)`
`void`	`updateNClob(int columnIndex, Reader reader, long length)`
`void`	`updateNClob(String columnName, NClob x)`
`void`	`updateNClob(String columnName, Reader reader)`
`void`	`updateNClob(String columnName, Reader reader, long length)`
`void`	`updateNString(int columnIndex, String x)`
`void`	`updateNString(String columnName, String x)`
`void`	`updateNull(int columnIndex)`
`void`	`updateNull(String columnName)`
`void`	`updateObject(int columnIndex, Object x)`
`void`	`updateObject(int columnIndex, Object x, int scale)`
`void`	`updateObject(String columnName, Object x)`
`void`	`updateObject(String columnName, Object x, int scale)`
`void`	`updateRef(int columnIndex, Ref x)`
`void`	`updateRef(String columnName, Ref x)`
`void`	`updateRow()`
`void`	`updateRowId(int columnIndex, RowId x)`
`void`	`updateRowId(String columnName, RowId x)`
`void`	`updateShort(int columnIndex, short x)`
`void`	`updateShort(String columnName, short x)`
`void`	`updateSQLXML(int columnIndex, SQLXML xmlObject)`
`void`	`updateSQLXML(String columnName, SQLXML xmlObject)`
`void`	`updateString(int columnIndex, String x)`
`void`	`updateString(String columnName, String x)`
`void`	`updateTime(int columnIndex, Time x)`
`void`	`updateTime(String columnName, Time x)`
`void`	`updateTimestamp(int columnIndex, Timestamp x)`
`void`	`updateTimestamp(String columnName, Timestamp x)`
`boolean`	`wasNull()`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Field Detail

m_resultSet

protected ResultSet m_resultSet

The wrapped ResultSet.

Constructor Detail

ResultSetWrapper

public ResultSetWrapper(ResultSet rs)

Creates a new ResultSetWrapper instance.

Parameters:: rs - the ResultSet to be wrapped

Method Detail

public boolean next()

close

public void close()

wasNull

public boolean wasNull()

getString

public String getString(int columnIndex)

getBoolean

public boolean getBoolean(int columnIndex)

getByte

public byte getByte(int columnIndex)

getShort

public short getShort(int columnIndex)

getInt

public int getInt(int columnIndex)

getLong

public long getLong(int columnIndex)

getFloat

public float getFloat(int columnIndex)

getDouble

public double getDouble(int columnIndex)

getBigDecimal

@Deprecated
public BigDecimal getBigDecimal(int columnIndex,
                                           int scale)

Deprecated.

getBytes

public byte[] getBytes(int columnIndex)

getDate

public Date getDate(int columnIndex)

getTime

public Time getTime(int columnIndex)

getTimestamp

public Timestamp getTimestamp(int columnIndex)

getAsciiStream

public InputStream getAsciiStream(int columnIndex)

getUnicodeStream

@Deprecated
public InputStream getUnicodeStream(int columnIndex)

Deprecated.

getBinaryStream

public InputStream getBinaryStream(int columnIndex)

getString

public String getString(String columnName)

getBoolean

public boolean getBoolean(String columnName)

getByte

public byte getByte(String columnName)

getShort

public short getShort(String columnName)

getInt

public int getInt(String columnName)

getLong

public long getLong(String columnName)

getFloat

public float getFloat(String columnName)

getDouble

public double getDouble(String columnName)

getBigDecimal

@Deprecated
public BigDecimal getBigDecimal(String columnName,
                                           int scale)

Deprecated.

getBytes

public byte[] getBytes(String columnName)

getDate

public Date getDate(String columnName)

getTime

public Time getTime(String columnName)

getTimestamp

public Timestamp getTimestamp(String columnName)

getAsciiStream

public InputStream getAsciiStream(String columnName)

getUnicodeStream

@Deprecated
public InputStream getUnicodeStream(String columnName)

Deprecated.

getBinaryStream

public InputStream getBinaryStream(String columnName)

getWarnings

public SQLWarning getWarnings()

clearWarnings

public void clearWarnings()

getCursorName

public String getCursorName()

getMetaData

public ResultSetMetaData getMetaData()

getObject

public Object getObject(int columnIndex)

getObject

public Object getObject(String columnName)

findColumn

public int findColumn(String columnName)

getCharacterStream

public Reader getCharacterStream(int columnIndex)

getCharacterStream

public Reader getCharacterStream(String columnName)

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)

getBigDecimal

public BigDecimal getBigDecimal(String columnName)

isBeforeFirst

public boolean isBeforeFirst()

isAfterLast

public boolean isAfterLast()

isFirst

public boolean isFirst()

isLast

public boolean isLast()

beforeFirst

public void beforeFirst()

afterLast

public void afterLast()

first

public boolean first()

last

public boolean last()

getRow

public int getRow()

absolute

public boolean absolute(int row)

relative

public boolean relative(int rows)

public boolean previous()

setFetchDirection

public void setFetchDirection(int direction)

getFetchDirection

public int getFetchDirection()

setFetchSize

public void setFetchSize(int rows)

getFetchSize

public int getFetchSize()

getType

public int getType()

getConcurrency

public int getConcurrency()

rowUpdated

public boolean rowUpdated()

rowInserted

public boolean rowInserted()

rowDeleted

public boolean rowDeleted()

updateNull

public void updateNull(int columnIndex)

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)

updateByte

public void updateByte(int columnIndex,
                       byte x)

updateShort

public void updateShort(int columnIndex,
                        short x)

updateInt

public void updateInt(int columnIndex,
                      int x)

updateLong

public void updateLong(int columnIndex,
                       long x)

updateFloat

public void updateFloat(int columnIndex,
                        float x)

updateDouble

public void updateDouble(int columnIndex,
                         double x)

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x)

updateString

public void updateString(int columnIndex,
                         String x)

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)

updateDate

public void updateDate(int columnIndex,
                       Date x)

updateTime

public void updateTime(int columnIndex,
                       Time x)

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp x)

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream inputStream,
                              int length)

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream inputStream,
                               int length)

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader,
                                  int length)

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader,
                                  long length)

updateObject

public void updateObject(int columnIndex,
                         Object x,
                         int scale)

updateObject

public void updateObject(int columnIndex,
                         Object x)

updateNull

public void updateNull(String columnName)

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)

updateByte

public void updateByte(String columnName,
                       byte x)

updateShort

public void updateShort(String columnName,
                        short x)

updateInt

public void updateInt(String columnName,
                      int x)

updateLong

public void updateLong(String columnName,
                       long x)

updateFloat

public void updateFloat(String columnName,
                        float x)

updateDouble

public void updateDouble(String columnName,
                         double x)

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)

updateString

public void updateString(String columnName,
                         String x)

updateBytes

public void updateBytes(String columnName,
                        byte[] x)

updateDate

public void updateDate(String columnName,
                       Date x)

updateTime

public void updateTime(String columnName,
                       Time x)

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream inputStream,
                              int length)

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream inputStream,
                               int length)

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  int length)

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  long length)

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)

updateObject

public void updateObject(String columnName,
                         Object x)

insertRow

public void insertRow()

updateRow

public void updateRow()

deleteRow

public void deleteRow()

refreshRow

public void refreshRow()

cancelRowUpdates

public void cancelRowUpdates()

moveToInsertRow

public void moveToInsertRow()

moveToCurrentRow

public void moveToCurrentRow()

getStatement

public Statement getStatement()

getObject

public Object getObject(int i,
                        Map map)

getRef

public Ref getRef(int i)

getBlob

public Blob getBlob(int i)

getClob

public Clob getClob(int i)

getArray

public Array getArray(int i)

getObject

public Object getObject(String colName,
                        Map map)

getRef

public Ref getRef(String colName)

getBlob

public Blob getBlob(String colName)

getClob

public Clob getClob(String colName)

getArray

public Array getArray(String colName)

getDate

public Date getDate(int columnIndex,
                    Calendar cal)

getDate

public Date getDate(String columnName,
                    Calendar cal)

getTime

public Time getTime(int columnIndex,
                    Calendar cal)

getTime

public Time getTime(String columnName,
                    Calendar cal)

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)

getURL

public URL getURL(int columnIndex)

getURL

public URL getURL(String columnName)

updateRef

public void updateRef(int columnIndex,
                      Ref x)

updateRef

public void updateRef(String columnName,
                      Ref x)

updateBlob

public void updateBlob(int columnIndex,
                       Blob x)

updateBlob

public void updateBlob(String columnName,
                       Blob x)

updateClob

public void updateClob(int columnIndex,
                       Clob x)

updateClob

public void updateClob(String columnName,
                       Clob x)

updateArray

public void updateArray(int columnIndex,
                        Array x)

updateArray

public void updateArray(String columnName,
                        Array x)

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream inputStream)

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream inputStream,
                              long length)

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream inputStream)

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream inputStream,
                              long length)

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream inputStream)

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream inputStream,
                               long length)

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream inputStream)

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream inputStream,
                               long length)

updateBlob

public void updateBlob(int columnIndex,
                       InputStream inputStream)

updateBlob

public void updateBlob(int columnIndex,
                       InputStream inputStream,
                       long length)

updateBlob

public void updateBlob(String columnName,
                       InputStream inputStream)

updateBlob

public void updateBlob(String columnName,
                       InputStream inputStream,
                       long length)

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader)

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader)

updateClob

public void updateClob(int columnIndex,
                       Reader reader)

updateClob

public void updateClob(int columnIndex,
                       Reader reader,
                       long length)

updateClob

public void updateClob(String columnName,
                       Reader reader)

updateClob

public void updateClob(String columnName,
                       Reader reader,
                       long length)

getNCharacterStream

public Reader getNCharacterStream(int columnIndex)

getNCharacterStream

public Reader getNCharacterStream(String columnName)

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   Reader reader)

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   Reader reader,
                                   long length)

updateNCharacterStream

public void updateNCharacterStream(String columnName,
                                   Reader reader)

updateNCharacterStream

public void updateNCharacterStream(String columnName,
                                   Reader reader,
                                   long length)

getNClob

public NClob getNClob(int columnIndex)

getNClob

public NClob getNClob(String columnName)

updateNClob

public void updateNClob(int columnIndex,
                        NClob x)

updateNClob

public void updateNClob(String columnName,
                        NClob x)

updateNClob

public void updateNClob(int columnIndex,
                        Reader reader)

updateNClob

public void updateNClob(int columnIndex,
                        Reader reader,
                        long length)

updateNClob

public void updateNClob(String columnName,
                        Reader reader)

updateNClob

public void updateNClob(String columnName,
                        Reader reader,
                        long length)

getNString

public String getNString(int columnIndex)

getNString

public String getNString(String columnName)

updateNString

public void updateNString(int columnIndex,
                          String x)

updateNString

public void updateNString(String columnName,
                          String x)

getRowId

public RowId getRowId(int columnIndex)

getRowId

public RowId getRowId(String columnName)

updateRowId

public void updateRowId(int columnIndex,
                        RowId x)

updateRowId

public void updateRowId(String columnName,
                        RowId x)

getSQLXML

public SQLXML getSQLXML(int columnIndex)

getSQLXML

public SQLXML getSQLXML(String columnName)

updateSQLXML

public void updateSQLXML(int columnIndex,
                         SQLXML xmlObject)

updateSQLXML

public void updateSQLXML(String columnName,
                         SQLXML xmlObject)

isClosed

public boolean isClosed()

getHoldability

public int getHoldability()

isWrapperFor

public boolean isWrapperFor(Class iface)

unwrap

public Object unwrap(Class iface)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.spotfire.ws.im.ds.sql Class ResultSetWrapper

m_resultSet

ResultSetWrapper

next

close

wasNull

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getWarnings

clearWarnings

getCursorName

getMetaData

getObject

getObject

findColumn

getCharacterStream

getCharacterStream

getBigDecimal

getBigDecimal

isBeforeFirst

isAfterLast

isFirst

isLast

beforeFirst

afterLast

first

last

getRow

absolute

relative

previous

setFetchDirection

getFetchDirection

setFetchSize

getFetchSize

getType

getConcurrency

rowUpdated

rowInserted

rowDeleted

updateNull

updateBoolean

updateByte

updateShort

updateInt

updateLong

updateFloat

updateDouble

updateBigDecimal

updateString

com.spotfire.ws.im.ds.sql
Class ResultSetWrapper