IConnection.PrepareCall Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| PrepareCall(String, Int32, Int32, Int32) |
Creates a <code>CallableStatement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency. |
| PrepareCall(String, Int32, Int32) |
Creates a <code>CallableStatement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency. |
| PrepareCall(String) |
Creates a <code>CallableStatement</code> object for calling database stored procedures. |
PrepareCall(String, Int32, Int32, Int32)
Creates a <code>CallableStatement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency.
[Android.Runtime.Register("prepareCall", "(Ljava/lang/String;III)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_IIIHandler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public Java.Sql.ICallableStatement? PrepareCall (string? sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability);[<Android.Runtime.Register("prepareCall", "(Ljava/lang/String;III)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_IIIHandler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member PrepareCall : string * int * int * int -> Java.Sql.ICallableStatementParameters
- sql
- String
a <code>String</code> object that is the SQL statement to be sent to the database; may contain on or more '?' parameters
- resultSetType
- Int32
one of the following <code>ResultSet</code> constants: <code>ResultSet.TYPE_FORWARD_ONLY</code>, <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or <code>ResultSet.TYPE_SCROLL_SENSITIVE</code>
- resultSetConcurrency
- Int32
one of the following <code>ResultSet</code> constants: <code>ResultSet.CONCUR_READ_ONLY</code> or <code>ResultSet.CONCUR_UPDATABLE</code>
- resultSetHoldability
- Int32
one of the following <code>ResultSet</code> constants: <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or <code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code>
Returns
a new <code>CallableStatement</code> object, containing the pre-compiled SQL statement, that will generate <code>ResultSet</code> objects with the given type, concurrency, and holdability
- Attributes
Exceptions
if a problem occurs accessing the database.
Remarks
Java documentation for java.sql.Connection.prepareCall(java.lang.String, int, int, int).
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.
Applies to
PrepareCall(String, Int32, Int32)
Creates a <code>CallableStatement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency.
[Android.Runtime.Register("prepareCall", "(Ljava/lang/String;II)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_IIHandler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public Java.Sql.ICallableStatement? PrepareCall (string? sql, int resultSetType, int resultSetConcurrency);[<Android.Runtime.Register("prepareCall", "(Ljava/lang/String;II)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_IIHandler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member PrepareCall : string * int * int -> Java.Sql.ICallableStatementParameters
- sql
- String
a <code>String</code> object that is the SQL statement to be sent to the database; may contain on or more '?' parameters
- resultSetType
- Int32
a result set type; one of <code>ResultSet.TYPE_FORWARD_ONLY</code>, <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or <code>ResultSet.TYPE_SCROLL_SENSITIVE</code>
- resultSetConcurrency
- Int32
a concurrency type; one of <code>ResultSet.CONCUR_READ_ONLY</code> or <code>ResultSet.CONCUR_UPDATABLE</code>
Returns
a new <code>CallableStatement</code> object containing the pre-compiled SQL statement that will produce <code>ResultSet</code> objects with the given type and concurrency
- Attributes
Exceptions
if a problem occurs accessing the database
Remarks
Java documentation for java.sql.Connection.prepareCall(java.lang.String, int, int).
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.
Applies to
PrepareCall(String)
Creates a <code>CallableStatement</code> object for calling database stored procedures.
[Android.Runtime.Register("prepareCall", "(Ljava/lang/String;)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_Handler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public Java.Sql.ICallableStatement? PrepareCall (string? sql);[<Android.Runtime.Register("prepareCall", "(Ljava/lang/String;)Ljava/sql/CallableStatement;", "GetPrepareCall_Ljava_lang_String_Handler:Java.Sql.IConnectionInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member PrepareCall : string -> Java.Sql.ICallableStatementParameters
- sql
- String
an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is specified using JDBC call escape syntax.
Returns
a new default <code>CallableStatement</code> object containing the pre-compiled SQL statement
- Attributes
Exceptions
if a problem occurs accessing the database.
Remarks
Java documentation for java.sql.Connection.prepareCall(java.lang.String).
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.