org.sqlite.database.sqlite

Class SQLiteCursor

java.lang.Object

android.database.AbstractCursor

android.database.AbstractWindowedCursor

org.sqlite.database.sqlite.SQLiteCursor

All Implemented Interfaces:

android.database.CrossProcessCursor, android.database.Cursor, java.io.Closeable, java.lang.AutoCloseable

public class SQLiteCursor
extends android.database.AbstractWindowedCursor

A Cursor implementation that exposes results from a query on a SQLiteDatabase. SQLiteCursor is not internally synchronized so code using a SQLiteCursor from multiple threads should perform its own synchronization when using the SQLiteCursor.

Nested Class Summary

Nested classes/interfaces inherited from class android.database.AbstractCursor

android.database.AbstractCursor.SelfContentObserver

Field Summary

Fields inherited from class android.database.AbstractWindowedCursor

mWindow

Fields inherited from class android.database.AbstractCursor

mClosed, mContentResolver, mPos

Fields inherited from interface android.database.Cursor

FIELD_TYPE_BLOB, FIELD_TYPE_FLOAT, FIELD_TYPE_INTEGER, FIELD_TYPE_NULL, FIELD_TYPE_STRING

Constructor Summary

Constructors

Constructor and Description
SQLiteCursor(SQLiteCursorDriver driver, java.lang.String editTable, SQLiteQuery query) Execute a query and provide access to its result set through a Cursor interface.
SQLiteCursor(SQLiteDatabase db, SQLiteCursorDriver driver, java.lang.String editTable, SQLiteQuery query) Deprecated. use SQLiteCursor(SQLiteCursorDriver, String, SQLiteQuery) instead

Method Summary

Modifier and Type	Method and Description
void	close()
void	deactivate()
protected void	finalize() Release the native resources, if they haven't been released yet.
int	getColumnIndex(java.lang.String columnName)
java.lang.String[]	getColumnNames()
int	getCount()
SQLiteDatabase	getDatabase() Get the database that this cursor is associated with.
boolean	onMove(int oldPosition, int newPosition)
boolean	requery()
void	setSelectionArguments(java.lang.String[] selectionArgs) Changes the selection arguments.
void	setWindow(android.database.CursorWindow window)

Methods inherited from class android.database.AbstractWindowedCursor

checkPosition, copyStringToBuffer, getBlob, getDouble, getFloat, getInt, getLong, getShort, getString, getType, getWindow, hasWindow, isBlob, isFloat, isLong, isNull, isString

Methods inherited from class android.database.AbstractCursor

fillWindow, getColumnCount, getColumnIndexOrThrow, getColumnName, getExtras, getNotificationUri, getPosition, getUpdatedField, getWantsAllOnMoveCalls, isAfterLast, isBeforeFirst, isClosed, isFieldUpdated, isFirst, isLast, move, moveToFirst, moveToLast, moveToNext, moveToPosition, moveToPrevious, onChange, registerContentObserver, registerDataSetObserver, respond, setExtras, setNotificationUri, unregisterContentObserver, unregisterDataSetObserver

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLiteCursor

@Deprecated
public SQLiteCursor(SQLiteDatabase db,
                                SQLiteCursorDriver driver,
                                java.lang.String editTable,
                                SQLiteQuery query)

Deprecated. use SQLiteCursor(SQLiteCursorDriver, String, SQLiteQuery) instead

Execute a query and provide access to its result set through a Cursor interface. For a query such as: SELECT name, birth, phone FROM myTable WHERE ... LIMIT 1,20 ORDER BY... the column names (name, birth, phone) would be in the projection argument and everything from FROM onward would be in the params argument.

Parameters:

db - a reference to a Database object that is already constructed and opened. This param is not used any longer

editTable - the name of the table used for this query

query - the rest of the query terms cursor is finalized

SQLiteCursor

public SQLiteCursor(SQLiteCursorDriver driver,
                    java.lang.String editTable,
                    SQLiteQuery query)

Execute a query and provide access to its result set through a Cursor interface. For a query such as: SELECT name, birth, phone FROM myTable WHERE ... LIMIT 1,20 ORDER BY... the column names (name, birth, phone) would be in the projection argument and everything from FROM onward would be in the params argument.

Parameters:

editTable - the name of the table used for this query

query - the SQLiteQuery object associated with this cursor object.

Method Detail

getDatabase

public SQLiteDatabase getDatabase()

Get the database that this cursor is associated with.

Returns:

the SQLiteDatabase that this cursor is associated with.

onMove

public boolean onMove(int oldPosition,
                      int newPosition)

Specified by:

onMove in interface android.database.CrossProcessCursor

Overrides:

onMove in class android.database.AbstractCursor

getCount

public int getCount()

Specified by:

getCount in interface android.database.Cursor

Specified by:

getCount in class android.database.AbstractCursor

getColumnIndex

public int getColumnIndex(java.lang.String columnName)

Specified by:

getColumnIndex in interface android.database.Cursor

Overrides:

getColumnIndex in class android.database.AbstractCursor

getColumnNames

public java.lang.String[] getColumnNames()

Specified by:

getColumnNames in interface android.database.Cursor

Specified by:

getColumnNames in class android.database.AbstractCursor

deactivate

public void deactivate()

Specified by:

deactivate in interface android.database.Cursor

Overrides:

deactivate in class android.database.AbstractCursor

close

public void close()

Specified by:

close in interface android.database.Cursor

Specified by:

close in interface java.io.Closeable

Specified by:

close in interface java.lang.AutoCloseable

Overrides:

close in class android.database.AbstractCursor

requery

public boolean requery()

Specified by:

requery in interface android.database.Cursor

Overrides:

requery in class android.database.AbstractCursor

setWindow

public void setWindow(android.database.CursorWindow window)

Overrides:

setWindow in class android.database.AbstractWindowedCursor

setSelectionArguments

public void setSelectionArguments(java.lang.String[] selectionArgs)

Changes the selection arguments. The new values take effect after a call to requery().

finalize

protected void finalize()

Release the native resources, if they haven't been released yet.

Overrides:

finalize in class android.database.AbstractCursor