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(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.

setBoolean
void setBoolean(int parameterIndex, bool x)
Undocumented in source.
setByte
void setByte(int parameterIndex, byte x)
Undocumented in source.
setBytes
void setBytes(int parameterIndex, byte[] x)
Undocumented in source.
setDate
void setDate(int parameterIndex, Date x)
Undocumented in source.
setDateTime
void setDateTime(int parameterIndex, DateTime x)
Undocumented in source.
setDouble
void setDouble(int parameterIndex, double x)
Undocumented in source.
setFloat
void setFloat(int parameterIndex, float x)
Undocumented in source.
setInt
void setInt(int parameterIndex, int x)
Undocumented in source.
setLong
void setLong(int parameterIndex, long x)
Undocumented in source.
setNull
void setNull(int parameterIndex, int sqlType)
Undocumented in source.
setNull
void setNull(int parameterIndex)
Undocumented in source.
setShort
void setShort(int parameterIndex, short x)
Undocumented in source.
setString
void setString(int parameterIndex, string x)
Undocumented in source.
setTime
void setTime(int parameterIndex, TimeOfDay x)
Undocumented in source.
setUbyte
void setUbyte(int parameterIndex, ubyte x)
Undocumented in source.
setUbytes
void setUbytes(int parameterIndex, ubyte[] x)
Undocumented in source.
setUint
void setUint(int parameterIndex, uint x)
Undocumented in source.
setUlong
void setUlong(int parameterIndex, ulong x)
Undocumented in source.
setUshort
void setUshort(int parameterIndex, ushort x)
Undocumented in source.
setVariant
void setVariant(int parameterIndex, Variant x)
Undocumented in source.

Inherited Members

From Statement

executeQuery
ResultSet executeQuery(string query)
Undocumented in source.
executeUpdate
int executeUpdate(string query)
Undocumented in source.
executeUpdate
int executeUpdate(string query, Variant insertId)
Undocumented in source.
close
void close()
Undocumented in source.

From DataSetWriter

setFloat
void setFloat(int parameterIndex, float x)
Undocumented in source.
setDouble
void setDouble(int parameterIndex, double x)
Undocumented in source.
setBoolean
void setBoolean(int parameterIndex, bool x)
Undocumented in source.
setLong
void setLong(int parameterIndex, long x)
Undocumented in source.
setInt
void setInt(int parameterIndex, int x)
Undocumented in source.
setShort
void setShort(int parameterIndex, short x)
Undocumented in source.
setByte
void setByte(int parameterIndex, byte x)
Undocumented in source.
setBytes
void setBytes(int parameterIndex, byte[] x)
Undocumented in source.
setUlong
void setUlong(int parameterIndex, ulong x)
Undocumented in source.
setUint
void setUint(int parameterIndex, uint x)
Undocumented in source.
setUshort
void setUshort(int parameterIndex, ushort x)
Undocumented in source.
setUbyte
void setUbyte(int parameterIndex, ubyte x)
Undocumented in source.
setUbytes
void setUbytes(int parameterIndex, ubyte[] x)
Undocumented in source.
setString
void setString(int parameterIndex, string x)
Undocumented in source.
setDateTime
void setDateTime(int parameterIndex, DateTime x)
Undocumented in source.
setDate
void setDate(int parameterIndex, Date x)
Undocumented in source.
setTime
void setTime(int parameterIndex, TimeOfDay x)
Undocumented in source.
setVariant
void setVariant(int columnIndex, Variant x)
Undocumented in source.
setNull
void setNull(int parameterIndex)
Undocumented in source.
setNull
void setNull(int parameterIndex, int sqlType)
Undocumented in source.

Meta