mysql_preparedstatement_parameter.h

Go to the documentation of this file.

#ifndef _WX_DATABASE_MYSQL_PREPARED_STATEMENT_PARAMETER_H_
#define _WX_DATABASE_MYSQL_PREPARED_STATEMENT_PARAMETER_H_

#include "wx/database/wxprec.h"

typedef struct bind_data {
  wxString strValue;
  int nValue;
  double dblValue;
  MYSQL_TIME dateValue;
  bool bValue;
  wxMemoryBuffer bufferValue;
  wxCharBuffer charBufferValue;
  unsigned long nBufferLength;
} MysqlBindData;

class wxMysqlPreparedStatementParameter : public wxDatabaseErrorReporter, public wxDatabaseStringConverter
{
public:
  // ctor
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind);  // Default to NULL
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, const wxString& strValue);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, int nValue);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, double dblValue);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, const void* pData, long nDataLength);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, const wxDateTime& dateValue);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, bool bValue);
  wxMysqlPreparedStatementParameter(MYSQL_BIND* pBind, MYSQL_FIELD* pField);

  // dtor
  virtual ~wxMysqlPreparedStatementParameter();
  
  MYSQL_BIND* GetMysqlBind() { return m_pBind; }
  MysqlBindData* GetBindData() { return &m_Data; }

  void SetInt(int nValue);
  void SetDouble(double dblValue);
  void SetString(const wxString& strValue);
  void SetNull();
  void SetBlob(const void* pData, long nDataLength);
  void SetDate(const wxDateTime& dateValue);
  void SetBool(bool bValue);

  void ClearBuffer();
private:
  MYSQL_BIND* m_pBind;
  MysqlBindData m_Data;
  my_bool m_bIsNull;
};

#endif//_WX_DATABASE_MYSQL_PREPARED_STATEMENT_PARAMETER_H_