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 query.
|
|
long
|
executeInsert()
Execute this SQL statement and return the ID of the row inserted due to this call.
|
|
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
|
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()
Returns a unique identifier for this program.
|
|
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()
Called before the object's memory is reclaimed by the VM.
|
|
final
Class<? extends Object>
|
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 query. For example,
CREATE TABLE, DELTE, INSERT, 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
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;
