PreparedStatement

An object that represents a precompiled SQL statement.

Members

Functions

clearParameters
void clearParameters()

Clears the current parameter values immediately.

executeQuery
ResultSet executeQuery()

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

executeUpdate
int executeUpdate()

Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.

executeUpdate
int executeUpdate(out Variant insertId)

Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.

getMetaData
ResultSetMetaData getMetaData()

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.

getParameterMetaData
ParameterMetaData getParameterMetaData()

Retrieves the number, types and properties of this PreparedStatement object's parameters.

Meta