| java.lang.Object
 com.uwyn.rife.database.DbResultSet
All known Subclasses: com.uwyn.rife.database.DbResultSet40, com.uwyn.rife.database.DbResultSet30,
| Method Summary | |
| final public boolean | absolute(int row)
| | final public void | afterLast()
| | final public void | beforeFirst()
| | final public void | cancelRowUpdates()
| | final public void | clearWarnings()
| | public Object | clone()
Simply clones the instance with the default clone method. | | final public void | close()
| | final public void | deleteRow()
| | final public int | findColumn(String columnName)
| | final public boolean | first()
| | final public Array | getArray(String colName)
| | final public Array | getArray(int i)
| | final public InputStream | getAsciiStream(int columnIndex)
| | final public InputStream | getAsciiStream(String columnName)
| | final public BigDecimal | getBigDecimal(int columnIndex)
| | final public BigDecimal | getBigDecimal(String columnName)
| | final public BigDecimal | getBigDecimal(int columnIndex, int scale)
| | final public BigDecimal | getBigDecimal(String columnName, int scale)
| | final public InputStream | getBinaryStream(int columnIndex)
| | final public InputStream | getBinaryStream(String columnName)
| | final public Blob | getBlob(int i)
| | final public Blob | getBlob(String colName)
| | final public boolean | getBoolean(int columnIndex)
| | final public boolean | getBoolean(String columnName)
| | final public byte | getByte(int columnIndex)
| | final public byte | getByte(String columnName)
| | final public byte[] | getBytes(int columnIndex)
| | final public byte[] | getBytes(String columnName)
| | final public Reader | getCharacterStream(int columnIndex)
| | final public Reader | getCharacterStream(String columnName)
| | final public Clob | getClob(int i)
| | final public Clob | getClob(String colName)
| | final public int | getConcurrency()
| | final public String | getCursorName()
| | final public Date | getDate(int columnIndex)
| | final public Date | getDate(String columnName)
| | final public Date | getDate(int columnIndex, Calendar cal)
| | final public Date | getDate(String columnName, Calendar cal)
| | final public double | getDouble(int columnIndex)
| | final public double | getDouble(String columnName)
| | final public int | getFetchDirection()
| | final public int | getFetchSize()
| | public InputStream | getFirstAsciiStream()
Retrieves the first field of the first row of this
DbResultSet object as an ascii stream. | | public BigDecimal | getFirstBigDecimal()
Retrieves the first field of the first row of this
DbResultSet object as a big decimal. | | public InputStream | getFirstBinaryStream()
Retrieves the first field of the first row of this
DbResultSet object as a binary stream. | | public boolean | getFirstBoolean()
Retrieves the first field of the first row of this
DbResultSet object as a boolean. | | public byte | getFirstByte()
Retrieves the first field of the first row of this
DbResultSet object as a byte. | | public byte[] | getFirstBytes()
Retrieves the first field of the first row of this
DbResultSet object as an array of bytes. | | public Reader | getFirstCharacterStream()
Retrieves the first field of the first row of this
DbResultSet object as a character stream. | | public java.sql.Date | getFirstDate()
Retrieves the first field of the first row of this
DbResultSet object as a sql date. | | public java.sql.Date | getFirstDate(Calendar cal)
Retrieves the first field of the first row of this
DbResultSet object as a sql date. | | public double | getFirstDouble()
Retrieves the first field of the first row of this
DbResultSet object as a double. | | public float | getFirstFloat()
Retrieves the first field of the first row of this
DbResultSet object as a float. | | public int | getFirstInt()
Retrieves the first field of the first row of this
DbResultSet object as an integer. | | public long | getFirstLong()
Retrieves the first field of the first row of this
DbResultSet object as a long. | | public short | getFirstShort()
Retrieves the first field of the first row of this
DbResultSet object as a short. | | public String | getFirstString()
Retrieves the first field of the first row of this
DbResultSet object as a string. | | public java.sql.Time | getFirstTime()
Retrieves the first field of the first row of this
DbResultSet object as a sql time. | | public java.sql.Time | getFirstTime(Calendar cal)
Retrieves the first field of the first row of this
DbResultSet object as a sql time. | | public java.sql.Timestamp | getFirstTimestamp()
Retrieves the first field of the first row of this
DbResultSet object as a sql timestamo. | | public java.sql.Timestamp | getFirstTimestamp(Calendar cal)
Retrieves the first field of the first row of this
DbResultSet object as a sql timestamp. | | final public float | getFloat(int columnIndex)
| | final public float | getFloat(String columnName)
| | final public int | getInt(int columnIndex)
| | final public int | getInt(String columnName)
| | final public long | getLong(int columnIndex)
| | final public long | getLong(String columnName)
| | final public ResultSetMetaData | getMetaData()
| | final public Object | getObject(int columnIndex)
| | final public Object | getObject(String columnName)
| | final public Object | getObject(int i, Map map)
| | final public Object | getObject(String colName, Map map)
| | final public Ref | getRef(String colName)
| | final public Ref | getRef(int i)
| | final public int | getRow()
| | final public short | getShort(int columnIndex)
| | final public short | getShort(String columnName)
| | final public Statement | getStatement()
| | final public String | getString(int columnIndex)
| | final public String | getString(String columnName)
| | final public Time | getTime(int columnIndex)
| | final public Time | getTime(String columnName)
| | final public Time | getTime(int columnIndex, Calendar cal)
| | final public Time | getTime(String columnName, Calendar cal)
| | final public Timestamp | getTimestamp(int columnIndex)
| | final public Timestamp | getTimestamp(String columnName)
| | final public Timestamp | getTimestamp(int columnIndex, Calendar cal)
| | final public Timestamp | getTimestamp(String columnName, Calendar cal)
| | final public int | getType()
| | final public URL | getURL(int columnIndex)
| | final public URL | getURL(String columnName)
| | final public InputStream | getUnicodeStream(int columnIndex)
| | final public InputStream | getUnicodeStream(String columnName)
| | final public SQLWarning | getWarnings()
| | public boolean | hasResultRows()
Determines if there are rows available in the ResultSet
object that was returned by an execute method. | | final public void | insertRow()
| | final public boolean | isAfterLast()
| | final public boolean | isBeforeFirst()
| | final public boolean | isFirst()
| | final public boolean | isLast()
| | final public boolean | last()
| | final public void | moveToCurrentRow()
| | final public void | moveToInsertRow()
| | final public boolean | next()
| | final public boolean | previous()
| | final public void | refreshRow()
| | final public boolean | relative(int rows)
| | final public boolean | rowDeleted()
| | final public boolean | rowInserted()
| | final public boolean | rowUpdated()
| | final public void | setFetchDirection(int direction)
| | final public void | setFetchSize(int rows)
| | final public void | updateArray(int columnIndex, Array x)
| | final public void | updateArray(String columnName, Array x)
| | final public void | updateAsciiStream(int columnIndex, InputStream x, int length)
| | final public void | updateAsciiStream(String columnName, InputStream x, int length)
| | final public void | updateBigDecimal(int columnIndex, BigDecimal x)
| | final public void | updateBigDecimal(String columnName, BigDecimal x)
| | final public void | updateBinaryStream(int columnIndex, InputStream x, int length)
| | final public void | updateBinaryStream(String columnName, InputStream x, int length)
| | final public void | updateBlob(int columnIndex, Blob x)
| | final public void | updateBlob(String columnName, Blob x)
| | final public void | updateBoolean(int columnIndex, boolean x)
| | final public void | updateBoolean(String columnName, boolean x)
| | final public void | updateByte(int columnIndex, byte x)
| | final public void | updateByte(String columnName, byte x)
| | final public void | updateBytes(int columnIndex, byte[] x)
| | final public void | updateBytes(String columnName, byte[] x)
| | final public void | updateCharacterStream(int columnIndex, Reader x, int length)
| | final public void | updateCharacterStream(String columnName, Reader reader, int length)
| | final public void | updateClob(int columnIndex, Clob x)
| | final public void | updateClob(String columnName, Clob x)
| | final public void | updateDate(int columnIndex, Date x)
| | final public void | updateDate(String columnName, Date x)
| | final public void | updateDouble(int columnIndex, double x)
| | final public void | updateDouble(String columnName, double x)
| | final public void | updateFloat(int columnIndex, float x)
| | final public void | updateFloat(String columnName, float x)
| | final public void | updateInt(int columnIndex, int x)
| | final public void | updateInt(String columnName, int x)
| | final public void | updateLong(int columnIndex, long x)
| | final public void | updateLong(String columnName, long x)
| | final public void | updateNull(int columnIndex)
| | final public void | updateNull(String columnName)
| | final public void | updateObject(int columnIndex, Object x)
| | final public void | updateObject(String columnName, Object x)
| | final public void | updateObject(int columnIndex, Object x, int scale)
| | final public void | updateObject(String columnName, Object x, int scale)
| | final public void | updateRef(int columnIndex, Ref x)
| | final public void | updateRef(String columnName, Ref x)
| | final public void | updateRow()
| | final public void | updateShort(int columnIndex, short x)
| | final public void | updateShort(String columnName, short x)
| | final public void | updateString(int columnIndex, String x)
| | final public void | updateString(String columnName, String x)
| | final public void | updateTime(int columnIndex, Time x)
| | final public void | updateTime(String columnName, Time x)
| | final public void | updateTimestamp(int columnIndex, Timestamp x)
| | final public void | updateTimestamp(String columnName, Timestamp x)
| | final public boolean | wasNull()
|
| mFirstRowSkew | | protected boolean mFirstRowSkew(Code) | | |
| mHasResultRows | | protected boolean mHasResultRows(Code) | | |
| clone | | public Object clone()(Code) | | Simply clones the instance with the default clone method. This creates a
shallow copy of all fields and the clone will in fact just be another
reference to the same underlying data. The independence of each cloned
instance is consciously not respected since they rely on resources
that can't be cloned.
since:
1.0 |
| getFirstAsciiStream | | public InputStream getFirstAsciiStream() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as an ascii stream. This method works both
when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.io.InputStream object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstBigDecimal | | public BigDecimal getFirstBigDecimal() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a big decimal. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first BigDecimal object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstBinaryStream | | public InputStream getFirstBinaryStream() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a binary stream. This method works hiboth
when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.io.InputStream object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstBoolean | | public boolean getFirstBoolean() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a boolean. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first boolean object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstByte | | public byte getFirstByte() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a byte. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first byte object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstBytes | | public byte[] getFirstBytes() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as an array of bytes. This method works
both when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first byte[] object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstCharacterStream | | public Reader getFirstCharacterStream() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a character stream. This method works
both when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.io.Reader object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstDate | | public java.sql.Date getFirstDate() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql date. This method works both
when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.sql.Date object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstDate | | public java.sql.Date getFirstDate(Calendar cal) throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql date. This method uses the given
calendar to construct an appropriate millisecond value for the date if
the underlying database does not store timezone information.
This method works both when the next method has never been
called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
Parameters:
cal - the java.util.Calendar objectto use in constructing the date the first java.sql.Date object in the resultsn;if the value is SQL NULL,the value returned is null in the Java programming language
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
since:
1.0 |
| getFirstDouble | | public double getFirstDouble() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a double. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first String object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstFloat | | public float getFirstFloat() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a float. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first float object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstInt | | public int getFirstInt() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as an integer. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first int object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstLong | | public long getFirstLong() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a long. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first long object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstShort | | public short getFirstShort() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a short. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first short object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstString | | public String getFirstString() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a string. This method works both when
the next method has never been called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first String object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstTime | | public java.sql.Time getFirstTime() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql time. This method works both
when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.sql.Time object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstTime | | public java.sql.Time getFirstTime(Calendar cal) throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql time. This method works both
when the next method has never been called or once been
called. This method uses the given calendar to construct an appropriate
millisecond value for the time if the underlying database does not store
timezone information.
This method works both when the next method has never been
called or once been called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
Parameters:
cal - the java.util.Calendar object to use inconstructing the time the first java.sql.Time object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstTimestamp | | public java.sql.Timestamp getFirstTimestamp() throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql timestamo. This method works both
when the next method has never been called or once been
called.
Therefore, it's thus perfectly usable after the hasResultRows
method or alone where catching the MissingResultsException
is used to indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
the first java.sql.Timestamp object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| getFirstTimestamp | | public java.sql.Timestamp getFirstTimestamp(Calendar cal) throws DatabaseException(Code) | | Retrieves the first field of the first row of this
DbResultSet object as a sql timestamp. This method uses the
given calendar to construct an appropriate millisecond value for the
timestamp if the underlying database does not store timezone information.
This method works both when the next method has never been
called or once been called.
It is perfectly usable after the hasResultRows method or
alone where catching the MissingResultsException is used to
indicate the absence of results.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
Parameters:
cal - the java.util.Calendar object to use inconstructing the date the first java.sql.Timestamp object in the results.
throws:
DatabaseException - if a database access error occurs. If thereare no results available the thrown exception isMissingResultsException.
See Also: DbResultSet.hasResultRows
since:
1.0 |
| hasResultRows | | public boolean hasResultRows() throws DatabaseException(Code) | | Determines if there are rows available in the ResultSet
object that was returned by an execute method.
If an exception is thrown, the related DbStatement is
automatically closed and an ongoing transaction will be automatically
rolled back if it belongs to the executing thread.
true if there are result rows available; or false if no ResultSet object was available orit didn't have any result rows.
throws:
DatabaseException - if a database access error occurs
since:
1.0
|
| setFetchDirection | | final public void setFetchDirection(int direction) throws SQLException(Code) | | |
| updateBoolean | | final public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) | | |
| updateBytes | | final public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code) | | |
| updateCharacterStream | | final public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException(Code) | | |
| updateDouble | | final public void updateDouble(int columnIndex, double x) throws SQLException(Code) | | |
| updateFloat | | final public void updateFloat(int columnIndex, float x) throws SQLException(Code) | | |
| updateShort | | final public void updateShort(int columnIndex, short x) throws SQLException(Code) | | |
|
|