mydbset.cpp

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

// mydbSet.cpp : implementation of the CMydbSet class
//

#include "stdafx.h"
#include "mydb.h"
#include "mydbSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMydbSet implementation

IMPLEMENT_DYNAMIC(CMydbSet, CRecordset)

CMydbSet::CMydbSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMydbSet)
	m_EmployeeID = _T("");
	m_EmployeeName = _T("");
	m_Birthday = _T("");
	m_HomeTele = _T("");
	m_DDepartID = _T("");
	m_EDepartID = _T("");
	//m_Salary = _T("");
	m_Salary = _T("");
	m_DepartName = _T("");
	m_Manager = _T("");
	m_Office = _T("");
	m_nFields =10;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
	m_nParams=1;
	//m_DepartNameParam=" ";
}

CString CMydbSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MS Access Database");
}

CString CMydbSet::GetDefaultSQL()
{
	return "Employee,Department";
}

void CMydbSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMydbSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[EmployeeID]"), m_EmployeeID);
	RFX_Text(pFX, _T("[EmployeeName]"), m_EmployeeName);
	RFX_Text(pFX, _T("[Birthday]"), m_Birthday);
	RFX_Text(pFX, _T("[HomeTele]"), m_HomeTele);
	RFX_Text(pFX,"Department.DepartID", m_DDepartID);
	RFX_Text(pFX,"Employee.DepartID", m_EDepartID);
	RFX_Text(pFX, _T("[Salary]"), m_Salary);
	RFX_Text(pFX, _T("[DepartName]"), m_DepartName);
	RFX_Text(pFX, _T("[Manager]"), m_Manager);
	RFX_Text(pFX, _T("[Office]"), m_Office);
	//}}AFX_FIELD_MAP
	pFX->SetFieldType(CFieldExchange::param);
	RFX_Text(pFX,"DepartNameParam",m_DepartNameParam);
}

/////////////////////////////////////////////////////////////////////////////
// CMydbSet diagnostics

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

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