public class

SQLiteCursor

extends AbstractWindowedCursor

java.lang.Object
↳	android.database.AbstractCursor
	↳	android.database.AbstractWindowedCursor
		↳	android.database.sqlite.SQLiteCursor

Class Overview

A Cursor implementation that exposes results from a query on a SQLiteDatabase.

Summary

[Expand]

Inherited Fields

From class android.database.AbstractWindowedCursor

From class android.database.AbstractCursor

Public Constructors
	SQLiteCursor(SQLiteDatabase db, SQLiteCursorDriver driver, String editTable, SQLiteQuery query) Execute a query and provide access to its result set through a Cursor interface.

Public Methods
void	close() Closes the Cursor, releasing all of its resources and making it completely invalid.
void	deactivate() Deactivates the Cursor, making all calls on it fail until `requery()` is called.
int	getColumnIndex(String columnName) Returns the zero-based index for the given column name, or -1 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.
int	getCount() Returns the numbers of rows in the cursor.
SQLiteDatabase	getDatabase()
boolean	onMove(int oldPosition, int newPosition) This function is called every time the cursor is successfully scrolled to a new position, giving the subclass a chance to update any state it may have.
void	registerDataSetObserver(DataSetObserver observer) Register an observer that is called when changes happen to the contents of the this cursors data set, for example, when the data set is changed via `requery()`, `deactivate()`, or `close()`.
boolean	requery() Performs the query that created the cursor again, refreshing its contents.
void	setSelectionArguments(String[] selectionArgs) Changes the selection arguments.
void	setWindow(CursorWindow window) Set a new cursor window to cursor, usually set a remote cursor window

Protected Methods
void	finalize() Release the native resources, if they haven't been released yet.

[Expand]

Inherited Methods

From class android.database.AbstractWindowedCursor

void	checkPosition() This function throws CursorIndexOutOfBoundsException if the cursor position is out of bounds.
void	copyStringToBuffer(int columnIndex, CharArrayBuffer 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.
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.
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.
CursorWindow	getWindow() returns a pre-filled window, return NULL if no such window
boolean	hasWindow()
boolean	isBlob(int columnIndex)
boolean	isFloat(int columnIndex)
boolean	isLong(int columnIndex)
boolean	isNull(int columnIndex) Returns `true` if the value in the indicated column is null.
boolean	isString(int columnIndex)
void	setWindow(CursorWindow window) Set a new cursor window to cursor, usually set a remote cursor window

From class android.database.AbstractCursor

void	checkPosition() This function throws CursorIndexOutOfBoundsException if the cursor position is out of bounds.
void	close() Closes the Cursor, releasing all of its resources and making it completely invalid.
void	copyStringToBuffer(int columnIndex, CharArrayBuffer buffer) Retrieves the requested column text and stores it in the buffer provided.
void	deactivate() Deactivates the Cursor, making all calls on it fail until `requery()` is called.
void	fillWindow(int position, CursorWindow window) Copy data from cursor to CursorWindow
void	finalize() Is called before the object's memory is being reclaimed by the VM.
byte[]	getBlob(int column) 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.
int	getColumnIndexOrThrow(String columnName) Returns the zero-based index for the given column name, or throws `IllegalArgumentException` if the column doesn't exist.
String	getColumnName(int columnIndex) Returns the column name at the given zero-based column index.
abstract 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.
abstract int	getCount() Returns the numbers of rows in the cursor.
abstract double	getDouble(int column) Returns the value of the requested column as a double.
Bundle	getExtras() Returns a bundle of extra values.
abstract float	getFloat(int column) Returns the value of the requested column as a float.
abstract int	getInt(int column) Returns the value of the requested column as an int.
abstract long	getLong(int column) Returns the value of the requested column as a long.
final int	getPosition() Returns the current position of the cursor in the row set.
abstract short	getShort(int column) Returns the value of the requested column as a short.
abstract String	getString(int column) Returns the value of the requested column as a String.
Object	getUpdatedField(int columnIndex) This function returns the uncommitted updated value for the field at columnIndex.
boolean	getWantsAllOnMoveCalls() onMove() will only be called across processes if this method returns true.
CursorWindow	getWindow() returns a pre-filled window, return NULL if no such window
final boolean	isAfterLast() Returns whether the cursor is pointing to the position after the last row.
final boolean	isBeforeFirst() Returns whether the cursor is pointing to the position before the first row.
boolean	isClosed() return true if the cursor is closed
boolean	isFieldUpdated(int columnIndex) This function returns true if the field has been updated and is used in conjunction with `getUpdatedField(int)` to allow subclasses to support reading uncommitted updates.
final boolean	isFirst() Returns whether the cursor is pointing to the first row.
final boolean	isLast() Returns whether the cursor is pointing to the last row.
abstract boolean	isNull(int column) Returns `true` if the value in the indicated column is null.
final boolean	move(int offset) Move the cursor by a relative amount, forward or backward, from the current position.
final boolean	moveToFirst() Move the cursor to the first row.
final boolean	moveToLast() Move the cursor to the last row.
final boolean	moveToNext() Move the cursor to the next row.
final boolean	moveToPosition(int position) Move the cursor to an absolute position.
final boolean	moveToPrevious() Move the cursor to the previous row.
void	onChange(boolean selfChange) Subclasses must call this method when they finish committing updates to notify all observers.
boolean	onMove(int oldPosition, int newPosition) This function is called every time the cursor is successfully scrolled to a new position, giving the subclass a chance to update any state it may have.
void	registerContentObserver(ContentObserver observer) Register an observer that is called when changes happen to the content backing this cursor.
void	registerDataSetObserver(DataSetObserver observer) Register an observer that is called when changes happen to the contents of the this cursors data set, for example, when the data set is changed via `requery()`, `deactivate()`, or `close()`.
boolean	requery() Performs the query that created the cursor again, refreshing its contents.
Bundle	respond(Bundle extras) This is an out-of-band way for the the user of a cursor to communicate with the cursor.
void	setNotificationUri(ContentResolver cr, Uri notifyUri) Specifies a content URI to watch for changes.
void	unregisterContentObserver(ContentObserver observer) Unregister an observer that has previously been registered with this cursor via `registerContentObserver(ContentObserver)`.
void	unregisterDataSetObserver(DataSetObserver observer) Unregister an observer that has previously been registered with this cursor via `registerContentObserver(ContentObserver)`.

From class java.lang.Object

Object	clone() Creates and returns a copy of this `Object`.
boolean	equals(Object o) Compares this instance with the specified object and indicates if they are equal.
void	finalize() Is called before the object's memory is being reclaimed by the VM.
final Class<? extends Object>	getClass() Returns the unique instance of `Class` which represents this object's class.
int	hashCode() Returns an integer hash code for this object.
final void	notify() Causes a thread which is waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up.
final void	notifyAll() Causes all threads which are waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up.
String	toString() Returns a string containing a concise, human-readable description of this object.
final void	wait(long millis, int nanos) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires.
final void	wait(long millis) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires.
final void	wait() Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object.

From interface android.database.CrossProcessCursor

From interface android.database.Cursor

abstract void	close() Closes the Cursor, releasing all of its resources and making it completely invalid.
abstract void	copyStringToBuffer(int columnIndex, CharArrayBuffer buffer) Retrieves the requested column text and stores it in the buffer provided.
abstract void	deactivate() Deactivates the Cursor, making all calls on it fail until `requery()` is called.
abstract byte[]	getBlob(int columnIndex) Returns the value of the requested column as a byte array.
abstract int	getColumnCount() Return total number of columns
abstract int	getColumnIndex(String columnName) Returns the zero-based index for the given column name, or -1 if the column doesn't exist.
abstract int	getColumnIndexOrThrow(String columnName) Returns the zero-based index for the given column name, or throws `IllegalArgumentException` if the column doesn't exist.
abstract String	getColumnName(int columnIndex) Returns the column name at the given zero-based column index.
abstract 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.
abstract int	getCount() Returns the numbers of rows in the cursor.
abstract double	getDouble(int columnIndex) Returns the value of the requested column as a double.
abstract Bundle	getExtras() Returns a bundle of extra values.
abstract float	getFloat(int columnIndex) Returns the value of the requested column as a float.
abstract int	getInt(int columnIndex) Returns the value of the requested column as an int.
abstract long	getLong(int columnIndex) Returns the value of the requested column as a long.
abstract int	getPosition() Returns the current position of the cursor in the row set.
abstract short	getShort(int columnIndex) Returns the value of the requested column as a short.
abstract String	getString(int columnIndex) Returns the value of the requested column as a String.
abstract boolean	getWantsAllOnMoveCalls() onMove() will only be called across processes if this method returns true.
abstract boolean	isAfterLast() Returns whether the cursor is pointing to the position after the last row.
abstract boolean	isBeforeFirst() Returns whether the cursor is pointing to the position before the first row.
abstract boolean	isClosed() return true if the cursor is closed
abstract boolean	isFirst() Returns whether the cursor is pointing to the first row.
abstract boolean	isLast() Returns whether the cursor is pointing to the last row.
abstract boolean	isNull(int columnIndex) Returns `true` if the value in the indicated column is null.
abstract boolean	move(int offset) Move the cursor by a relative amount, forward or backward, from the current position.
abstract boolean	moveToFirst() Move the cursor to the first row.
abstract boolean	moveToLast() Move the cursor to the last row.
abstract boolean	moveToNext() Move the cursor to the next row.
abstract boolean	moveToPosition(int position) Move the cursor to an absolute position.
abstract boolean	moveToPrevious() Move the cursor to the previous row.
abstract void	registerContentObserver(ContentObserver observer) Register an observer that is called when changes happen to the content backing this cursor.
abstract void	registerDataSetObserver(DataSetObserver observer) Register an observer that is called when changes happen to the contents of the this cursors data set, for example, when the data set is changed via `requery()`, `deactivate()`, or `close()`.
abstract boolean	requery() Performs the query that created the cursor again, refreshing its contents.
abstract Bundle	respond(Bundle extras) This is an out-of-band way for the the user of a cursor to communicate with the cursor.
abstract void	setNotificationUri(ContentResolver cr, Uri uri) Register to watch a content URI for changes.
abstract void	unregisterContentObserver(ContentObserver observer) Unregister an observer that has previously been registered with this cursor via `registerContentObserver(ContentObserver)`.
abstract void	unregisterDataSetObserver(DataSetObserver observer) Unregister an observer that has previously been registered with this cursor via `registerContentObserver(ContentObserver)`.

Public Constructors

public SQLiteCursor (SQLiteDatabase db, SQLiteCursorDriver driver, String editTable, SQLiteQuery query)

Since: API Level 1

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. This constructor has package scope.

Parameters

db	a reference to a Database object that is already constructed and opened
editTable	the name of the table used for this query
query	the rest of the query terms cursor is finalized

Public Methods

public void close ()

Since: API Level 1

Closes the Cursor, releasing all of its resources and making it completely invalid. Unlike deactivate() a call to requery() will not make the Cursor valid again.

public void deactivate ()

Since: API Level 1

Deactivates the Cursor, making all calls on it fail until requery() is called. Inactive Cursors use fewer resources than active Cursors. Calling requery() will make the cursor active again.

public int getColumnIndex (String columnName)

Since: API Level 1

Returns the zero-based index for the given column name, or -1 if the column doesn't exist. If you expect the column to exist use getColumnIndexOrThrow(String) instead, which will make the error more clear.

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.

public String[] getColumnNames ()

Since: API Level 1

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.

Returns

the names of the columns returned in this query.

public int getCount ()

Since: API Level 1

Returns the numbers of rows in the cursor.

Returns

the number of rows in the cursor.

public SQLiteDatabase getDatabase ()

Since: API Level 1

Returns

the SQLiteDatabase that this cursor is associated with.

public boolean onMove (int oldPosition, int newPosition)

Since: API Level 1

This function is called every time the cursor is successfully scrolled to a new position, giving the subclass a chance to update any state it may have. If it returns false the move function will also do so and the cursor will scroll to the beforeFirst position.

Parameters

oldPosition	the position that we're moving from
newPosition	the position that we're moving to

Returns

true if the move is successful, false otherwise

public void registerDataSetObserver (DataSetObserver observer)

Since: API Level 1

Register an observer that is called when changes happen to the contents of the this cursors data set, for example, when the data set is changed via requery(), deactivate(), or close().

Parameters

observer	the object that gets notified when the cursors data set changes.

public boolean requery ()

Since: API Level 1

Performs the query that created the cursor again, refreshing its contents. This may be done at any time, including after a call to deactivate().

Returns

true if the requery succeeded, false if not, in which case the cursor becomes invalid.

public void setSelectionArguments (String[] selectionArgs)

Since: API Level 1

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

public void setWindow (CursorWindow window)

Since: API Level 1

Set a new cursor window to cursor, usually set a remote cursor window

Parameters

window	cursor window

Protected Methods

protected void finalize ()

Since: API Level 1

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

Interfaces

Classes

Exceptions

SQLiteCursor

Class Overview

Summary

Public Constructors

public SQLiteCursor (SQLiteDatabase db, SQLiteCursorDriver driver, String editTable, SQLiteQuery query)

Parameters

Public Methods

public void close ()

public void deactivate ()

public int getColumnIndex (String columnName)

Parameters

Returns

public String[] getColumnNames ()

Returns

public int getCount ()

Returns

public SQLiteDatabase getDatabase ()

Returns

public boolean onMove (int oldPosition, int newPosition)

Parameters

Returns

public void registerDataSetObserver (DataSetObserver observer)

Parameters

public boolean requery ()

Returns

public void setSelectionArguments (String[] selectionArgs)

public void setWindow (CursorWindow window)

Parameters

Protected Methods

protected void finalize ()