added in version 2.0.0
belongs to Maven artifact androidx.sqlite:sqlite:2.0.0-beta01

SupportSQLiteStatement

public interface SupportSQLiteStatement
implements SupportSQLiteProgram

androidx.sqlite.db.SupportSQLiteStatement


An interface to map the behavior of SQLiteStatement.

Summary

Public methods

abstract void execute()

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

abstract long executeInsert()

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

abstract 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.

abstract long simpleQueryForLong()

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

abstract String simpleQueryForString()

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

Inherited methods

Public methods

execute

added in version 2.0.0
public abstract void execute ()

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

Throws
SQLException If the SQL string is invalid for some reason

executeInsert

added in version 2.0.0
public abstract 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
long the row ID of the last row inserted, if this insert is successful. -1 otherwise.

Throws
SQLException If the SQL string is invalid for some reason

executeUpdateDelete

added in version 2.0.0
public abstract 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
int the number of rows affected by this SQL statement execution.

Throws
SQLException If the SQL string is invalid for some reason

simpleQueryForLong

added in version 2.0.0
public abstract long simpleQueryForLong ()

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

Returns
long The result of the query.

Throws
SQLiteDoneException if the query returns zero rows

simpleQueryForString

added in version 2.0.0
public abstract String simpleQueryForString ()

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

Returns
String The result of the query.

Throws
SQLiteDoneException if the query returns zero rows