|
| Statement (IStatement *stmt_=0) |
|
Statement & | clear () |
| Sets all hostvariables to NULL. More...
|
|
Statement & | setNull (const std::string &col) |
| Sets the hostvariable with the given name to NULL. More...
|
|
Statement & | setBool (const std::string &col, bool data) |
| Sets the hostvariable with the given name to a boolean value. More...
|
|
Statement & | setShort (const std::string &col, short data) |
| Sets the hostvariable with the given name to a short value. More...
|
|
Statement & | setInt (const std::string &col, int data) |
| Sets the hostvariable with the given name to a int value. More...
|
|
Statement & | setLong (const std::string &col, long data) |
| Sets the hostvariable with the given name to a int value. More...
|
|
Statement & | setUnsignedShort (const std::string &col, unsigned short data) |
| Sets the hostvariable with the given name to a unsigned short value. More...
|
|
Statement & | setUnsigned (const std::string &col, unsigned data) |
| Sets the hostvariable with the given name to a unsigned value. More...
|
|
Statement & | setUnsignedLong (const std::string &col, unsigned long data) |
| Sets the hostvariable with the given name to a unsigned long value. More...
|
|
Statement & | setInt32 (const std::string &col, int32_t data) |
| Sets the hostvariable with the given name to a int32_t value. More...
|
|
Statement & | setUnsigned32 (const std::string &col, uint32_t data) |
| Sets the hostvariable with the given name to a uint32_t value. More...
|
|
Statement & | setInt64 (const std::string &col, int64_t data) |
| Sets the hostvariable with the given name to a int64_t value. More...
|
|
Statement & | setUnsigned64 (const std::string &col, uint64_t data) |
| Sets the hostvariable with the given name to a uint64_t value. More...
|
|
Statement & | setDecimal (const std::string &col, const Decimal &data) |
| Sets the hostvariable with the given name to a Decimal. More...
|
|
Statement & | setFloat (const std::string &col, float data) |
| Sets the hostvariable with the given name to a float value. More...
|
|
Statement & | setDouble (const std::string &col, double data) |
| Sets the hostvariable with the given name to a double value. More...
|
|
Statement & | setChar (const std::string &col, char data) |
| Sets the hostvariable with the given name to a char value. More...
|
|
Statement & | setString (const std::string &col, const std::string &data) |
| Sets the hostvariable with the given name to a string value. More...
|
|
Statement & | setString (const std::string &col, const char *data) |
| Sets the hostvariable with the given name to a string value or null, if passing null-pointer. More...
|
|
Statement & | setUString (const std::string &col, const cxxtools::String &data) |
| Sets the hostvariable with the given name to a unicode string value. More...
|
|
Statement & | setBlob (const std::string &col, const Blob &data) |
| Sets the hostvariable with the given name to a blob value. More...
|
|
Statement & | setDate (const std::string &col, const Date &data) |
| Sets the hostvariable with the given name to a date value. More...
|
|
Statement & | setTime (const std::string &col, const Time &data) |
| Sets the hostvariable with the given name to a time value. More...
|
|
Statement & | setDatetime (const std::string &col, const Datetime &data) |
| Sets the hostvariable with the given name to a datetime value. More...
|
|
template<typename Iterator > |
Statement & | set (const std::string &col, Iterator it1, Iterator it2) |
|
template<typename T > |
Statement & | setIf (const std::string &col, bool notNull, const T &data) |
| Set the hostvariable with the given name to the passed value or null. More...
|
|
size_type | execute () |
| statement-execution-methods More...
|
|
Result | select () |
| Executes a query, which returns a resultset, with the current parameters. More...
|
|
Row | selectRow () |
| Executes a query, which returns a row, with the current parameters. More...
|
|
Value | selectValue () |
| Executes a query, which returns a single value, with the current parameters. More...
|
|
const_iterator | begin (unsigned fetchsize=100) const |
| This methods creates a cursor and fetches the first row. More...
|
|
const_iterator | end () const |
| A empty iterator is returned. More...
|
|
bool | operator! () const |
| Returns true, if this class is not connected to a actual statement. More...
|
|
const IStatement * | getImpl () const |
| Returns the actual implementation-class. More...
|
|
IStatement * | getImpl () |
|
|
template<typename T > |
Statement & | set (const std::string &col, const T &data) |
| Set the hostvariable with the given name to the passed value. More...
|
|
This class represents a sql-statement.
A statement can have parameters, which are referenced by name, called hostvariables. They are prefixed with a colon followed by a name. A name starts with a letter followed by alphanumeric characters or underscore. Hostvariables are not searched in strings (between apostrophes, quotation marks or backticks). The backslash prevents the interpretation of a special meaning of the following character.