departset.h

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

#if !defined(AFX_DEPARTSET_H__F346BBF5_1BA8_4839_BE28_E96ABE4E9538__INCLUDED_)
#define AFX_DEPARTSET_H__F346BBF5_1BA8_4839_BE28_E96ABE4E9538__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// DepartSet.h : header file
//

/////////////////////////////////////////////////////////////////////////////
// CDepartSet recordset

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

// Field/Param Data
	//{{AFX_FIELD(CDepartSet, CRecordset)
	long	m_DepartID;
	CString	m_DepartName;
	CString	m_Manager;
	CString	m_Office;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CDepartSet)
	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_DEPARTSET_H__F346BBF5_1BA8_4839_BE28_E96ABE4E9538__INCLUDED_)