DatabaseResults (ORMLite Core 6.1 API)

All Superinterfaces:

AutoCloseable
```
public interface DatabaseResults
extends AutoCloseable
```
A reduction of the SQL ResultSet so we can implement it outside of JDBC.
NOTE: In all cases, the columnIndex parameters are 0 based -- not 1 based like JDBC.

Author:

graywatson

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`void`	`closeQuietly()` Closes any underlying database connections but swallows any SQLExceptions.
`int`	`findColumn(String columnName)` Returns the column index associated with the column name.
`boolean`	`first()` Moves to the first result.
`BigDecimal`	`getBigDecimal(int columnIndex)` Returns the SQL big decimal value from the results at the column index.
`InputStream`	`getBlobStream(int columnIndex)` Returns an input stream for a blob value from the results at the column index.
`boolean`	`getBoolean(int columnIndex)` Returns the boolean value from the results at the column index.
`byte`	`getByte(int columnIndex)` Returns the byte value from the results at the column index.
`byte[]`	`getBytes(int columnIndex)` Returns the byte array value from the results at the column index.
`char`	`getChar(int columnIndex)` Returns the char value from the results at the column index.
`int`	`getColumnCount()` Returns the number of columns in these results.
`String[]`	`getColumnNames()` Returns an array of column names.
`double`	`getDouble(int columnIndex)` Returns the double value from the results at the column index.
`float`	`getFloat(int columnIndex)` Returns the float value from the results at the column index.
`int`	`getInt(int columnIndex)` Returns the integer value from the results at the column index.
`long`	`getLong(int columnIndex)` Returns the long value from the results at the column index.
`Object`	`getObject(int columnIndex)` Returns the SQL object value from the results at the column index.
`ObjectCache`	`getObjectCacheForRetrieve()` Returns the object cache for looking up objects associated with these results or null if none.
`ObjectCache`	`getObjectCacheForStore()` Returns the object cache for storing objects generated by these results or null if none.
`short`	`getShort(int columnIndex)` Returns the short value from the results at the column index.
`String`	`getString(int columnIndex)` Returns the string from the results at the column index.
`Timestamp`	`getTimestamp(int columnIndex)` Returns the SQL timestamp value from the results at the column index.
`boolean`	`last()` Moves to the last result.
`boolean`	`moveAbsolute(int position)` Moves to an absolute position in the list of results.
`boolean`	`moveRelative(int offset)` Moves forward (positive value) or backwards (negative value) the list of results.
`boolean`	`next()` Moves to the next result.
`boolean`	`previous()` Moves to the previous result.
`boolean`	`wasNull(int columnIndex)` Returns true if the last object returned with the column index is null.

Methods inherited from interface java.lang.AutoCloseable
close

- Method Detail
  - getColumnCount
```
int getColumnCount()
            throws SQLException
```
    Returns the number of columns in these results.
    
    Throws:
    
    SQLException
  - getColumnNames
```
String[] getColumnNames()
                 throws SQLException
```
    Returns an array of column names.
    
    Throws:
    
    SQLException
  - first
```
boolean first()
       throws SQLException
```
    Moves to the first result. This may not work with the default iterator depending on your database.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - previous
```
boolean previous()
          throws SQLException
```
    Moves to the previous result. This may not work with the default iterator depending on your database.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - next
```
boolean next()
      throws SQLException
```
    Moves to the next result.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - last
```
boolean last()
      throws SQLException
```
    Moves to the last result. This may not work with the default iterator depending on your database.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - moveRelative
```
boolean moveRelative(int offset)
              throws SQLException
```
    Moves forward (positive value) or backwards (negative value) the list of results. moveRelative(1) should be the same as next(). moveRelative(-1) is the same as previous() result. This may not work with the default iterator depending on your database.
    
    Parameters:
    
    offset - Number of rows to move. Positive moves forward in the results. Negative moves backwards.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - moveAbsolute
```
boolean moveAbsolute(int position)
              throws SQLException
```
    Moves to an absolute position in the list of results. This may not work with the default iterator depending on your database.
    
    Parameters:
    
    position - Row number in the result list to move to.
    
    Returns:
    
    true if there are more results to be processed.
    
    Throws:
    
    SQLException
  - findColumn
```
int findColumn(String columnName)
        throws SQLException
```
    Returns the column index associated with the column name.
    
    Throws:
    
    SQLException - if the column was not found in the results.
  - getString
```
String getString(int columnIndex)
          throws SQLException
```
    Returns the string from the results at the column index.
    
    Throws:
    
    SQLException
  - getBoolean
```
boolean getBoolean(int columnIndex)
            throws SQLException
```
    Returns the boolean value from the results at the column index.
    
    Throws:
    
    SQLException
  - getChar
```
char getChar(int columnIndex)
      throws SQLException
```
    Returns the char value from the results at the column index.
    
    Throws:
    
    SQLException
  - getByte
```
byte getByte(int columnIndex)
      throws SQLException
```
    Returns the byte value from the results at the column index.
    
    Throws:
    
    SQLException
  - getBytes
```
byte[] getBytes(int columnIndex)
         throws SQLException
```
    Returns the byte array value from the results at the column index.
    
    Throws:
    
    SQLException
  - getShort
```
short getShort(int columnIndex)
        throws SQLException
```
    Returns the short value from the results at the column index.
    
    Throws:
    
    SQLException
  - getInt
```
int getInt(int columnIndex)
    throws SQLException
```
    Returns the integer value from the results at the column index.
    
    Throws:
    
    SQLException
  - getLong
```
long getLong(int columnIndex)
      throws SQLException
```
    Returns the long value from the results at the column index.
    
    Throws:
    
    SQLException
  - getFloat
```
float getFloat(int columnIndex)
        throws SQLException
```
    Returns the float value from the results at the column index.
    
    Throws:
    
    SQLException
  - getDouble
```
double getDouble(int columnIndex)
          throws SQLException
```
    Returns the double value from the results at the column index.
    
    Throws:
    
    SQLException
  - getTimestamp
```
Timestamp getTimestamp(int columnIndex)
                throws SQLException
```
    Returns the SQL timestamp value from the results at the column index.
    
    Throws:
    
    SQLException
  - getBlobStream
```
InputStream getBlobStream(int columnIndex)
                   throws SQLException
```
    Returns an input stream for a blob value from the results at the column index.
    
    Throws:
    
    SQLException
  - getBigDecimal
```
BigDecimal getBigDecimal(int columnIndex)
                  throws SQLException
```
    Returns the SQL big decimal value from the results at the column index.
    
    Throws:
    
    SQLException
  - getObject
```
Object getObject(int columnIndex)
          throws SQLException
```
    Returns the SQL object value from the results at the column index.
    
    Throws:
    
    SQLException
  - wasNull
```
boolean wasNull(int columnIndex)
         throws SQLException
```
    Returns true if the last object returned with the column index is null.
    
    Throws:
    
    SQLException
  - getObjectCacheForRetrieve
```
ObjectCache getObjectCacheForRetrieve()
```
    Returns the object cache for looking up objects associated with these results or null if none.
  - getObjectCacheForStore
```
ObjectCache getObjectCacheForStore()
```
    Returns the object cache for storing objects generated by these results or null if none.
  - closeQuietly
```
void closeQuietly()
```
    Closes any underlying database connections but swallows any SQLExceptions.

Interface DatabaseResults

Method Summary

Methods inherited from interface java.lang.AutoCloseable

Method Detail

getColumnCount

getColumnNames

first

previous

next

last

moveRelative

moveAbsolute

findColumn

getString

getBoolean

getChar

getByte

getBytes

getShort

getInt

getLong

getFloat

getDouble

getTimestamp

getBlobStream

getBigDecimal

getObject

wasNull

getObjectCacheForRetrieve

getObjectCacheForStore

closeQuietly