sqlbasewhere.h

简单的ODBC访问接口

#ifndef _SQLBASEWHERE_H__
#define _SQLBASEWHERE_H__

#include "SQLBase.h"

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CSQLBaseWhere : public CSQLBase
{
public:
	CSQLBaseWhere();
	virtual ~CSQLBaseWhere();

   void SetWhere( const char* a_szWhere );
   void SetWhereOr( const char* a_szWhere );
   void SetWhere( const char* columnName, int value );
   void SetWhere( const char* columnName, long value, char a_DataType=LONG );
   void SetWhere( const char* columnName, double value );
   void SetWhere( const char* columnName, bool isValidTime, int month, int day, int year );
   void SetWhere( const char* columnName, const char* value, char a_DataType=STRING, bool a_bUseLike=false );
   const char* GetWhere() { return _where.c_str(); }
   const char* GetStatement();
   void ResetContent();
protected:
   std::string _where;
   std::string _temp;
};

#endif // !defined _SQLBASEWHERE_H__