adorecordset.h

封装的ADO访问所有数据库的代码

// DataBase.h: interface for the CDataBase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADORECORDSET_H__A6142D59_66BD_471A_80F7_80141FF0A401__INCLUDED_)
#define AFX_ADORECORDSET_H__A6142D59_66BD_471A_80F7_80141FF0A401__INCLUDED_

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

#include "constant.h"

class DF_EXT_DATAMANAGER CAdoRecordset  
{
public:
		
	CAdoRecordset();

	CAdoRecordset(const _RecordsetPtr& pRs);
	
	CAdoRecordset(LPCTSTR lpszSql,enum CursorTypeEnum cursorType,enum LockTypeEnum lockType,long options);
	
	virtual ~CAdoRecordset();
	
	static void SetServerName(const CString& strServerName);
	static CString GetDataSource();
	
	BOOL InitConnection(_ConnectionPtr& pConn,CString strConnString);
	static void UnInit();
	//以下是对记录集的操作
	BOOL Requery(LPCTSTR lpszFilter=NULL);
	
	BOOL AddNew();

	BOOL Update();

	BOOL BatchUpdate(enum AffectEnum AffectRecords);

	BOOL CancelUpdate();

	BOOL Close();

	BOOL Delete(enum AffectEnum AffectRecords);

	BOOL IsEof();

	BOOL IsBof();

	BOOL MoveFirst();

	BOOL MoveNext();

	BOOL MoveLast();

	BOOL MovePrev();

	LONG GetState();

	FieldsPtr GetFields();

	CAdoRecordset Clone(enum LockTypeEnum lockType);

	void operator =(const _RecordsetPtr& pRs);

	void Copy(CAdoRecordset& set);

	_RecordsetPtr& GetRecordset();

	BOOL Open(LPCTSTR lpszSql,enum CursorTypeEnum cursorType,enum LockTypeEnum lockType,long options,BOOL bFalseNoRecord=FALSE);
	
	_variant_t GetCollect(const _variant_t& Index);
	
	void PutCollect(const _variant_t& Index,const _variant_t& pVar);

	LONG BeginTrans();

	BOOL CommitTrans(LONG nTrans);

	BOOL Rollback(LONG nTrans);

	long GetRowCount();

	_RecordsetPtr ExcuteSql( _bstr_t CommandText, VARIANT * RecordsAffected, long Options );
	
	static CString m_strServerName;
	static CString m_strLoginID;
	static CString m_strLoginPassword;
	static CString m_strRelPath;
	static _ConnectionPtr m_pConnection;
	static BOOL m_bGuest;
private:
	_RecordsetPtr m_pRs;
};

#endif // !defined(AFX_ADORECORDSET_H__A6142D59_66BD_471A_80F7_80141FF0A401__INCLUDED_)