Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.jcreme.sql
Class WrappedResultSet

java.lang.Object
  extended byorg.jcreme.sql.WrappedResultSet
All Implemented Interfaces:
java.sql.ResultSet
public class WrappedResultSet
extends java.lang.Object
implements java.sql.ResultSet

This class enables to wrap an actual ResultSet to provide a few extra services: tracing of the queries, handling of some exceptions (rollback, loss of connection).

Version:
$Revision: 1.1 $
Author:
$Author: dbregeon $

Field Summary
protected static java.lang.String UNKNOWN_QUERY
          The String displayed when no query has been assigned to the ResultSet yet.
 
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
WrappedResultSet(java.sql.ResultSet rs, java.sql.Statement stmt, java.lang.String sql)
          Enables to wrap a ResultSet.
 
Method Summary
 boolean absolute(int row)
           
 void afterLast()
           
 void beforeFirst()
           
 void cancelRowUpdates()
           
 void clearWarnings()
           
 void close()
           
 void deleteRow()
           
 int findColumn(java.lang.String columnName)
           
 boolean first()
           
protected  ConnectionLostException generateConnectionLostException(java.lang.String message, java.sql.SQLException e)
          This method generates a ConnectionLostException from an SQLException.
protected  DeadLockException generateDeadLockException(java.lang.String message, java.sql.SQLException e)
          This method generates a DeadLockException from an SQLException.
protected  java.sql.SQLException generateException(java.sql.SQLException e)
          This method enables to generate an SQLException that contains the query of the ResultSet in its message.
protected  java.sql.SQLException generateNewException(java.lang.String message, java.sql.SQLException e)
          This method generates a new SQLException from an SQLException.
 java.sql.Array getArray(int i)
           
 java.sql.Array getArray(java.lang.String colName)
           
 java.io.InputStream getAsciiStream(int columnIndex)
           
 java.io.InputStream getAsciiStream(java.lang.String columnName)
           
 java.math.BigDecimal getBigDecimal(int columnIndex)
           
 java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
          Deprecated.  
 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
           
 java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
          Deprecated.  
 java.io.InputStream getBinaryStream(int columnIndex)
           
 java.io.InputStream getBinaryStream(java.lang.String columnName)
           
 java.sql.Blob getBlob(int i)
           
 java.sql.Blob getBlob(java.lang.String colName)
           
 boolean getBoolean(int columnIndex)
           
 boolean getBoolean(java.lang.String columnName)
           
 byte getByte(int columnIndex)
           
 byte getByte(java.lang.String columnName)
           
 byte[] getBytes(int columnIndex)
           
 byte[] getBytes(java.lang.String columnName)
           
 java.io.Reader getCharacterStream(int columnIndex)
           
 java.io.Reader getCharacterStream(java.lang.String columnName)
           
 java.sql.Clob getClob(int i)
           
 java.sql.Clob getClob(java.lang.String colName)
           
 int getConcurrency()
           
 java.lang.String getCursorName()
           
 java.sql.Date getDate(int columnIndex)
           
 java.sql.Date getDate(int columnIndex, java.util.Calendar cal)
           
 java.sql.Date getDate(java.lang.String columnName)
           
 java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal)
           
 double getDouble(int columnIndex)
           
 double getDouble(java.lang.String columnName)
           
 int getFetchDirection()
           
 int getFetchSize()
           
 float getFloat(int columnIndex)
           
 float getFloat(java.lang.String columnName)
           
 int getInt(int columnIndex)
           
 int getInt(java.lang.String columnName)
           
 long getLong(int columnIndex)
           
 long getLong(java.lang.String columnName)
           
 java.sql.ResultSetMetaData getMetaData()
           
 java.lang.Object getObject(int columnIndex)
           
 java.lang.Object getObject(int i, java.util.Map map)
           
 java.lang.Object getObject(java.lang.String columnName)
           
 java.lang.Object getObject(java.lang.String colName, java.util.Map map)
           
 java.sql.Ref getRef(int i)
           
 java.sql.Ref getRef(java.lang.String colName)
           
 int getRow()
           
 short getShort(int columnIndex)
           
 short getShort(java.lang.String columnName)
           
 java.sql.Statement getStatement()
           
 java.lang.String getString(int columnIndex)
           
 java.lang.String getString(java.lang.String columnName)
           
 java.sql.Time getTime(int columnIndex)
           
 java.sql.Time getTime(int columnIndex, java.util.Calendar cal)
           
 java.sql.Time getTime(java.lang.String columnName)
           
 java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(int columnIndex)
           
 java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(java.lang.String columnName)
           
 java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal)
           
 int getType()
           
 java.io.InputStream getUnicodeStream(int columnIndex)
          Deprecated.  
 java.io.InputStream getUnicodeStream(java.lang.String columnName)
          Deprecated. use getCharacterStream instead
 java.net.URL getURL(int columnIndex)
           
 java.net.URL getURL(java.lang.String columnName)
           
 java.sql.SQLWarning getWarnings()
           
 void insertRow()
           
 boolean isAfterLast()
           
 boolean isBeforeFirst()
           
 boolean isFirst()
           
 boolean isLast()
           
 boolean last()
           
protected  int manageException(java.sql.SQLException e)
          This method enables to call upon an ExceptionHandler to manage the given exception.
protected  int manageException(java.sql.SQLException e, CremeAction redo)
          This method enables to call upon an ExceptionHandler to manage the given exception.
 void moveToCurrentRow()
           
 void moveToInsertRow()
           
 boolean next()
           
 boolean previous()
           
 void refreshRow()
           
 boolean relative(int rows)
           
 boolean rowDeleted()
           
 boolean rowInserted()
           
 boolean rowUpdated()
           
 void setFetchDirection(int direction)
           
 void setFetchSize(int rows)
           
 void updateArray(int columnIndex, java.sql.Array x)
           
 void updateArray(java.lang.String columnName, java.sql.Array x)
           
 void updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
           
 void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
           
 void updateBigDecimal(int columnIndex, java.math.BigDecimal x)
           
 void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
           
 void updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
           
 void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
           
 void updateBlob(int columnIndex, java.sql.Blob x)
           
 void updateBlob(java.lang.String columnName, java.sql.Blob x)
           
 void updateBoolean(int columnIndex, boolean x)
           
 void updateBoolean(java.lang.String columnName, boolean x)
           
 void updateByte(int columnIndex, byte x)
           
 void updateByte(java.lang.String columnName, byte x)
           
 void updateBytes(int columnIndex, byte[] x)
           
 void updateBytes(java.lang.String columnName, byte[] x)
           
 void updateCharacterStream(int columnIndex, java.io.Reader x, int length)
           
 void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
           
 void updateClob(int columnIndex, java.sql.Clob x)
           
 void updateClob(java.lang.String columnName, java.sql.Clob x)
           
 void updateDate(int columnIndex, java.sql.Date x)
           
 void updateDate(java.lang.String columnName, java.sql.Date x)
           
 void updateDouble(int columnIndex, double x)
           
 void updateDouble(java.lang.String columnName, double x)
           
 void updateFloat(int columnIndex, float x)
           
 void updateFloat(java.lang.String columnName, float x)
           
 void updateInt(int columnIndex, int x)
           
 void updateInt(java.lang.String columnName, int x)
           
 void updateLong(int columnIndex, long x)
           
 void updateLong(java.lang.String columnName, long x)
           
 void updateNull(int columnIndex)
           
 void updateNull(java.lang.String columnName)
           
 void updateObject(int columnIndex, java.lang.Object x)
           
 void updateObject(int columnIndex, java.lang.Object x, int scale)
           
 void updateObject(java.lang.String columnName, java.lang.Object x)
           
 void updateObject(java.lang.String columnName, java.lang.Object x, int scale)
           
 void updateRef(int columnIndex, java.sql.Ref x)
           
 void updateRef(java.lang.String columnName, java.sql.Ref x)
           
 void updateRow()
           
 void updateShort(int columnIndex, short x)
           
 void updateShort(java.lang.String columnName, short x)
           
 void updateString(int columnIndex, java.lang.String x)
           
 void updateString(java.lang.String columnName, java.lang.String x)
           
 void updateTime(int columnIndex, java.sql.Time x)
           
 void updateTime(java.lang.String columnName, java.sql.Time x)
           
 void updateTimestamp(int columnIndex, java.sql.Timestamp x)
           
 void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)
           
 boolean wasNull()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

UNKNOWN_QUERY

protected static final java.lang.String UNKNOWN_QUERY
The String displayed when no query has been assigned to the ResultSet yet.

See Also:
Constant Field Values
Constructor Detail

WrappedResultSet

public WrappedResultSet(java.sql.ResultSet rs,
                        java.sql.Statement stmt,
                        java.lang.String sql)
                 throws java.sql.SQLException
Enables to wrap a ResultSet.

Parameters:
rs - the ResultSet to wrap.
stmt - the Statement that produced this ResultSet.
sql - the query that produced this ResultSet.
Throws:
java.sql.SQLException - if the statement is null.
Method Detail

generateException

protected java.sql.SQLException generateException(java.sql.SQLException e)
This method enables to generate an SQLException that contains the query of the ResultSet in its message.

Parameters:
e - the original exception.
Returns:
an exception which has the query as message.

generateDeadLockException

protected DeadLockException generateDeadLockException(java.lang.String message,
                                                      java.sql.SQLException e)
This method generates a DeadLockException from an SQLException.

Parameters:
message - the message to append.
e - the original exception.
Returns:
a DeadLockException with the given message.

generateConnectionLostException

protected ConnectionLostException generateConnectionLostException(java.lang.String message,
                                                                  java.sql.SQLException e)
This method generates a ConnectionLostException from an SQLException.

Parameters:
message - the message to append.
e - the original exception.
Returns:
a ConnectionLostException with the given message.

generateNewException

protected java.sql.SQLException generateNewException(java.lang.String message,
                                                     java.sql.SQLException e)
This method generates a new SQLException from an SQLException.

Parameters:
message - the message to append.
e - the original exception.
Returns:
a new SQLException with the given message.

manageException

protected int manageException(java.sql.SQLException e)
This method enables to call upon an ExceptionHandler to manage the given exception. Both rollbacks and loss of connections are handled through this method.

Parameters:
e - exception to handle.
Returns:
the type of the exception as defined in the SQLExceptionHandler interface.

manageException

protected int manageException(java.sql.SQLException e,
                              CremeAction redo)
This method enables to call upon an ExceptionHandler to manage the given exception. Both rollbacks and loss of connections are handled through this method. This method also enables to redo the action that caused the original exception.

Parameters:
e - exception to handle.
redo - the action that caused the original exception.
Returns:
the type of the exception as defined in the SQLExceptionHandler interface.

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getInt(int)

getRef

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

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(int)

getFetchSize

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

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int)

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getShort(int)

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateObject(int, java.lang.Object, int)

updateAsciiStream

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

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(java.lang.String)

getObject

public java.lang.Object getObject(java.lang.String colName,
                                  java.util.Map map)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(java.lang.String, java.util.Map)

updateBigDecimal

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

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(int)

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int, int)

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDouble(java.lang.String)

getMetaData

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

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateObject(java.lang.String, java.lang.Object)

first

public boolean first()
              throws java.sql.SQLException
Specified by:
first in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.first()

getTimestamp

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

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getAsciiStream(java.lang.String)

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBinaryStream(java.lang.String)

getStatement

public java.sql.Statement getStatement()
Specified by:
getStatement in interface java.sql.ResultSet
See Also:
ResultSet.getStatement()

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getFloat(int)

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCharacterStream(java.lang.String)

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getInt(java.lang.String)

updateBinaryStream

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

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateFloat(int, float)

clearWarnings

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

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCharacterStream(int)

isFirst

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

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateShort(int, short)

updateBigDecimal

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

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.cancelRowUpdates()

updateBinaryStream

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

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
findColumn in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.findColumn(java.lang.String)

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(java.lang.String)

getUnicodeStream

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

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getUnicodeStream(int)

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getString(java.lang.String)

getBytes

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

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.beforeFirst()

updateString

public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateString(int, java.lang.String)

updateByte

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

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Specified by:
getCursorName in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCursorName()

rowDeleted

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

getFetchDirection

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

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateInt(int, int)

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getLong(int)

updateBoolean

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

updateTime

public void updateTime(java.lang.String columnName,
                       java.sql.Time x)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateTime(java.lang.String, java.sql.Time)

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(int)

afterLast

public void afterLast()
               throws java.sql.SQLException
Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.afterLast()

getDate

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

last

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

getType

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

getArray

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

close

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

getRow

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

deleteRow

public void deleteRow()
               throws java.sql.SQLException
Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.deleteRow()

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateLong(int, long)

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getLong(java.lang.String)

updateInt

public void updateInt(java.lang.String columnName,
                      int x)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateInt(java.lang.String, int)

updateBytes

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

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(java.lang.String)

getRef

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

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(int)

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(java.lang.String, int)

updateDouble

public void updateDouble(java.lang.String columnName,
                         double x)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateDouble(java.lang.String, double)

rowUpdated

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

getBlob

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

getObject

public java.lang.Object getObject(int i,
                                  java.util.Map map)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(int, java.util.Map)

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(int)

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(java.lang.String)

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateObject(java.lang.String, java.lang.Object,int)

getWarnings

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

relative

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

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBytes(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(java.lang.String)

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateObject(int, java.lang.Object)

updateNull

public void updateNull(java.lang.String columnName)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateNull(java.lang.String)

updateTimestamp

public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateTimestamp(int, java.sql.Timestamp)

setFetchSize

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

updateDate

public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateDate(int, java.sql.Date)

getClob

public java.sql.Clob getClob(int i)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getClob(int)

updateNull

public void updateNull(int columnIndex)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateNull(int)

getClob

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

updateAsciiStream

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

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(java.lang.String)

isLast

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

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getFloat(java.lang.String)

isBeforeFirst

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

updateLong

public void updateLong(java.lang.String columnName,
                       long x)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateLong(java.lang.String, long)

updateBoolean

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

getDate

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

getConcurrency

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

getTime

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

updateBytes

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

getBlob

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

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDouble(int)

updateShort

public void updateShort(java.lang.String columnName,
                        short x)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateShort(java.lang.String, short)

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getAsciiStream(int)

setFetchDirection

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

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.moveToCurrentRow()

updateTime

public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateTime(int, java.sql.Time)

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateCharacterStream(int, java.io.Reader, int)

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
Deprecated. use getCharacterStream instead

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getUnicodeStream(java.lang.String)

updateRow

public void updateRow()
               throws java.sql.SQLException
Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateRow()

updateCharacterStream

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

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(java.lang.String)

updateString

public void updateString(java.lang.String columnName,
                         java.lang.String x)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateString(java.lang.String, java.lang.String)

rowInserted

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

updateFloat

public void updateFloat(java.lang.String columnName,
                        float x)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateFloat(java.lang.String, float)

insertRow

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

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBinaryStream(int)

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateDouble(int, double)

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.moveToInsertRow()

next

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

getTimestamp

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

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getShort(java.lang.String)

getTime

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

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
Specified by:
absolute in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.absolute(int)

updateDate

public void updateDate(java.lang.String columnName,
                       java.sql.Date x)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateDate(java.lang.String, java.sql.Date)

wasNull

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

previous

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

getArray

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

refreshRow

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

updateTimestamp

public void updateTimestamp(java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp)

updateByte

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

isAfterLast

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

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getString(int)

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getURL(int)

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getURL(java.lang.String)

updateRef

public void updateRef(int columnIndex,
                      java.sql.Ref x)
               throws java.sql.SQLException
Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateRef(int, java.sql.Ref)

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref x)
               throws java.sql.SQLException
Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateRef(java.lang.String, java.sql.Ref)

updateBlob

public void updateBlob(int columnIndex,
                       java.sql.Blob x)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob x)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateBlob(java.lang.String, java.sql.Blob)

updateClob

public void updateClob(int columnIndex,
                       java.sql.Clob x)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob x)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateClob(java.lang.String, java.sql.Clob)

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array x)
                 throws java.sql.SQLException
Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateArray(int, java.sql.Array)

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array x)
                 throws java.sql.SQLException
Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.updateArray(java.lang.String, java.sql.Array)
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright 2006 null. All Rights Reserved.