org.sqlite.database.sqlite

Class SQLiteStatement

java.lang.Object

org.sqlite.database.sqlite.SQLiteClosable

org.sqlite.database.sqlite.SQLiteProgram

org.sqlite.database.sqlite.SQLiteStatement

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable

public final class SQLiteStatement
extends SQLiteProgram

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.

This class is not thread-safe.

Method Summary

Modifier and Type	Method and Description
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.
android.os.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.
java.lang.String	simpleQueryForString() Execute a statement that returns a 1 by 1 table with a text value.
java.lang.String	toString()

Methods inherited from class org.sqlite.database.sqlite.SQLiteProgram

bindAllArgsAsStrings, bindBlob, bindDouble, bindLong, bindNull, bindString, clearBindings, getConnectionFlags, getSession, getUniqueId, onAllReferencesReleased, onCorruption

Methods inherited from class org.sqlite.database.sqlite.SQLiteClosable

acquireReference, close, onAllReferencesReleasedFromContainer, releaseReference, releaseReferenceFromContainer

Methods inherited from class java.lang.Object

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

Method Detail

execute

public void execute()

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

Throws:

android.database.SQLException - If the SQL string is invalid for some reason

executeUpdateDelete

public 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.

Returns:

the number of rows affected by this SQL statement execution.

Throws:

android.database.SQLException - If the SQL string is invalid for some reason

executeInsert

public long executeInsert()

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:

android.database.SQLException - If the SQL string is invalid for some reason

simpleQueryForLong

public long simpleQueryForLong()

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:

android.database.sqlite.SQLiteDoneException - if the query returns zero rows

simpleQueryForString

public java.lang.String simpleQueryForString()

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:

android.database.sqlite.SQLiteDoneException - if the query returns zero rows

simpleQueryForBlobFileDescriptor

public android.os.ParcelFileDescriptor simpleQueryForBlobFileDescriptor()

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:

android.database.sqlite.SQLiteDoneException - if the query returns zero rows

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object