Wt  3.3.9
Public Member Functions | List of all members
Wt::Dbo::backend::MySQLStatement Class Reference

MySQL prepared statement. More...

Inheritance diagram for Wt::Dbo::backend::MySQLStatement:
Inheritance graph
[legend]

Public Member Functions

virtual void reset ()
 Resets the statement.
 
virtual void bind (int column, const std::string &value)
 Binds a value to a column.
 
virtual void bind (int column, short value)
 Binds a value to a column.
 
virtual void bind (int column, int value)
 Binds a value to a column.
 
virtual void bind (int column, long long value)
 Binds a value to a column.
 
virtual void bind (int column, float value)
 Binds a value to a column.
 
virtual void bind (int column, double value)
 Binds a value to a column.
 
virtual void bind (int column, const boost::posix_time::ptime &value, SqlDateTimeType type)
 Binds a value to a column.
 
virtual void bind (int column, const boost::posix_time::time_duration &value)
 Binds a value to a column.
 
virtual void bind (int column, const std::vector< unsigned char > &value)
 Binds a value to a column.
 
virtual void bindNull (int column)
 Binds null to a column.
 
virtual void execute ()
 Executes the statement.
 
virtual long long insertedId ()
 Returns the id if the statement was an SQL insert.
 
virtual int affectedRowCount ()
 Returns the affected number of rows. More...
 
virtual bool nextRow ()
 Fetches the next result row. More...
 
virtual bool getResult (int column, std::string *value, int size)
 Fetches a result value. More...
 
virtual bool getResult (int column, short *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, int *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, long long *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, float *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, double *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, boost::posix_time::ptime *value, SqlDateTimeType type)
 Fetches a result value. More...
 
virtual bool getResult (int column, boost::posix_time::time_duration *value)
 Fetches a result value. More...
 
virtual bool getResult (int column, std::vector< unsigned char > *value, int size)
 Fetches a result value. More...
 
virtual std::string sql () const
 Returns the prepared SQL string.
 
- Public Member Functions inherited from Wt::Dbo::SqlStatement
virtual ~SqlStatement ()
 Destructor.
 
bool use ()
 Uses the statement. More...
 
void done ()
 Finish statement use. More...
 

Detailed Description

MySQL prepared statement.

Member Function Documentation

virtual int Wt::Dbo::backend::MySQLStatement::affectedRowCount ( )
virtual

Returns the affected number of rows.

This is only useful for an SQL update or delete statement.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
std::string *  value,
int  size 
)
virtual

Fetches a result value.

Returns true when the value was not null. The size is the expected size of sql string type and can be used to dimension buffers but the return string may be bigger.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
short *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
int *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
long long *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
float *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
double *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
boost::posix_time::ptime *  value,
SqlDateTimeType  type 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
boost::posix_time::time_duration *  value 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::getResult ( int  column,
std::vector< unsigned char > *  value,
int  size 
)
virtual

Fetches a result value.

Returns true when the value was not null.

Implements Wt::Dbo::SqlStatement.

virtual bool Wt::Dbo::backend::MySQLStatement::nextRow ( )
virtual

Fetches the next result row.

Returns true if there was one more row to be fetched.

Implements Wt::Dbo::SqlStatement.


Generated on Tue Nov 21 2017 for the C++ Web Toolkit (Wt) by doxygen 1.8.11