bookset.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// BookSet.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "BookSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookSet

IMPLEMENT_DYNAMIC(CBookSet, CRecordset)

CBookSet::CBookSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBookSet)
	m_BOOK_ID = 0;
	m_BOOK_NAME = _T("");
	m_BOOK_AUTHOR = _T("");
	m_BOOK_STATE = 0;
	m_BOOK_COURSE_ID = 0;
	m_BOOK_QUANTITY = 0;
	m_BOOK_PRICE = 0.0;
	m_nFields = 7;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBookSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=Train");
}

CString CBookSet::GetDefaultSQL()
{
	return _T("[BOOK]");
}

void CBookSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBookSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Int(pFX, _T("[BOOK_ID]"), m_BOOK_ID);
	RFX_Text(pFX, _T("[BOOK_NAME]"), m_BOOK_NAME);
	RFX_Text(pFX, _T("[BOOK_AUTHOR]"), m_BOOK_AUTHOR);
	RFX_Byte(pFX, _T("[BOOK_STATE]"), m_BOOK_STATE);
	RFX_Int(pFX, _T("[BOOK_COURSE_ID]"), m_BOOK_COURSE_ID);
	RFX_Int(pFX, _T("[BOOK_QUANTITY]"), m_BOOK_QUANTITY);
	RFX_Double(pFX, _T("[BOOK_PRICE]"), m_BOOK_PRICE);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBookSet diagnostics

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

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