IStatement IStatement Interface

Definition

Interface used for executing static SQL statements to retrieve query results.

[Android.Runtime.Register("java/sql/Statement", "", "Java.Sql.IStatementInvoker", ApiSince=1)]
public interface IStatement : IDisposable, Java.Sql.IWrapper
type IStatement = interface
    interface IWrapper
    interface IJavaObject
    interface IDisposable
Derived
Attributes
Implements

Remarks

Android platform documentation

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.

Properties

Connection Connection

Gets the Connection object which created this statement.

FetchDirection FetchDirection

Gets the default direction for fetching rows for ResultSets generated from this statement.

FetchSize FetchSize

Gets the default number of rows for a fetch for the ResultSet objects returned from this statement.

GeneratedKeys GeneratedKeys

Returns auto generated keys created by executing this statement.

Handle Handle

Gets the JNI value of the underlying Android object.

(Inherited from IJavaObject)
IsClosed IsClosed

Returns true if this statement has been closed, false otherwise.

MaxFieldSize MaxFieldSize

Gets the maximum number of bytes which can be returned as values from character and binary type columns in a ResultSet derived from this statement.

MaxRows MaxRows

Gets the maximum number of rows that a ResultSet can contain when produced from this statement.

MoreResults MoreResults

Moves to this statement's next result.

Poolable Poolable

Returns true if this statement is poolable, false otherwise.

QueryTimeout QueryTimeout

Gets the timeout value for the statement's execution time.

ResultSet ResultSet

Gets the current result.

ResultSetConcurrency ResultSetConcurrency

Gets the concurrency setting for ResultSet objects generated by this statement.

ResultSetHoldability ResultSetHoldability

Gets the cursor hold setting for ResultSet objects generated by this statement.

ResultSetType ResultSetType

Gets the ResultSet type setting for ResultSets derived from this statement.

UpdateCount UpdateCount

Gets an update count for the current result if it is not a ResultSet.

Warnings Warnings

Retrieves the first SQLWarning reported by calls on this statement.

Methods

AddBatch(String) AddBatch(String)

Adds a specified SQL command to the list of commands for this Statement.

Cancel() Cancel()

Cancels this statement's execution if both the database and the JDBC driver support aborting an SQL statement in flight.

ClearBatch() ClearBatch()

Clears the current list of SQL commands for this statement.

ClearWarnings() ClearWarnings()

Clears all SQLWarnings from this statement.

Close() Close()

Releases this statement's database and JDBC driver resources.

Execute(String) Execute(String)

Executes a supplied SQL statement.

Execute(String, Int32) Execute(String, Int32)

Executes a supplied SQL statement.

Execute(String, Int32[]) Execute(String, Int32[])

Executes the supplied SQL statement.

Execute(String, String[]) Execute(String, String[])

Executes the supplied SQL statement.

ExecuteBatch() ExecuteBatch()

Submits a batch of SQL commands to the database.

ExecuteQuery(String) ExecuteQuery(String)

Executes a supplied SQL statement.

ExecuteUpdate(String) ExecuteUpdate(String)

Executes the supplied SQL statement.

ExecuteUpdate(String, Int32) ExecuteUpdate(String, Int32)

Executes the supplied SQL statement.

ExecuteUpdate(String, Int32[]) ExecuteUpdate(String, Int32[])

Executes the supplied SQL statement.

ExecuteUpdate(String, String[]) ExecuteUpdate(String, String[])

Executes the supplied SQL statement.

GetMoreResults(Int32) GetMoreResults(Int32)

Moves to this statement's next result.

IsWrapperFor(Class) IsWrapperFor(Class) Inherited from IWrapper
SetCursorName(String) SetCursorName(String)

Sets the SQL cursor name.

SetEscapeProcessing(Boolean) SetEscapeProcessing(Boolean)

Sets Escape Processing mode.

Unwrap(Class) Unwrap(Class) Inherited from IWrapper

Extension Methods

JavaCast<TResult>(IJavaObject) JavaCast<TResult>(IJavaObject)

Performs an Android runtime-checked type conversion.

JavaCast<TResult>(IJavaObject) JavaCast<TResult>(IJavaObject)

Applies to