Represents a pre-compiled SQL statement with or without IN parameters.
public class PreparedStatement
All members of PreparedStatement class, including all inherited members.
Name | Description |
---|---|
Appends the specified subset of the specified array of bytes to the new value for the specified SQLType.LONGBINARY column. | |
Closes the prepared statement. | |
Executes a SQL SELECT statement as a query. | |
Executes a statement that does not return a result set, such as a SQL INSERT, DELETE or UPDATE statement. | |
Returns a text-based description of the query execution plan. | |
Returns the schema describing the result set of this query statement. | |
Checks whether the prepared statement generated a result set. | |
Checks whether this prepared statement is currently open. | |
Sets the value for the specified parameter using a boolean. | |
Sets the value for the specified parameter using an array of bytes. | |
Sets the value for the specified SQLType.DATE type parameter using a date. | |
Sets the value for the specified SQLType.DOUBLE type parameter using a double. | |
Sets the value for the specified SQLType.REAL type parameter. | |
Sets a parameter to a signed 32-bit value. | |
Sets a parameter to a signed 64-bit value. | |
Sets a parameter to a signed 16-bit value. | |
Sets the value for the specified parameter using a String. | |
Sets the value for the specified SQLType.TIME type parameter using a date. | |
Sets the value for the specified SQLType.TIMESTAMP type parameter using a date. | |
Sets the value for the specified SQLType.TIMESTAMP_WITH_TIME_ZONE type parameter using a date. | |
Sets a parameter to an unsigned 64-bit value. | |
Sets the value for the specified parameter using a UUID. |
This object can then be used to efficiently execute this statement multiple times.
When a prepared statement is closed, all ResultSet and ResultSetSchema objects associated with it are also closed. For resource management reasons, it is preferred that you explicitly close prepared statements when you are done with them.
appendBytesParameter method
close method
executeQuery method
executeStatement method
getPlan method
getResultSetSchema method
hasResultSet method
isOpen method
setBooleanParameter method
setBytesParameter method
setDateParameter method
setDoubleParameter method
setFloatParameter method
setIntParameter method
setLongParameter method
setShortParameter method
setStringParameter method
setTimeParameter method
setTimestampParameter method
setTimestampWithTimeZoneParameter method
setULongParameter method
setUUIDParameter method
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |