ctlibadapter.h

封装基于ctlib的sybase数据库的接口

/**
 * CTLIBAdapter.h
 * author: 林朗
 * 封装使用CTLIB操作sybase数据库的功能。
*/
#ifndef _CTLIBADAPTER_H
#define _CTLIBADAPTER_H

#include <ctpublic.h>
#include "DbAdapter.h"
#include "DbPool.h"

#define CTLIB_VERSION	CS_VERSION_110
#define CTLIB_LOGIN_TIMEOUT	60

typedef struct
{
	CS_CONNECTION *conn;
	CS_SMALLINT indicator[MAX_COLUNNS];
}CTL_Connect_t;

typedef struct
{
	CS_COMMAND *stmt;
	CS_SMALLINT *indicator;
}CTL_Statement_t;

class CCTLIBAdapter : public CDbAdapter
{
public:
	CCTLIBAdapter(CDbPool *pool);
	virtual ~CCTLIBAdapter();

	virtual bool init(DbInit_t *init);

	virtual void* newConnect(DbInfo_t *info);
	virtual void closeConnect(void *con);
	virtual bool testConnect(void *con, int timeout=0);
	virtual void* newStatement(void *con);
	virtual void closeStatement(void *stmt);

	virtual bool Query(void *stmt, char *sql, DbField_t *record, DbDesc_t *desc, int *cols, int timeout=0);
	virtual bool Next(void *stmt, DbField_t *record, int cols);
	virtual int Execute(void *stmt, char *sql, int timeout=0, int row=0);
	//procname的格式为 dbo.proc
	virtual int Procedure(void *stmt, char *procname, DbProc_t *params, int nparam, int timeout=0);

	virtual DB_TYPE DbType(int type);
	virtual int DbType(DB_TYPE type);

private:
	void release();
	int execute(void *stmt, char *sql, int timeout);

	CDbPool *m_pPool;
	CS_CONTEXT *m_pContext;
};

#endif