IDatabaseStatement Class
(CDP2SQL::IDatabaseStatement)Abstract interface base for SQL statements. More...
| Header: | #include <IDatabaseStatement> |
Public Functions
| virtual | ~IDatabaseStatement() |
| virtual void | Bind(int param, int value) = 0 |
| virtual void | Bind(int param, int64_t value) = 0 |
| virtual void | Bind(int param, const std::string &value) |
| virtual void | Bind(int param, const char *value) = 0 |
| virtual void | Bind(int param, const unsigned char *blobValue, int len) = 0 |
| virtual void | Bind(int param, double value) = 0 |
| virtual void | Bind(int param, bool value) = 0 |
| virtual void | BindNull(int param) = 0 |
| virtual void | Close() = 0 |
| virtual void | Compile(const std::string &sqlString) = 0 |
| virtual void | Execute() = 0 |
| virtual void | ExecuteQuery(IDatabaseQuery *qr) = 0 |
| virtual void | Reset() = 0 |
Detailed Description
Abstract interface base for SQL statements.
Concrete implementations are created (and destroyed) by IDatabaseConnection.
Member Function Documentation
[virtual] IDatabaseStatement::~IDatabaseStatement()
Should have virtual destructor for all abstract classes. Must close statement if open.
[pure virtual] void IDatabaseStatement::Bind(int param, int value)
Binds placeholder at position param to integer value value.
[pure virtual] void IDatabaseStatement::Bind(int param, int64_t value)
Binds placeholder at position param to int64_t value value.
[virtual] void IDatabaseStatement::Bind(int param, const std::string &value)
Binds placeholder at position param to string value value.
[pure virtual] void IDatabaseStatement::Bind(int param, const char *value)
Binds placeholder at position param to string value value.
[pure virtual] void IDatabaseStatement::Bind(int param, const unsigned char *blobValue, int len)
Binds placeholder at position param to blobValue with length len.
[pure virtual] void IDatabaseStatement::Bind(int param, double value)
Binds placeholder at position param to floating point value value.
[pure virtual] void IDatabaseStatement::Bind(int param, bool value)
Binds placeholder at position param to boolean value value.
[pure virtual] void IDatabaseStatement::BindNull(int param)
Binds placeholder at position param to SQL NULL.
[pure virtual] void IDatabaseStatement::Close()
Closes and finalizes the statement. Should do any major cleanup on the statement.
[pure virtual] void IDatabaseStatement::Compile(const std::string &sqlString)
Compiles an SQL string for the statment.
[pure virtual] void IDatabaseStatement::Execute()
Executes the statement.
All placeholders must have been bound to values.
[pure virtual] void IDatabaseStatement::ExecuteQuery(IDatabaseQuery *qr)
Executes the query.
[pure virtual] void IDatabaseStatement::Reset()
Resets the statement for reuse.
Remember to re-Bind all placeholder values before calling Execute().
Get started with CDP Studio today
Let us help you take your great ideas and turn them into the products your customer will love.