hadodatabase.h

通过ADO访问数据库的方法的封装类的实现文件,以某数据可为例子访问

// HADODatabase.h: interface for the CADODatabase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_HADODATABASE_H__37B1756C_FE5D_4F9C_B989_FDC0ACF3F54E__INCLUDED_)
#define AFX_HADODATABASE_H__37B1756C_FE5D_4F9C_B989_FDC0ACF3F54E__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
//>>>>>>>>>>>>>>>>>>>>>>>>
#include "comdef.h"
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \
   no_namespace \
   rename("EOF","ISEOF")
//<<<<<<<<<<<<<<<<<<<<<<<<<

class CADODatabase  
{
protected:
    _ConnectionPtr m_pCon;
	//数据源名称：
	LPCTSTR m_ConnectionName;
	//数据库是否被打开的标记：
	BOOL m_bOpened;
	//SQL查询语句：
	CString m_SQL;
public:

	BOOL RollBackTrans();
	BOOL CommitTrans();
	BOOL BeginTrans();
	BOOL Execute(LPCTSTR lpszSQL);
	BOOL IsOpen();
	BOOL Close();
	BOOL Open(LPCTSTR lpszName);
	CADODatabase();
	virtual ~CADODatabase();
	friend class CADORecordset;
};


class CADORecordset  
{
public:
	BOOL MoveNext();
	long GetPageCount();
	long GetPageSize();
	void SetPageSize(long psz);
	BOOL AddNew();
	long GetMaxRecords();
	BOOL Save(LPCTSTR fn);
	BOOL DeleteField(long index);
	BOOL Delete();
	BOOL MovePrevious();
	BOOL ReQuery();
	BOOL CancelUpdate();
	BOOL Update();
	BOOL IsBOF();
	BOOL MoveLast();
	BOOL Move(long disp);
	BOOL MoveFirst();
	BOOL Close();
	BOOL SetFieldValue(long index,_variant_t var);
	_variant_t GetFieldValue(long index);
	long GetFieldCount();
	CString GetFieldName(long index);
	BOOL IsEOF();
	BOOL IsOpen();
	BOOL Open(LPCTSTR lpszSQL);
	CADORecordset();
	virtual ~CADORecordset();
	CADODatabase * m_pDatabase;
protected:
	BOOL m_Opened;
	_RecordsetPtr m_set;
};

#endif // !defined(AFX_HADODATABASE_H__37B1756C_FE5D_4F9C_B989_FDC0ACF3F54E__INCLUDED_)