org.acmsl.queryj
Class QueryResultSet

java.lang.Object
  |
  +--org.acmsl.queryj.QueryResultSet
All Implemented Interfaces:
java.sql.ResultSet

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

Represents standard SQL queries.

Version:
$Revision: 1.1 $
Author:
Jose San Leandro

Field Summary
 
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
QueryResultSet(SelectQuery query, java.sql.ResultSet resultSet)
          Builds a query result set with given references.
 
Method Summary
 boolean absolute(int index)
          See ResultSet#absolute(int)
 void afterLast()
          See ResultSet#afterLast()
 void beforeFirst()
          See ResultSet#beforeFirst()
 void cancelRowUpdates()
          See ResultSet#cancelRowUpdates()
 void clearWarnings()
          See ResultSet#clearWarnings()
 void close()
          See ResultSet#close()
 void deleteRow()
          See ResultSet#deleteRow()
 int findColumn(Field field)
          Retrieves the column index associated to given field.
 int findColumn(java.lang.String columnName)
          See ResultSet#findColumn(String)
 boolean first()
          See ResultSet#first()
 java.sql.Array getArray(Field field)
          Retrieves an array value using the field reference.
 java.sql.Array getArray(int index)
          See ResultSet#getArray(int)
 java.sql.Array getArray(java.lang.String columnName)
          See ResultSet#getArray(String)
 java.io.InputStream getAsciiStream(Field field)
          Retrieves an ASCII stream using the field reference.
 java.io.InputStream getAsciiStream(int index)
          See ResultSet#getAsciiStream(int)
 java.io.InputStream getAsciiStream(java.lang.String columnName)
          See ResultSet#getAsciiStream(String)
 java.math.BigDecimal getBigDecimal(Field field)
          Retrieves a BigDecimal value using the field reference.
 java.math.BigDecimal getBigDecimal(Field field, int scale)
          Retrieves a BigDecimal value using the field reference.
 java.math.BigDecimal getBigDecimal(int index)
          See ResultSet#getBigDecimal(int)
 java.math.BigDecimal getBigDecimal(int index, int scale)
          See ResultSet#getBigDecimal(int,int)
 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
          See ResultSet#getBigDecimal(String)
 java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
          See ResultSet#getBigDecimal(String,int)
 java.io.InputStream getBinaryStream(Field field)
          Retrieves a binary stream using the field reference.
 java.io.InputStream getBinaryStream(int index)
          See ResultSet#getBinaryStream(int)
 java.io.InputStream getBinaryStream(java.lang.String columnName)
          See ResultSet#getBinaryStream(String)
 java.sql.Blob getBlob(Field field)
          Retrieves a blob using the field reference.
 java.sql.Blob getBlob(int index)
          See ResultSet#getBlob(int)
 java.sql.Blob getBlob(java.lang.String columnName)
          See ResultSet#getBlob(String)
 boolean getBoolean(Field field)
          Retrieves a boolean value using the field reference.
 boolean getBoolean(int index)
          See ResultSet#getBoolean(int)
 boolean getBoolean(java.lang.String columnName)
          See ResultSet#getBoolean(String)
 byte getByte(Field field)
          Retrieves a byte value using the field reference.
 byte getByte(int index)
          See ResultSet#getByte(int)
 byte getByte(java.lang.String columnName)
          See ResultSet#getByte(String)
 byte[] getBytes(Field field)
          Retrieves a byte array value using the field reference.
 byte[] getBytes(int index)
          See ResultSet.getBytes(int)
 byte[] getBytes(java.lang.String columnName)
          See ResultSet.getBytes(String)
 java.io.Reader getCharacterStream(Field field)
          Retrieves a character stream using the field reference.
 java.io.Reader getCharacterStream(int index)
          See ResultSet#getCharacterStream(int)
 java.io.Reader getCharacterStream(java.lang.String columnName)
          See ResultSet#getCharacterStream(String)
 java.sql.Clob getClob(Field field)
          Retrieves a clob value using the field reference.
 java.sql.Clob getClob(int index)
          See ResultSet#getClob(int)
 java.sql.Clob getClob(java.lang.String columnName)
          See ResultSet#getClob(String)
 int getConcurrency()
          See ResultSet#getConcurrency()
 java.lang.String getCursorName()
          See ResultSet#getCursorName()
 java.sql.Date getDate(Field field)
          Retrieves a Date value using the field reference.
 java.sql.Date getDate(Field field, java.util.Calendar calendar)
          Retrieves a Date value using the field reference.
 java.sql.Date getDate(int index)
          See ResultSet#getDate(int)
 java.sql.Date getDate(int index, java.util.Calendar calendar)
          See ResultSet#getDate(int,Calendar)
 java.sql.Date getDate(java.lang.String columnName)
          See ResultSet#getDate(String)
 java.sql.Date getDate(java.lang.String columnName, java.util.Calendar calendar)
          See ResultSet#getDate(String,Calendar)
 double getDouble(Field field)
          Retrieves a double value using the field reference.
 double getDouble(int index)
          See ResultSet#getDouble(int)
 double getDouble(java.lang.String columnName)
          See ResultSet#getDouble(String)
 int getFetchDirection()
          See ResultSet#getFetchDirection()
 int getFetchSize()
          See ResultSet#getFetchSize()
 float getFloat(Field field)
          Retrieves a float value using the field reference.
 float getFloat(int index)
          See ResultSet#getFloat(int)
 float getFloat(java.lang.String columnName)
          See ResultSet#getFloat(String)
 int getInt(Field field)
          Retrieves an integer value using the field reference.
 int getInt(int index)
          See ResultSet#getInt(int)
 int getInt(java.lang.String columnName)
          See ResultSet#getInt(String)
 long getLong(Field field)
          Retrieves a boolean value using the field reference.
 long getLong(int index)
          See ResultSet#getLong(int)
 long getLong(java.lang.String columnName)
          See ResultSet#getLong(String)
 java.sql.ResultSetMetaData getMetaData()
          See ResultSet#getMetaData()
 java.lang.Object getObject(Field field)
          Retrieves an object value using the field reference.
 java.lang.Object getObject(Field field, java.util.Map map)
          Retrieves an object value using the field reference.
 java.lang.Object getObject(int index)
          See ResultSet#getObject(int)
 java.lang.Object getObject(int index, java.util.Map map)
          See ResultSet#getObject(int,Map)
 java.lang.Object getObject(java.lang.String columnName)
          See ResultSet#getObject(String)
 java.lang.Object getObject(java.lang.String columnName, java.util.Map map)
          See ResultSet#getObject(String,Map)
protected  SelectQuery getQuery()
          Retrieves the query.
 java.sql.Ref getRef(Field field)
          Retrieves a Ref value using the field reference.
 java.sql.Ref getRef(int index)
          See ResultSet#getRef(int)
 java.sql.Ref getRef(java.lang.String columnName)
          See ResultSet#getRef(String)
protected  java.sql.ResultSet getResultSet()
          Retrieves the result set.
 int getRow()
          See ResultSet#getRow()
 short getShort(Field field)
          Retrieves a short value using the field reference.
 short getShort(int index)
          See ResultSet#getShort(int)
 short getShort(java.lang.String columnName)
          See ResultSet#getShort(String)
 java.sql.Statement getStatement()
          See ResultSet#getStatement()
 java.lang.String getString(Field field)
          Retrieves a text value using the field reference.
 java.lang.String getString(int index)
          See ResultSet#getString(int)
 java.lang.String getString(java.lang.String columnName)
          See ResultSet#getString(String)
 java.sql.Time getTime(Field field)
          Retrieves a Time value using the field reference.
 java.sql.Time getTime(Field field, java.util.Calendar calendar)
          Retrieves a Time value using the field reference.
 java.sql.Time getTime(int index)
          See ResultSet#getTime(int)
 java.sql.Time getTime(int index, java.util.Calendar calendar)
          See ResultSet#getTime(int,Calendar)
 java.sql.Time getTime(java.lang.String columnName)
          See ResultSet#getTime(String)
 java.sql.Time getTime(java.lang.String columnName, java.util.Calendar calendar)
          See ResultSet#getTime(String,Calendar)
 java.sql.Timestamp getTimestamp(Field field)
          Retrieves a timestamp value using the field reference.
 java.sql.Timestamp getTimestamp(Field field, java.util.Calendar calendar)
          Retrieves a timestamp value using the field reference.
 java.sql.Timestamp getTimestamp(int index)
          See ResultSet#getTimestamp(int)
 java.sql.Timestamp getTimestamp(int index, java.util.Calendar calendar)
          See ResultSet#getTimestamp(int,Calendar)
 java.sql.Timestamp getTimestamp(java.lang.String columnName)
          See ResultSet#getTimestamp(String)
 java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar calendar)
          See ResultSet#getTimestamp(String,Calendar)
 int getType()
          See ResultSet#getType()
 java.io.InputStream getUnicodeStream(Field field)
          Retrieves an Unicode stream using the field reference.
 java.io.InputStream getUnicodeStream(int index)
          See ResultSet#getUnicodeStream(int)
 java.io.InputStream getUnicodeStream(java.lang.String columnName)
          See ResultSet#getUnicodeStream(String)
 java.net.URL getURL(Field field)
          Retrieves an URL using the field reference.
 java.net.URL getURL(int columnIndex)
          See ResultSet#getURL(int)
 java.net.URL getURL(java.lang.String columnName)
          See ResultSet#getURL(String)
 java.sql.SQLWarning getWarnings()
          See ResultSet#getWarnings()
 void insertRow()
          See ResultSet#insertRow()
 boolean isAfterLast()
          See ResultSet#isAfterLast()
 boolean isBeforeFirst()
          See ResultSet#isBeforeFirst()
 boolean isFirst()
          See ResultSet#isFirst()
 boolean isLast()
          See ResultSet#isLast()
 boolean last()
          See ResultSet#last()
 void moveToCurrentRow()
          See ResultSet#moveToCurrentRow()
 void moveToInsertRow()
          See ResultSet#moveToInsertRow()
 boolean next()
          See ResultSet#next()
 boolean previous()
          See ResultSet#previous()
 void refreshRow()
          See ResultSet#refreshRow()
 boolean relative(int index)
          See ResultSet#relative(int)
 boolean rowDeleted()
          See ResultSet#rowDeleted()
 boolean rowInserted()
          See ResultSet#rowInserted()
 boolean rowUpdated()
          See ResultSet#rowUpdated()
 void setFetchDirection(int direction)
          See ResultSet#setFetchDirection(int)
 void setFetchSize(int size)
          See ResultSet#setFetchSize(int)
protected  void setQuery(SelectQuery query)
          Specifies the query reference.
protected  void setResultSet(java.sql.ResultSet resultSet)
          Specifies the result set reference.
 void updateArray(Field field, java.sql.Array value)
          Updates a Array column using the field arrayerence.
 void updateArray(int columnIndex, java.sql.Array value)
          See ResultSet#updateArray(int,Array)
 void updateArray(java.lang.String columnName, java.sql.Array value)
          See ResultSet#updateArray(String,Array)
 void updateAsciiStream(Field field, java.io.InputStream value, int length)
          Updates an ASCII stream column using the field reference.
 void updateAsciiStream(int index, java.io.InputStream value, int length)
          See ResultSet#updateAsciiStream(int,InputStream,int)
 void updateAsciiStream(java.lang.String columnName, java.io.InputStream value, int length)
          See ResultSet#updateAsciiStream(String,InputStream,int)
 void updateBigDecimal(Field field, java.math.BigDecimal value)
          See ResultSet#updateBigDecimal(String,BigDecimal)
 void updateBigDecimal(int index, java.math.BigDecimal value)
          See ResultSet#updateBigDecimal(int,BigDecimal)
 void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal value)
          See ResultSet#updateBigDecimal(String,BigDecimal)
 void updateBinaryStream(Field field, java.io.InputStream value, int length)
          Updates a binary stream column using the field reference.
 void updateBinaryStream(int index, java.io.InputStream value, int length)
          See ResultSet#updateBinaryStream(int,InputStream,int)
 void updateBinaryStream(java.lang.String columnName, java.io.InputStream value, int length)
          See ResultSet#updateBinaryStream(String,InputStream,int)
 void updateBlob(Field field, java.sql.Blob value)
          Updates a Blob column using the field bloberence.
 void updateBlob(int columnIndex, java.sql.Blob value)
          See ResultSet#updateBlob(int,Blob)
 void updateBlob(java.lang.String columnName, java.sql.Blob value)
          See ResultSet#updateBlob(String,Blob)
 void updateBoolean(Field field, boolean value)
          Updates a boolean column using the field reference.
 void updateBoolean(int index, boolean value)
          See ResultSet#updateBoolean(int,boolean)
 void updateBoolean(java.lang.String columnName, boolean value)
          See ResultSet#updateBoolean(String,boolean)
 void updateByte(Field field, byte value)
          Updates a byte column using the field reference.
 void updateByte(int index, byte value)
          See ResultSet#updateByte(int,byte)
 void updateByte(java.lang.String columnName, byte value)
          See ResultSet#updateByte(String,byte)
 void updateBytes(Field field, byte[] value)
          Updates a byte array column using the field reference.
 void updateBytes(int index, byte[] value)
          See ResultSet#updateBytes(int,byte[])
 void updateBytes(java.lang.String columnName, byte[] value)
          See ResultSet#updateBytes(String,byte[])
 void updateCharacterStream(Field field, java.io.Reader value, int length)
          Updates a character stream column using the field reference.
 void updateCharacterStream(int index, java.io.Reader value, int length)
          See ResultSet#updateCharacterStream(int,Reader,int)
 void updateCharacterStream(java.lang.String columnName, java.io.Reader value, int length)
          See ResultSet#updateCharacterStream(String,Reader,int)
 void updateClob(Field field, java.sql.Clob value)
          Updates a Clob column using the field cloberence.
 void updateClob(int columnIndex, java.sql.Clob value)
          See ResultSet#updateClob(int,Clob)
 void updateClob(java.lang.String columnName, java.sql.Clob value)
          See ResultSet#updateClob(String,Clob)
 void updateDate(Field field, java.sql.Date value)
          Updates a date column using the field reference.
 void updateDate(int index, java.sql.Date value)
          See ResultSet#updateDate(int,Date)
 void updateDate(java.lang.String columnName, java.sql.Date value)
          See ResultSet#updateDate(String,Date)
 void updateDouble(Field field, double value)
          Updates a double column using the field reference.
 void updateDouble(int index, double value)
          See ResultSet#updateDouble(int,double)
 void updateDouble(java.lang.String columnName, double value)
          See ResultSet#updateDouble(String,double)
 void updateFloat(Field field, float value)
          Updates a float column using the field reference.
 void updateFloat(int index, float value)
          See ResultSet#updateFloat(int,float)
 void updateFloat(java.lang.String columnName, float value)
          See ResultSet#updateFloat(String,float)
 void updateInt(Field field, int value)
          Updates an integer column using the field reference.
 void updateInt(int index, int value)
          See ResultSet#updateInt(int,int)
 void updateInt(java.lang.String columnName, int value)
          See ResultSet#updateInt(String,int)
 void updateLong(Field field, long value)
          Updates a long column using the field reference.
 void updateLong(int index, long value)
          See ResultSet#updateLong(int,long)
 void updateLong(java.lang.String columnName, long value)
          See ResultSet#updateLong(String,long)
 void updateNull(Field field)
          Sets a column to null using the field reference.
 void updateNull(int index)
          See ResultSet#updateNull(int)
 void updateNull(java.lang.String columnName)
          See ResultSet#updateNull(String)
 void updateObject(Field field, java.lang.Object value)
          Updates an object column using the field reference.
 void updateObject(Field field, java.lang.Object value, int scale)
          Updates an object column using the field reference.
 void updateObject(int index, java.lang.Object value)
          See ResultSet#updateObject(int,Object)
 void updateObject(int index, java.lang.Object value, int scale)
          See ResultSet#updateObject(int,Object,int)
 void updateObject(java.lang.String columnName, java.lang.Object value)
          See ResultSet#updateObject(String,Object)
 void updateObject(java.lang.String columnName, java.lang.Object value, int scale)
          See ResultSet#updateObject(String,Object,int)
 void updateRef(Field field, java.sql.Ref value)
          Updates a Ref column using the field reference.
 void updateRef(int columnIndex, java.sql.Ref value)
          See ResultSet#updateRef(int,Ref)
 void updateRef(java.lang.String columnName, java.sql.Ref value)
          See ResultSet#updateRef(String,Ref)
 void updateRow()
          See ResultSet#updateRow()
 void updateShort(Field field, short value)
          Updates a short column using the field reference.
 void updateShort(int index, short value)
          See ResultSet#updateShort(int,short)
 void updateShort(java.lang.String columnName, short value)
          See ResultSet#updateShort(String,short)
 void updateString(Field field, java.lang.String value)
          Updates a text column using the field reference.
 void updateString(int index, java.lang.String value)
          See ResultSet#updateString(int,String)
 void updateString(java.lang.String columnName, java.lang.String value)
          See ResultSet#updateString(String,String)
 void updateTime(Field field, java.sql.Time value)
          Updates a time column using the field reference.
 void updateTime(int index, java.sql.Time value)
          See ResultSet#updateTime(int,Time)
 void updateTime(java.lang.String columnName, java.sql.Time value)
          See ResultSet#updateTime(String,Time)
 void updateTimestamp(Field field, java.sql.Timestamp value)
          Updates a timestamp column using the field reference.
 void updateTimestamp(int index, java.sql.Timestamp value)
          See ResultSet#updateTimestamp(int,Timestamp)
 void updateTimestamp(java.lang.String columnName, java.sql.Timestamp value)
          See ResultSet#updateTimestamp(String,Timestamp)
 boolean wasNull()
          See ResultSet#wasNull()
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

QueryResultSet

public QueryResultSet(SelectQuery query,
                      java.sql.ResultSet resultSet)
Builds a query result set with given references.

Parameters:
query - the query.
resultSet - the wrapped result set.
Method Detail

setQuery

protected void setQuery(SelectQuery query)
Specifies the query reference.

Parameters:
query - the query.

getQuery

protected SelectQuery getQuery()
Retrieves the query.

Returns:
such reference.

setResultSet

protected void setResultSet(java.sql.ResultSet resultSet)
Specifies the result set reference.

Parameters:
resultSet - the result set.

getResultSet

protected java.sql.ResultSet getResultSet()
Retrieves the result set.

Returns:
such reference.

getBytes

public byte[] getBytes(int index)
                throws java.sql.SQLException
See ResultSet.getBytes(int)

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null
Throws:
java.sql.SQLException - if an error occurs.
See Also:
java.sql.ResultSet.getBytes(int)

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException
See ResultSet.getBytes(String)

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
java.sql.ResultSet.getBytes(java.lang.String)

next

public boolean next()
             throws java.sql.SQLException
See ResultSet#next()

Specified by:
next in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the new current row is valid; false if there are no more rows.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.next()

previous

public boolean previous()
                 throws java.sql.SQLException
See ResultSet#previous()

Specified by:
previous in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is on a valid row; false if it is off the result set.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.previous()

getBoolean

public boolean getBoolean(int index)
                   throws java.sql.SQLException
See ResultSet#getBoolean(int)

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is false.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBoolean(int)

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException
See ResultSet#getBoolean(String)

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is false.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBoolean(String)

getType

public int getType()
            throws java.sql.SQLException
See ResultSet#getType()

Specified by:
getType in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getType()

getLong

public long getLong(int index)
             throws java.sql.SQLException
See ResultSet#getLong(int)

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getLong(int)

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException
See ResultSet#getLong(String)

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getLong(String)

getObject

public java.lang.Object getObject(int index)
                           throws java.sql.SQLException
See ResultSet#getObject(int)

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getObject(int)

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
See ResultSet#getObject(String)

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getObject(String)

getObject

public java.lang.Object getObject(int index,
                                  java.util.Map map)
                           throws java.sql.SQLException
See ResultSet#getObject(int,Map)

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
map - (Taken from Sun's Javadoc) a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getObject(int,java.util.Map)

getObject

public java.lang.Object getObject(java.lang.String columnName,
                                  java.util.Map map)
                           throws java.sql.SQLException
See ResultSet#getObject(String,Map)

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
map - (Taken from Sun's Javadoc) a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getObject(java.lang.String,java.util.Map)

close

public void close()
           throws java.sql.SQLException
See ResultSet#close()

Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.close()

getRef

public java.sql.Ref getRef(int index)
                    throws java.sql.SQLException
See ResultSet#getRef(int)

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getRef(int)

getRef

public java.sql.Ref getRef(java.lang.String columnName)
                    throws java.sql.SQLException
See ResultSet#getRef(String)

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getRef(java.lang.String)

getTime

public java.sql.Time getTime(int index)
                      throws java.sql.SQLException
See ResultSet#getTime(int)

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
See ResultSet#getTime(String)

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTime(java.lang.String)

getTime

public java.sql.Time getTime(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
See ResultSet#getTime(int,Calendar)

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTime(int,java.util.Calendar)

getTime

public java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
See ResultSet#getTime(String,Calendar)

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTime(java.lang.String,java.util.Calendar)

getDate

public java.sql.Date getDate(int index)
                      throws java.sql.SQLException
See ResultSet#getDate(int)

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
See ResultSet#getDate(String)

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDate(java.lang.String)

getDate

public java.sql.Date getDate(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
See ResultSet#getDate(int,Calendar)

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDate(int,java.util.Calendar)

getDate

public java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
See ResultSet#getDate(String,Calendar)

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDate(java.lang.String,java.util.Calendar)

first

public boolean first()
              throws java.sql.SQLException
See ResultSet#first()

Specified by:
first in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc)
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.first()

getByte

public byte getByte(int index)
             throws java.sql.SQLException
See ResultSet#getByte(int)

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getByte(int)

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException
See ResultSet#getByte(String)

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getByte(String)

getShort

public short getShort(int index)
               throws java.sql.SQLException
See ResultSet#getShort(int)

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getShort(int)

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException
See ResultSet#getShort(String)

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getShort(java.lang.String)

getInt

public int getInt(int index)
           throws java.sql.SQLException
See ResultSet#getInt(int)

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getInt(int)

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException
See ResultSet#getInt(String)

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getInt(java.lang.String)

getFloat

public float getFloat(int index)
               throws java.sql.SQLException
See ResultSet#getFloat(int)

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getFloat(int)

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException
See ResultSet#getFloat(String)

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getFloat(java.lang.String)

getDouble

public double getDouble(int index)
                 throws java.sql.SQLException
See ResultSet#getDouble(int)

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDouble(int)

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException
See ResultSet#getDouble(String)

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getDouble(java.lang.String)

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
See ResultSet#getMetaData()

Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the description of a ResultSet object's columns or null if the driver cannot return a ResultSetMetaData object.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getMetaData()

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
See ResultSet#getWarnings()

Specified by:
getWarnings in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the first SQLWarning object reported or null if there are none.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getWarnings()

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
See ResultSet#clearWarnings()

Specified by:
clearWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.clearWarnings()

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
See ResultSet#setFetchDirection(int)

Specified by:
setFetchDirection in interface java.sql.ResultSet
Parameters:
direction - (Taken from Sun's Javadoc) an integer specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.setFetchDirection(int)

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
See ResultSet#getFetchDirection()

Specified by:
getFetchDirection in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the current fetch direction for this ResultSet object.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getFetchDirection()

setFetchSize

public void setFetchSize(int size)
                  throws java.sql.SQLException
See ResultSet#setFetchSize(int)

Specified by:
setFetchSize in interface java.sql.ResultSet
Parameters:
size - (Taken from Sun's Javadoc) the number of rows to fetch.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.setFetchSize(int)

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
See ResultSet#getFetchSize()

Specified by:
getFetchSize in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the current fetch size for this ResultSet object.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getFetchSize()

getString

public java.lang.String getString(int index)
                           throws java.sql.SQLException
See ResultSet#getString(int)

Specified by:
getString in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getString(int)

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
See ResultSet#getString(String)

Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getString(java.lang.String)

getArray

public java.sql.Array getArray(int index)
                        throws java.sql.SQLException
See ResultSet#getArray(int)

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getArray(int)

getArray

public java.sql.Array getArray(java.lang.String columnName)
                        throws java.sql.SQLException
See ResultSet#getArray(String)

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getArray(java.lang.String)

getAsciiStream

public java.io.InputStream getAsciiStream(int index)
                                   throws java.sql.SQLException
See ResultSet#getAsciiStream(int)

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getAsciiStream(int)

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
See ResultSet#getAsciiStream(String)

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getAsciiStream(String)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int index,
                                          int scale)
                                   throws java.sql.SQLException
See ResultSet#getBigDecimal(int,int)

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
scale - (Taken from Sun's Javadoc) the number of digits to the right of the decimal point.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBigDecimal(int,int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException
See ResultSet#getBigDecimal(String,int)

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
scale - (Taken from Sun's Javadoc) the number of digits to the right of the decimal point.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBigDecimal(java.lang.String,int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int index)
                                   throws java.sql.SQLException
See ResultSet#getBigDecimal(int)

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBigDecimal(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException
See ResultSet#getBigDecimal(String)

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBigDecimal(java.lang.String)

getBinaryStream

public java.io.InputStream getBinaryStream(int index)
                                    throws java.sql.SQLException
See ResultSet#getBinaryStream(int)

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBinaryStream(int)

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
See ResultSet#getBinaryStream(String)

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
java.sql.ResultSet#getBinaryStream(java.lang.Stream)

getBlob

public java.sql.Blob getBlob(int index)
                      throws java.sql.SQLException
See ResultSet#getBlob(int)

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBlob(int)

getBlob

public java.sql.Blob getBlob(java.lang.String columnName)
                      throws java.sql.SQLException
See ResultSet#getBlob(String)

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getBlob(String)

getClob

public java.sql.Clob getClob(int index)
                      throws java.sql.SQLException
See ResultSet#getClob(int)

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getClob(int)

getClob

public java.sql.Clob getClob(java.lang.String columnName)
                      throws java.sql.SQLException
See ResultSet#getClob(String)

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getClob(java.lang.String)

getTimestamp

public java.sql.Timestamp getTimestamp(int index)
                                throws java.sql.SQLException
See ResultSet#getTimestamp(int)

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
See ResultSet#getTimestamp(String)

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTimestamp(java.lang.String)

getTimestamp

public java.sql.Timestamp getTimestamp(int index,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
See ResultSet#getTimestamp(int,Calendar)

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTimestamp(int,java.util.Calendar)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
See ResultSet#getTimestamp(String,Calendar)

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getTimestamp(java.lang.String,java.util.Calendar)

getUnicodeStream

public java.io.InputStream getUnicodeStream(int index)
                                     throws java.sql.SQLException
See ResultSet#getUnicodeStream(int)

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getUnicodeStream(int)

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
See ResultSet#getUnicodeStream(String)

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getUnicodeStream(java.lang.String)

wasNull

public boolean wasNull()
                throws java.sql.SQLException
See ResultSet#wasNull()

Specified by:
wasNull in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the last column value read was SQL NULL and false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.wasNull()

getCharacterStream

public java.io.Reader getCharacterStream(int index)
                                  throws java.sql.SQLException
See ResultSet#getCharacterStream(int)

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getCharacterStream(int)

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException
See ResultSet#getCharacterStream(String)

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getCharacterStream(java.lang.String)

absolute

public boolean absolute(int index)
                 throws java.sql.SQLException
See ResultSet#absolute(int)

Specified by:
absolute in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) true if the cursor is on the result set; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.absolute(int)

afterLast

public void afterLast()
               throws java.sql.SQLException
See ResultSet#afterLast()

Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.afterLast()

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
See ResultSet#beforeFirst()

Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.beforeFirst()

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
See ResultSet#cancelRowUpdates()

Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.cancelRowUpdates()

deleteRow

public void deleteRow()
               throws java.sql.SQLException
See ResultSet#deleteRow()

Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.deleteRow()

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException
See ResultSet#findColumn(String)

Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column index of the given column name.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.findColumn(java.lang.String)

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
See ResultSet#getConcurrency()

Specified by:
getConcurrency in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the concurrency type, either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getConcurrency()

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
See ResultSet#getCursorName()

Specified by:
getCursorName in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the SQL name for this ResultSet object's cursor.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getCursorName()

getRow

public int getRow()
           throws java.sql.SQLException
See ResultSet#getRow()

Specified by:
getRow in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the current row number; 0 if there is no current row.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getRow()

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException
See ResultSet#getStatement()

Specified by:
getStatement in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) the Statement object that produced this ResultSet object or null if the result set was produced some other way.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getStatement()

insertRow

public void insertRow()
               throws java.sql.SQLException
See ResultSet#insertRow()

Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.insertRow()

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
See ResultSet#isAfterLast()

Specified by:
isAfterLast in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is after the last row; false if the cursor is at any other position or the result set contains no rows.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.isAfterLast()

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
See ResultSet#isBeforeFirst()

Specified by:
isBeforeFirst in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.isBeforeFirst()

isFirst

public boolean isFirst()
                throws java.sql.SQLException
See ResultSet#isFirst()

Specified by:
isFirst in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is on the first row; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.isFirst()

isLast

public boolean isLast()
               throws java.sql.SQLException
See ResultSet#isLast()

Specified by:
isLast in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is on the last row; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.isLast()

last

public boolean last()
             throws java.sql.SQLException
See ResultSet#last()

Specified by:
last in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.last()

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
See ResultSet#moveToCurrentRow()

Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.moveToCurrentRow()

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
See ResultSet#moveToInsertRow()

Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.moveToInsertRow()

refreshRow

public void refreshRow()
                throws java.sql.SQLException
See ResultSet#refreshRow()

Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.refreshRow()

relative

public boolean relative(int index)
                 throws java.sql.SQLException
See ResultSet#relative(int)

Specified by:
relative in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Returns:
(Taken from Sun's Javadoc) true if the cursor is on a row; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.relative(int)

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
See ResultSet#rowDeleted()

Specified by:
rowDeleted in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if a row was deleted and deletions are detected; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.rowDeleted()

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
See ResultSet#rowInserted()

Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if a row has had an insertion and insertions are detected; false otherwise.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.rowInserted()

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
See ResultSet#rowUpdated()

Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
(Taken from Sun's Javadoc) true if both (1) the row has been visibly updated by the owner or another and (2) updates are detected.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.rowUpdated()

updateAsciiStream

public void updateAsciiStream(int index,
                              java.io.InputStream value,
                              int length)
                       throws java.sql.SQLException
See ResultSet#updateAsciiStream(int,InputStream,int)

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateAsciiStream(int,java.io.InputStream,int)

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream value,
                              int length)
                       throws java.sql.SQLException
See ResultSet#updateAsciiStream(String,InputStream,int)

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateAsciiStream(java.lang.String,java.io.InputStream,int)

updateBigDecimal

public void updateBigDecimal(int index,
                             java.math.BigDecimal value)
                      throws java.sql.SQLException
See ResultSet#updateBigDecimal(int,BigDecimal)

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBigDecimal(int,java.math.BigDecimal)

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName,
                             java.math.BigDecimal value)
                      throws java.sql.SQLException
See ResultSet#updateBigDecimal(String,BigDecimal)

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBigDecimal(java.lang.String,java.math.BigDecimal)

updateBinaryStream

public void updateBinaryStream(int index,
                               java.io.InputStream value,
                               int length)
                        throws java.sql.SQLException
See ResultSet#updateBinaryStream(int,InputStream,int)

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBinaryStream(int,java.io.InputStream,int)

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName,
                               java.io.InputStream value,
                               int length)
                        throws java.sql.SQLException
See ResultSet#updateBinaryStream(String,InputStream,int)

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
java.sql.ResultSet#updateBinrayStream(java.lang.String,java.io.InputStream,int)

updateBoolean

public void updateBoolean(int index,
                          boolean value)
                   throws java.sql.SQLException
See ResultSet#updateBoolean(int,boolean)

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBoolean(int,boolean)

updateBoolean

public void updateBoolean(java.lang.String columnName,
                          boolean value)
                   throws java.sql.SQLException
See ResultSet#updateBoolean(String,boolean)

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBoolean(java.lang.String,boolean)

updateByte

public void updateByte(int index,
                       byte value)
                throws java.sql.SQLException
See ResultSet#updateByte(int,byte)

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateByte(int,byte)

updateByte

public void updateByte(java.lang.String columnName,
                       byte value)
                throws java.sql.SQLException
See ResultSet#updateByte(String,byte)

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateByte(java.lang.String,byte)

updateBytes

public void updateBytes(int index,
                        byte[] value)
                 throws java.sql.SQLException
See ResultSet#updateBytes(int,byte[])

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBytes(int,byte[])

updateBytes

public void updateBytes(java.lang.String columnName,
                        byte[] value)
                 throws java.sql.SQLException
See ResultSet#updateBytes(String,byte[])

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBytes(java.lang.String,byte[])

updateCharacterStream

public void updateCharacterStream(int index,
                                  java.io.Reader value,
                                  int length)
                           throws java.sql.SQLException
See ResultSet#updateCharacterStream(int,Reader,int)

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateCharacterStream(int,java.io.Reader,int)

updateCharacterStream

public void updateCharacterStream(java.lang.String columnName,
                                  java.io.Reader value,
                                  int length)
                           throws java.sql.SQLException
See ResultSet#updateCharacterStream(String,Reader,int)

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateCharacterStream(java.lang.String,java.io.Reader,int)

updateDate

public void updateDate(int index,
                       java.sql.Date value)
                throws java.sql.SQLException
See ResultSet#updateDate(int,Date)

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateDate(int,java.sql.Date)

updateDate

public void updateDate(java.lang.String columnName,
                       java.sql.Date value)
                throws java.sql.SQLException
See ResultSet#updateDate(String,Date)

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateDate(java.lang.String,java.sql.Date)

updateDouble

public void updateDouble(int index,
                         double value)
                  throws java.sql.SQLException
See ResultSet#updateDouble(int,double)

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateDouble(int,double)

updateDouble

public void updateDouble(java.lang.String columnName,
                         double value)
                  throws java.sql.SQLException
See ResultSet#updateDouble(String,double)

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateDouble(String,double)

updateFloat

public void updateFloat(int index,
                        float value)
                 throws java.sql.SQLException
See ResultSet#updateFloat(int,float)

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateFloat(int,float)

updateFloat

public void updateFloat(java.lang.String columnName,
                        float value)
                 throws java.sql.SQLException
See ResultSet#updateFloat(String,float)

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs
See Also:
ResultSet.updateFloat(String,float)

updateInt

public void updateInt(int index,
                      int value)
               throws java.sql.SQLException
See ResultSet#updateInt(int,int)

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateInt(int,int)

updateInt

public void updateInt(java.lang.String columnName,
                      int value)
               throws java.sql.SQLException
See ResultSet#updateInt(String,int)

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateInt(java.lang.String,int)

updateLong

public void updateLong(int index,
                       long value)
                throws java.sql.SQLException
See ResultSet#updateLong(int,long)

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateLong(int,long)

updateLong

public void updateLong(java.lang.String columnName,
                       long value)
                throws java.sql.SQLException
See ResultSet#updateLong(String,long)

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs
See Also:
ResultSet.updateLong(java.lang.String,long)

updateNull

public void updateNull(int index)
                throws java.sql.SQLException
See ResultSet#updateNull(int)

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateNull(int)

updateNull

public void updateNull(java.lang.String columnName)
                throws java.sql.SQLException
See ResultSet#updateNull(String)

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateNull(java.lang.String)

updateObject

public void updateObject(int index,
                         java.lang.Object value,
                         int scale)
                  throws java.sql.SQLException
See ResultSet#updateObject(int,Object,int)

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
scale - (Taken from Sun's Javadoc) for java.sql.Types.DECIMA or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateObject(int,java.lang.Object,int)

updateObject

public void updateObject(int index,
                         java.lang.Object value)
                  throws java.sql.SQLException
See ResultSet#updateObject(int,Object)

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateObject(int,java.lang.Object)

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object value,
                         int scale)
                  throws java.sql.SQLException
See ResultSet#updateObject(String,Object,int)

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
scale - (Taken from Sun's Javadoc) for java.sql.Types.DECIMA or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateObject(java.lang.String,java.lang.Object,int)

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object value)
                  throws java.sql.SQLException
See ResultSet#updateObject(String,Object)

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateObject(java.lang.String,java.lang.Object)

updateRow

public void updateRow()
               throws java.sql.SQLException
See ResultSet#updateRow()

Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateRow()

updateShort

public void updateShort(int index,
                        short value)
                 throws java.sql.SQLException
See ResultSet#updateShort(int,short)

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateShort(int,short)

updateShort

public void updateShort(java.lang.String columnName,
                        short value)
                 throws java.sql.SQLException
See ResultSet#updateShort(String,short)

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateShort(java.lang.String,short)

updateString

public void updateString(int index,
                         java.lang.String value)
                  throws java.sql.SQLException
See ResultSet#updateString(int,String)

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateString(int,java.lang.String)

updateString

public void updateString(java.lang.String columnName,
                         java.lang.String value)
                  throws java.sql.SQLException
See ResultSet#updateString(String,String)

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateString(java.lang.String,java.lang.String)

updateTime

public void updateTime(int index,
                       java.sql.Time value)
                throws java.sql.SQLException
See ResultSet#updateTime(int,Time)

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateTime(int,java.sql.Time)

updateTime

public void updateTime(java.lang.String columnName,
                       java.sql.Time value)
                throws java.sql.SQLException
See ResultSet#updateTime(String,Time)

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateTime(java.lang.String,java.sql.Time)

updateTimestamp

public void updateTimestamp(int index,
                            java.sql.Timestamp value)
                     throws java.sql.SQLException
See ResultSet#updateTimestamp(int,Timestamp)

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
index - (Taken from Sun's Javadoc) the first column is 1, the second is 2, ...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateTimestamp(int,java.sql.Timestamp)

updateTimestamp

public void updateTimestamp(java.lang.String columnName,
                            java.sql.Timestamp value)
                     throws java.sql.SQLException
See ResultSet#updateTimestamp(String,Timestamp)

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateTimestamp(java.lang.String,java.sql.Timestamp)

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
See ResultSet#getURL(int)

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
columnIndex - (Taken from Sun's Javadoc) the index of the column 1 is the first, 2 is the second,...
Returns:
(Taken from Sun's Javadoc) the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getURL(int)

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
See ResultSet#getURL(String)

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
Returns:
(Taken from Sun's Javadoc) the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.getURL(java.lang.String)

updateRef

public void updateRef(int columnIndex,
                      java.sql.Ref value)
               throws java.sql.SQLException
See ResultSet#updateRef(int,Ref)

Specified by:
updateRef in interface java.sql.ResultSet
Parameters:
columnIndex - (Taken from Sun's Javadoc) the index of the column 1 is the first, 2 is the second,...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateRef(int,java.sql.Ref)

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref value)
               throws java.sql.SQLException
See ResultSet#updateRef(String,Ref)

Specified by:
updateRef in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateRef(java.lang.String,java.sql.Ref)

updateBlob

public void updateBlob(int columnIndex,
                       java.sql.Blob value)
                throws java.sql.SQLException
See ResultSet#updateBlob(int,Blob)

Specified by:
updateBlob in interface java.sql.ResultSet
Parameters:
columnIndex - (Taken from Sun's Javadoc) the index of the column 1 is the first, 2 is the second,...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBlob(int,java.sql.Blob)

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob value)
                throws java.sql.SQLException
See ResultSet#updateBlob(String,Blob)

Specified by:
updateBlob in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBlob(java.lang.String,java.sql.Blob)

updateClob

public void updateClob(int columnIndex,
                       java.sql.Clob value)
                throws java.sql.SQLException
See ResultSet#updateClob(int,Clob)

Specified by:
updateClob in interface java.sql.ResultSet
Parameters:
columnIndex - (Taken from Sun's Javadoc) the index of the column 1 is the first, 2 is the second,...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateClob(int,java.sql.Clob)

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob value)
                throws java.sql.SQLException
See ResultSet#updateClob(String,Clob)

Specified by:
updateClob in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateClob(java.lang.String,java.sql.Clob)

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array value)
                 throws java.sql.SQLException
See ResultSet#updateArray(int,Array)

Specified by:
updateArray in interface java.sql.ResultSet
Parameters:
columnIndex - (Taken from Sun's Javadoc) the index of the column 1 is the first, 2 is the second,...
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateArray(int,java.sql.Array)

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array value)
                 throws java.sql.SQLException
See ResultSet#updateArray(String,Array)

Specified by:
updateArray in interface java.sql.ResultSet
Parameters:
columnName - (Taken from Sun's Javadoc) the SQL name of the column.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateArray(java.lang.String,java.sql.Array)

getBytes

public byte[] getBytes(Field field)
                throws java.sql.SQLException
Retrieves a byte array value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getBoolean

public boolean getBoolean(Field field)
                   throws java.sql.SQLException
Retrieves a boolean value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is false.
Throws:
java.sql.SQLException - if an error occurs.

getLong

public long getLong(Field field)
             throws java.sql.SQLException
Retrieves a boolean value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.

getObject

public java.lang.Object getObject(Field field)
                           throws java.sql.SQLException
Retrieves an object value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getObject

public java.lang.Object getObject(Field field,
                                  java.util.Map map)
                           throws java.sql.SQLException
Retrieves an object value using the field reference.

Parameters:
field - the field.
map - (Taken from Sun's Javadoc) a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getRef

public java.sql.Ref getRef(Field field)
                    throws java.sql.SQLException
Retrieves a Ref value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getTime

public java.sql.Time getTime(Field field)
                      throws java.sql.SQLException
Retrieves a Time value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getTime

public java.sql.Time getTime(Field field,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Retrieves a Time value using the field reference.

Parameters:
field - the field.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getDate

public java.sql.Date getDate(Field field)
                      throws java.sql.SQLException
Retrieves a Date value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getDate

public java.sql.Date getDate(Field field,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Retrieves a Date value using the field reference.

Parameters:
field - the field.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getByte

public byte getByte(Field field)
             throws java.sql.SQLException
Retrieves a byte value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getShort

public short getShort(Field field)
               throws java.sql.SQLException
Retrieves a short value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getInt

public int getInt(Field field)
           throws java.sql.SQLException
Retrieves an integer value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getFloat

public float getFloat(Field field)
               throws java.sql.SQLException
Retrieves a float value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getDouble

public double getDouble(Field field)
                 throws java.sql.SQLException
Retrieves a double value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is 0.
Throws:
java.sql.SQLException - if an error occurs.

getString

public java.lang.String getString(Field field)
                           throws java.sql.SQLException
Retrieves a text value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getArray

public java.sql.Array getArray(Field field)
                        throws java.sql.SQLException
Retrieves an array value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getAsciiStream

public java.io.InputStream getAsciiStream(Field field)
                                   throws java.sql.SQLException
Retrieves an ASCII stream using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getBigDecimal

public java.math.BigDecimal getBigDecimal(Field field,
                                          int scale)
                                   throws java.sql.SQLException
Retrieves a BigDecimal value using the field reference.

Parameters:
field - the field.
scale - (Taken from Sun's Javadoc) the number of digits to the right of the decimal point.
Throws:
java.sql.SQLException - if an error occurs.

getBigDecimal

public java.math.BigDecimal getBigDecimal(Field field)
                                   throws java.sql.SQLException
Retrieves a BigDecimal value using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getBinaryStream

public java.io.InputStream getBinaryStream(Field field)
                                    throws java.sql.SQLException
Retrieves a binary stream using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getBlob

public java.sql.Blob getBlob(Field field)
                      throws java.sql.SQLException
Retrieves a blob using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getClob

public java.sql.Clob getClob(Field field)
                      throws java.sql.SQLException
Retrieves a clob value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getTimestamp

public java.sql.Timestamp getTimestamp(Field field)
                                throws java.sql.SQLException
Retrieves a timestamp value using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getTimestamp

public java.sql.Timestamp getTimestamp(Field field,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
Retrieves a timestamp value using the field reference.

Parameters:
field - the field.
calendar - (Taken from Sun's Javadoc) the java.util.Calendar object to use in constructing the time.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getUnicodeStream

public java.io.InputStream getUnicodeStream(Field field)
                                     throws java.sql.SQLException
Retrieves an Unicode stream using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

getCharacterStream

public java.io.Reader getCharacterStream(Field field)
                                  throws java.sql.SQLException
Retrieves a character stream using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value; if the value is SQL NULL, the value returned is null.
Throws:
java.sql.SQLException - if an error occurs.

getURL

public java.net.URL getURL(Field field)
                    throws java.sql.SQLException
Retrieves an URL using the field reference.

Parameters:
field - the field.
Returns:
(Taken from Sun's Javadoc) the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:
java.sql.SQLException - if an error occurs.

findColumn

public int findColumn(Field field)
               throws java.sql.SQLException
Retrieves the column index associated to given field.

Parameters:
field - the field.
Returns:
the column index of the given field.
Throws:
java.sql.SQLException - if an error occurs.

updateAsciiStream

public void updateAsciiStream(Field field,
                              java.io.InputStream value,
                              int length)
                       throws java.sql.SQLException
Updates an ASCII stream column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.

updateBigDecimal

public void updateBigDecimal(Field field,
                             java.math.BigDecimal value)
                      throws java.sql.SQLException
See ResultSet#updateBigDecimal(String,BigDecimal)

Throws:
java.sql.SQLException - if an error occurs.
See Also:
ResultSet.updateBigDecimal(java.lang.String,java.math.BigDecimal)

updateBinaryStream

public void updateBinaryStream(Field field,
                               java.io.InputStream value,
                               int length)
                        throws java.sql.SQLException
Updates a binary stream column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.

updateBoolean

public void updateBoolean(Field field,
                          boolean value)
                   throws java.sql.SQLException
Updates a boolean column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateByte

public void updateByte(Field field,
                       byte value)
                throws java.sql.SQLException
Updates a byte column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateBytes

public void updateBytes(Field field,
                        byte[] value)
                 throws java.sql.SQLException
Updates a byte array column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateCharacterStream

public void updateCharacterStream(Field field,
                                  java.io.Reader value,
                                  int length)
                           throws java.sql.SQLException
Updates a character stream column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
length - (Taken from Sun's Javadoc) the length of the stream.
Throws:
java.sql.SQLException - if an error occurs.

updateDate

public void updateDate(Field field,
                       java.sql.Date value)
                throws java.sql.SQLException
Updates a date column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateDouble

public void updateDouble(Field field,
                         double value)
                  throws java.sql.SQLException
Updates a double column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateFloat

public void updateFloat(Field field,
                        float value)
                 throws java.sql.SQLException
Updates a float column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs

updateInt

public void updateInt(Field field,
                      int value)
               throws java.sql.SQLException
Updates an integer column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateLong

public void updateLong(Field field,
                       long value)
                throws java.sql.SQLException
Updates a long column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs

updateNull

public void updateNull(Field field)
                throws java.sql.SQLException
Sets a column to null using the field reference.

Parameters:
field - the field.
Throws:
java.sql.SQLException - if an error occurs.

updateObject

public void updateObject(Field field,
                         java.lang.Object value,
                         int scale)
                  throws java.sql.SQLException
Updates an object column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
scale - (Taken from Sun's Javadoc) for java.sql.Types.DECIMA or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:
java.sql.SQLException - if an error occurs.

updateObject

public void updateObject(Field field,
                         java.lang.Object value)
                  throws java.sql.SQLException
Updates an object column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateShort

public void updateShort(Field field,
                        short value)
                 throws java.sql.SQLException
Updates a short column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateString

public void updateString(Field field,
                         java.lang.String value)
                  throws java.sql.SQLException
Updates a text column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateTime

public void updateTime(Field field,
                       java.sql.Time value)
                throws java.sql.SQLException
Updates a time column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateTimestamp

public void updateTimestamp(Field field,
                            java.sql.Timestamp value)
                     throws java.sql.SQLException
Updates a timestamp column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateRef

public void updateRef(Field field,
                      java.sql.Ref value)
               throws java.sql.SQLException
Updates a Ref column using the field reference.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateBlob

public void updateBlob(Field field,
                       java.sql.Blob value)
                throws java.sql.SQLException
Updates a Blob column using the field bloberence.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateClob

public void updateClob(Field field,
                       java.sql.Clob value)
                throws java.sql.SQLException
Updates a Clob column using the field cloberence.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.

updateArray

public void updateArray(Field field,
                        java.sql.Array value)
                 throws java.sql.SQLException
Updates a Array column using the field arrayerence.

Parameters:
field - the field.
value - (Taken from Sun's Javadoc) the new column value.
Throws:
java.sql.SQLException - if an error occurs.


Copyright © 2003 ACM S.L.. All Rights Reserved.