au.com.cybersearch2.classydb

Class SqliteResultRow

java.lang.Object

au.com.cybersearch2.classydb.SqliteResultRow

All Implemented Interfaces:

ResultRow

public class SqliteResultRow
extends Object
implements ResultRow

SqliteResultRow Converts SQLite DatabaseResults to generic ResultRow

Author:

Andrew Bowley 30/07/2014

Nested Class Summary

Nested classes/interfaces inherited from interface au.com.cybersearch2.classyjpa.query.ResultRow

ResultRow.FunctionSpec, ResultRow.op

Constructor Summary

Constructors

Constructor and Description
SqliteResultRow(int position, com.j256.ormlite.support.DatabaseResults results) Construct a SqliteResultRow object

Method Summary

Methods

Modifier and Type	Method and Description
void	copyStringToBuffer(int columnIndex, StringBuffer buffer) Retrieves the requested column text and stores it in the buffer provided.
byte[]	getBlob(int columnIndex) Returns the value of the requested column as a byte array.
int	getColumnCount() Return total number of columns
int	getColumnIndex(String columnName) Returns the zero-based index for the given column name, or -1 if the column doesn't exist.
String	getColumnName(int columnIndex) Returns the zero-based index for the given column name, or throws IllegalArgumentException if the column doesn't exist.
String[]	getColumnNames() Returns a string array holding the names of all of the columns in the result set in the order in which they were listed in the result.
double	getDouble(int columnIndex) Returns the value of the requested column as a double.
float	getFloat(int columnIndex) Returns the value of the requested column as a float.
int	getInt(int columnIndex) Returns the value of the requested column as an int.
long	getLong(int columnIndex) Returns the value of the requested column as a long.
int	getPosition() Returns the current position of the cursor in the row set.
short	getShort(int columnIndex) Returns the value of the requested column as a short.
String	getString(int columnIndex) Returns the value of the requested column as a String.
boolean	isNull(int columnIndex) Returns true if the last object returned with the column index is null.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqliteResultRow

public SqliteResultRow(int position,
               com.j256.ormlite.support.DatabaseResults results)

Construct a SqliteResultRow object

Parameters:

position - Current position of the cursor in the row set

results - DatabaseResults object

Method Detail

getPosition

public int getPosition()

Returns the current position of the cursor in the row set. The value is zero-based. When the row set is first returned the cursor will be at position -1, which is before the first row. After the last row is returned another call to next() will leave the cursor past the last entry, at a position of count().

Specified by:

getPosition in interface ResultRow

Returns:

The current cursor position.

getColumnIndex

public int getColumnIndex(String columnName)

Returns the zero-based index for the given column name, or -1 if the column doesn't exist.

Specified by:

getColumnIndex in interface ResultRow

Parameters:

columnName - The name of the target column.

Returns:

The zero-based column index for the given column name, or -1 if the column name does not exist.

getColumnName

public String getColumnName(int columnIndex)

Returns the zero-based index for the given column name, or throws IllegalArgumentException if the column doesn't exist. If you're not sure if a column will exist or not use getColumnIndex(String) and check for -1, which is more efficient than catching the exceptions.

Specified by:

getColumnName in interface ResultRow

Parameters:

columnIndex - The zero-based column index

Returns:

The column name

Throws:

IllegalArgumentException - if the column does not exist

See Also:

getColumnIndex(String)

getColumnNames

public String[] getColumnNames()

Returns a string array holding the names of all of the columns in the result set in the order in which they were listed in the result.

Specified by:

getColumnNames in interface ResultRow

Returns:

The names of the columns returned in this query.

getColumnCount

public int getColumnCount()

Return total number of columns

Specified by:

getColumnCount in interface ResultRow

Returns:

number of columns

getBlob

public byte[] getBlob(int columnIndex)

Returns the value of the requested column as a byte array.

The result and whether this method throws an exception when the column value is null or the column type is not a blob type is implementation-defined.

Specified by:

getBlob in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a byte array.

getString

public String getString(int columnIndex)

Returns the value of the requested column as a String.

Specified by:

getString in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a String.

copyStringToBuffer

public void copyStringToBuffer(int columnIndex,
                      StringBuffer buffer)

Retrieves the requested column text and stores it in the buffer provided. If the buffer size is not sufficient, a new char buffer will be allocated and assigned to CharArrayBuffer.data

Specified by:

copyStringToBuffer in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column. if the target column is null, return buffer

buffer - the buffer to copy the text into.

getShort

public short getShort(int columnIndex)

Returns the value of the requested column as a short.

Specified by:

getShort in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a short.

getInt

public int getInt(int columnIndex)

Returns the value of the requested column as an int.

Specified by:

getInt in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as an int.

getLong

public long getLong(int columnIndex)

Returns the value of the requested column as a long.

Specified by:

getLong in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a long.

getFloat

public float getFloat(int columnIndex)

Returns the value of the requested column as a float.

Specified by:

getFloat in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a float.

getDouble

public double getDouble(int columnIndex)

Returns the value of the requested column as a double.

Specified by:

getDouble in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

The value of that column as a double.

isNull

public boolean isNull(int columnIndex)

Returns true if the last object returned with the column index is null.

Specified by:

isNull in interface ResultRow

Parameters:

columnIndex - The zero-based index of the target column.

Returns:

Whether the column value is null.