/// MySQL statement executor.

{

enum State

{

STMT_INITED,

STMT_COMPILED,

STMT_EXECUTED

};

explicit StatementExecutor(MYSQL* mysql);

/// Creates the StatementExecutor.

~StatementExecutor();

/// Destroys the StatementExecutor.

int state() const;

/// Returns the current state.

void prepare(const std::string& query);

/// Prepares the statement for execution.

void bindParams(MYSQL_BIND* params, std::size_t count);

/// Binds the params.

void bindResult(MYSQL_BIND* result);

/// Binds result.

void execute();

/// Executes the statement.

bool fetch();

/// Fetches the data.

bool fetchColumn(std::size_t n, MYSQL_BIND *bind);

/// Fetches the column.

int getAffectedRowCount() const;

operator MYSQL_STMT* ();

/// Cast operator to native handle type.

StatementExecutor(const StatementExecutor&);

StatementExecutor& operator=(const StatementExecutor&);

MYSQL* _pSessionHandle;

MYSQL_STMT* _pHandle;

int _state;

std::size_t _affectedRowCount;

std::string _query;