testodbc4set.cpp

使用ODBC访问SQL数据库

// testODBC4Set.cpp : implementation of the CTestODBC4Set class
//

#include "stdafx.h"
#include "testODBC4.h"
#include "testODBC4Set.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTestODBC4Set implementation

IMPLEMENT_DYNAMIC(CTestODBC4Set, CRecordset)

CTestODBC4Set::CTestODBC4Set(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CTestODBC4Set)
	m_id = 0;
	m_name = _T("");
	m_sex = _T("");
	m_age = _T("");
	m_grade = _T("");
	m_class = _T("");
	m_adress = _T("");
	
	m_math = 0.0;
	m_physics = 0.0;
	m_english = 0.0;
	m_politics = 0.0;

	m_more = _T("");
	m_nFields = 12;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CTestODBC4Set::GetDefaultConnect()
{
	return _T("ODBC;DSN=czc");
}

CString CTestODBC4Set::GetDefaultSQL()
{
	return _T("[dbo].[czc_table1]");
}

void CTestODBC4Set::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CTestODBC4Set)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[id]"), m_id);
	RFX_Text(pFX, _T("[name]"), m_name);
	RFX_Text(pFX, _T("[sex]"), m_sex);
	RFX_Text(pFX, _T("[age]"), m_age);
	RFX_Text(pFX, _T("[grade]"), m_grade);
	RFX_Text(pFX, _T("[class]"), m_class);
	RFX_Text(pFX, _T("[adress]"), m_adress);

	RFX_Double(pFX, _T("[math]"), m_math);
	RFX_Double(pFX, _T("[physics]"), m_physics);
	RFX_Double(pFX, _T("[english]"), m_english);
	RFX_Double(pFX, _T("[politics]"), m_politics);
	RFX_Text(pFX, _T("[more]"), m_more);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CTestODBC4Set diagnostics

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

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