adodatabase.h

难得的数据库基础及应用程序

// ADOConn.h: interface for the CADOConn class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADODATABASE_H__C4B5D43B_4074_4B05_86FE_083A0C7E3C27__INCLUDED_)
#define AFX_ADODATABASE_H__C4B5D43B_4074_4B05_86FE_083A0C7E3C27__INCLUDED_

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

#pragma warning(disable: 4146)  // Q231931 

#import "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) 

class CADORecordset;

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

public:
	BOOL Open(_bstr_t ConnectionString);	//打开连接
	void Close();							//关闭连接

	CADORecordset* Execute(_bstr_t CommandText);	    //执行SQL命令

	void BeginTrans();						//开始事务处理
	void CommitTrans();						//提交事务处理
	void RollbackTrans();					//回滚事务处理

	_ConnectionPtr GetConnection();

private:
	_ConnectionPtr m_pConn;					//连接对象指针
	_bstr_t m_sConnString;					//连接串
};

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

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

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

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

public:
	long GetRecordCount();    // 获取记录数
	long GetRecordNo();       // 获取当前记录号

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

public:
	//void operator =(CString sFieldName, _variant_t vVal);

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

#endif // !defined(AFX_ADODATABASE_H__C4B5D43B_4074_4B05_86FE_083A0C7E3C27__INCLUDED_)