com.codestudio.sql
Class PoolManResultSet

java.lang.Object
  |
  +--com.codestudio.sql.PoolManResultSet
All Implemented Interfaces:
java.sql.ResultSet

public class PoolManResultSet
extends java.lang.Object
implements java.sql.ResultSet

This JDBC 2.0 ResultSet implementation transforms underlying ResultSets so they can support more advanced JDBC 2.0 features (scrolling, updates, etc.).

It is implemented as an ArrayList representing the rows in a ResultSet. Each element in this ArrayList is a "row" that is in turn represented as an ArrayList of com.codestudio.sql.Result objects.

A cursor, implemented as a simple int index, indicates the current row by indicating the index of the element in the top-level ArrayList of rows.

Yet another ArrayList represents a virtual row, one that is based on the current row but is being updated. This structure is used to permanently alter the original row when updateRow() is invoked. If that method is never invoked, then the changes are discarded via the clearUpdates() method, which is invoked whenever the cursor moves.

Author:
PS Neville

Fields inherited from interface java.sql.ResultSet
CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Constructor Summary
PoolManResultSet()
           
PoolManResultSet(java.sql.Statement s, java.util.ArrayList rowlist, java.sql.ResultSetMetaData meta, int rScrollableType, int rConcurType)
           
 
Method Summary
 boolean absolute(int row)
          Move the cursor to a specific row number.
 void afterLast()
          Move the cursor one step beyond the final row.
 void beforeFirst()
          Move the cursor one step before the first row.
 void cancelRowUpdates()
          Clear the updates made to the current row.
 void clearWarnings()
           
 java.sql.ResultSet cloneSet()
           
 void close()
           
 void deleteRow()
          Delete the current row from this ResultSet AND from the database.
 int findColumn(java.lang.String colName)
          Retrieve the index of a column given its label.
 boolean first()
          Move the cursor to the first row in the ResultSet.
 java.sql.Array getArray(int i)
           
 java.sql.Array getArray(java.lang.String colName)
           
 java.io.InputStream getAsciiStream(int colIndex)
           
 java.io.InputStream getAsciiStream(java.lang.String colName)
           
 java.math.BigDecimal getBigDecimal(int colIndex)
           
 java.math.BigDecimal getBigDecimal(int colIndex, int scale)
          Deprecated.  
 java.math.BigDecimal getBigDecimal(java.lang.String colName)
           
 java.math.BigDecimal getBigDecimal(java.lang.String colName, int scale)
          Deprecated.  
 java.io.InputStream getBinaryStream(int colIndex)
           
 java.io.InputStream getBinaryStream(java.lang.String colName)
           
 java.sql.Blob getBlob(int i)
           
 java.sql.Blob getBlob(java.lang.String colName)
           
 boolean getBoolean(int colIndex)
           
 boolean getBoolean(java.lang.String colName)
           
 byte getByte(int colIndex)
           
 byte getByte(java.lang.String colName)
           
 byte[] getBytes(int colIndex)
           
 byte[] getBytes(java.lang.String colName)
           
 java.io.Reader getCharacterStream(int colIndex)
           
 java.io.Reader getCharacterStream(java.lang.String colName)
           
 java.sql.Clob getClob(int colIndex)
           
 java.sql.Clob getClob(java.lang.String colName)
           
 int getConcurrency()
           
 java.lang.String getCursorName()
          This implementation does not support named cursors.
 java.sql.Date getDate(int colIndex)
           
 java.sql.Date getDate(int colIndex, java.util.Calendar cal)
           
 java.sql.Date getDate(java.lang.String colName)
           
 java.sql.Date getDate(java.lang.String colName, java.util.Calendar cal)
           
 double getDouble(int colIndex)
           
 double getDouble(java.lang.String colName)
           
 int getFetchDirection()
           
 int getFetchSize()
           
 float getFloat(int colIndex)
           
 float getFloat(java.lang.String colName)
           
 int getInt(int colIndex)
           
 int getInt(java.lang.String colName)
           
 long getLong(int colIndex)
           
 long getLong(java.lang.String colName)
           
 java.sql.ResultSetMetaData getMetaData()
           
 java.lang.Object getObject(int colIndex)
           
 java.lang.Object getObject(int i, java.util.Map map)
          Custom UDT mapping is not supported, default Map is always used.
 java.lang.Object getObject(java.lang.String colName)
           
 java.lang.Object getObject(java.lang.String colName, java.util.Map map)
          Custom UDT mapping is not supported.
 java.sql.Ref getRef(int i)
           
 java.sql.Ref getRef(java.lang.String colName)
           
 int getRow()
           
 short getShort(int colIndex)
           
 short getShort(java.lang.String colName)
           
 java.sql.Statement getStatement()
           
 java.lang.String getString(int colIndex)
           
 java.lang.String getString(java.lang.String colName)
           
 java.sql.Time getTime(int colIndex)
           
 java.sql.Time getTime(int colIndex, java.util.Calendar cal)
           
 java.sql.Time getTime(java.lang.String colName)
           
 java.sql.Time getTime(java.lang.String colName, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(int colIndex)
           
 java.sql.Timestamp getTimestamp(int colIndex, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(java.lang.String colName)
           
 java.sql.Timestamp getTimestamp(java.lang.String colName, java.util.Calendar cal)
           
 int getType()
           
 java.io.InputStream getUnicodeStream(int colIndex)
          Deprecated.  
 java.io.InputStream getUnicodeStream(java.lang.String colName)
          Deprecated.  
 java.sql.SQLWarning getWarnings()
           
 void insertRow()
           
 boolean isAfterLast()
           
 boolean isBeforeFirst()
           
 boolean isClosed()
           
 boolean isFirst()
           
 boolean isLast()
           
 boolean last()
           
 void moveToCurrentRow()
          If currently on the insert row, this method will move the cursor back to an active row -- either the row the cursor was on before moving to the insert row or the row that the cursor was moved to while handling the insert row.
 void moveToInsertRow()
          After invoking this method, all updates and gets will be invoked on the insert row rather than the current row.
 boolean next()
           
 boolean previous()
           
 void refreshRow()
           
 boolean relative(int rows)
           
 boolean rowDeleted()
           
 boolean rowInserted()
           
 boolean rowUpdated()
           
 void setConcurrencyType(int n)
           
 void setFetchDirection(int direction)
           
 void setFetchSize(int rows)
           
 void setScrollableType(int n)
           
 void updateAsciiStream(int colIndex, java.io.InputStream x, int length)
           
 void updateAsciiStream(java.lang.String colName, java.io.InputStream x, int length)
           
 void updateBigDecimal(int colIndex, java.math.BigDecimal x)
           
 void updateBigDecimal(java.lang.String colName, java.math.BigDecimal x)
           
 void updateBinaryStream(int colIndex, java.io.InputStream x, int length)
           
 void updateBinaryStream(java.lang.String colName, java.io.InputStream x, int length)
           
 void updateBoolean(int colIndex, boolean x)
           
 void updateBoolean(java.lang.String colName, boolean x)
           
 void updateByte(int colIndex, byte x)
           
 void updateByte(java.lang.String colName, byte x)
           
 void updateBytes(int colIndex, byte[] x)
           
 void updateBytes(java.lang.String colName, byte[] x)
           
 void updateCharacterStream(int colIndex, java.io.Reader reader, int length)
           
 void updateCharacterStream(java.lang.String colName, java.io.Reader reader, int length)
           
 void updateDate(int colIndex, java.sql.Date d)
           
 void updateDate(java.lang.String colName, java.sql.Date d)
           
 void updateDouble(int colIndex, double d)
           
 void updateDouble(java.lang.String colName, double d)
           
 void updateFloat(int colIndex, float f)
           
 void updateFloat(java.lang.String colName, float f)
           
 void updateInt(int colIndex, int i)
           
 void updateInt(java.lang.String colName, int i)
           
 void updateLong(int colIndex, long l)
           
 void updateLong(java.lang.String colName, long l)
           
 void updateNull(int colIndex)
           
 void updateNull(java.lang.String colName)
           
 void updateObject(int colIndex, java.lang.Object o)
           
 void updateObject(int colIndex, java.lang.Object o, int scale)
           
 void updateObject(java.lang.String colName, java.lang.Object o)
           
 void updateObject(java.lang.String colName, java.lang.Object o, int scale)
           
 void updateRow()
          Update the row with the new Result objects in updatedResults.
 void updateShort(int colIndex, short s)
           
 void updateShort(java.lang.String colName, short s)
           
 void updateString(int colIndex, java.lang.String s)
           
 void updateString(java.lang.String colName, java.lang.String s)
           
 void updateTime(int colIndex, java.sql.Time t)
           
 void updateTime(java.lang.String colName, java.sql.Time t)
           
 void updateTimestamp(int colIndex, java.sql.Timestamp t)
           
 void updateTimestamp(java.lang.String colName, java.sql.Timestamp t)
           
 boolean wasNull()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PoolManResultSet

public PoolManResultSet()

PoolManResultSet

public PoolManResultSet(java.sql.Statement s,
                        java.util.ArrayList rowlist,
                        java.sql.ResultSetMetaData meta,
                        int rScrollableType,
                        int rConcurType)
                 throws java.sql.SQLException
Method Detail

setScrollableType

public void setScrollableType(int n)

setConcurrencyType

public void setConcurrencyType(int n)

cloneSet

public java.sql.ResultSet cloneSet()

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
Move the cursor to a specific row number. NOTE: row 1 and pos 1 == rowlist index of 0.
Specified by:
absolute in interface java.sql.ResultSet

afterLast

public void afterLast()
               throws java.sql.SQLException
Move the cursor one step beyond the final row.
Specified by:
afterLast in interface java.sql.ResultSet

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Move the cursor one step before the first row.
Specified by:
beforeFirst in interface java.sql.ResultSet

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Clear the updates made to the current row.
Specified by:
cancelRowUpdates in interface java.sql.ResultSet

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
Specified by:
clearWarnings in interface java.sql.ResultSet

close

public void close()
           throws java.sql.SQLException
Specified by:
close in interface java.sql.ResultSet

isClosed

public boolean isClosed()

deleteRow

public void deleteRow()
               throws java.sql.SQLException
Delete the current row from this ResultSet AND from the database.
Specified by:
deleteRow in interface java.sql.ResultSet

findColumn

public int findColumn(java.lang.String colName)
               throws java.sql.SQLException
Retrieve the index of a column given its label.
Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
String - The column name
Returns:
The index of the column

first

public boolean first()
              throws java.sql.SQLException
Move the cursor to the first row in the ResultSet.
Specified by:
first in interface java.sql.ResultSet
Returns:
true if the row is valid, false if the ResultSet is empty

getArray

public java.sql.Array getArray(int i)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet

getArray

public java.sql.Array getArray(java.lang.String colName)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet

getAsciiStream

public java.io.InputStream getAsciiStream(int colIndex)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String colName)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet

getBigDecimal

public java.math.BigDecimal getBigDecimal(int colIndex)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet

getBigDecimal

public java.math.BigDecimal getBigDecimal(int colIndex,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated.  

Specified by:
getBigDecimal in interface java.sql.ResultSet

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String colName)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String colName,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated.  

Specified by:
getBigDecimal in interface java.sql.ResultSet

getBinaryStream

public java.io.InputStream getBinaryStream(int colIndex)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String colName)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet

getBlob

public java.sql.Blob getBlob(int i)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet

getBlob

public java.sql.Blob getBlob(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet

getBoolean

public boolean getBoolean(int colIndex)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet

getBoolean

public boolean getBoolean(java.lang.String colName)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet

getByte

public byte getByte(int colIndex)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet

getByte

public byte getByte(java.lang.String colName)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet

getBytes

public byte[] getBytes(int colIndex)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet

getBytes

public byte[] getBytes(java.lang.String colName)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet

getCharacterStream

public java.io.Reader getCharacterStream(int colIndex)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String colName)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet

getClob

public java.sql.Clob getClob(int colIndex)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet

getClob

public java.sql.Clob getClob(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Specified by:
getConcurrency in interface java.sql.ResultSet

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
This implementation does not support named cursors. ResultSets can be easily updated without them now, so they are not necessary.
Specified by:
getCursorName in interface java.sql.ResultSet

getDate

public java.sql.Date getDate(int colIndex)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet

getDate

public java.sql.Date getDate(int colIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet

getDate

public java.sql.Date getDate(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet

getDate

public java.sql.Date getDate(java.lang.String colName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet

getDouble

public double getDouble(int colIndex)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet

getDouble

public double getDouble(java.lang.String colName)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Specified by:
getFetchDirection in interface java.sql.ResultSet

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Specified by:
getFetchSize in interface java.sql.ResultSet

getFloat

public float getFloat(int colIndex)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet

getFloat

public float getFloat(java.lang.String colName)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet

getInt

public int getInt(int colIndex)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet

getInt

public int getInt(java.lang.String colName)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet

getLong

public long getLong(int colIndex)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet

getLong

public long getLong(java.lang.String colName)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Specified by:
getMetaData in interface java.sql.ResultSet

getObject

public java.lang.Object getObject(int colIndex)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet

getObject

public java.lang.Object getObject(int i,
                                  java.util.Map map)
                           throws java.sql.SQLException
Custom UDT mapping is not supported, default Map is always used.
Specified by:
getObject in interface java.sql.ResultSet

getObject

public java.lang.Object getObject(java.lang.String colName)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet

getObject

public java.lang.Object getObject(java.lang.String colName,
                                  java.util.Map map)
                           throws java.sql.SQLException
Custom UDT mapping is not supported.
Specified by:
getObject in interface java.sql.ResultSet

getRef

public java.sql.Ref getRef(int i)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet

getRef

public java.sql.Ref getRef(java.lang.String colName)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet

getRow

public int getRow()
           throws java.sql.SQLException
Specified by:
getRow in interface java.sql.ResultSet

getShort

public short getShort(int colIndex)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet

getShort

public short getShort(java.lang.String colName)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException
Specified by:
getStatement in interface java.sql.ResultSet

getString

public java.lang.String getString(int colIndex)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet

getString

public java.lang.String getString(java.lang.String colName)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet

getTime

public java.sql.Time getTime(int colIndex)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet

getTime

public java.sql.Time getTime(int colIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet

getTime

public java.sql.Time getTime(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet

getTime

public java.sql.Time getTime(java.lang.String colName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet

getTimestamp

public java.sql.Timestamp getTimestamp(int colIndex)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet

getTimestamp

public java.sql.Timestamp getTimestamp(int colIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String colName)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String colName,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet

getType

public int getType()
            throws java.sql.SQLException
Specified by:
getType in interface java.sql.ResultSet

getUnicodeStream

public java.io.InputStream getUnicodeStream(int colIndex)
                                     throws java.sql.SQLException
Deprecated.  

Specified by:
getUnicodeStream in interface java.sql.ResultSet

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String colName)
                                     throws java.sql.SQLException
Deprecated.  

Specified by:
getUnicodeStream in interface java.sql.ResultSet

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Specified by:
getWarnings in interface java.sql.ResultSet

insertRow

public void insertRow()
               throws java.sql.SQLException
Specified by:
insertRow in interface java.sql.ResultSet

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Specified by:
isAfterLast in interface java.sql.ResultSet

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Specified by:
isBeforeFirst in interface java.sql.ResultSet

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Specified by:
isFirst in interface java.sql.ResultSet

isLast

public boolean isLast()
               throws java.sql.SQLException
Specified by:
isLast in interface java.sql.ResultSet

last

public boolean last()
             throws java.sql.SQLException
Specified by:
last in interface java.sql.ResultSet

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
If currently on the insert row, this method will move the cursor back to an active row -- either the row the cursor was on before moving to the insert row or the row that the cursor was moved to while handling the insert row. If not on the insert row, this method has no effect.
Specified by:
moveToCurrentRow in interface java.sql.ResultSet

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
After invoking this method, all updates and gets will be invoked on the insert row rather than the current row. The current row will be remembered, however, and can be recovered by invoking moveToCurrentRow().
Specified by:
moveToInsertRow in interface java.sql.ResultSet

next

public boolean next()
             throws java.sql.SQLException
Specified by:
next in interface java.sql.ResultSet

previous

public boolean previous()
                 throws java.sql.SQLException
Specified by:
previous in interface java.sql.ResultSet

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Specified by:
refreshRow in interface java.sql.ResultSet

relative

public boolean relative(int rows)
                 throws java.sql.SQLException
Specified by:
relative in interface java.sql.ResultSet

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Specified by:
rowDeleted in interface java.sql.ResultSet

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Specified by:
rowInserted in interface java.sql.ResultSet

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Specified by:
rowUpdated in interface java.sql.ResultSet

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Specified by:
setFetchDirection in interface java.sql.ResultSet

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
Specified by:
setFetchSize in interface java.sql.ResultSet

updateAsciiStream

public void updateAsciiStream(int colIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet

updateAsciiStream

public void updateAsciiStream(java.lang.String colName,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet

updateBigDecimal

public void updateBigDecimal(int colIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Specified by:
updateBigDecimal in interface java.sql.ResultSet

updateBigDecimal

public void updateBigDecimal(java.lang.String colName,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Specified by:
updateBigDecimal in interface java.sql.ResultSet

updateBinaryStream

public void updateBinaryStream(int colIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet

updateBinaryStream

public void updateBinaryStream(java.lang.String colName,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet

updateBoolean

public void updateBoolean(int colIndex,
                          boolean x)
                   throws java.sql.SQLException
Specified by:
updateBoolean in interface java.sql.ResultSet

updateBoolean

public void updateBoolean(java.lang.String colName,
                          boolean x)
                   throws java.sql.SQLException
Specified by:
updateBoolean in interface java.sql.ResultSet

updateByte

public void updateByte(int colIndex,
                       byte x)
                throws java.sql.SQLException
Specified by:
updateByte in interface java.sql.ResultSet

updateByte

public void updateByte(java.lang.String colName,
                       byte x)
                throws java.sql.SQLException
Specified by:
updateByte in interface java.sql.ResultSet

updateBytes

public void updateBytes(int colIndex,
                        byte[] x)
                 throws java.sql.SQLException
Specified by:
updateBytes in interface java.sql.ResultSet

updateBytes

public void updateBytes(java.lang.String colName,
                        byte[] x)
                 throws java.sql.SQLException
Specified by:
updateBytes in interface java.sql.ResultSet

updateCharacterStream

public void updateCharacterStream(int colIndex,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet

updateCharacterStream

public void updateCharacterStream(java.lang.String colName,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet

updateDate

public void updateDate(int colIndex,
                       java.sql.Date d)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet

updateDate

public void updateDate(java.lang.String colName,
                       java.sql.Date d)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet

updateDouble

public void updateDouble(int colIndex,
                         double d)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet

updateDouble

public void updateDouble(java.lang.String colName,
                         double d)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet

updateFloat

public void updateFloat(int colIndex,
                        float f)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet

updateFloat

public void updateFloat(java.lang.String colName,
                        float f)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet

updateInt

public void updateInt(int colIndex,
                      int i)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet

updateInt

public void updateInt(java.lang.String colName,
                      int i)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet

updateLong

public void updateLong(int colIndex,
                       long l)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet

updateLong

public void updateLong(java.lang.String colName,
                       long l)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet

updateNull

public void updateNull(int colIndex)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet

updateNull

public void updateNull(java.lang.String colName)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet

updateObject

public void updateObject(int colIndex,
                         java.lang.Object o)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet

updateObject

public void updateObject(int colIndex,
                         java.lang.Object o,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet

updateObject

public void updateObject(java.lang.String colName,
                         java.lang.Object o)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet

updateObject

public void updateObject(java.lang.String colName,
                         java.lang.Object o,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet

updateRow

public void updateRow()
               throws java.sql.SQLException
Update the row with the new Result objects in updatedResults. Also update the database and the SQLCache.
Specified by:
updateRow in interface java.sql.ResultSet

updateShort

public void updateShort(int colIndex,
                        short s)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet

updateShort

public void updateShort(java.lang.String colName,
                        short s)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet

updateString

public void updateString(int colIndex,
                         java.lang.String s)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet

updateString

public void updateString(java.lang.String colName,
                         java.lang.String s)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet

updateTime

public void updateTime(int colIndex,
                       java.sql.Time t)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet

updateTime

public void updateTime(java.lang.String colName,
                       java.sql.Time t)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet

updateTimestamp

public void updateTimestamp(int colIndex,
                            java.sql.Timestamp t)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet

updateTimestamp

public void updateTimestamp(java.lang.String colName,
                            java.sql.Timestamp t)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Specified by:
wasNull in interface java.sql.ResultSet


Copyright © 1999-2001 The Code Studio. All Rights Reserved.