com.exalead.papi.helper

Class ResultSetProxy

java.lang.Object

com.exalead.papi.helper.ResultSetProxy

Direct Known Subclasses:

ResultSetCacheAsStream, ResultSetDirectAccess, ResultSetProxyReadThru

public abstract class ResultSetProxy
extends java.lang.Object

Proxy of a ResultSet that exposes the bare minimal primitives. Used to enforce the policy toward the use of a ResultSet, currently either

• Fetch the value from the result set each time it is requested
• Caches the values in RAM in order to fetch it only once.

See Also:

ResultSetCacheAsStream, ResultSetDirectAccess

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	FAILED_RETR_MSG
protected java.sql.ResultSetMetaData	metaData
protected java.sql.ResultSet	rs

Constructor Summary

Constructors

Constructor and Description
ResultSetProxy(java.sql.ResultSet rs, java.sql.ResultSetMetaData metaData)

Method Summary

Modifier and Type	Method and Description
java.math.BigDecimal	getBigDecimal(ColumnMapping mapping)
java.math.BigDecimal	getBigDecimal(int index)
java.sql.Blob	getBlob(ColumnMapping mapping)
java.sql.Blob	getBlob(int index)
byte[]	getBytes(ColumnMapping mapping)
byte[]	getBytes(int index)
java.sql.Clob	getClob(ColumnMapping mapping)
java.sql.Clob	getClob(int index)
double	getDouble(ColumnMapping mapping)
double	getDouble(int index)
long	getLong(ColumnMapping mapping)
long	getLong(int index)
java.lang.String	getString(ColumnMapping mapping)
java.lang.String	getString(int index)
java.lang.String	getString(java.lang.String columnName)
java.sql.Timestamp	getTimestamp(ColumnMapping mapping)
java.sql.Timestamp	getTimestamp(int index)
protected abstract java.lang.Object	getValue(int sqlIndex) Returns the value of the current row for the given index.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

FAILED_RETR_MSG

protected static final java.lang.String FAILED_RETR_MSG

See Also:

Constant Field Values

rs

protected final java.sql.ResultSet rs

metaData

protected final java.sql.ResultSetMetaData metaData

Constructor Detail

ResultSetProxy

public ResultSetProxy(java.sql.ResultSet rs,
                      java.sql.ResultSetMetaData metaData)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

getValue

protected abstract java.lang.Object getValue(int sqlIndex)
                                      throws java.sql.SQLException

Returns the value of the current row for the given index. If the value is NULL, then returns null

Parameters:

sqlIndex - The index of the column. Starts at 1.

Returns:

Either the value of the column, or null if the column's value is NULL

Throws:

java.sql.SQLException

getClob

public java.sql.Clob getClob(ColumnMapping mapping)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getClob

public java.sql.Clob getClob(int index)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getDouble

public double getDouble(ColumnMapping mapping)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getDouble

public double getDouble(int index)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getLong

public long getLong(ColumnMapping mapping)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

getLong

public long getLong(int index)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

public java.lang.String getString(ColumnMapping mapping)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

public java.lang.String getString(int index)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getBytes

public byte[] getBytes(ColumnMapping mapping)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getBytes

public byte[] getBytes(int index)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getBlob

public java.sql.Blob getBlob(ColumnMapping mapping)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int index)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(ColumnMapping mapping)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int index)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(ColumnMapping mapping)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int index)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException