dbodbcset.cpp

VC环境下进行ACCESS数据库连接,查询等操作的程序,ODBC方式,适合初学者.

// DbOdbcSet.cpp : implementation of the CDbOdbcSet class
//

#include "stdafx.h"
#include "DbOdbc.h"
#include "DbOdbcSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDbOdbcSet implementation

IMPLEMENT_DYNAMIC(CDbOdbcSet, CRecordset)

CDbOdbcSet::CDbOdbcSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CDbOdbcSet)
	m_EmailAddress = _T("");
	m_City = _T("");
	m_FaxNumber = _T("");
	m_Address = _T("");
	m_AddressID = 0;
	m_Notes = _T("");
	m_WorkPhone = _T("");
	m_WorkExtension = _T("");
	m_Country = _T("");
	m_SendCard = FALSE;
	m_HomePhone = _T("");
	m_FirstName = _T("");
	m_SpouseName = _T("");
	m_StateOrProvince = _T("");
	m_LastName = _T("");
	m_PostalCode = _T("");
	m_nFields = 17;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CDbOdbcSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MyODBC");
}

CString CDbOdbcSet::GetDefaultSQL()
{
	return _T("[地址信息]");
}

void CDbOdbcSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDbOdbcSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[E_mail地址]"), m_EmailAddress);
	RFX_Text(pFX, _T("[城市]"), m_City);
	RFX_Text(pFX, _T("[传真]"), m_FaxNumber);
	RFX_Text(pFX, _T("[地址]"), m_Address);
	RFX_Long(pFX, _T("[地址ID]"), m_AddressID);
	RFX_Text(pFX, _T("[附注]"), m_Notes);
	RFX_Text(pFX, _T("[工作电话]"), m_WorkPhone);
	RFX_Text(pFX, _T("[工作分机]"), m_WorkExtension);
	RFX_Text(pFX, _T("[国家]"), m_Country);
	RFX_Bool(pFX, _T("[寄明信片]"), m_SendCard);
	RFX_Text(pFX, _T("[家庭电话]"), m_HomePhone);
	RFX_Text(pFX, _T("[名字]"), m_FirstName);
	RFX_Text(pFX, _T("[配偶姓名]"), m_SpouseName);
	RFX_Date(pFX, _T("[生日]"), m_Birthdate);
	RFX_Text(pFX, _T("[省份]"), m_StateOrProvince);
	RFX_Text(pFX, _T("[姓氏]"), m_LastName);
	RFX_Text(pFX, _T("[邮编]"), m_PostalCode);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CDbOdbcSet diagnostics

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

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

long CDbOdbcSet::GetMaxID()
{
    //移到最后一条记录
	MoveLast();
	//返回该记录的ID值
	return m_AddressID;
}