Added in API level 1

SQLiteStatement


class SQLiteStatement : SQLiteProgram
kotlin.Any
   ↳ 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.

Summary

Public methods
Unit

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

Long

Execute this SQL statement and return the ID of the row inserted due to this call.

Int

Execute this SQL statement, if 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!

Executes a statement that returns a 1 by 1 table with a blob value.

Long

Execute a statement that returns a 1 by 1 table with a numeric value.

String!

Execute a statement that returns a 1 by 1 table with a text value.

String

Inherited functions

Public methods

execute

Added in API level 1
fun execute(): Unit

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

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

executeInsert

Added in API level 1
fun executeInsert(): Long

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.

Return
Long the row ID of the last row inserted, if this insert is successful. -1 otherwise.
Exceptions
android.database.SQLException If the SQL string is invalid for some reason

executeUpdateDelete

Added in API level 11
fun executeUpdateDelete(): Int

Execute this SQL statement, if the number of rows affected by execution of this SQL statement is of any importance to the caller - for example, UPDATE / DELETE SQL statements.

Return
Int the number of rows affected by this SQL statement execution.
Exceptions
android.database.SQLException If the SQL string is invalid for some reason

simpleQueryForBlobFileDescriptor

Added in API level 11
fun simpleQueryForBlobFileDescriptor(): ParcelFileDescriptor!

Executes a statement that returns a 1 by 1 table with a blob value.

Return
ParcelFileDescriptor! 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.
Exceptions
android.database.sqlite.SQLiteDoneException if the query returns zero rows

simpleQueryForLong

Added in API level 1
fun simpleQueryForLong(): Long

Execute a statement that returns a 1 by 1 table with a numeric value. For example, SELECT COUNT(*) FROM table;

Return
Long The result of the query.
Exceptions
android.database.sqlite.SQLiteDoneException if the query returns zero rows

simpleQueryForString

Added in API level 1
fun simpleQueryForString(): String!

Execute a statement that returns a 1 by 1 table with a text value. For example, SELECT COUNT(*) FROM table;

Return
String! The result of the query.
Exceptions
android.database.sqlite.SQLiteDoneException if the query returns zero rows

toString

Added in API level 1
fun toString(): String
Return
String a string representation of the object.