prepared_statement.h

Go to the documentation of this file.

#ifndef _WX_DATABASE_PREPARED_STATEMENT_H_
#define _WX_DATABASE_PREPARED_STATEMENT_H_

#include "wx/database/wxprec.h"

WX_DECLARE_HASH_SET( wxDatabaseResultSet*, wxPointerHash, wxPointerEqual, StatementResultSetHashSet );

class WXDLLIMPEXP_DATABASE wxPreparedStatement : public wxDatabaseErrorReporter, public wxDatabaseStringConverter
{
public:
  wxPreparedStatement();

  virtual ~wxPreparedStatement();

  virtual void Close() = 0;
  
  // set parameters
  virtual void SetParamInt(int nPosition, int nValue) = 0;
  virtual void SetParamDouble(int nPosition, double dblValue) = 0;
  virtual void SetParamString(int nPosition, const wxString& strValue) = 0;
  virtual void SetParamNull(int nPosition) = 0;
  virtual void SetParamBlob(int nPosition, const wxMemoryBuffer& buffer);
  virtual void SetParamBlob(int nPosition, const void* pData, long nDataLength) = 0;
  virtual void SetParamDate(int nPosition, const wxDateTime& dateValue) = 0;
  virtual void SetParamBool(int nPosition, bool bValue) = 0;
  virtual int GetParameterCount() = 0;
  
  virtual int RunQuery() = 0;
  virtual wxDatabaseResultSet* RunQueryWithResults() = 0;

  // function names more consistent with JDBC and wxSQLite3
  // these just provide wrappers for existing functions
  int ExecuteUpdate() { return RunQuery(); } 
  wxDatabaseResultSet* ExecuteQuery() { return RunQueryWithResults(); }

  virtual bool CloseResultSet(wxDatabaseResultSet* pResultSet);

protected:
  void CloseResultSets();
  void LogResultSetForCleanup(wxDatabaseResultSet* pResultSet) { m_ResultSets.insert(pResultSet); }
  
private:
  StatementResultSetHashSet m_ResultSets;
};

#endif//_WX_DATABASE_PREPARED_STATEMENT_H_