SQLITEPreparedStatement

Undocumented in source.

version(USE_SQLITE)
class SQLITEPreparedStatement : SQLITEStatement , PreparedStatement {}

Constructors

this
this(SQLITEConnection conn, string query)

Undocumented in source.

Members

Functions

clearParameters
void clearParameters()

Undocumented in source. Be warned that the author may not have intended to support it.

close
void close()

Undocumented in source. Be warned that the author may not have intended to support it.

createMetadata
ResultSetMetaData createMetadata()

Undocumented in source. Be warned that the author may not have intended to support it.

createParamMetadata
ParameterMetaData createParamMetadata()

Undocumented in source. Be warned that the author may not have intended to support it.

executeQuery
dstruct.ddbc.core.ResultSet executeQuery()

Undocumented in source. Be warned that the author may not have intended to support it.

executeUpdate
int executeUpdate(Variant insertId)

Undocumented in source. Be warned that the author may not have intended to support it.

executeUpdate
int executeUpdate()

Undocumented in source. Be warned that the author may not have intended to support it.

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.

getParam
Variant getParam(int index)

Undocumented in source. Be warned that the author may not have intended to support it.

getParameterMetaData
ParameterMetaData getParameterMetaData()

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

resetParams
void resetParams()

Undocumented in source. Be warned that the author may not have intended to support it.

setBoolean
void setBoolean(int parameterIndex, bool x)

Undocumented in source. Be warned that the author may not have intended to support it.

setByte
void setByte(int parameterIndex, byte x)

Undocumented in source. Be warned that the author may not have intended to support it.

setBytes
void setBytes(int parameterIndex, byte[] x)

Undocumented in source. Be warned that the author may not have intended to support it.

setDate
void setDate(int parameterIndex, Date x)

Undocumented in source. Be warned that the author may not have intended to support it.

setDateTime
void setDateTime(int parameterIndex, DateTime x)

Undocumented in source. Be warned that the author may not have intended to support it.

setDouble
void setDouble(int parameterIndex, double x)

Undocumented in source. Be warned that the author may not have intended to support it.

setFloat
void setFloat(int parameterIndex, float x)

Undocumented in source. Be warned that the author may not have intended to support it.

setInt
void setInt(int parameterIndex, int x)

Undocumented in source. Be warned that the author may not have intended to support it.

setLong
void setLong(int parameterIndex, long x)

Undocumented in source. Be warned that the author may not have intended to support it.

setNull
void setNull(int parameterIndex)

Undocumented in source. Be warned that the author may not have intended to support it.

setNull
void setNull(int parameterIndex, int sqlType)

Undocumented in source. Be warned that the author may not have intended to support it.

setShort
void setShort(int parameterIndex, short x)

Undocumented in source. Be warned that the author may not have intended to support it.

setString
void setString(int parameterIndex, string x)

Undocumented in source. Be warned that the author may not have intended to support it.

setSysTime
void setSysTime(int parameterIndex, SysTime x)

Undocumented in source. Be warned that the author may not have intended to support it.

setTime
void setTime(int parameterIndex, TimeOfDay x)

Undocumented in source. Be warned that the author may not have intended to support it.

setUbyte
void setUbyte(int parameterIndex, ubyte x)

Undocumented in source. Be warned that the author may not have intended to support it.

setUbytes
void setUbytes(int parameterIndex, ubyte[] x)

Undocumented in source. Be warned that the author may not have intended to support it.

setUint
void setUint(int parameterIndex, uint x)

Undocumented in source. Be warned that the author may not have intended to support it.

setUlong
void setUlong(int parameterIndex, ulong x)

Undocumented in source. Be warned that the author may not have intended to support it.

setUshort
void setUshort(int parameterIndex, ushort x)

Undocumented in source. Be warned that the author may not have intended to support it.

setVariant
void setVariant(int parameterIndex, Variant x)

Undocumented in source. Be warned that the author may not have intended to support it.

sqliteToSqlType
SqlType sqliteToSqlType(int t)

Undocumented in source. Be warned that the author may not have intended to support it.

toString
string toString()

Undocumented in source. Be warned that the author may not have intended to support it.

Variables

done
bool done;

Undocumented in source.

metadata
ResultSetMetaData metadata;

Undocumented in source.

paramCount
int paramCount;

Undocumented in source.

paramIsSet
bool[] paramIsSet;

Undocumented in source.

paramMetadata
ParameterMetaData paramMetadata;

Undocumented in source.

preparing
bool preparing;

Undocumented in source.

query
string query;

Undocumented in source.

stmt
sqlite3_stmt* stmt;

Undocumented in source.

Inherited Members

From SQLITEStatement

checkClosed
void checkClosed()

Undocumented in source. Be warned that the author may not have intended to support it.

lock
void lock()

Undocumented in source. Be warned that the author may not have intended to support it.

unlock
void unlock()

Undocumented in source. Be warned that the author may not have intended to support it.

getConnection
SQLITEConnection getConnection()

Undocumented in source. Be warned that the author may not have intended to support it.

executeQuery
dstruct.ddbc.core.ResultSet executeQuery(string query)

Undocumented in source. Be warned that the author may not have intended to support it.

executeUpdate
int executeUpdate(string query)

Undocumented in source. Be warned that the author may not have intended to support it.

executeUpdate
int executeUpdate(string query, Variant insertId)

Undocumented in source. Be warned that the author may not have intended to support it.

close
void close()

Undocumented in source. Be warned that the author may not have intended to support it.

closeResultSet
void closeResultSet()

Undocumented in source. Be warned that the author may not have intended to support it.

From PreparedStatement

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.

executeQuery
ResultSet executeQuery()

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

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.

clearParameters
void clearParameters()

Clears the current parameter values immediately.

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.

setSysTime
void setSysTime(int parameterIndex, SysTime 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 parameterIndex, Variant x)

Undocumented in source.

setNull
void setNull(int parameterIndex)

Undocumented in source.

setNull
void setNull(int parameterIndex, int sqlType)

Undocumented in source.

Meta