IPreparedStatement IPreparedStatement Interface

Definition

An interface for a precompiled SQL Statement.

[Android.Runtime.Register("java/sql/PreparedStatement", "", "Java.Sql.IPreparedStatementInvoker", ApiSince=1)]
public interface IPreparedStatement : IDisposable, Java.Sql.IStatement
type IPreparedStatement = interface
    interface IStatement
    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.

(Inherited from IStatement)
FetchDirection FetchDirection

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

(Inherited from IStatement)
FetchSize FetchSize

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

(Inherited from IStatement)
GeneratedKeys GeneratedKeys

Returns auto generated keys created by executing this statement.

(Inherited from IStatement)
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.

(Inherited from IStatement)
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.

(Inherited from IStatement)
MaxRows MaxRows

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

(Inherited from IStatement)
MetaData MetaData

Returns a ResultSetMetaData describing the ResultSet that would be produced by execution of the PreparedStatement.

MoreResults MoreResults

Moves to this statement's next result.

(Inherited from IStatement)
ParameterMetaData ParameterMetaData

Gets information about the parameters of the PreparedStatement.

Poolable Poolable

Returns true if this statement is poolable, false otherwise.

(Inherited from IStatement)
QueryTimeout QueryTimeout

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

(Inherited from IStatement)
ResultSet ResultSet

Gets the current result.

(Inherited from IStatement)
ResultSetConcurrency ResultSetConcurrency

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

(Inherited from IStatement)
ResultSetHoldability ResultSetHoldability

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

(Inherited from IStatement)
ResultSetType ResultSetType

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

(Inherited from IStatement)
UpdateCount UpdateCount

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

(Inherited from IStatement)
Warnings Warnings

Retrieves the first SQLWarning reported by calls on this statement.

(Inherited from IStatement)

Methods

AddBatch() AddBatch()

Add a set of parameters to the PreparedStatement's command batch.

AddBatch(String) AddBatch(String)

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

(Inherited from IStatement)
Cancel() Cancel()

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

(Inherited from IStatement)
ClearBatch() ClearBatch()

Clears the current list of SQL commands for this statement.

(Inherited from IStatement)
ClearParameters() ClearParameters()

Clear the current parameter values.

ClearWarnings() ClearWarnings()

Clears all SQLWarnings from this statement.

(Inherited from IStatement)
Close() Close()

Releases this statement's database and JDBC driver resources.

(Inherited from IStatement)
Execute() Execute()

Executes the SQL statement in this PreparedStatement.

Execute(String) Execute(String)

Executes a supplied SQL statement.

(Inherited from IStatement)
Execute(String, Int32) Execute(String, Int32)

Executes a supplied SQL statement.

(Inherited from IStatement)
Execute(String, Int32[]) Execute(String, Int32[])

Executes the supplied SQL statement.

(Inherited from IStatement)
Execute(String, String[]) Execute(String, String[])

Executes the supplied SQL statement.

(Inherited from IStatement)
ExecuteBatch() ExecuteBatch()

Submits a batch of SQL commands to the database.

(Inherited from IStatement)
ExecuteQuery() ExecuteQuery()

Executes the SQL query in the PreparedStatement and returns the ResultSet generated by the query.

ExecuteQuery(String) ExecuteQuery(String)

Executes a supplied SQL statement.

(Inherited from IStatement)
ExecuteUpdate() ExecuteUpdate()

Invokes the SQL command contained within the prepared statement.

ExecuteUpdate(String) ExecuteUpdate(String)

Executes the supplied SQL statement.

(Inherited from IStatement)
ExecuteUpdate(String, Int32) ExecuteUpdate(String, Int32)

Executes the supplied SQL statement.

(Inherited from IStatement)
ExecuteUpdate(String, Int32[]) ExecuteUpdate(String, Int32[])

Executes the supplied SQL statement.

(Inherited from IStatement)
ExecuteUpdate(String, String[]) ExecuteUpdate(String, String[])

Executes the supplied SQL statement.

(Inherited from IStatement)
GetMoreResults(Int32) GetMoreResults(Int32)

Moves to this statement's next result.

(Inherited from IStatement)
IsWrapperFor(Class) IsWrapperFor(Class) Inherited from IWrapper
SetArray(Int32, IArray) SetArray(Int32, IArray)

Sets the value of a specified parameter to the supplied Array.

SetAsciiStream(Int32, Stream) SetAsciiStream(Int32, Stream)

Sets the value of the specified parameter to the bytes from inputStream.

SetAsciiStream(Int32, Stream, Int32) SetAsciiStream(Int32, Stream, Int32)

Sets the value of a specified parameter to the content of a supplied InputStream, which has a specified number of bytes.

SetAsciiStream(Int32, Stream, Int64) SetAsciiStream(Int32, Stream, Int64)

Sets the value of the specified parameter to the next length bytes from inputStream.

SetBigDecimal(Int32, BigDecimal) SetBigDecimal(Int32, BigDecimal)

Sets the value of a specified parameter to a supplied java.math.BigDecimal value.

SetBinaryStream(Int32, Stream) SetBinaryStream(Int32, Stream)

Sets the value of the specified parameter to the bytes from inputStream.

SetBinaryStream(Int32, Stream, Int32) SetBinaryStream(Int32, Stream, Int32)

Sets the value of a specified parameter to the content of a supplied binary InputStream, which has a specified number of bytes.

SetBinaryStream(Int32, Stream, Int64) SetBinaryStream(Int32, Stream, Int64)

Sets the value of the specified parameter to the next length bytes from inputStream.

SetBlob(Int32, IBlob) SetBlob(Int32, IBlob)

Sets the value of a specified parameter to the given Blob object.

SetBlob(Int32, Stream) SetBlob(Int32, Stream)

Sets the value of the specified parameter to the bytes from inputStream.

SetBlob(Int32, Stream, Int64) SetBlob(Int32, Stream, Int64)

Sets the value of the specified parameter to the next length bytes from inputStream.

SetBoolean(Int32, Boolean) SetBoolean(Int32, Boolean)

Sets the value of a specified parameter to a supplied boolean value.

SetByte(Int32, SByte) SetByte(Int32, SByte)

Sets the value of a specified parameter to a supplied byte value.

SetBytes(Int32, Byte[]) SetBytes(Int32, Byte[])

Sets the value of a specified parameter to a supplied array of bytes.

SetCharacterStream(Int32, Reader) SetCharacterStream(Int32, Reader)

Sets the value of the specified parameter to the characters from reader.

SetCharacterStream(Int32, Reader, Int32) SetCharacterStream(Int32, Reader, Int32)

Sets the value of a specified parameter to the character content of a Reader object, with the specified length of character data.

SetCharacterStream(Int32, Reader, Int64) SetCharacterStream(Int32, Reader, Int64)

Sets the value of the specified parameter to the next length characters from reader.

SetClob(Int32, IClob) SetClob(Int32, IClob)

Sets the value of a specified parameter to the given Clob object.

SetClob(Int32, Reader) SetClob(Int32, Reader)

Sets the value of the specified parameter to the characters from reader.

SetClob(Int32, Reader, Int64) SetClob(Int32, Reader, Int64)

Sets the value of the specified parameter to the next length characters from reader.

SetCursorName(String) SetCursorName(String)

Sets the SQL cursor name.

(Inherited from IStatement)
SetDate(Int32, Date) SetDate(Int32, Date)

Sets the value of a specified parameter to a supplied java.sql.Date value.

SetDate(Int32, Date, Calendar) SetDate(Int32, Date, Calendar)

Sets the value of a specified parameter to a supplied java.sql.Date value, using a supplied Calendar to map the Date.

SetDouble(Int32, Double) SetDouble(Int32, Double)

Sets the value of a specified parameter to a supplied double value.

SetEscapeProcessing(Boolean) SetEscapeProcessing(Boolean)

Sets Escape Processing mode.

(Inherited from IStatement)
SetFloat(Int32, Single) SetFloat(Int32, Single)

Sets the value of a specified parameter to to a supplied float value.

SetInt(Int32, Int32) SetInt(Int32, Int32)

Sets the value of a specified parameter to a supplied int value.

SetLong(Int32, Int64) SetLong(Int32, Int64)

Sets the value of a specified parameter to a supplied long value.

SetNCharacterStream(Int32, Reader) SetNCharacterStream(Int32, Reader)

Sets the value of the specified parameter to the characters from reader.

SetNCharacterStream(Int32, Reader, Int64) SetNCharacterStream(Int32, Reader, Int64)

Sets the value of the specified parameter to the next length characters from reader.

SetNClob(Int32, INClob) SetNClob(Int32, INClob)

Sets the value of the specified parameter to value.

SetNClob(Int32, Reader) SetNClob(Int32, Reader)

Sets the value of the specified parameter to the characters from reader.

SetNClob(Int32, Reader, Int64) SetNClob(Int32, Reader, Int64)

Sets the value of the specified parameter to the next length characters from reader.

SetNString(Int32, String) SetNString(Int32, String)

Sets the value of a specified parameter to a supplied string.

SetNull(Int32, Int32) SetNull(Int32, Int32)

Sets the value of a specified parameter to SQL NULL.

SetNull(Int32, Int32, String) SetNull(Int32, Int32, String)

Sets the value of a specified parameter to SQL NULL.

SetObject(Int32, Object) SetObject(Int32, Object)

Sets the value of a specified parameter using a supplied object.

SetObject(Int32, Object, Int32) SetObject(Int32, Object, Int32)

Sets the value of a specified parameter using a supplied object.

SetObject(Int32, Object, Int32, Int32) SetObject(Int32, Object, Int32, Int32)

Sets the value of a specified parameter using a supplied object.

SetRef(Int32, IRef) SetRef(Int32, IRef)

)

SetRowId(Int32, IRowId) SetRowId(Int32, IRowId)

Sets the value of a specified parameter to a supplied java.sql.RowId.

SetShort(Int32, Int16) SetShort(Int32, Int16)

Sets the value of a specified parameter to a supplied short value.

SetSQLXML(Int32, ISQLXML) SetSQLXML(Int32, ISQLXML)

Sets the value of the specified parameter to the value of xmlObject.

SetString(Int32, String) SetString(Int32, String)

Sets the value of a specified parameter to a supplied string.

SetTime(Int32, Time) SetTime(Int32, Time)

Sets the value of a specified parameter to a supplied java.sql.Time value.

SetTime(Int32, Time, Calendar) SetTime(Int32, Time, Calendar)

Sets the value of a specified parameter to a supplied java.sql.Time value, using a supplied Calendar.

SetTimestamp(Int32, Timestamp) SetTimestamp(Int32, Timestamp)

Sets the value of a specified parameter to a supplied java.sql.

SetTimestamp(Int32, Timestamp, Calendar) SetTimestamp(Int32, Timestamp, Calendar)

Sets the value of a specified parameter to a supplied java.sql.Timestamp value, using the supplied Calendar.

SetUnicodeStream(Int32, Stream, Int32) SetUnicodeStream(Int32, Stream, Int32)

Sets the value of a specified parameter to the characters from a supplied InputStream, with a specified number of bytes.

SetURL(Int32, URL) SetURL(Int32, URL)

Sets the value of a specified parameter to a supplied java.net.URL.

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