database.h

通信BOSS计费方面的服务器源码,有很多经典的创意,值得借鉴,在UNIX上运行.

#ifndef __DATABASE_H

#define __DATABASE_H

#include "SupTempl.h"

#include <string.h>



#define MAX_SQL_LEN 1024

#ifndef BOOL

	#define BOOL int

#endif

#ifndef TRUE

	#define TRUE 1

#endif

#ifndef FALSE

	#define FALSE 0

#endif



#define MAX_COLUMN			100

#define MAX_COLSIZE			100



typedef class CDatabase CDatabase;

class CDatabase

{

protected:

	SupArrayT<char*> Data;

	SupListT<char*> DataList;

	char UserName[32];

	char Password[32];

	char Server[32];

	char DbName[16];

	char AppName[32];

	char HostName[16];

public:

	BOOL isConnected;

	int ErrNo;

	char ErrText[256];

	long Rows;

	long Cols;

	char CmdBuf[MAX_SQL_LEN];

	CDatabase();

	CDatabase(char *pUser,char *pPass,char *pServer,char *pDb,char *pApp,char *pHost);

	~CDatabase();

	BOOL SetProps(char *Name,char *Value);

	char* GetProps(char *Name);

	char** GetData();

	virtual BOOL Connect(){return FALSE;}

	virtual BOOL DisConnect(){return FALSE;}

	virtual BOOL Execute(char *pSql){return FALSE;}

	virtual BOOL Open(char *pSql){return FALSE;}

	virtual BOOL BeginTran(){return FALSE;}

	virtual BOOL Commit(){return FALSE;}

	virtual BOOL Rollback(){return FALSE;}

};

#endif //__DATABASE_H