wdb.cpp

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

    if(pFace)
        return pFace->DeleteUser(useinfo);
    return false;
}

/*bool  __stdcall WDB_DelUser (HANDLE pHandle,char *username)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->DeleteUser(username);
    return false;
}*/


bool  __stdcall WDB_ExecSQLCmd(HANDLE pHandle,char * szSQL)
{
bool re=false;
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
//    return S_ExecSQL(pHandle,szSQL);
    if(pFace)
        re = pFace->ExecSQLCmd(szSQL);
    return re;
}


bool  __stdcall WDB_ExecSQL(HANDLE pHandle,char * szSQL,void *callback)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->ExecSQL(szSQL,callback);
    return false;
}


bool  __stdcall WDB_ExecSQLFile(HANDLE pHandle,char * szSQLFile,void *callback)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->ExecSQLFile(szSQLFile,callback);
    return false;
}


bool __stdcall WDB_Query(HANDLE pHandle,char * szSQL)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Query(szSQL);
    return false;
}


int __stdcall  WDB_RecordCount(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->RecordCount();
    return false;
}

bool __stdcall WDB_First(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->First();
    return false;
}

bool __stdcall WDB_Next(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Next();
    return false;
}

char *__stdcall WDB_GetDataValue(HANDLE pHandle,char *szFieldName,int *len)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
    {
        if(len)
            return pFace->GetDataValue(szFieldName,len);
        else
        {
            int mylen;
            return pFace->GetDataValue(szFieldName,&mylen);
        }
    }
    return NULL;
}

int  __stdcall WDB_GetIntValue(HANDLE pHandle,char *szFieldName)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetIntValue(szFieldName);
    return 0;
}

char *__stdcall WDB_GetValueByIdx(HANDLE pHandle,int idx,char *szFieldName,int *len)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetValueByIdx(idx,szFieldName,len);
    return NULL;
}

int  __stdcall WDB_GetIntByIdx(HANDLE pHandle,int idx,char *szFieldName)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetIntByIdx(idx,szFieldName);
    return 0;
}

void  __stdcall WDB_AddSQL(HANDLE pHandle,char *sql)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        pFace->AddSQL(sql);
}

bool   __stdcall WDB_SetParam(HANDLE pHandle,char *parm,char *value,int size,int type)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->SetParam(parm,value,size,type);
    return 0;
}

bool   __stdcall WDB_RunSql(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->RunSql();
    return 0;
}

bool   __stdcall WDB_GetFields(HANDLE pHandle,char *Fields,int *memsize,int *count)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetFields(Fields,memsize,count);
    return 0;
}

bool   __stdcall BeginTrans(HANDLE pHandle,int *outLevel)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->BeginTrans(outLevel);
    return 0;
}

bool   __stdcall Commit(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Commit();
    return 0;
}

bool   __stdcall Rollback(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Rollback();
    return 0;
}

bool   __stdcall LockTables(HANDLE pHandle,char *tables)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->LockTables(tables);
    return 0;
}

bool   __stdcall UnlockTables(HANDLE pHandle,char *tables)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->UnlockTables(tables);
    return 0;
}

bool   __stdcall WDB_Backup(HANDLE pHandle,char *db,char *username,char *password,char *pathname,void *callback)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Backup(db,username,password,pathname,callback);
    return 0;
}

bool   __stdcall WDB_Restore(HANDLE pHandle,char *db,char *username,char *password,char *pathname,void *callback)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->Restore(db,username,password,pathname,callback);
    return 0;
}


char    *__stdcall WDB_GetField(HANDLE pHandle,int idx)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetField(idx);
    return 0;
}

int     __stdcall WDB_FieldCount(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->FieldCount();
    return 0;
}


int     __stdcall WDB_EscapeString(char *from ,char *to ,int fromlen)
{
    return 0;//mysql_escape_string(to,from,fromlen);
}


char*   __stdcall WDB_GetErr(HANDLE pHandle)
{
    CDBFaceBase *pFace = (CDBFaceBase *)pHandle;
    if(pFace)
        return pFace->GetErr();
    return "句柄是空指针";
}



/*
bool GetDSN(char *pDSN,char *pHost)
{
HKEY hKey;
int re;
//char str[120]={0};
char key[1024];
DWORD type,lpcbData=50 ;
    sprintf(key,"Software\\ODBC\\ODBC.ini\\%s",pDSN);
    re=RegOpenKeyEx(HKEY_LOCAL_MACHINE,
            key,0,KEY_ALL_ACCESS,
            &hKey);
    if(re==ERROR_SUCCESS)
    {
        re = RegQueryValueEx(hKey,
                    "Server",
                    NULL,
                    &type,
                    pHost,
                    &lpcbData);
        if(re==ERROR_SUCCESS)
        {
            RegCloseKey(hKey);
            return true;
        }
    }
    RegCloseKey(hKey);
//  return 0;
    //if(str[0]=='1')
    //    return 1;
    return false;
}

*/