SQLiteStatement

Represents a statement that can be executed against a database. The statement cannot return multiple rows or columns, but single value (1 x 1) result sets are supported.

Summary

Public Methods
void	execute () Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.
long	executeInsert () Execute this SQL statement and return the ID of the row inserted due to this call.
int	executeUpdateDelete () Execute this SQL statement, if the the number of rows affected by execution of this SQL statement is of any importance to the caller - for example, UPDATE / DELETE SQL statements.
ParcelFileDescriptor	simpleQueryForBlobFileDescriptor () Executes a statement that returns a 1 by 1 table with a blob value.
long	simpleQueryForLong () Execute a statement that returns a 1 by 1 table with a numeric value.
String	simpleQueryForString () Execute a statement that returns a 1 by 1 table with a text value.
String	toString () Returns a string containing a concise, human-readable description of this object.

Public Methods

void

execute ()

Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.

long

executeInsert ()

Execute this SQL statement and return the ID of the row inserted due to this call.

int

executeUpdateDelete ()

Execute this SQL statement, if the the number of rows affected by execution of this SQL statement is of any importance to the caller - for example, UPDATE / DELETE SQL statements.

ParcelFileDescriptor

simpleQueryForBlobFileDescriptor ()

Executes a statement that returns a 1 by 1 table with a blob value.

long

simpleQueryForLong ()

Execute a statement that returns a 1 by 1 table with a numeric value.

String

simpleQueryForString ()

Execute a statement that returns a 1 by 1 table with a text value.

String

toString ()

Returns a string containing a concise, human-readable description of this object.

[Expand]

Inherited Methods

From class android.database.sqlite.SQLiteProgram

void	bindAllArgsAsStrings ( String[] bindArgs) Given an array of String bindArgs, this method binds all of them in one single call.
void	bindBlob (int index, byte[] value) Bind a byte array value to this statement.
void	bindDouble (int index, double value) Bind a double value to this statement.
void	bindLong (int index, long value) Bind a long value to this statement.
void	bindNull (int index) Bind a NULL value to this statement.
void	bindString (int index, String value) Bind a String value to this statement.
void	clearBindings () Clears all existing bindings.
final int	getUniqueId () This method was deprecated in API level 11. This method is deprecated and must not be used.
void	onAllReferencesReleased () Called when the last reference to the object was released by a call to `releaseReference()` or `close()` .

From class android.database.sqlite.SQLiteClosable

void	acquireReference () Acquires a reference to the object.
void	close () Releases a reference to the object, closing the object if the last reference was released.
abstract void	onAllReferencesReleased () Called when the last reference to the object was released by a call to `releaseReference()` or `close()` .
void	onAllReferencesReleasedFromContainer () This method was deprecated in API level 16. Do not use.
void	releaseReference () Releases a reference to the object, closing the object if the last reference was released.
void	releaseReferenceFromContainer () This method was deprecated in API level 16. Do not use.

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 () Invoked when the garbage collector has detected that this instance is no longer reachable.
final Class <?>	getClass () Returns the unique instance of `Class` that 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 () Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method 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.

From interface java.io.Closeable

From interface java.lang.AutoCloseable

Public Methods

public void execute ()

Added in API level 1

Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.

Throws

SQLException	If the SQL string is invalid for some reason

public long executeInsert ()

Added in API level 1

Execute this SQL statement and return the ID of the row inserted due to this call. The SQL statement should be an INSERT for this to be a useful call.

Returns

the row ID of the last row inserted, if this insert is successful. -1 otherwise.

Throws

SQLException	If the SQL string is invalid for some reason

public int executeUpdateDelete ()

Added in API level 11

Execute this SQL statement, if the the number of rows affected by execution of this SQL statement is of any importance to the caller - for example, UPDATE / DELETE SQL statements.

Returns

the number of rows affected by this SQL statement execution.

Throws

SQLException	If the SQL string is invalid for some reason

public ParcelFileDescriptor simpleQueryForBlobFileDescriptor ()

Added in API level 11

Executes a statement that returns a 1 by 1 table with a blob value.

Returns

A read-only file descriptor for a copy of the blob value, or null if the value is null or could not be read for some reason.

Throws

SQLiteDoneException	if the query returns zero rows

public long simpleQueryForLong ()

Added in API level 1

Execute a statement that returns a 1 by 1 table with a numeric value. For example, SELECT COUNT(*) FROM table;

Returns

The result of the query.

Throws

SQLiteDoneException	if the query returns zero rows

public String simpleQueryForString ()

Added in API level 1

Execute a statement that returns a 1 by 1 table with a text value. For example, SELECT COUNT(*) FROM table;

Returns

The result of the query.

Throws

SQLiteDoneException	if the query returns zero rows

public String toString ()

Added in API level 1

Returns a string containing a concise, human-readable description of this object. Subclasses are encouraged to override this method and provide an implementation that takes into account the object's type and data. The default implementation is equivalent to the following expression:

          getClass().getName() + '@' + Integer.toHexString(hashCode())

See Writing a useful toString method if you intend implementing your own toString method.

Returns

a printable representation of this object.

java.lang.Object
↳	android.database.sqlite.SQLiteClosable
	↳	android.database.sqlite.SQLiteProgram
		↳	android.database.sqlite.SQLiteStatement

Results

Interfaces

Classes

Exceptions

Class Overview

Summary

Public Methods

public void execute ()

Throws

public long executeInsert ()

Returns

Throws

public int executeUpdateDelete ()

Returns

Throws

public ParcelFileDescriptor simpleQueryForBlobFileDescriptor ()

Returns

Throws

public long simpleQueryForLong ()

Returns

Throws

public String simpleQueryForString ()

Returns

Throws

public String toString ()

Returns