datasource.h

数据库连接访问显示、增加删除更新记录、打开上一条下一条记录

// DataSource.h: interface for the CDataSource class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DATASOURCE_H__D9AF887D_7150_4CE7_84E2_8E4683118F46__INCLUDED_)
#define AFX_DATASOURCE_H__D9AF887D_7150_4CE7_84E2_8E4683118F46__INCLUDED_
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","EndOfFile")


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

class CDataSource  
{
public:
    BOOL IsEOF();
	BOOL IsBOF();
	void Delete();//删除当前记录
	void SetAsInteger(CString FieldName,int Value);
	void SetAsString(CString FieldName,CString Value);
	void Update();
	void New(CString Number,CString Class );//新增一条记录
	int GetAsInteger(CString FieldName);
	CString GetAsString(CString FieldName);
	BOOL IsLast();
	BOOL IsFirst();
	void MoveFirst();
	void MoveNext();
	void MoveLast();
    void MovePrev();
	void InitData();
	CDataSource();
	virtual ~CDataSource();
private:
	//int m_MaxID;
	_RecordsetPtr m_pRecordset;

	_ConnectionPtr m_pConn;
	void FreeData();

};

#endif // !defined(AFX_DATASOURCE_H__D9AF887D_7150_4CE7_84E2_8E4683118F46__INCLUDED_)