odbcdemo5set.cpp

MFC的Recordset类通过ODBC方式连接数据库

// ODBCDemo5Set.cpp : implementation of the CODBCDemo5Set class
//

#include "stdafx.h"
#include "ODBCDemo5.h"
#include "ODBCDemo5Set.h"

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

/////////////////////////////////////////////////////////////////////////////
// CODBCDemo5Set implementation

IMPLEMENT_DYNAMIC(CODBCDemo5Set, CRecordset)

CODBCDemo5Set::CODBCDemo5Set(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CODBCDemo5Set)
	m___ID = 0;
	m_column1 = 0;
	m_ISBN = _T("");
	m_column2 = 0;
	m_nFields = 4;
	//}}AFX_FIELD_INIT
	m_nParams = 1;
	m_price = 0;
	m_nDefaultType = dynaset;
}

CString CODBCDemo5Set::GetDefaultConnect()
{
	return _T("ODBC;DSN=ODBCDemo1");
}

CString CODBCDemo5Set::GetDefaultSQL()
{
	return _T("[出售信息]");
}

void CODBCDemo5Set::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CODBCDemo5Set)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[图书ID]"), m___ID);
	RFX_Long(pFX, _T("[出售价格]"), m_column1);
	RFX_Text(pFX, _T("[ISBN]"), m_ISBN);
	RFX_Long(pFX, _T("[出售数量]"), m_column2);
	//}}AFX_FIELD_MAP
	pFX->SetFieldType(CFieldExchange::param);
	RFX_Long(pFX, "[出售价格]", m_price);
}

/////////////////////////////////////////////////////////////////////////////
// CODBCDemo5Set diagnostics

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

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