mydbset.h

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

// mydbSet.h : interface of the CMydbSet class
//
/////////////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYDBSET_H__C1CFE235_B563_4C44_9457_3BB6E0DF215D__INCLUDED_)
#define AFX_MYDBSET_H__C1CFE235_B563_4C44_9457_3BB6E0DF215D__INCLUDED_

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

class CMydbSet : public CRecordset
{
public:
	CMydbSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CMydbSet)

// Field/Param Data
	//{{AFX_FIELD(CMydbSet, CRecordset)
	CString	m_EmployeeID;
	CString	m_EmployeeName;
	CString	m_Birthday;
	CString	m_HomeTele;
	CString	m_DDepartID;
	CString	m_EDepartID;
	CString	m_Salary;
	CString	m_DepartName;
	CString	m_Manager;
	CString	m_Office;
	//}}AFX_FIELD
	CString	m_DepartNameParam;

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CMydbSet)
	public:
	virtual CString GetDefaultConnect();	// Default connection string
	virtual CString GetDefaultSQL(); 	// default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);	// RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif

};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_MYDBSET_H__C1CFE235_B563_4C44_9457_3BB6E0DF215D__INCLUDED_)