com.ricebridge.xmlman.in
Class XmlResultSet

java.lang.Object
  com.ricebridge.xmlman.in.XmlResultSet

All Implemented Interfaces:

ResultSet

public class XmlResultSet

extends Object

implements ResultSet

Implementation of a ResultSet to present XML data.

This ResultSet provides much the same interface as a database ResultSet. This implementation assumes that your data is fairly well behaved and attempts direct data type conversions for methods like getInt(java.lang.String). Bad data will cause an exception to be thrown. Refer to ResultSet for method documentation if none is given here.

NOTE: in order to reuse the

The Source Code of this Java class is available under a BSD-style license.

Field Summary

protected ArrayList	iData Data as a List of String[] arrays.
protected boolean	iDataHasHeaders The first line of the CSV file may contain headers.
protected DateFormat	iDateFormat Default data format for date parsing.
protected boolean	iHeadersStored Flag to indicate that headers have been loaded.
protected String[]	iRecord Current data record.
protected long	iRecordIndex index of current record.
protected XmlResultSetMetaData	iXmlRSMD ResultSetMetaData provider

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

XmlResultSet()
Support Class.newInstance() object instantiation.

XmlResultSet(List pData)
Create a new ResultSet with specified a List of String[] arrays.

Method Summary

boolean	absolute(int pRow)
void	addRecord(String[] pRecord) Set data for ResultSet.
void	afterLast()
void	beforeFirst()
void	cancelRowUpdates()
void	clear() Remove all data rows.
void	clearWarnings()
void	close()
void	deleteRow()
int	findColumn(String pColumnName)
boolean	first()
Array	getArray(int pIndex)
Array	getArray(String pColName)
InputStream	getAsciiStream(int pColumnIndex)
InputStream	getAsciiStream(String pColumnName)
BigDecimal	getBigDecimal(int pColumnIndex)
BigDecimal	getBigDecimal(int pColumnIndex, int pScale)
BigDecimal	getBigDecimal(String pColumnName)
BigDecimal	getBigDecimal(String pColumnName, int pScale)
InputStream	getBinaryStream(int pColumnIndex)
InputStream	getBinaryStream(String pColumnName)
Blob	getBlob(int pIndex)
Blob	getBlob(String pColName)
boolean	getBoolean(int pColumnIndex)
boolean	getBoolean(String pColumnName)
byte	getByte(int pColumnIndex)
byte	getByte(String pColumnName)
byte[]	getBytes(int pColumnIndex)
byte[]	getBytes(String pColumnName)
Reader	getCharacterStream(int pColumnIndex)
Reader	getCharacterStream(String pColumnName)
Clob	getClob(int pIndex)
Clob	getClob(String pColName)
int	getConcurrency()
String	getCursorName()
Date	getDate(int pColumnIndex)
Date	getDate(int pColumnIndex, Calendar pCalendar) ignores Calendar
Date	getDate(String pColumnName)
Date	getDate(String pColumnName, Calendar pCalendar)
double	getDouble(int pColumnIndex)
double	getDouble(String pColumnName)
int	getFetchDirection()
int	getFetchSize()
float	getFloat(int pColumnIndex)
float	getFloat(String pColumnName)
int	getInt(int pColumnIndex)
int	getInt(String pColumnName)
long	getLong(int pColumnIndex)
long	getLong(String pColumnName)
ResultSetMetaData	getMetaData()
Object	getObject(int pColumnIndex)
Object	getObject(int pIndex, Map pMap)
Object	getObject(String pColumnName)
Object	getObject(String pColName, Map pMap)
Ref	getRef(int pIndex)
Ref	getRef(String pColName)
int	getRow()
int	getRowCount() Get the number of rows.
short	getShort(int pColumnIndex)
short	getShort(String pColumnName)
Statement	getStatement()
String	getString(int pColumnIndex)
String	getString(String pColumnName)
Time	getTime(int pColumnIndex)
Time	getTime(int pColumnIndex, Calendar pCalendar) Note: ignores Calendar.
Time	getTime(String pColumnName)
Time	getTime(String pColumnName, Calendar pCalendar)
Timestamp	getTimestamp(int pColumnIndex)
Timestamp	getTimestamp(int pColumnIndex, Calendar pCalendar) Note: ignores Calendar.
Timestamp	getTimestamp(String pColumnName)
Timestamp	getTimestamp(String pColumnName, Calendar pCalendar)
int	getType()
InputStream	getUnicodeStream(int pColumnIndex)
InputStream	getUnicodeStream(String pColumnName)
URL	getURL(int pColumnIndex)
URL	getURL(String pColumnName)
SQLWarning	getWarnings()
void	init() Initialise the internal data containers before loading new XML record data.
void	insertRow()
boolean	isAfterLast()
boolean	isBeforeFirst()
boolean	isFirst()
boolean	isLast()
boolean	last()
void	moveToCurrentRow()
void	moveToInsertRow()
protected boolean	moveToLine() Move to correct data line.
boolean	next()
boolean	previous()
void	refreshRow()
boolean	relative(int pRows)
boolean	rowDeleted()
boolean	rowInserted()
boolean	rowUpdated()
void	setDataHasHeaders(boolean pDataHasHeaders) The first record contains the column names.
void	setDateFormat(DateFormat pDateFormat) Specify custom date format.
void	setFetchDirection(int pDirection)
void	setFetchSize(int pRows)
void	setHeaders(String[] pHeaders) Set the column header names.
String	toString() String description of object instance.
void	updateArray(int pColumnIndex, Array pArray)
void	updateArray(String pColumnName, Array pArray)
void	updateAsciiStream(int pColumnIndex, InputStream pInputStream, int pLength)
void	updateAsciiStream(String pColumnName, InputStream pInputStream, int pLength)
void	updateBigDecimal(int pColumnIndex, BigDecimal pBigDecimal)
void	updateBigDecimal(String pColumnName, BigDecimal pBigDecimal)
void	updateBinaryStream(int pColumnIndex, InputStream pInputStream, int pLength)
void	updateBinaryStream(String pColumnName, InputStream pInputStream, int pLength)
void	updateBlob(int pColumnIndex, Blob pBlob)
void	updateBlob(String pColumnName, Blob pBlob)
void	updateBoolean(int pColumnIndex, boolean pValue)
void	updateBoolean(String pColumnName, boolean pValue)
void	updateByte(int pColumnIndex, byte pValue)
void	updateByte(String pColumnName, byte pValue)
void	updateBytes(int pColumnIndex, byte[] pBytes)
void	updateBytes(String pColumnName, byte[] pBytes)
void	updateCharacterStream(int pColumnIndex, Reader pReader, int pLength)
void	updateCharacterStream(String pColumnName, Reader pReader, int pLength)
void	updateClob(int pColumnIndex, Clob pValue)
void	updateClob(String pColumnName, Clob pValue)
void	updateDate(int pColumnIndex, Date pValue)
void	updateDate(String pColumnName, Date pValue)
void	updateDouble(int pColumnIndex, double pValue)
void	updateDouble(String pColumnName, double pValue)
void	updateFloat(int pColumnIndex, float pValue)
void	updateFloat(String pColumnName, float pValue)
void	updateInt(int pColumnIndex, int pValue)
void	updateInt(String pColumnName, int pValue)
void	updateLong(int pColumnIndex, long pValue)
void	updateLong(String pColumnName, long pValue)
void	updateNull(int pColumnIndex)
void	updateNull(String pColumnName)
void	updateObject(int pColumnIndex, Object pValue)
void	updateObject(int pColumnIndex, Object pValue, int pScale)
void	updateObject(String pColumnName, Object pValue)
void	updateObject(String pColumnName, Object pValue, int pScale)
void	updateRef(int pColumnIndex, Ref pValue)
void	updateRef(String pColumnName, Ref pValue)
void	updateRow()
void	updateShort(int pColumnIndex, short pValue)
void	updateShort(String pColumnName, short pValue)
void	updateString(int pColumnIndex, String pValue)
void	updateString(String pColumnName, String pValue)
void	updateTime(int pColumnIndex, Time pValue)
void	updateTime(String pColumnName, Time pValue)
void	updateTimestamp(int pColumnIndex, Timestamp pValue)
void	updateTimestamp(String pColumnName, Timestamp pValue)
boolean	wasNull()

Methods inherited from class java.lang.Object

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

Field Detail

iData

protected ArrayList iData

Data as a List of String[] arrays.

iRecord

protected String[] iRecord

Current data record.

iRecordIndex

protected long iRecordIndex

index of current record.

iDateFormat

protected DateFormat iDateFormat

Default data format for date parsing.

iXmlRSMD

protected XmlResultSetMetaData iXmlRSMD

ResultSetMetaData provider

iDataHasHeaders

protected boolean iDataHasHeaders

The first line of the CSV file may contain headers.

iHeadersStored

protected boolean iHeadersStored

Flag to indicate that headers have been loaded.

Constructor Detail

XmlResultSet

public XmlResultSet()

Support Class.newInstance() object instantiation.

XmlResultSet

public XmlResultSet(List pData)

Create a new ResultSet with specified a List of String[] arrays.

Method Detail

getArray

public Array getArray(String pColName)
               throws SQLException

Specified by:

getArray in interface ResultSet

Throws:

SQLException

getArray

public Array getArray(int pIndex)
               throws SQLException

Specified by:

getArray in interface ResultSet

Throws:

SQLException

getBlob

public Blob getBlob(String pColName)
             throws SQLException

Specified by:

getBlob in interface ResultSet

Throws:

SQLException

getBlob

public Blob getBlob(int pIndex)
             throws SQLException

Specified by:

getBlob in interface ResultSet

Throws:

SQLException

getClob

public Clob getClob(String pColName)
             throws SQLException

Specified by:

getClob in interface ResultSet

Throws:

SQLException

getClob

public Clob getClob(int pIndex)
             throws SQLException

Specified by:

getClob in interface ResultSet

Throws:

SQLException

getObject

public Object getObject(String pColName,
                        Map pMap)
                 throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

public Object getObject(int pIndex,
                        Map pMap)
                 throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getRef

public Ref getRef(String pColName)
           throws SQLException

Specified by:

getRef in interface ResultSet

Throws:

SQLException

getRef

public Ref getRef(int pIndex)
           throws SQLException

Specified by:

getRef in interface ResultSet

Throws:

SQLException

getStatement

public Statement getStatement()
                       throws SQLException

Specified by:

getStatement in interface ResultSet

Throws:

SQLException

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Specified by:

getWarnings in interface ResultSet

Throws:

SQLException

getCursorName

public String getCursorName()
                     throws SQLException

Specified by:

getCursorName in interface ResultSet

Throws:

SQLException

rowDeleted

public boolean rowDeleted()
                   throws SQLException

Specified by:

rowDeleted in interface ResultSet

Throws:

SQLException

rowInserted

public boolean rowInserted()
                    throws SQLException

Specified by:

rowInserted in interface ResultSet

Throws:

SQLException

rowUpdated

public boolean rowUpdated()
                   throws SQLException

Specified by:

rowUpdated in interface ResultSet

Throws:

SQLException

wasNull

public boolean wasNull()
                throws SQLException

Specified by:

wasNull in interface ResultSet

Throws:

SQLException

getFetchDirection

public int getFetchDirection()
                      throws SQLException

Specified by:

getFetchDirection in interface ResultSet

Throws:

SQLException

setFetchDirection

public void setFetchDirection(int pDirection)
                       throws SQLException

Specified by:

setFetchDirection in interface ResultSet

Throws:

SQLException

getFetchSize

public int getFetchSize()
                 throws SQLException

Specified by:

getFetchSize in interface ResultSet

Throws:

SQLException

setFetchSize

public void setFetchSize(int pRows)
                  throws SQLException

Specified by:

setFetchSize in interface ResultSet

Throws:

SQLException

getConcurrency

public int getConcurrency()
                   throws SQLException

Specified by:

getConcurrency in interface ResultSet

Throws:

SQLException

cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException

Specified by:

cancelRowUpdates in interface ResultSet

Throws:

SQLException

clearWarnings

public void clearWarnings()
                   throws SQLException

Specified by:

clearWarnings in interface ResultSet

Throws:

SQLException

close

public void close()
           throws SQLException

Specified by:

close in interface ResultSet

Throws:

SQLException

deleteRow

public void deleteRow()
               throws SQLException

Specified by:

deleteRow in interface ResultSet

Throws:

SQLException

insertRow

public void insertRow()
               throws SQLException

Specified by:

insertRow in interface ResultSet

Throws:

SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException

Specified by:

moveToCurrentRow in interface ResultSet

Throws:

SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException

Specified by:

moveToInsertRow in interface ResultSet

Throws:

SQLException

refreshRow

public void refreshRow()
                throws SQLException

Specified by:

refreshRow in interface ResultSet

Throws:

SQLException

updateArray

public void updateArray(String pColumnName,
                        Array pArray)
                 throws SQLException

Specified by:

updateArray in interface ResultSet

Throws:

SQLException

updateArray

public void updateArray(int pColumnIndex,
                        Array pArray)
                 throws SQLException

Specified by:

updateArray in interface ResultSet

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(String pColumnName,
                              InputStream pInputStream,
                              int pLength)
                       throws SQLException

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(int pColumnIndex,
                              InputStream pInputStream,
                              int pLength)
                       throws SQLException

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateBigDecimal

public void updateBigDecimal(String pColumnName,
                             BigDecimal pBigDecimal)
                      throws SQLException

Specified by:

updateBigDecimal in interface ResultSet

Throws:

SQLException

updateBigDecimal

public void updateBigDecimal(int pColumnIndex,
                             BigDecimal pBigDecimal)
                      throws SQLException

Specified by:

updateBigDecimal in interface ResultSet

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(String pColumnName,
                               InputStream pInputStream,
                               int pLength)
                        throws SQLException

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(int pColumnIndex,
                               InputStream pInputStream,
                               int pLength)
                        throws SQLException

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(String pColumnName,
                       Blob pBlob)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(int pColumnIndex,
                       Blob pBlob)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBoolean

public void updateBoolean(String pColumnName,
                          boolean pValue)
                   throws SQLException

Specified by:

updateBoolean in interface ResultSet

Throws:

SQLException

updateBoolean

public void updateBoolean(int pColumnIndex,
                          boolean pValue)
                   throws SQLException

Specified by:

updateBoolean in interface ResultSet

Throws:

SQLException

updateByte

public void updateByte(String pColumnName,
                       byte pValue)
                throws SQLException

Specified by:

updateByte in interface ResultSet

Throws:

SQLException

updateByte

public void updateByte(int pColumnIndex,
                       byte pValue)
                throws SQLException

Specified by:

updateByte in interface ResultSet

Throws:

SQLException

updateBytes

public void updateBytes(String pColumnName,
                        byte[] pBytes)
                 throws SQLException

Specified by:

updateBytes in interface ResultSet

Throws:

SQLException

updateBytes

public void updateBytes(int pColumnIndex,
                        byte[] pBytes)
                 throws SQLException

Specified by:

updateBytes in interface ResultSet

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(String pColumnName,
                                  Reader pReader,
                                  int pLength)
                           throws SQLException

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(int pColumnIndex,
                                  Reader pReader,
                                  int pLength)
                           throws SQLException

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(String pColumnName,
                       Clob pValue)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(int pColumnIndex,
                       Clob pValue)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateDate

public void updateDate(String pColumnName,
                       Date pValue)
                throws SQLException

Specified by:

updateDate in interface ResultSet

Throws:

SQLException

updateDate

public void updateDate(int pColumnIndex,
                       Date pValue)
                throws SQLException

Specified by:

updateDate in interface ResultSet

Throws:

SQLException

updateDouble

public void updateDouble(String pColumnName,
                         double pValue)
                  throws SQLException

Specified by:

updateDouble in interface ResultSet

Throws:

SQLException

updateDouble

public void updateDouble(int pColumnIndex,
                         double pValue)
                  throws SQLException

Specified by:

updateDouble in interface ResultSet

Throws:

SQLException

updateFloat

public void updateFloat(String pColumnName,
                        float pValue)
                 throws SQLException

Specified by:

updateFloat in interface ResultSet

Throws:

SQLException

updateFloat

public void updateFloat(int pColumnIndex,
                        float pValue)
                 throws SQLException

Specified by:

updateFloat in interface ResultSet

Throws:

SQLException

updateInt

public void updateInt(String pColumnName,
                      int pValue)
               throws SQLException

Specified by:

updateInt in interface ResultSet

Throws:

SQLException

updateInt

public void updateInt(int pColumnIndex,
                      int pValue)
               throws SQLException

Specified by:

updateInt in interface ResultSet

Throws:

SQLException

updateLong

public void updateLong(String pColumnName,
                       long pValue)
                throws SQLException

Specified by:

updateLong in interface ResultSet

Throws:

SQLException

updateLong

public void updateLong(int pColumnIndex,
                       long pValue)
                throws SQLException

Specified by:

updateLong in interface ResultSet

Throws:

SQLException

updateNull

public void updateNull(String pColumnName)
                throws SQLException

Specified by:

updateNull in interface ResultSet

Throws:

SQLException

updateNull

public void updateNull(int pColumnIndex)
                throws SQLException

Specified by:

updateNull in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(String pColumnName,
                         Object pValue)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(String pColumnName,
                         Object pValue,
                         int pScale)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(int pColumnIndex,
                         Object pValue)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(int pColumnIndex,
                         Object pValue,
                         int pScale)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateRef

public void updateRef(String pColumnName,
                      Ref pValue)
               throws SQLException

Specified by:

updateRef in interface ResultSet

Throws:

SQLException

updateRef

public void updateRef(int pColumnIndex,
                      Ref pValue)
               throws SQLException

Specified by:

updateRef in interface ResultSet

Throws:

SQLException

updateRow

public void updateRow()
               throws SQLException

Specified by:

updateRow in interface ResultSet

Throws:

SQLException

updateShort

public void updateShort(String pColumnName,
                        short pValue)
                 throws SQLException

Specified by:

updateShort in interface ResultSet

Throws:

SQLException

updateShort

public void updateShort(int pColumnIndex,
                        short pValue)
                 throws SQLException

Specified by:

updateShort in interface ResultSet

Throws:

SQLException

updateString

public void updateString(String pColumnName,
                         String pValue)
                  throws SQLException

Specified by:

updateString in interface ResultSet

Throws:

SQLException

updateString

public void updateString(int pColumnIndex,
                         String pValue)
                  throws SQLException

Specified by:

updateString in interface ResultSet

Throws:

SQLException

updateTime

public void updateTime(String pColumnName,
                       Time pValue)
                throws SQLException

Specified by:

updateTime in interface ResultSet

Throws:

SQLException

updateTime

public void updateTime(int pColumnIndex,
                       Time pValue)
                throws SQLException

Specified by:

updateTime in interface ResultSet

Throws:

SQLException

updateTimestamp

public void updateTimestamp(String pColumnName,
                            Timestamp pValue)
                     throws SQLException

Specified by:

updateTimestamp in interface ResultSet

Throws:

SQLException

updateTimestamp

public void updateTimestamp(int pColumnIndex,
                            Timestamp pValue)
                     throws SQLException

Specified by:

updateTimestamp in interface ResultSet

Throws:

SQLException

init

public void init()

Initialise the internal data containers before loading new XML record data.

setDataHasHeaders

public void setDataHasHeaders(boolean pDataHasHeaders)

The first record contains the column names.

Parameters:

pDataHasHeaders - flag headers in data

setHeaders

public void setHeaders(String[] pHeaders)

Set the column header names.

Parameters:

pHeaders - field names are used as column header names

addRecord

public void addRecord(String[] pRecord)

Set data for ResultSet.

Parameters:

pRecord - data record

getRowCount

public int getRowCount()

Get the number of rows.

setDateFormat

public void setDateFormat(DateFormat pDateFormat)

Specify custom date format.

Parameters:

pDateFormat - custom data format

clear

public void clear()

Remove all data rows.

toString

public String toString()

String description of object instance.

getType

public int getType()
            throws SQLException

Specified by:

getType in interface ResultSet

Throws:

SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Specified by:

getMetaData in interface ResultSet

Throws:

SQLException

findColumn

public int findColumn(String pColumnName)
               throws SQLException

Specified by:

findColumn in interface ResultSet

Throws:

SQLException

absolute

public boolean absolute(int pRow)
                 throws SQLException

Specified by:

absolute in interface ResultSet

Throws:

SQLException

first

public boolean first()
              throws SQLException

Specified by:

first in interface ResultSet

Throws:

SQLException

last

public boolean last()
             throws SQLException

Specified by:

last in interface ResultSet

Throws:

SQLException

isAfterLast

public boolean isAfterLast()
                    throws SQLException

Specified by:

isAfterLast in interface ResultSet

Throws:

SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws SQLException

Specified by:

isBeforeFirst in interface ResultSet

Throws:

SQLException

isFirst

public boolean isFirst()
                throws SQLException

Specified by:

isFirst in interface ResultSet

Throws:

SQLException

isLast

public boolean isLast()
               throws SQLException

Specified by:

isLast in interface ResultSet

Throws:

SQLException

next

public boolean next()
             throws SQLException

Specified by:

next in interface ResultSet

Throws:

SQLException

previous

public boolean previous()
                 throws SQLException

Specified by:

previous in interface ResultSet

Throws:

SQLException

relative

public boolean relative(int pRows)
                 throws SQLException

Specified by:

relative in interface ResultSet

Throws:

SQLException

getRow

public int getRow()
           throws SQLException

Specified by:

getRow in interface ResultSet

Throws:

SQLException

afterLast

public void afterLast()
               throws SQLException

Specified by:

afterLast in interface ResultSet

Throws:

SQLException

beforeFirst

public void beforeFirst()
                 throws SQLException

Specified by:

beforeFirst in interface ResultSet

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(String pColumnName)
                         throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(String pColumnName,
                                int pScale)
                         throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(int pColumnIndex)
                         throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(int pColumnIndex,
                                int pScale)
                         throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getObject

public Object getObject(String pColumnName)
                 throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

public Object getObject(int pColumnIndex)
                 throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getString

public String getString(String pColumnName)
                 throws SQLException

Specified by:

getString in interface ResultSet

Throws:

SQLException

getString

public String getString(int pColumnIndex)
                 throws SQLException

Specified by:

getString in interface ResultSet

Throws:

SQLException

getBoolean

public boolean getBoolean(String pColumnName)
                   throws SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

SQLException

getBoolean

public boolean getBoolean(int pColumnIndex)
                   throws SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

SQLException

getByte

public byte getByte(String pColumnName)
             throws SQLException

Specified by:

getByte in interface ResultSet

Throws:

SQLException

getByte

public byte getByte(int pColumnIndex)
             throws SQLException

Specified by:

getByte in interface ResultSet

Throws:

SQLException

getBytes

public byte[] getBytes(String pColumnName)
                throws SQLException

Specified by:

getBytes in interface ResultSet

Throws:

SQLException

getBytes

public byte[] getBytes(int pColumnIndex)
                throws SQLException

Specified by:

getBytes in interface ResultSet

Throws:

SQLException

getDouble

public double getDouble(String pColumnName)
                 throws SQLException

Specified by:

getDouble in interface ResultSet

Throws:

SQLException

getDouble

public double getDouble(int pColumnIndex)
                 throws SQLException

Specified by:

getDouble in interface ResultSet

Throws:

SQLException

getFloat

public float getFloat(String pColumnName)
               throws SQLException

Specified by:

getFloat in interface ResultSet

Throws:

SQLException

getFloat

public float getFloat(int pColumnIndex)
               throws SQLException

Specified by:

getFloat in interface ResultSet

Throws:

SQLException

getInt

public int getInt(String pColumnName)
           throws SQLException

Specified by:

getInt in interface ResultSet

Throws:

SQLException

getInt

public int getInt(int pColumnIndex)
           throws SQLException

Specified by:

getInt in interface ResultSet

Throws:

SQLException

getAsciiStream

public InputStream getAsciiStream(String pColumnName)
                           throws SQLException

Specified by:

getAsciiStream in interface ResultSet

Throws:

SQLException

getAsciiStream

public InputStream getAsciiStream(int pColumnIndex)
                           throws SQLException

Specified by:

getAsciiStream in interface ResultSet

Throws:

SQLException

getBinaryStream

public InputStream getBinaryStream(String pColumnName)
                            throws SQLException

Specified by:

getBinaryStream in interface ResultSet

Throws:

SQLException

getBinaryStream

public InputStream getBinaryStream(int pColumnIndex)
                            throws SQLException

Specified by:

getBinaryStream in interface ResultSet

Throws:

SQLException

getUnicodeStream

public InputStream getUnicodeStream(String pColumnName)
                             throws SQLException

Specified by:

getUnicodeStream in interface ResultSet

Throws:

SQLException

getUnicodeStream

public InputStream getUnicodeStream(int pColumnIndex)
                             throws SQLException

Specified by:

getUnicodeStream in interface ResultSet

Throws:

SQLException

getCharacterStream

public Reader getCharacterStream(String pColumnName)
                          throws SQLException

Specified by:

getCharacterStream in interface ResultSet

Throws:

SQLException

getCharacterStream

public Reader getCharacterStream(int pColumnIndex)
                          throws SQLException

Specified by:

getCharacterStream in interface ResultSet

Throws:

SQLException

getURL

public URL getURL(String pColumnName)
           throws SQLException

Specified by:

getURL in interface ResultSet

Throws:

SQLException

getURL

public URL getURL(int pColumnIndex)
           throws SQLException

Specified by:

getURL in interface ResultSet

Throws:

SQLException

getDate

public Date getDate(String pColumnName)
             throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

public Date getDate(String pColumnName,
                    Calendar pCalendar)
             throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

public Date getDate(int pColumnIndex)
             throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

public Date getDate(int pColumnIndex,
                    Calendar pCalendar)
             throws SQLException

ignores Calendar

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getTime

public Time getTime(String pColumnName)
             throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

public Time getTime(String pColumnName,
                    Calendar pCalendar)
             throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

public Time getTime(int pColumnIndex)
             throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

public Time getTime(int pColumnIndex,
                    Calendar pCalendar)
             throws SQLException

Note: ignores Calendar.

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(String pColumnName)
                       throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(String pColumnName,
                              Calendar pCalendar)
                       throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(int pColumnIndex)
                       throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(int pColumnIndex,
                              Calendar pCalendar)
                       throws SQLException

Note: ignores Calendar.

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getLong

public long getLong(String pColumnName)
             throws SQLException

Specified by:

getLong in interface ResultSet

Throws:

SQLException

getLong

public long getLong(int pColumnIndex)
             throws SQLException

Specified by:

getLong in interface ResultSet

Throws:

SQLException

getShort

public short getShort(String pColumnName)
               throws SQLException

Specified by:

getShort in interface ResultSet

Throws:

SQLException

getShort

public short getShort(int pColumnIndex)
               throws SQLException

Specified by:

getShort in interface ResultSet

Throws:

SQLException

moveToLine

protected boolean moveToLine()

Move to correct data line.