niaccessctdb.h

本动态库主要为了根据对数据源操作使用SQL语句了直接嵌入VC过程来实现,可以用在很多数据库种类的基本操作,实现了简单的SQL在外部调用动态库尔嵌入.数据库框架的设计不会影像本动态库的使用.

// NIAccessCTDB.h: interface for the NIAccessCTDB class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_NIACCESSCTDB_H__DC06B9BD_FCA2_4806_A101_946FB60B4E77__INCLUDED_)
#define AFX_NIACCESSCTDB_H__DC06B9BD_FCA2_4806_A101_946FB60B4E77__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include <afxdb.h>
#pragma warning(disable:4786)
#include "ado.h"
#include <vector>
#include <list>
using namespace std;


class AFX_EXT_CLASS NIAccessCTDB:public CObject   
{
public:
	NIAccessCTDB();
	virtual ~NIAccessCTDB();
public:
	typedef vector< CString     >	FIELDPARAM;
	typedef vector< _variant_t  >	RECORDSET;
	typedef vector< RECORDSET*  >	RESULT;

	CADODatabase* m_pDb;

	BOOL	OpenDB(CString strDBPath);
	VOID    CloseDB();
	CADODatabase* GetDB();

	INT     LoadRecord(CADODatabase* pDB,const FIELDPARAM& fp,CString strTblAndCondition,RESULT& result);
	INT		Query(CADODatabase* pDB,const FIELDPARAM& fp, CString strTblAndCondition,RESULT& result);
	INT     RecursionQuery(CADODatabase* pDB,const FIELDPARAM& fp,CString strSQL,RESULT& result);

	BOOL	ModifyRecord(CADODatabase* pDB,const FIELDPARAM& fp,CString strTblAndCondition,RECORDSET& result);
	BOOL    DeleteRecord(CADODatabase* pDB,CString strTblAndCondition);
	BOOL	AddRecord(CADODatabase* pDB,const FIELDPARAM& fp,CString strTblAndCondition,RECORDSET& result);
	_variant_t AddAutoIDRecord(CADODatabase* pDB,const FIELDPARAM& fp,CString strTblAndCondition,CString ID,RECORDSET& result);

	INT    GetRecordCount(CADODatabase* pDB,CString strSQL);
	_variant_t GetFieldValue(CADODatabase* pDB,CString strFieldName,CString strSqlList);

	VOID    HandleError(CDBException& err);

protected:
	CString       strConnection;
};

#endif // !defined(AFX_NIACCESSCTDB_H__DC06B9BD_FCA2_4806_A101_946FB60B4E77__INCLUDED_)