Module com.aoapps.dbc

Package com.aoapps.dbc

Interface SingleResult

All Superinterfaces:

AutoCloseable, ResultSet, Wrapper

All Known Subinterfaces:

ReadOnlySingleResult

public interface SingleResult
extends ResultSet

A ResultSet from a query that only returns a single row and the cursor is already positioned.

Cursor navigation methods are marked deprecated to discourage their use, since this is a result set from a query that only returns a single row and the cursor is already positioned. Calling these methods will still pass-through to the wrapped ResultSet, though.

Author:

AO Industries, Inc.

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

Method Summary

Modifier and Type	Method	Description
boolean	absolute(int row)	Deprecated. This query only returns a single row and the cursor is already positioned.
void	afterLast()	Deprecated. This query only returns a single row and the cursor is already positioned.
void	beforeFirst()	Deprecated. This query only returns a single row and the cursor is already positioned.
void	close()
boolean	first()	Deprecated. This query only returns a single row and the cursor is already positioned.
int	getFetchDirection()	Deprecated. This query only returns a single row and the cursor is already positioned.
int	getFetchSize()	Deprecated. This query only returns a single row and the cursor is already positioned.
int	getRow()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	isAfterLast()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	isBeforeFirst()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	isFirst()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	isLast()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	last()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	next()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	previous()	Deprecated. This query only returns a single row and the cursor is already positioned.
boolean	relative(int rows)	Deprecated. This query only returns a single row and the cursor is already positioned.
void	setFetchDirection(int direction)	Deprecated. This query only returns a single row and the cursor is already positioned.
void	setFetchSize(int rows)	Deprecated. This query only returns a single row and the cursor is already positioned.

Methods inherited from interface java.sql.ResultSet

cancelRowUpdates, clearWarnings, deleteRow, findColumn, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isClosed, moveToCurrentRow, moveToInsertRow, refreshRow, rowDeleted, rowInserted, rowUpdated, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Details

next

@Deprecated(forRemoval=false)
boolean next()
      throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

next in interface ResultSet

Throws:

SQLException

close

void close()
    throws ExtraRowException,
SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface ResultSet

Throws:

ExtraRowException - when more rows are retrieved than expected. ResultSet.next() will be called once upon close. If it returns true, it indicates multiple rows were returned while only a single one is expected.

SQLException

isBeforeFirst

@Deprecated(forRemoval=false)
boolean isBeforeFirst()
               throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

isBeforeFirst in interface ResultSet

Throws:

SQLException

isAfterLast

@Deprecated(forRemoval=false)
boolean isAfterLast()
             throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

isAfterLast in interface ResultSet

Throws:

SQLException

isFirst

@Deprecated(forRemoval=false)
boolean isFirst()
         throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

isFirst in interface ResultSet

Throws:

SQLException

isLast

@Deprecated(forRemoval=false)
boolean isLast()
        throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

isLast in interface ResultSet

Throws:

SQLException

beforeFirst

@Deprecated(forRemoval=false)
void beforeFirst()
          throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

beforeFirst in interface ResultSet

Throws:

SQLException

afterLast

@Deprecated(forRemoval=false)
void afterLast()
        throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

afterLast in interface ResultSet

Throws:

SQLException

first

@Deprecated(forRemoval=false)
boolean first()
       throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

first in interface ResultSet

Throws:

SQLException

last

@Deprecated(forRemoval=false)
boolean last()
      throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

last in interface ResultSet

Throws:

SQLException

getRow

@Deprecated(forRemoval=false)
int getRow()
    throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

getRow in interface ResultSet

Throws:

SQLException

absolute

@Deprecated(forRemoval=false)
boolean absolute(int row)
          throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

absolute in interface ResultSet

Throws:

SQLException

relative

@Deprecated(forRemoval=false)
boolean relative(int rows)
          throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

relative in interface ResultSet

Throws:

SQLException

previous

@Deprecated(forRemoval=false)
boolean previous()
          throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

previous in interface ResultSet

Throws:

SQLException

setFetchDirection

@Deprecated(forRemoval=false)
void setFetchDirection(int direction)
                throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

setFetchDirection in interface ResultSet

Throws:

SQLException

getFetchDirection

@Deprecated(forRemoval=false)
int getFetchDirection()
               throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

getFetchDirection in interface ResultSet

Throws:

SQLException

setFetchSize

@Deprecated(forRemoval=false)
void setFetchSize(int rows)
           throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

setFetchSize in interface ResultSet

Throws:

SQLException

getFetchSize

@Deprecated(forRemoval=false)
int getFetchSize()
          throws SQLException

Deprecated.

This query only returns a single row and the cursor is already positioned.

Specified by:

getFetchSize in interface ResultSet

Throws:

SQLException