dbset.cpp

SQL和MFC实现的 订票服务系统,属于简单型,适合学生应付老师检查,原创

// dbSet.cpp : implementation of the CDbSet class
//

#include "stdafx.h"
#include "db.h"
#include "dbSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDbSet implementation

IMPLEMENT_DYNAMIC(CDbSet, CRecordset)

CDbSet::CDbSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CDbSet)
	m_flightNum = _T("");
	m_price = 0;
	m_numSeats = 0;
	m_numAvail = 0;
	m_FromCity = _T("");
	m_ArivCity = _T("");
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CDbSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=mydb");
}

CString CDbSet::GetDefaultSQL()
{
	return _T("[dbo].[FLIGHTS]");
}

void CDbSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDbSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[flightNum]"), m_flightNum);
	RFX_Long(pFX, _T("[price]"), m_price);
	RFX_Long(pFX, _T("[numSeats]"), m_numSeats);
	RFX_Long(pFX, _T("[numAvail]"), m_numAvail);
	RFX_Text(pFX, _T("[FromCity]"), m_FromCity);
	RFX_Text(pFX, _T("[ArivCity]"), m_ArivCity);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CDbSet diagnostics

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

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