myrecordset.cpp

来自「VC++一个数据库的开发」· C++ 代码 · 共 72 行

// MyRecordSet.cpp : implementation file
//

#include "stdafx.h"
#include "ODBC.h"
#include "MyRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyRecordSet

IMPLEMENT_DYNAMIC(CMyRecordSet, CRecordset)

CMyRecordSet::CMyRecordSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMyRecordSet)
	m_stu_id = _T("");
	m_stu_name = _T("");
	m_Chinese = 0;
	m_Math = 0;
	m_English = 0;
	m_total = 0;
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CMyRecordSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=stu_scores");
}

CString CMyRecordSet::GetDefaultSQL()
{
	return _T("[dbo].[scores]");
}

void CMyRecordSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMyRecordSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[stu_id]"), m_stu_id);
	RFX_Text(pFX, _T("[stu_name]"), m_stu_name);
	RFX_Long(pFX, _T("[Chinese]"), m_Chinese);
	RFX_Long(pFX, _T("[Math]"), m_Math);
	RFX_Long(pFX, _T("[English]"), m_English);
	RFX_Long(pFX, _T("[total]"), m_total);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMyRecordSet diagnostics

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

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