com.ricebridge.xmlman.in
Class XmlResultSet

java.lang.Object
  extended bycom.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.



Copyright © 2004-2005 Ricebridge