SQLiteStatement Class

Definition

Represents a statement that can be executed against a database.

[Android.Runtime.Register("android/database/sqlite/SQLiteStatement", DoNotGenerateAcw=true)]
public class SQLiteStatement : Android.Database.Sqlite.SQLiteProgram
[<Android.Runtime.Register("android/database/sqlite/SQLiteStatement", DoNotGenerateAcw=true)>]
type SQLiteStatement = class
    inherit SQLiteProgram
Inheritance
Attributes

Remarks

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.

Java documentation for android.database.sqlite.SQLiteStatement.

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Constructors

SQLiteStatement(IntPtr, JniHandleOwnership)

A constructor used when creating managed representations of JNI objects; called by the runtime.

Properties

Class

Returns the runtime class of this Object.

(Inherited from Object)
Handle

The handle to the underlying Android instance.

(Inherited from Object)
JniIdentityHashCode (Inherited from Object)
JniPeerMembers
MDatabase
Obsolete.
(Inherited from SQLiteProgram)
NHandle
Obsolete.
(Inherited from SQLiteProgram)
NStatement
Obsolete.
(Inherited from SQLiteProgram)
PeerReference (Inherited from Object)
ThresholdClass

This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

ThresholdType

This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

UniqueId
Obsolete.

Unimplemented.

(Inherited from SQLiteProgram)

Methods

AcquireReference()

Acquires a reference to the object.

(Inherited from SQLiteClosable)
BindAllArgsAsStrings(String[])

Given an array of String bindArgs, this method binds all of them in one single call.

(Inherited from SQLiteProgram)
BindBlob(Int32, Byte[])

Bind a byte array value to this statement.

(Inherited from SQLiteProgram)
BindDouble(Int32, Double)

Bind a double value to this statement.

(Inherited from SQLiteProgram)
BindLong(Int32, Int64)

Bind a long value to this statement.

(Inherited from SQLiteProgram)
BindNull(Int32)

Bind a NULL value to this statement.

(Inherited from SQLiteProgram)
BindString(Int32, String)

Bind a String value to this statement.

(Inherited from SQLiteProgram)
ClearBindings()

Clears all existing bindings.

(Inherited from SQLiteProgram)
Clone()

Creates and returns a copy of this object.

(Inherited from Object)
Close() (Inherited from SQLiteProgram)
Compile(String, Boolean)
Obsolete.
(Inherited from SQLiteProgram)
Dispose() (Inherited from Object)
Dispose(Boolean) (Inherited from Object)
Equals(Object)

Indicates whether some other object is "equal to" this one.

(Inherited from Object)
Execute()

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

ExecuteInsert()

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

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.

GetHashCode()

Returns a hash code value for the object.

(Inherited from Object)
JavaFinalize()

Called by the garbage collector on an object when garbage collection determines that there are no more references to the object.

(Inherited from Object)
Native_bind_blob(Int32, Byte[]) (Inherited from SQLiteProgram)
Native_bind_double(Int32, Double) (Inherited from SQLiteProgram)
Native_bind_long(Int32, Int64) (Inherited from SQLiteProgram)
Native_bind_null(Int32) (Inherited from SQLiteProgram)
Native_bind_string(Int32, String) (Inherited from SQLiteProgram)
Native_compile(String)
Obsolete.
(Inherited from SQLiteProgram)
Native_finalize()
Obsolete.
(Inherited from SQLiteProgram)
Notify()

Wakes up a single thread that is waiting on this object's monitor.

(Inherited from Object)
NotifyAll()

Wakes up all threads that are waiting on this object's monitor.

(Inherited from Object)
OnAllReferencesReleased()

Called when the last reference to the object was released by a call to ReleaseReference() or Close().

(Inherited from SQLiteProgram)
OnAllReferencesReleasedFromContainer()
Obsolete.

Called when the last reference to the object was released by a call to #releaseReferenceFromContainer().

(Inherited from SQLiteClosable)
ReleaseReference()

Releases a reference to the object, closing the object if the last reference was released.

(Inherited from SQLiteClosable)
ReleaseReferenceFromContainer()
Obsolete.

Releases a reference to the object that was owned by the container of the object, closing the object if the last reference was released.

(Inherited from SQLiteClosable)
SetHandle(IntPtr, JniHandleOwnership)

Sets the Handle property.

(Inherited from Object)
SimpleQueryForBlobFileDescriptor()

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

SimpleQueryForLong()

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

SimpleQueryForString()

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

ToArray<T>() (Inherited from Object)
ToString()

Returns a string representation of the object.

(Inherited from Object)
UnregisterFromRuntime() (Inherited from Object)
Wait()

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>.

(Inherited from Object)
Wait(Int64, Int32)

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed.

(Inherited from Object)
Wait(Int64)

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed.

(Inherited from Object)

Explicit Interface Implementations

Extension Methods

Applies to