#ifndef _DBAPI_H_
#define _DBAPI_H_
//
typedef struct _tagFileUseCount
{
char szFileName[MAX_PATH];
int nUseCount;
}FILE_USE_COUNT, *LPFILE_USE_COUNT;#define MAX_DB_FILE 256static FILE_USE_COUNT FileUseCount[MAX_DB_FILE] = {0};typedef struct _tagDBHandle
{
char szFileName[MAX_PATH];
int nDatabaseType;
_ConnectionPtr pConnection;
}DB_HANDLE, *LPDB_HANDLE;typedef struct _tagTableHandle
{
char szTableName[MAX_PATH];
_RecordsetPtr pRocordset;
LONG lRecordCount;
FieldsPtr pFields;
LONG lFieldCount;
LONG lCurRecordPos;
}TABLE_HANDLE, *LPTABLE_HANDLE;
typedef struct _tagSQLRemote
{
char szIP[16];
char szName[64];
char szPassword[64];
}SQL_REMOTE, *LPSQL_REMOTE;inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
DWORD WINAPI OpenDatabase(char * szFileName,
char * szPassword,
int nDatabaseType,
HANDLE * hDatabase,
LPVOID pVoid);DWORD WINAPI CloseDatabase(HANDLE hDatabase);DWORD WINAPI CompressDatabase(HANDLE hDatabase);DWORD WINAPI GetTableHand(HANDLE hDatabase,
char * szTableName,
HANDLE * hTableHandle);DWORD WINAPI ReleaseTableHandle(HANDLE hTableHandle);DWORD WINAPI OpenSql( HANDLE hDatabase,
char * szSQL,
HANDLE * hTableHandle);DWORD WINAPI GetRecordCountEx(HANDLE hTableHandle,
LONG * lCount);DWORD WINAPI GetFieldName (HANDLE hTableHandle,
LONG lIndex,
char * strFieldName);DWORD WINAPI GetFieldCount(HANDLE hTableHandle,
LONG *lCount);DWORD WINAPI GetFieldValue(HANDLE hTableHandle,
LONG lFieldIndex,
LONG lIndex,
VOID* pValue,
DWORD* pdwValueLen);DWORD WINAPI SetFieldValue(HANDLE hTableHandle,
LONG lFieldIndex,
LONG lIndex,
VOID* pValue,
DWORD* pdwValueLen);DWORD WINAPI DeleteRecord(HANDLE hTableHandle,
LONG lIndex);DWORD WINAPI AppendRecord( HANDLE hTableHandle,
void* pCondition);DWORD WINAPI DeviceIDToIndex(HANDLE hTableHandle, DWORD dwDeviceID, LONG * pnIndex);DWORD WINAPI UpdateTable(HANDLE hTableHandle);DWORD WINAPI ChangePassword(char * pszFileName, char * pszOldPassword, char * pszNewPassword);DWORD WINAPI AppendField(HANDLE hDatabase, char * pszTableName, char * pszFieldName, int nType, int nDefinedSize);#endif //_DBAPI_H_
#define _DBAPI_H_
//
typedef struct _tagFileUseCount
{
char szFileName[MAX_PATH];
int nUseCount;
}FILE_USE_COUNT, *LPFILE_USE_COUNT;#define MAX_DB_FILE 256static FILE_USE_COUNT FileUseCount[MAX_DB_FILE] = {0};typedef struct _tagDBHandle
{
char szFileName[MAX_PATH];
int nDatabaseType;
_ConnectionPtr pConnection;
}DB_HANDLE, *LPDB_HANDLE;typedef struct _tagTableHandle
{
char szTableName[MAX_PATH];
_RecordsetPtr pRocordset;
LONG lRecordCount;
FieldsPtr pFields;
LONG lFieldCount;
LONG lCurRecordPos;
}TABLE_HANDLE, *LPTABLE_HANDLE;
typedef struct _tagSQLRemote
{
char szIP[16];
char szName[64];
char szPassword[64];
}SQL_REMOTE, *LPSQL_REMOTE;inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
DWORD WINAPI OpenDatabase(char * szFileName,
char * szPassword,
int nDatabaseType,
HANDLE * hDatabase,
LPVOID pVoid);DWORD WINAPI CloseDatabase(HANDLE hDatabase);DWORD WINAPI CompressDatabase(HANDLE hDatabase);DWORD WINAPI GetTableHand(HANDLE hDatabase,
char * szTableName,
HANDLE * hTableHandle);DWORD WINAPI ReleaseTableHandle(HANDLE hTableHandle);DWORD WINAPI OpenSql( HANDLE hDatabase,
char * szSQL,
HANDLE * hTableHandle);DWORD WINAPI GetRecordCountEx(HANDLE hTableHandle,
LONG * lCount);DWORD WINAPI GetFieldName (HANDLE hTableHandle,
LONG lIndex,
char * strFieldName);DWORD WINAPI GetFieldCount(HANDLE hTableHandle,
LONG *lCount);DWORD WINAPI GetFieldValue(HANDLE hTableHandle,
LONG lFieldIndex,
LONG lIndex,
VOID* pValue,
DWORD* pdwValueLen);DWORD WINAPI SetFieldValue(HANDLE hTableHandle,
LONG lFieldIndex,
LONG lIndex,
VOID* pValue,
DWORD* pdwValueLen);DWORD WINAPI DeleteRecord(HANDLE hTableHandle,
LONG lIndex);DWORD WINAPI AppendRecord( HANDLE hTableHandle,
void* pCondition);DWORD WINAPI DeviceIDToIndex(HANDLE hTableHandle, DWORD dwDeviceID, LONG * pnIndex);DWORD WINAPI UpdateTable(HANDLE hTableHandle);DWORD WINAPI ChangePassword(char * pszFileName, char * pszOldPassword, char * pszNewPassword);DWORD WINAPI AppendField(HANDLE hDatabase, char * pszTableName, char * pszFieldName, int nType, int nDefinedSize);#endif //_DBAPI_H_
如
class xxxx
{
private:
Handle m_Hdatabase;
public:
xxxx():m_Hdatabase(NULL){}
OpenDatabase(.......){}
CloseDatabase()
{
if(Hdatabase)
{
//调用API
}
}
};
class A
{
static DWORD WINAPI GetRecordCountEx();
}
调用得时候可以A::GetRecordCountEx();