# Print output for @column tags ?>
Developers

- Design
- Develop
- Distribute

Developer Console

## Most visited

## Recently visited

## Results for

Summary: Methods | Inherited Methods

# SQLiteStatement

`public final class SQLiteStatement`
`` `` `extends SQLiteProgram` ``

java.lang.Object
↳ | 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
`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 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 representation of the object.

### Inherited methods
From class `android.database.sqlite.SQLiteProgram`
`void` | `bindAllArgsAsStrings(String[] bindArgs)` Given an array of String bindArgs, this method binds all of them in one single call.
`void` | `bindBlob(int index, byte[] value)` Bind a byte array value to this statement.
`void` | `bindDouble(int index, double value)` Bind a double value to this statement.
`void` | `bindLong(int index, long value)` Bind a long value to this statement.
`void` | `bindNull(int index)` Bind a NULL value to this statement.
`void` | `bindString(int index, String value)` Bind a String value to this statement.
`void` | `clearBindings()` Clears all existing bindings.
`final int` | `getUniqueId()` This method is deprecated. This method is deprecated and must not be used.
`void` | `onAllReferencesReleased()` Called when the last reference to the object was released by a call to `releaseReference()` or `close()`.
From class `android.database.sqlite.SQLiteClosable`
`void` | `acquireReference()` Acquires a reference to the object.
`void` | `close()` Releases a reference to the object, closing the object if the last reference was released.
`abstract void` | `onAllReferencesReleased()` Called when the last reference to the object was released by a call to `releaseReference()` or `close()`.
`void` | `onAllReferencesReleasedFromContainer()` This method is deprecated. Do not use.
`void` | `releaseReference()` Releases a reference to the object, closing the object if the last reference was released.
`void` | `releaseReferenceFromContainer()` This method is deprecated. Do not use.
From class `java.lang.Object`
`Object` | `clone()` Creates and returns a copy of this object.
`boolean` | `equals(Object obj)` Indicates whether some other object is "equal to" this one.
`void` | `finalize()` Called by the garbage collector on an object when garbage collection determines that there are no more references to the object.
`final Class<?>` | `getClass()` Returns the runtime class of this `Object`.
`int` | `hashCode()` Returns a hash code value for the object.
`final void` | `notify()` Wakes up a single thread that is waiting on this object's monitor.
`final void` | `notifyAll()` Wakes up all threads that are waiting on this object's monitor.
`String` | `toString()` Returns a string representation of the object.
`final void` | `wait(long timeout, int nanos)` Causes the current thread to wait until another thread invokes the `notify()` method or the `notifyAll()` method for this object, or some other thread interrupts the current thread, or a certain amount of real time has elapsed.
`final void` | `wait(long timeout)` Causes the current thread to wait until either another thread invokes the `notify()` method or the `notifyAll()` method for this object, or a specified amount of time has elapsed.
`final void` | `wait()` Causes the current thread to wait until another thread invokes the `notify()` method or the `notifyAll()` method for this object.
From interface `java.io.Closeable`
`abstract void` | `close()` Closes this stream and releases any system resources associated with it.
From interface `java.lang.AutoCloseable`
`abstract void` | `close()` Closes this resource, relinquishing any underlying resources.

## Public methods

### 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

### 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
`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

    public int executeUpdateDelete ()

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.

Returns
`int` | the number of rows affected by this SQL statement execution.

Throws
`SQLException` | If the SQL string is invalid for some reason

### simpleQueryForBlobFileDescriptor

    public ParcelFileDescriptor simpleQueryForBlobFileDescriptor ()

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

Returns
`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.

Throws
`SQLiteDoneException` | if the query returns zero rows

### 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
`long` | 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
`String` | The result of the query.

Throws
`SQLiteDoneException` | if the query returns zero rows

### toString

    public String toString ()

Returns a string representation of the object. In general, the `toString` method returns a string that "textually represents" this object. The result should be a concise but informative representation that is easy for a person to read. It is recommended that all subclasses override this method.

The `toString` method for class `Object` returns a string consisting of the name of the class of which the object is an instance, the at-sign character ``@`', and the unsigned hexadecimal representation of the hash code of the object. In other words, this method returns a string equal to the value of:

>      getClass().getName() + '@' + Integer.toHexString(hashCode())

Returns
`String` | a string representation of the object.

Full name *
Email address *
Company / developer name
One of your Play Store app URLs *
Which best describes your business:*
Apps
Games
Apps & Games
*
*