IT. Expert System.

All Implemented Interfaces:

Closeable, AutoCloseable

public final class SQLiteStatement
extends SQLiteProgram

• Method Summary

  Methods

  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.
  ParcelFileDescriptor	simpleQueryForBlobFileDescriptor() Executes a statement that returns a 1 by 1 table with a blob value.
  long	simpleQueryForLong() Execute a statement that returns a 1 by 1 table with a numeric value.
  String	simpleQueryForString() Execute a statement that returns a 1 by 1 table with a text value.
  String	toString() Returns a string containing a concise, human-readable description of this object.

  • Methods inherited from class android.database.sqlite.SQLiteProgram

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

  • Methods inherited from class android.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:

    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:

    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:

    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:

    SQLiteDoneException - if the query returns zero rows

  • simpleQueryForString

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

    SQLiteDoneException - if the query returns zero rows

  • simpleQueryForBlobFileDescriptor

    public ParcelFileDescriptor simpleQueryForBlobFileDescriptor()

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

    Returns:

    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.

    Throws:

    SQLiteDoneException - if the query returns zero rows

  • toString

    public String toString()

    Description copied from class: Object
    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.

    Overrides:

    toString in class Object

    Returns:

    a printable representation of this object.