dbbaseclass.h.bak

ADO写的数据库接口,CB 6 编译通过

//---------------------------------------------------------------------------

#ifndef dbbaseclassH
#define dbbaseclassH
//---------------------------------------------------------------------------
#define AS_STRING 0
#define AS_BLOB   1
#define AS_INT    2

#pragma pack(1)
typedef struct USER_INFO
{
	char szHost[128];    //用户登陆主机
    char szUser[32];     // 用户名
//    char szDBName[128];      // 用户允许连接的数据库。空表示没有限制数据库的连接
    char szPassword[32]; //用户口令
}USER_INFO;
#pragma pack()

class CDBFaceBase
{
public:
    virtual bool  SetDirver (char * szAttributes);
    
    virtual bool  CreateDSN (char * szAttributes);
    virtual bool  CreateDB (char * szDBName);
    virtual bool  ConnectDB (char *szDSN,char *szUser,char *szPassWord);
    virtual bool  SetDBName (char *szDBName){return false;};
    virtual bool  GetDBName(char *szName){return false;};
    virtual bool  CloseDB ();
    virtual bool  GetAllDB (char * szDBName,int iSize);
    virtual bool  GetAllDSN (char * szDBDSN,int iSize);
    virtual bool  GetAllUser (char * szUser,int iSize);
    virtual bool  SetUserRole (USER_INFO *useinfo,char *szDBName);
    virtual bool  DeleteUser (USER_INFO *szUser);
    virtual bool  DeleteUser (char *username);
    virtual bool  ExecSQL(char * szSQL);

    virtual bool  SetQuery(int idx);
    virtual bool  Query(char * szSQL){return false;};
    virtual int   RecordCount(){return false;};
    virtual bool  First(){return false;};
    virtual bool  Next(){return false;};
    virtual char *GetDataValue(char *szFieldName,int *len=0){return 0;};
    virtual int   GetIntValue(char *szFieldName){return 0;};
    virtual void  AddSQL(char *sql);
    virtual int   SetParam(char *parm,char *value,int size=0,int type=0);
    virtual int   RunSql();
    virtual int   Backup(char *db,char *username,char *password,char *pathname);
    virtual int   Restore(char *db,char *username,char *password,char *pathname);
};
#endif