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)
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 most
recently inserted row.
|
|
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)
Compiles the given SQL into a SQLite byte code program using sqlite3_prepare_v2().
|
|
void
|
finalize()
Make sure that the native resource is cleaned up.
|
|
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)
Compiles SQL into a SQLite program.
|
|
final
void
|
native_finalize()
|
|
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()
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.
|
|
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 most
recently inserted row. The SQL statement should probably be an
INSERT for this to be a useful call.
Returns
- the row ID of the last row inserted.
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;
