flightset.cpp

利用odbc编程实现以下功能： 航班

// flightset.cpp : implementation file
//

#include "stdafx.h"
#include "dbexe.h"
#include "flightset.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cflightset

IMPLEMENT_DYNAMIC(Cflightset, CRecordset)

Cflightset::Cflightset(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(Cflightset)
	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 Cflightset::GetDefaultConnect()
{
	return _T("ODBC;DSN=database1");
}

CString Cflightset::GetDefaultSQL()
{
	return _T("[flights]");
}

void Cflightset::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(Cflightset)
	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
}

/////////////////////////////////////////////////////////////////////////////
// Cflightset diagnostics

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

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