departset.cpp

这个小例子可以查询雇员的平均工资和基本信息

// DepartSet.cpp : implementation file
//

#include "stdafx.h"
#include "mydb.h"
#include "DepartSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDepartSet

IMPLEMENT_DYNAMIC(CDepartSet, CRecordset)

CDepartSet::CDepartSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CDepartSet)
	m_DepartID = 0;
	m_DepartName = _T("");
	m_Manager = _T("");
	m_Office = _T("");
	m_nFields = 4;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CDepartSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=guyuan");
}

CString CDepartSet::GetDefaultSQL()
{
	return _T("[Department]");
}

void CDepartSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDepartSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[DepartID]"), m_DepartID);
	RFX_Text(pFX, _T("[DepartName]"), m_DepartName);
	RFX_Text(pFX, _T("[Manager]"), m_Manager);
	RFX_Text(pFX, _T("[Office]"), m_Office);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CDepartSet diagnostics

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

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