publishset.cpp

一个简单的用ADO方式连接Aceess数据库程序.

// PublishSet.cpp : implementation of the CPublishSet class
//

#include "stdafx.h"
#include "Publish.h"
#include "PublishSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CPublishSet implementation

IMPLEMENT_DYNAMIC(CPublishSet, CRecordset)

CPublishSet::CPublishSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CPublishSet)
	m___ID = 0;
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = 0.0;
	m_nFields = 4;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CPublishSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=Publish");
}

CString CPublishSet::GetDefaultSQL()
{
	return _T("[table1]");
}

void CPublishSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CPublishSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[书籍ID]"), m___ID);
	RFX_Text(pFX, _T("[作者]"), m_column1);
	RFX_Text(pFX, _T("[出版社]"), m_column2);
	RFX_Double(pFX, _T("[价格]"), m_column3);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CPublishSet diagnostics

#ifdef _DEBUG
void CPublishSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CPublishSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG

long CPublishSet::GetMaxID()
{
	MoveLast();//
	return m___ID;//
}