com.couchbase.lite.internal.database.sqlite

Class SQLiteStatement

java.lang.Object

com.couchbase.lite.internal.database.sqlite.SQLiteClosable

com.couchbase.lite.internal.database.sqlite.SQLiteProgram

com.couchbase.lite.internal.database.sqlite.SQLiteStatement

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable

public final class SQLiteStatement
extends SQLiteProgram

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.

Method Summary

Modifier and Type	Method and Description
void	execute() Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.
long	executeInsert() Execute this SQL statement and return the ID of the row inserted due to this call.
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.
long	simpleQueryForLong() Execute a statement that returns a 1 by 1 table with a numeric value.
java.lang.String	simpleQueryForString() Execute a statement that returns a 1 by 1 table with a text value.
java.lang.String	toString()

Methods inherited from class com.couchbase.lite.internal.database.sqlite.SQLiteProgram

bindAllArgsAsStrings, bindBlob, bindDouble, bindLong, bindNull, bindString, clearBindings, getConnectionFlags, getSession, getUniqueId, onAllReferencesReleased, onCorruption

Methods inherited from class com.couchbase.lite.internal.database.sqlite.SQLiteClosable

acquireReference, close, onAllReferencesReleasedFromContainer, releaseReference, releaseReferenceFromContainer

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Method Detail

execute

public 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:

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

executeUpdateDelete

public 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:

the number of rows affected by this SQL statement execution.

Throws:

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

executeInsert

public 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:

the row ID of the last row inserted, if this insert is successful. -1 otherwise.

Throws:

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

simpleQueryForLong

public long simpleQueryForLong()

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

Returns:

The result of the query.

Throws:

android.database.sqlite.SQLiteDoneException - if the query returns zero rows

simpleQueryForString

public java.lang.String simpleQueryForString()

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

Returns:

The result of the query.

Throws:

android.database.sqlite.SQLiteDoneException - if the query returns zero rows

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object