Class Overview
A pre-compiled statement against a SQLiteDatabase that can be reused.
The statement cannot return multiple rows, but 1x1 result sets are allowed.
Don't use SQLiteStatement constructor directly, please use
compileStatement(String)
SQLiteStatement is NOT internally synchronized so code using a SQLiteStatement from multiple
threads should perform its own synchronization when using the SQLiteStatement.
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.
|
|
[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.
|
|
void
|
close()
Release this program's resources, making it invalid.
|
|
void
|
compile(String sql, boolean forceCompilation)
This method is deprecated.
This method is deprecated and must not be used.
|
|
final
int
|
getUniqueId()
This method is deprecated.
do not use this method. it is not guaranteed to be the same across executions of
the SQL statement contained in this object.
|
|
final
void
|
native_bind_blob(int index, byte[] value)
|
|
final
void
|
native_bind_double(int index, double value)
|
|
final
void
|
native_bind_long(int index, long value)
|
|
final
void
|
native_bind_null(int index)
|
|
final
void
|
native_bind_string(int index, String value)
|
|
final
void
|
native_compile(String sql)
This method is deprecated.
This method is deprecated and must not be used.
Compiles SQL into a SQLite program.
The database lock must be held when calling this method.
|
|
final
void
|
native_finalize()
This method is deprecated.
This method is deprecated and must not be used.
|
|
void
|
onAllReferencesReleased()
|
|
void
|
onAllReferencesReleasedFromContainer()
|
|
|
From class
android.database.sqlite.SQLiteClosable
|
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.
|
|
Public Methods
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.
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.
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.
public
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.
public
long
simpleQueryForLong
()
Execute a statement that returns a 1 by 1 table with a numeric value.
For example, SELECT COUNT(*) FROM table;
public
String
simpleQueryForString
()
Execute a statement that returns a 1 by 1 table with a text value.
For example, SELECT COUNT(*) FROM table;
