Version: 1.0.0
mysql_preparedstatement.h
Go to the documentation of this file.
1 #ifndef _WX_DATABASE_MYSQL_PREPARED_STATEMENT_H_
2 #define _WX_DATABASE_MYSQL_PREPARED_STATEMENT_H_
3 
4 #include "wx/database/wxprec.h"
6 
8 
9 WX_DEFINE_ARRAY_PTR(wxMysqlPreparedStatementWrapper*, MysqlStatementWrapperArray);
10 
12 {
13 public:
14  // ctor
16  wxMysqlPreparedStatement(wxMysqlDynamicInterface* pInterface, MYSQL_STMT* pStatement);
17 
18  // dtor
19  virtual ~wxMysqlPreparedStatement();
20 
21  virtual void Close();
22 
23  void AddPreparedStatement(MYSQL_STMT* pStatement);
24 
25  // get field
26  virtual void SetParamInt(int nPosition, int nValue);
27  virtual void SetParamDouble(int nPosition, double dblValue);
28  virtual void SetParamString(int nPosition, const wxString& strValue);
29  virtual void SetParamNull(int nPosition);
30  virtual void SetParamBlob(int nPosition, const void* pData, long nDataLength);
31  virtual void SetParamDate(int nPosition, const wxDateTime& dateValue);
32  virtual void SetParamBool(int nPosition, bool bValue);
33  virtual int GetParameterCount();
34 
35  virtual int RunQuery();
37 
38 private:
39  int FindStatementAndAdjustPositionIndex(int* pPosition);
40 
42  MysqlStatementWrapperArray m_Statements;
43 };
44 
45 #endif//_WX_DATABASE_MYSQL_PREPARED_STATEMENT_H_
46 
virtual int GetParameterCount()
virtual void SetParamString(int nPosition, const wxString &strValue)
Set the parameter at the 1-based position to a wxString value.
virtual void SetParamNull(int nPosition)
Set the parameter at the 1-based position to a NULL value.
virtual void SetParamDate(int nPosition, const wxDateTime &dateValue)
Set the parameter at the 1-based position to a wxDateTime value.
virtual int RunQuery()
Run an insert, update, or delete query on the database.
WX_DEFINE_ARRAY_PTR(wxMysqlPreparedStatementWrapper *, MysqlStatementWrapperArray)
virtual void Close()
Close the result set (call wxDatabase::ClosePreparedStatement() instead on the statement)
virtual ~wxMysqlPreparedStatement()
virtual void SetParamBool(int nPosition, bool bValue)
Set the parameter at the 1-based position to a boolean value.
wxMysqlDynamicInterface * m_pInterface
virtual void SetParamInt(int nPosition, int nValue)
Set the parameter at the 1-based position to an int value.
void AddPreparedStatement(MYSQL_STMT *pStatement)
int FindStatementAndAdjustPositionIndex(int *pPosition)
MysqlStatementWrapperArray m_Statements
virtual void SetParamBlob(int nPosition, const void *pData, long nDataLength)
Set the parameter at the 1-based position to a Blob value.
wxMysqlPreparedStatement(wxMysqlDynamicInterface *pInterface)
virtual wxDatabaseResultSet * RunQueryWithResults()
Run an insert, update, or delete query on the database.
virtual void SetParamDouble(int nPosition, double dblValue)
Set the parameter at the 1-based position to a double value.