added in version 1.1.0
belongs to Maven artifact android.arch.persistence:db:1.1.0-beta2

Summary: Methods | Inherited Methods

SupportSQLiteStatement

The android.arch Architecture Components packages are no longer maintained. They have been superseded by the corresponding androidx.* packages. See androidx.sqlite.db.SupportSQLiteStatement instead.

public interface SupportSQLiteStatement
implements SupportSQLiteProgram

android.arch.persistence.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
From interface android.arch.persistence.db.SupportSQLiteProgram abstract void bindBlob(int index, byte[] value) Bind a byte array value to this statement. abstract void bindDouble(int index, double value) Bind a double value to this statement. abstract void bindLong(int index, long value) Bind a long value to this statement. abstract void bindNull(int index) Bind a NULL value to this statement. abstract void bindString(int index, String value) Bind a String value to this statement. abstract void clearBindings() Clears all existing bindings.
From interface java.io.Closeable abstract void close()
From interface java.lang.AutoCloseable abstract void close()

Public methods

execute

added in version 1.1.0

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 1.1.0

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 1.1.0

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 1.1.0

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 1.1.0

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

• Interfaces

  • SupportSQLiteDatabase
  • SupportSQLiteOpenHelper
  • SupportSQLiteOpenHelper.Factory
  • SupportSQLiteProgram
  • SupportSQLiteQuery
  • SupportSQLiteStatement

• Classes

  • SimpleSQLiteQuery
  • SupportSQLiteOpenHelper.Callback
  • SupportSQLiteOpenHelper.Configuration
  • SupportSQLiteOpenHelper.Configuration.Builder
  • SupportSQLiteQueryBuilder