adodatabase.h

一个ADO数据库变程的通用类

// ADODatabase.h: interface for the CADOConnection class and the CADORecordset class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_)
#define AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_

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

#pragma warning(disable:4146)  //禁止4146警告
//引入ADO对象动态链接库
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace \
	rename("EOF", "adoEOF") \
	rename("LockTypeEnum", "adoLockTypeEnum") \
	rename("DataTypeEnum", "adoDataTypeEnum") \
	rename("FieldAttributeEnum", "adoFieldAttributeEnum") \
	rename("EditModeEnum", "adoEditModeEnum") \
	rename("RecordStatusEnum", "adoRecordStatusEnum") \
	rename("ParameterDirectionEnum", "adoParameterDirectionEnum") 

#pragma warning(default:4146) //恢复4146警告
//#include <icrsint.h>

class CADORecordset;

//数据库连接类
class CADOConnection  
{
public:
	CADOConnection();
	virtual ~CADOConnection();

public:
	_ConnectionPtr GetConnection();             
	void RollbackTrans();                       //回滚事务处理
	void CommitTrans();                         //提交事务处理
	void BeginTrans();                          //开始事务处理
	CADORecordset* Excute(_bstr_t CommandText); //执行SQL命令
	void Close();                               //关闭连接                             
	BOOL Open(_bstr_t ConnectionString);        //打开连接
	
private:
	_ConnectionPtr m_pConn;                     //连接对象指针
	_bstr_t m_sConnString;		                //连接串
};

//数据库记录集类
class CADORecordset  
{
public:
	CADORecordset();
	virtual ~CADORecordset();

	void Close();             //关闭记录集
	BOOL Open(CString sCommandString, CADOConnection *adoConn); //打开记录集

	//增加、删除、更新记录
	void AddNew();
	void Delete();
	void Update();
	void UpdateBatch();

	//读取或设置字段的值
	_variant_t operator()(_variant_t FieldName);
	void operator()(_variant_t FieldName, _variant_t Val);

	long GetRecordNo();
	long GetRecordCount();

	//记录指针的移动
	void MoveLast();
	void MoveNext();
	void MovePrev();
	void MoveFirst();

public:
	_RecordsetPtr m_pRs;      //记录集对象指针
	_variant_t *FiledValue;
};

#endif // !defined(AFX_ADOCONNECTION_H__B447B981_25C2_4530_839F_80170E09A0F4__INCLUDED_)