com.stc.connector.appconn.db
Interface ResultSetAgent


public interface ResultSetAgent

Agent hosts ResultSet interface


Method Summary
 boolean absolute(int index)
          Moves the cursor to the specified row of the result set.
 void afterLast()
          Moves the cursor after the last row of the result set.
 void beforeFirst()
          Moves the cursor before the first row of the result set.
 void cancelRowUpdates()
          Rolls back the updates made to a row if it is invoked before calling the method updateRow.
 void clearWarnings()
          Clears any warnings reported on this object.
 void close()
          Immediately releases a ResultSet object's resources.
 void deleteRow()
          Deletes the current row from the result set and the underlying database.
 int findColumn(java.lang.String index)
          Returns the column index for the named column in the result set.
 boolean first()
          Moves the cursor to the first row of the result set.
 java.sql.Array getArray(int index)
          Gets the Array value of the specified column.
 java.sql.Array getArray(java.lang.String index)
          Gets the Array value of the specified column.
 java.io.InputStream getAsciiStream(int index)
          Retrieves the value of the specified column value as a stream of ASCII characters.
 java.io.InputStream getAsciiStream(java.lang.String index)
          Retrieves the value of the specified column as a stream of ASCII characters.
 java.math.BigDecimal getBigDecimal(int index)
          Gets the decimal value of the specified column..
 java.math.BigDecimal getBigDecimal(java.lang.String index)
          Gets the decimal value of the specified column.
 java.io.InputStream getBinaryStream(int index)
          Retrieves the value of the specified column as a stream of un-interpreted bytes.
 java.io.InputStream getBinaryStream(java.lang.String index)
          Retrieves the value of the specified column as a stream of un-interpreted bytes.
 java.sql.Blob getBlob(int index)
          Gets the Blob value of the specified column.
 java.sql.Blob getBlob(java.lang.String index)
          Gets the Blob value of the specified column.
 boolean getBoolean(int index)
          Gets the boolean value of the specified column.
 boolean getBoolean(java.lang.String index)
          Gets the boolean value of the specified column.
 byte getByte(int index)
          Gets the byte value of the specified column.
 byte getByte(java.lang.String index)
          Gets the byte value of the specified column.
 byte[] getBytes(int index)
          Gets the byte array value of the specified column.
 byte[] getBytes(java.lang.String index)
          Gets the byte array value of the specified column.
 java.io.Reader getCharacterStream(int index)
          Retrieves the value of the specified column as a Reader object.
 java.io.Reader getCharacterStream(java.lang.String index)
          Retrieves the value of the specified column as a Reader object.
 java.sql.Clob getClob(int index)
          Gets the Clob value of the specified column.
 java.sql.Clob getClob(java.lang.String index)
          Gets the Clob value of the specified column.
 int getConcurrency()
          Gets the concurrency mode for this ResultSet object.
 java.lang.String getCursorName()
          Retrieves the name for the cursor associated with this ResultSet object.
 java.sql.Date getDate(int index)
          Gets the date value of the specified column.
 java.sql.Date getDate(int index, java.util.Calendar calendar)
          Gets the date value of the specified column using the time zone from calendar.
 java.sql.Date getDate(java.lang.String index)
          Gets the date value of the specified column.
 java.sql.Date getDate(java.lang.String index, java.util.Calendar calendar)
          Gets the date value of the specified column using the time zone from calendar.
 double getDouble(int index)
          Gets the double value of the specified column..
 double getDouble(java.lang.String index)
          Gets the double value of the specified column.
 int getFetchDirection()
          Gets the direction suggested to the driver as the row fetch direction.
 int getFetchSize()
          Gets the number of rows to fetch suggested to the driver
 float getFloat(int index)
          Gets the float value of the specified column..
 float getFloat(java.lang.String index)
          Gets the float value of the specified column..
 int getInt(int index)
          Gets the integer value of the specified column.
 int getInt(java.lang.String index)
          Gets the integer value of the specified column.
 long getLong(int index)
          Gets the long value of the specified column.
 long getLong(java.lang.String index)
          Gets the long value of the specified column.
 java.sql.ResultSetMetaData getMetaData()
          Retrieves a ResultSetMetaData object that contains ResultSet proprieties.
 java.lang.Object getObject(int index)
          Gets the object value of the specified column.
 java.lang.Object getObject(int index, java.util.Map map)
          Gets the object value of the specified column using the given type map.
 java.lang.Object getObject(java.lang.String index)
          Gets the object value of the specified column.
 java.lang.Object getObject(java.lang.String index, java.util.Map map)
          Gets the object value of the specified column using the given type map.
 java.sql.Ref getRef(int index)
          Gets the Ref value of the specified column.
 java.sql.Ref getRef(java.lang.String index)
          Gets the Ref value of the specified column..
 int getRow()
          Retrieves the current row number in the result set.
 short getShort(int index)
          Gets the short value of the specified column.
 short getShort(java.lang.String index)
          Gets the short value of the specified column.
 java.lang.String getString(int index)
          Gets the string value of the specified column.
 java.lang.String getString(java.lang.String index)
          Gets the string value of the specified column.
 java.sql.Time getTime(int index)
          Gets the time value of the specified column.
 java.sql.Time getTime(int index, java.util.Calendar calendar)
          Gets the time value of the specified column using the time zone from calendar.
 java.sql.Time getTime(java.lang.String index)
          Gets the time value of the specified column.
 java.sql.Time getTime(java.lang.String index, java.util.Calendar calendar)
          Gets the time value of the specified column using the time zone from calendar.
 java.sql.Timestamp getTimestamp(int index)
          Gets the timestamp value of the specified column.
 java.sql.Timestamp getTimestamp(int index, java.util.Calendar calendar)
          Gets the timestamp value of the specified column using the time zone from calendar.
 java.sql.Timestamp getTimestamp(java.lang.String index)
          Gets the timestamp value of the specified column.
 java.sql.Timestamp getTimestamp(java.lang.String index, java.util.Calendar calendar)
          Gets the timestamp value of the specified column using the time zone from calendar.
 int getType()
          Retrieves the scroll type of cursor associated with the result set.
 java.sql.SQLWarning getWarnings()
          Gets the first SQLWarning that has been reported for this object..
 void insertRow()
          Inserts the contents of the insert row into the result set and the database.
 boolean isAfterLast()
          Determines whether the cursor is after the last row of the result set.
 boolean isBeforeFirst()
          Determines whether the cursor is before the first row of the result set.
 boolean isFirst()
          Determines whether the cursor is on the first row of the result set.
 boolean isLast()
          Determines whether the cursor is on the last row of the result set.
 boolean last()
          Moves the cursor to the last row of the result set.
 void moveToCurrentRow()
          Moves the cursor to the remembered cursor position in the result set before it was moved to the insert row.
 void moveToInsertRow()
          Moves the cursor to the insert row that associated with an updatable result set.
 boolean next()
          Moves the cursor to the next row of the result set.
 boolean previous()
          Moves the cursor to the previous row of the result set.
 java.lang.String queryName()
          Supplies the name of the listener.
 void refreshRow()
          Replaces the values int the current row of the result set with their current values in the database
 boolean relative(int index)
          Moves the cursor to the specified row relative to current row of the result set.
 boolean rowDeleted()
          Determines whether the current row in the result set has been deleted.
 boolean rowInserted()
          Determines whether the current row in this result set has been inserted..
 boolean rowUpdated()
          Determines whether the current row int the result set has been updated..
 void setFetchDirection(int iDir)
          Gives the driver a hint as to the row process direction.
 void setFetchSize(int nSize)
          Gives the drivers a hint as to the number of rows that should be fetched each time.
 void updateAsciiStream(int index, java.io.InputStream is, int length)
          Updates the designated column with an InputStream object of specified length.
 void updateAsciiStream(java.lang.String index, java.io.InputStream is, int length)
          Updates the designated column with an InputStream object of specified length.
 void updateBigDecimal(int index, java.math.BigDecimal dec)
          Updates the designated column with a BigDecimal object.
 void updateBigDecimal(java.lang.String index, java.math.BigDecimal dec)
          Updates the designated column with a BigDecimal object.
 void updateBinaryStream(int index, java.io.InputStream is, int length)
          Updates the designated column with an InputStream object of specified length.
 void updateBinaryStream(java.lang.String index, java.io.InputStream is, int length)
          Updates the designated column with an InputStream object of specified length.
 void updateBoolean(int index, boolean b)
          Updates the designated column with a boolean value.
 void updateBoolean(java.lang.String index, boolean b)
          Updates the designated column with a boolean value.
 void updateByte(int index, byte byt)
          Updates the designated column with a byte value.
 void updateByte(java.lang.String index, byte byt)
          Updates the designated column with a byte value.
 void updateBytes(int index, byte[] bytes)
          Updates the designated column with a byte array value.
 void updateBytes(java.lang.String index, byte[] bytes)
          Updates the designated column with a byte array value.
 void updateCharacterStream(int index, java.io.Reader rd, int length)
          Updates the designated column with a Reader object of specified length.
 void updateCharacterStream(java.lang.String index, java.io.Reader rd, int length)
          Updates the designated column with a Reader object of specified length.
 void updateDate(int index, java.sql.Date date)
          Updates the designated column with a Date object.
 void updateDate(java.lang.String index, java.sql.Date date)
          Updates the designated column with a Date object.
 void updateDouble(int index, double d)
          Updates the designated column with a double value.
 void updateDouble(java.lang.String index, double d)
          Updates the designated column with a double value.
 void updateFloat(int index, float f)
          Updates the designated column with a float value.
 void updateFloat(java.lang.String index, float f)
          Updates the designated column with a float value.
 void updateInt(int index, int i)
          Updates the designated column with an integer value.
 void updateInt(java.lang.String index, int i)
          Updates the designated column with an integer value.
 void updateLong(int index, long l)
          Updates the designated column with a long value.
 void updateLong(java.lang.String index, long l)
          Updates the designated column with a long value.
 void updateNull(int index)
          Updates the designated nullable column with a null value.
 void updateNull(java.lang.String index)
          Updates the designated nullable column with a null value.
 void updateObject(int index, java.lang.Object ob)
          Updates the designated column with a Object value.
 void updateObject(int index, java.lang.Object ob, int scale)
          Updates the designated column with a Object value with the specified scale.
 void updateObject(java.lang.String index, java.lang.Object ob)
          Updates the designated column with a Object value.
 void updateObject(java.lang.String index, java.lang.Object ob, int scale)
          Updates the designated column with a Object value with the specified scale.
 void updateRow()
          Updates the underlying database with the new contents of the current row.
 void updateShort(int index, short si)
          Updates the designated column with a short value.
 void updateShort(java.lang.String index, short si)
          Updates the designated column with a short value.
 void updateString(int index, java.lang.String s)
          Updates the designated column with a String object.
 void updateString(java.lang.String index, java.lang.String s)
          Updates the designated column with a String object.
 void updateTime(int index, java.sql.Time t)
          Updates the designated column with a Time object.
 void updateTime(java.lang.String index, java.sql.Time t)
          Updates the designated column with a Time object.
 void updateTimestamp(int index, java.sql.Timestamp ts)
          Updates the designated column with a Timestamp object.
 void updateTimestamp(java.lang.String index, java.sql.Timestamp ts)
          Updates the designated column with a Timestamp object.
 boolean wasNull()
          Checks to see if the last value read was SQL NULL or not..
 

Method Detail

absolute

public boolean absolute(int index)
                 throws java.sql.SQLException
Moves the cursor to the specified row of the result set.

Parameters:
index - the column index.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

afterLast

public void afterLast()
               throws java.sql.SQLException
Moves the cursor after the last row of the result set.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Moves the cursor before the first row of the result set.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Rolls back the updates made to a row if it is invoked before calling the method updateRow.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
Clears any warnings reported on this object.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

close

public void close()
           throws java.sql.SQLException
Immediately releases a ResultSet object's resources.

Parameters:
None.
Returns:
the name for the cursor.
Throws:
java.sql.SQLException - when SQL problems occur.

deleteRow

public void deleteRow()
               throws java.sql.SQLException
Deletes the current row from the result set and the underlying database.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

findColumn

public int findColumn(java.lang.String index)
               throws java.sql.SQLException
Returns the column index for the named column in the result set.

Parameters:
index - the column name.
Returns:
the column index for the named column.
Throws:
java.sql.SQLException - when SQL problems occur.

first

public boolean first()
              throws java.sql.SQLException
Moves the cursor to the first row of the result set.

Parameters:
None.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

getArray

public java.sql.Array getArray(int index)
                        throws java.sql.SQLException
Gets the Array value of the specified column.

Parameters:
index - the column index.
Returns:
the Array value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getArray

public java.sql.Array getArray(java.lang.String index)
                        throws java.sql.SQLException
Gets the Array value of the specified column.

Parameters:
index - the column name.
Returns:
the Array value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getAsciiStream

public java.io.InputStream getAsciiStream(int index)
                                   throws java.sql.SQLException
Retrieves the value of the specified column value as a stream of ASCII characters.

Parameters:
index - the column index.
Returns:
the ASCII stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String index)
                                   throws java.sql.SQLException
Retrieves the value of the specified column as a stream of ASCII characters.

Parameters:
index - the column name.
Returns:
the ASCII stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int index)
                                   throws java.sql.SQLException
Gets the decimal value of the specified column..

Parameters:
index - the column index.
Returns:
the BigDecimal value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String index)
                                   throws java.sql.SQLException
Gets the decimal value of the specified column.

Parameters:
index - the column name.
Returns:
the BigDecimal value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBinaryStream

public java.io.InputStream getBinaryStream(int index)
                                    throws java.sql.SQLException
Retrieves the value of the specified column as a stream of un-interpreted bytes.

Parameters:
index - the column index.
Returns:
the Binary stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String index)
                                    throws java.sql.SQLException
Retrieves the value of the specified column as a stream of un-interpreted bytes.

Parameters:
index - the column name.
Returns:
the Binary stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBlob

public java.sql.Blob getBlob(int index)
                      throws java.sql.SQLException
Gets the Blob value of the specified column.

Parameters:
index - the column index.
Returns:
the Blob value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBlob

public java.sql.Blob getBlob(java.lang.String index)
                      throws java.sql.SQLException
Gets the Blob value of the specified column.

Parameters:
index - the column name.
Returns:
the Blob value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBoolean

public boolean getBoolean(int index)
                   throws java.sql.SQLException
Gets the boolean value of the specified column.

Parameters:
index - the column index.
Returns:
the boolean value of the specified column
Throws:
java.sql.SQLException - when SQL problems occur.

getBoolean

public boolean getBoolean(java.lang.String index)
                   throws java.sql.SQLException
Gets the boolean value of the specified column.

Parameters:
index - the column name.
Returns:
the boolean value of the specified column
Throws:
java.sql.SQLException - when SQL problems occur.

getByte

public byte getByte(int index)
             throws java.sql.SQLException
Gets the byte value of the specified column.

Parameters:
index - the column index.
Returns:
the byte value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getByte

public byte getByte(java.lang.String index)
             throws java.sql.SQLException
Gets the byte value of the specified column.

Parameters:
index - the column name.
Returns:
the byte value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBytes

public byte[] getBytes(int index)
                throws java.sql.SQLException
Gets the byte array value of the specified column.

Parameters:
index - the column index.
Returns:
the byte array value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getBytes

public byte[] getBytes(java.lang.String index)
                throws java.sql.SQLException
Gets the byte array value of the specified column.

Parameters:
index - the column name.
Returns:
the byte array value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getCharacterStream

public java.io.Reader getCharacterStream(int index)
                                  throws java.sql.SQLException
Retrieves the value of the specified column as a Reader object.

Parameters:
index - the column index.
Returns:
the Character stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String index)
                                  throws java.sql.SQLException
Retrieves the value of the specified column as a Reader object.

Parameters:
index - the column name.
Returns:
the Character stream value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getClob

public java.sql.Clob getClob(int index)
                      throws java.sql.SQLException
Gets the Clob value of the specified column.

Parameters:
index - the column index.
Returns:
the Clob value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getClob

public java.sql.Clob getClob(java.lang.String index)
                      throws java.sql.SQLException
Gets the Clob value of the specified column.

Parameters:
index - the column name.
Returns:
the Clob value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Gets the concurrency mode for this ResultSet object.

Parameters:
None.
Returns:
the concurrency mode.
Throws:
java.sql.SQLException - when SQL problems occur.

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Retrieves the name for the cursor associated with this ResultSet object.

Parameters:
None.
Returns:
the name for the cursor.
Throws:
java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(int index)
                      throws java.sql.SQLException
Gets the date value of the specified column.

Parameters:
index - the column index.
Returns:
the Date value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Gets the date value of the specified column using the time zone from calendar.

Parameters:
index - the column index.
calendar - the Calendar object used to construct the Date object.
Returns:
the Date value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(java.lang.String index)
                      throws java.sql.SQLException
Gets the date value of the specified column.

Parameters:
index - the column name.
Returns:
the Date value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(java.lang.String index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Gets the date value of the specified column using the time zone from calendar.

Parameters:
index - the column name.
calendar - the Calendar object used to construct the Date object.
Returns:
the Date value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getDouble

public double getDouble(int index)
                 throws java.sql.SQLException
Gets the double value of the specified column..

Parameters:
index - the column name.
Returns:
the double value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getDouble

public double getDouble(java.lang.String index)
                 throws java.sql.SQLException
Gets the double value of the specified column.

Parameters:
index - the column name.
Returns:
the double value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Gets the direction suggested to the driver as the row fetch direction.

Parameters:
None.
Returns:
the fetch direction.
Throws:
java.sql.SQLException - when SQL problems occur.

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Gets the number of rows to fetch suggested to the driver

Parameters:
None.
Returns:
the number of rows to fetch.
Throws:
java.sql.SQLException - when SQL problems occur.

getFloat

public float getFloat(int index)
               throws java.sql.SQLException
Gets the float value of the specified column..

Parameters:
index - the column index.
Returns:
the float value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getFloat

public float getFloat(java.lang.String index)
               throws java.sql.SQLException
Gets the float value of the specified column..

Parameters:
index - the column name.
Returns:
the float value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getInt

public int getInt(int index)
           throws java.sql.SQLException
Gets the integer value of the specified column.

Parameters:
index - the column index.
Returns:
the integer value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getInt

public int getInt(java.lang.String index)
           throws java.sql.SQLException
Gets the integer value of the specified column.

Parameters:
index - the column name.
Returns:
the integer value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getLong

public long getLong(int index)
             throws java.sql.SQLException
Gets the long value of the specified column.

Parameters:
index - the column index.
Returns:
the long value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getLong

public long getLong(java.lang.String index)
             throws java.sql.SQLException
Gets the long value of the specified column.

Parameters:
index - the column name.
Returns:
the long value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Retrieves a ResultSetMetaData object that contains ResultSet proprieties.

Parameters:
None.
Returns:
the metadata of the result set.
Throws:
java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(int index)
                           throws java.sql.SQLException
Gets the object value of the specified column.

Parameters:
index - the column index.
Returns:
the Object value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(int index,
                                  java.util.Map map)
                           throws java.sql.SQLException
Gets the object value of the specified column using the given type map.

Parameters:
index - the column index.
map - the mapping from SQL type names to Java classes.
Returns:
the object value of the specified column
Throws:
java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(java.lang.String index)
                           throws java.sql.SQLException
Gets the object value of the specified column.

Parameters:
index - the column name.
Returns:
the Object value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(java.lang.String index,
                                  java.util.Map map)
                           throws java.sql.SQLException
Gets the object value of the specified column using the given type map.

Parameters:
index - the column name.
map - the mapping from SQL type names to Java classes.
Returns:
the object value of the specified column
Throws:
java.sql.SQLException - when SQL problems occur.

getRef

public java.sql.Ref getRef(int index)
                    throws java.sql.SQLException
Gets the Ref value of the specified column.

Parameters:
index - the column index.
Returns:
the Ref value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getRef

public java.sql.Ref getRef(java.lang.String index)
                    throws java.sql.SQLException
Gets the Ref value of the specified column..

Parameters:
index - the column name.
Returns:
the Ref value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getRow

public int getRow()
           throws java.sql.SQLException
Retrieves the current row number in the result set.

Parameters:
None.
Returns:
the current row number.
Throws:
java.sql.SQLException - when SQL problems occur.

getShort

public short getShort(int index)
               throws java.sql.SQLException
Gets the short value of the specified column.

Parameters:
index - the column index.
Returns:
the short value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getShort

public short getShort(java.lang.String index)
               throws java.sql.SQLException
Gets the short value of the specified column.

Parameters:
index - the column name.
Returns:
the short value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getString

public java.lang.String getString(int index)
                           throws java.sql.SQLException
Gets the string value of the specified column.

Parameters:
index - the column index.
Returns:
the String value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getString

public java.lang.String getString(java.lang.String index)
                           throws java.sql.SQLException
Gets the string value of the specified column.

Parameters:
index - the column name.
Returns:
the String value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(int index)
                      throws java.sql.SQLException
Gets the time value of the specified column.

Parameters:
index - the column index.
Returns:
the Time value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Gets the time value of the specified column using the time zone from calendar.

Parameters:
index - the column index.
calendar - the Calendar object used to construct the Time object.
Returns:
the Time value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(java.lang.String index)
                      throws java.sql.SQLException
Gets the time value of the specified column.

Parameters:
index - the column name.
Returns:
the Time value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(java.lang.String index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Gets the time value of the specified column using the time zone from calendar.

Parameters:
index - the column name.
calendar - the Calendar object used to construct the Time object.
Returns:
the Time value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(int index)
                                throws java.sql.SQLException
Gets the timestamp value of the specified column.

Parameters:
index - the column index.
Returns:
the Timestamp value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(int index,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
Gets the timestamp value of the specified column using the time zone from calendar.

Parameters:
index - the column index.
calendar - the Calendar object used to construct the Timestamp object.
Returns:
the Timestamp value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String index)
                                throws java.sql.SQLException
Gets the timestamp value of the specified column.

Parameters:
index - the column name.
Returns:
the Timestamp value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String index,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
Gets the timestamp value of the specified column using the time zone from calendar.

Parameters:
index - the column name.
calendar - the Calendar object used to construct the Timestamp object.
Returns:
the Timestamp value of the specified column.
Throws:
java.sql.SQLException - when SQL problems occur.

getType

public int getType()
            throws java.sql.SQLException
Retrieves the scroll type of cursor associated with the result set.

Parameters:
None.
Returns:
the scroll type of the cursor.
Throws:
java.sql.SQLException - when SQL problems occur.

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Gets the first SQLWarning that has been reported for this object..

Parameters:
None.
Returns:
the first SQLWarning.
Throws:
java.sql.SQLException - when SQL problems occur.

insertRow

public void insertRow()
               throws java.sql.SQLException
Inserts the contents of the insert row into the result set and the database.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Determines whether the cursor is after the last row of the result set.

Parameters:
None.
Returns:
true if the cursor is after the last row; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Determines whether the cursor is before the first row of the result set.

Parameters:
None.
Returns:
true if the cursor is before the first row; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Determines whether the cursor is on the first row of the result set.

Parameters:
None.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

isLast

public boolean isLast()
               throws java.sql.SQLException
Determines whether the cursor is on the last row of the result set.

Parameters:
None.
Returns:
true if the cursor is in the last row; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

last

public boolean last()
             throws java.sql.SQLException
Moves the cursor to the last row of the result set.

Parameters:
None.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Moves the cursor to the remembered cursor position in the result set before it was moved to the insert row.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Moves the cursor to the insert row that associated with an updatable result set.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

next

public boolean next()
             throws java.sql.SQLException
Moves the cursor to the next row of the result set.

Parameters:
None.
Returns:
true if successful; false if there is no more row.
Throws:
java.sql.SQLException - when SQL problems occur.

previous

public boolean previous()
                 throws java.sql.SQLException
Moves the cursor to the previous row of the result set.

Parameters:
None.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

queryName

public java.lang.String queryName()
Supplies the name of the listener.
Parameters:
None.
Returns:
the listener's class name.
Throws:
None.

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Replaces the values int the current row of the result set with their current values in the database

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

relative

public boolean relative(int index)
                 throws java.sql.SQLException
Moves the cursor to the specified row relative to current row of the result set.

Parameters:
index - the column index.
Returns:
true if successful; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Determines whether the current row in the result set has been deleted.

Parameters:
None.
Returns:
true if the current row in this result set has been deleted; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Determines whether the current row in this result set has been inserted..

Parameters:
None.
Returns:
true if the current row in this result set has been inserted; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Determines whether the current row int the result set has been updated..

Parameters:
None.
Returns:
true if the current row in this result set has been updated; false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.

setFetchDirection

public void setFetchDirection(int iDir)
                       throws java.sql.SQLException
Gives the driver a hint as to the row process direction.

Parameters:
iDir - the fetch direction value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

setFetchSize

public void setFetchSize(int nSize)
                  throws java.sql.SQLException
Gives the drivers a hint as to the number of rows that should be fetched each time.

Parameters:
nSize - the number of rows to fetch.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateAsciiStream

public void updateAsciiStream(int index,
                              java.io.InputStream is,
                              int length)
                       throws java.sql.SQLException
Updates the designated column with an InputStream object of specified length.

Parameters:
index - the column index.
is - the desired ASCII stream value.
length - the number of bytes of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateAsciiStream

public void updateAsciiStream(java.lang.String index,
                              java.io.InputStream is,
                              int length)
                       throws java.sql.SQLException
Updates the designated column with an InputStream object of specified length.

Parameters:
index - the column name.
is - the desired ASCII stream value.
length - the number of bytes of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBigDecimal

public void updateBigDecimal(int index,
                             java.math.BigDecimal dec)
                      throws java.sql.SQLException
Updates the designated column with a BigDecimal object.

Parameters:
index - the column index.
dec - the desired BigDecimal value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBigDecimal

public void updateBigDecimal(java.lang.String index,
                             java.math.BigDecimal dec)
                      throws java.sql.SQLException
Updates the designated column with a BigDecimal object.

Parameters:
index - the column name.
dec - the desired BigDecimal value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBinaryStream

public void updateBinaryStream(int index,
                               java.io.InputStream is,
                               int length)
                        throws java.sql.SQLException
Updates the designated column with an InputStream object of specified length.

Parameters:
index - the column index.
is - the desired Binary stream value.
length - the number of bytes of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBinaryStream

public void updateBinaryStream(java.lang.String index,
                               java.io.InputStream is,
                               int length)
                        throws java.sql.SQLException
Updates the designated column with an InputStream object of specified length.

Parameters:
index - the column name.
is - the desired Binary stream value.
length - the number of bytes of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBoolean

public void updateBoolean(int index,
                          boolean b)
                   throws java.sql.SQLException
Updates the designated column with a boolean value.

Parameters:
index - the column index.
b - the desired boolean value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBoolean

public void updateBoolean(java.lang.String index,
                          boolean b)
                   throws java.sql.SQLException
Updates the designated column with a boolean value.

Parameters:
index - the column name.
b - the desired boolean value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateByte

public void updateByte(int index,
                       byte byt)
                throws java.sql.SQLException
Updates the designated column with a byte value.

Parameters:
index - the column index.
byt - the desired byte value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateByte

public void updateByte(java.lang.String index,
                       byte byt)
                throws java.sql.SQLException
Updates the designated column with a byte value.

Parameters:
index - the column name.
byt - the desired byte value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBytes

public void updateBytes(int index,
                        byte[] bytes)
                 throws java.sql.SQLException
Updates the designated column with a byte array value.

Parameters:
index - the column index.
bytes - the desired byte array value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateBytes

public void updateBytes(java.lang.String index,
                        byte[] bytes)
                 throws java.sql.SQLException
Updates the designated column with a byte array value.

Parameters:
index - the column name.
bytes - the desired byte array value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateCharacterStream

public void updateCharacterStream(int index,
                                  java.io.Reader rd,
                                  int length)
                           throws java.sql.SQLException
Updates the designated column with a Reader object of specified length.

Parameters:
index - the column index.
rd - the desired Reader value.
length - the number of characters of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateCharacterStream

public void updateCharacterStream(java.lang.String index,
                                  java.io.Reader rd,
                                  int length)
                           throws java.sql.SQLException
Updates the designated column with a Reader object of specified length.

Parameters:
index - the column name.
rd - the desired Reader value.
length - the number of characters of the stream.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateDate

public void updateDate(int index,
                       java.sql.Date date)
                throws java.sql.SQLException
Updates the designated column with a Date object.

Parameters:
index - the column index.
date - the desired Date value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateDate

public void updateDate(java.lang.String index,
                       java.sql.Date date)
                throws java.sql.SQLException
Updates the designated column with a Date object.

Parameters:
index - the column name.
date - the desired Date value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateDouble

public void updateDouble(int index,
                         double d)
                  throws java.sql.SQLException
Updates the designated column with a double value.

Parameters:
index - the column index.
d - the desired double value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateDouble

public void updateDouble(java.lang.String index,
                         double d)
                  throws java.sql.SQLException
Updates the designated column with a double value.

Parameters:
index - the column name.
d - the desired double value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateFloat

public void updateFloat(int index,
                        float f)
                 throws java.sql.SQLException
Updates the designated column with a float value.

Parameters:
index - the column index.
f - the desired float value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateFloat

public void updateFloat(java.lang.String index,
                        float f)
                 throws java.sql.SQLException
Updates the designated column with a float value.

Parameters:
index - the column name.
f - the desired float value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateInt

public void updateInt(int index,
                      int i)
               throws java.sql.SQLException
Updates the designated column with an integer value.

Parameters:
index - the column index.
i - the desired integer value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateInt

public void updateInt(java.lang.String index,
                      int i)
               throws java.sql.SQLException
Updates the designated column with an integer value.

Parameters:
index - the column name.
i - the desired integer value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateLong

public void updateLong(int index,
                       long l)
                throws java.sql.SQLException
Updates the designated column with a long value.

Parameters:
index - the column index.
l - the desired long value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateLong

public void updateLong(java.lang.String index,
                       long l)
                throws java.sql.SQLException
Updates the designated column with a long value.

Parameters:
index - the column name.
l - the desired long value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateNull

public void updateNull(int index)
                throws java.sql.SQLException
Updates the designated nullable column with a null value.

Parameters:
index - the column index.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateNull

public void updateNull(java.lang.String index)
                throws java.sql.SQLException
Updates the designated nullable column with a null value.

Parameters:
index - the column name.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(int index,
                         java.lang.Object ob)
                  throws java.sql.SQLException
Updates the designated column with a Object value.

Parameters:
index - the column index.
ob - the desired Object value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(int index,
                         java.lang.Object ob,
                         int scale)
                  throws java.sql.SQLException
Updates the designated column with a Object value with the specified scale.

Parameters:
index - the column index.
ob - the desired Object value.
scale - the desired number of digits to the right of the decimal point.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(java.lang.String index,
                         java.lang.Object ob)
                  throws java.sql.SQLException
Updates the designated column with a Object value.

Parameters:
index - the column name.
ob - the desired Object value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(java.lang.String index,
                         java.lang.Object ob,
                         int scale)
                  throws java.sql.SQLException
Updates the designated column with a Object value with the specified scale.

Parameters:
index - the column name.
ob - the desired Object value.
scale - the desired number of digits to the right of the decimal point.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateRow

public void updateRow()
               throws java.sql.SQLException
Updates the underlying database with the new contents of the current row.

Parameters:
None.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateShort

public void updateShort(int index,
                        short si)
                 throws java.sql.SQLException
Updates the designated column with a short value.

Parameters:
index - the column index.
si - the desired short value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateShort

public void updateShort(java.lang.String index,
                        short si)
                 throws java.sql.SQLException
Updates the designated column with a short value.

Parameters:
index - the column name.
si - the desired short value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateString

public void updateString(int index,
                         java.lang.String s)
                  throws java.sql.SQLException
Updates the designated column with a String object.

Parameters:
index - the column index.
s - the desired String value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateString

public void updateString(java.lang.String index,
                         java.lang.String s)
                  throws java.sql.SQLException
Updates the designated column with a String object.

Parameters:
index - the column name.
s - the desired String value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateTime

public void updateTime(int index,
                       java.sql.Time t)
                throws java.sql.SQLException
Updates the designated column with a Time object.

Parameters:
index - the column index.
t - the desired Time value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateTime

public void updateTime(java.lang.String index,
                       java.sql.Time t)
                throws java.sql.SQLException
Updates the designated column with a Time object.

Parameters:
index - the column name.
t - the desired Time value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateTimestamp

public void updateTimestamp(int index,
                            java.sql.Timestamp ts)
                     throws java.sql.SQLException
Updates the designated column with a Timestamp object.

Parameters:
index - the column index.
ts - the desired Timestamp value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

updateTimestamp

public void updateTimestamp(java.lang.String index,
                            java.sql.Timestamp ts)
                     throws java.sql.SQLException
Updates the designated column with a Timestamp object.

Parameters:
index - the column name.
ts - the desired Timestamp value.
Returns:
void - None.
Throws:
java.sql.SQLException - when SQL problems occur.

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Checks to see if the last value read was SQL NULL or not..

Parameters:
None.
Returns:
true if the last value read was SQL NUll;false otherwise.
Throws:
java.sql.SQLException - when SQL problems occur.


Copyright 2004 by SeeBeyond Technology Corporation. All Rights Reserved.