sqlinsert.h

应用VC++编的简单的ODBC访问接口。(我已经是会员了! 挖哈哈!!!)

#ifndef CSQLINSERT_H
#define CSQLINSERT_H

#include "SQLBase.h"
#include <string>

class CSQLInsert :public CSQLBase {
public:
   CSQLInsert();
   CSQLInsert( const char* table );
   CSQLInsert( CSQLInsert& o );
   ~CSQLInsert();

   const char* GetStatement();
   bool HasColumns() { return( _columns.length() > 0 ); }
   void SetColumn( const char* columnName, const char* a_chValue, 
      char a_DataType=STRING );
   void SetColumn( const char* columnName, double value );
   void SetColumn( const char* columnName, long value, char a_DataType=CSQLBase::LONG );
   void SetColumn( const char* columnName, int value );
   void SetColumn( const char* columnName, bool isValidTime, int month, int day, int year ); // use CSQLBASE_OLEDATETIME( o ) as 2nd arg

   void ResetContent();
protected:
private:
   std::string _columns;
   std::string _values;
};

#endif