java.lang.Object | |||
↳ | android.database.sqlite.SQLiteClosable | ||
↳ | android.database.sqlite.SQLiteProgram | ||
↳ | android.database.sqlite.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.
This class is not thread-safe.
Public Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example
CREATE / DROP table, view, trigger, index etc.
| |||||||||||
Execute this SQL statement and return the ID of the row inserted due to this call.
| |||||||||||
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.
| |||||||||||
Executes a statement that returns a 1 by 1 table with a blob value.
| |||||||||||
Execute a statement that returns a 1 by 1 table with a numeric value.
| |||||||||||
Execute a statement that returns a 1 by 1 table with a text value.
| |||||||||||
Returns a string containing a concise, human-readable description of this
object.
|
[Expand]
Inherited Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From class
android.database.sqlite.SQLiteProgram
| |||||||||||
From class
android.database.sqlite.SQLiteClosable
| |||||||||||
From class
java.lang.Object
| |||||||||||
From interface
java.io.Closeable
| |||||||||||
From interface
java.lang.AutoCloseable
|
Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.
SQLException | If the SQL string is invalid for some reason |
---|
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.
SQLException | If the SQL string is invalid for some reason |
---|
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.
SQLException | If the SQL string is invalid for some reason |
---|
Executes a statement that returns a 1 by 1 table with a blob value.
null
if the value is null or could not be read for some reason.SQLiteDoneException | if the query returns zero rows |
---|
Execute a statement that returns a 1 by 1 table with a numeric value. For example, SELECT COUNT(*) FROM table;
SQLiteDoneException | if the query returns zero rows |
---|
Execute a statement that returns a 1 by 1 table with a text value. For example, SELECT COUNT(*) FROM table;
SQLiteDoneException | if the query returns zero rows |
---|
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.