net.spy.db
Class GenericResultSetStub

java.lang.Object
  net.spy.SpyObject
      net.spy.db.GenericResultSetStub

All Implemented Interfaces:

Cloneable

Direct Known Subclasses:

CachedResultSetStub

public abstract class GenericResultSetStub

extends SpyObject

implements Cloneable

This object contains all the common stuff required to stub a ResultSet implementation.

Constructor Summary

protected	GenericResultSetStub() Get an instance of a GenericResultSetStub with no initialization.
	GenericResultSetStub(ResultSet rs) Magically transform the passed in ResultSet to a GenericResultSetStub

Method Summary

void	clearWarnings()
void	close() Close the ResultSet.
int	findColumn(String columnName)
BigDecimal	getBigDecimal(int index)
BigDecimal	getBigDecimal(String name)
boolean	getBoolean(int index) Get the given value as a boolean.
boolean	getBoolean(String name)
Date	getDate(int index)
Date	getDate(String name)
double	getDouble(int index)
double	getDouble(String name)
float	getFloat(int index)
float	getFloat(String name)
int	getInt(int index)
int	getInt(String name)
long	getLong(int index)
long	getLong(String name)
ResultSetMetaData	getMetaData()
Object	getObject(int index)
Object	getObject(String name)
protected Object	getResultColumn(int index) Get the Object at the given result column for the current result row.
short	getShort(int index)
short	getShort(String name)
String	getString(int index) Get the given column as a string.
String	getString(String name)
Time	getTime(int index)
Time	getTime(String name)
Timestamp	getTimestamp(int index)
Timestamp	getTimestamp(String name)
SQLWarning	getWarnings()
boolean	next() Seek to the next row in this ResultSet.
protected void	resetResults() Reset the results to the beginning.
protected void	setMetaData(ResultSetMetaData rsmd) Set the ResultSetMetaData used for this ResultSet.
protected void	setResults(List to) Set the results for this ResultSet to use.
String	toString() Debug routine for displaying the current row of the ResultSet.
boolean	wasNull() Check to see if the last column fetched was null.

Methods inherited from class net.spy.SpyObject

getLogger

Methods inherited from class java.lang.Object

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

Constructor Detail

GenericResultSetStub

public GenericResultSetStub(ResultSet rs)
                     throws SQLException

Magically transform the passed in ResultSet to a GenericResultSetStub

Parameters:

rs - the ResultSet we want to magically transform

Throws:

SQLException - if the ResultSet somehow fails us.

GenericResultSetStub

protected GenericResultSetStub()
                        throws SQLException

Get an instance of a GenericResultSetStub with no initialization. The subclass is expected to do whatever is necessary, and then call setResults(List) and setMetaData(ResultSetMetaData) to make everything happy.

Throws:

SQLException - (never)

Method Detail

resetResults

protected void resetResults()

Reset the results to the beginning.

setResults

protected void setResults(List to)

Set the results for this ResultSet to use.

setMetaData

protected void setMetaData(ResultSetMetaData rsmd)
                    throws SQLException

Set the ResultSetMetaData used for this ResultSet.

Parameters:

rsmd - the ResultSetMetaData

Throws:

SQLException - if there's a problem examining the signature

getResultColumn

protected Object getResultColumn(int index)
                          throws SQLException

Get the Object at the given result column for the current result row.

Parameters:

index - the numeric index of the column

Returns:

whatever Object is found at that column (may be null)

Throws:

SQLException - if there is not a current ResultSet row, or the index is out of bounds

toString

public String toString()

Debug routine for displaying the current row of the ResultSet.

next

public boolean next()
             throws SQLException

Seek to the next row in this ResultSet.

Returns:

true if there was another row.

Throws:

SQLException - if there's a problem seeking...or something

close

public void close()
           throws SQLException

Close the ResultSet. This currently does nothing.

Throws:

SQLException - (never)

wasNull

public boolean wasNull()
                throws SQLException

Check to see if the last column fetched was null.

Returns:

true if it was null

Throws:

SQLException - (never)

getString

public String getString(int index)
                 throws SQLException

Get the given column as a string.

Parameters:

index - the index of the column

Returns:

the String value of the column, or null

Throws:

SQLException - if misused

getBoolean

public boolean getBoolean(int index)
                   throws SQLException

Get the given value as a boolean.

Parameters:

index - the index of the column

Returns:

the boolean value of the column

Throws:

SQLException - if there's a problem getting the value

getShort

public short getShort(int index)
               throws SQLException

Throws:

SQLException

See Also:

ResultSet

getInt

public int getInt(int index)
           throws SQLException

Throws:

SQLException

See Also:

ResultSet

getLong

public long getLong(int index)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getFloat

public float getFloat(int index)
               throws SQLException

Throws:

SQLException

See Also:

ResultSet

getDouble

public double getDouble(int index)
                 throws SQLException

Throws:

SQLException

See Also:

ResultSet

getBigDecimal

public BigDecimal getBigDecimal(int index)
                         throws SQLException

Throws:

SQLException

See Also:

ResultSet

getDate

public Date getDate(int index)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getTime

public Time getTime(int index)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getTimestamp

public Timestamp getTimestamp(int index)
                       throws SQLException

Throws:

SQLException

See Also:

ResultSet

getObject

public Object getObject(int index)
                 throws SQLException

Throws:

SQLException

See Also:

ResultSet

findColumn

public int findColumn(String columnName)
               throws SQLException

Throws:

SQLException

See Also:

ResultSet

getString

public String getString(String name)
                 throws SQLException

Throws:

SQLException

See Also:

ResultSet

getBoolean

public boolean getBoolean(String name)
                   throws SQLException

Throws:

SQLException

See Also:

ResultSet

getShort

public short getShort(String name)
               throws SQLException

Throws:

SQLException

See Also:

ResultSet

getInt

public int getInt(String name)
           throws SQLException

Throws:

SQLException

See Also:

ResultSet

getLong

public long getLong(String name)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getFloat

public float getFloat(String name)
               throws SQLException

Throws:

SQLException

See Also:

ResultSet

getDouble

public double getDouble(String name)
                 throws SQLException

Throws:

SQLException

See Also:

ResultSet

getDate

public Date getDate(String name)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getTime

public Time getTime(String name)
             throws SQLException

Throws:

SQLException

See Also:

ResultSet

getTimestamp

public Timestamp getTimestamp(String name)
                       throws SQLException

Throws:

SQLException

See Also:

ResultSet

getBigDecimal

public BigDecimal getBigDecimal(String name)
                         throws SQLException

Throws:

SQLException

See Also:

ResultSet

getObject

public Object getObject(String name)
                 throws SQLException

Throws:

SQLException

See Also:

ResultSet

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Throws:

SQLException

See Also:

ResultSet

clearWarnings

public void clearWarnings()
                   throws SQLException

Throws:

SQLException

See Also:

ResultSet

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Throws:

SQLException

See Also:

ResultSet