studatabaseset.cpp

用VC实现的与ACCESS数据库连接的计算机培训学校信息管理系统

// stuDataBaseSet.cpp : implementation of the CStuDataBaseSet class
//

#include "stdafx.h"
#include "stuDataBase.h"
#include "stuDataBaseSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStuDataBaseSet implementation

IMPLEMENT_DYNAMIC(CStuDataBaseSet, CRecordset)

CStuDataBaseSet::CStuDataBaseSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CStuDataBaseSet)
	m_stuNO = _T("");
	m_stuName = _T("");
	m_stuHome = _T("");
	m_stuSex = FALSE;
	m_stuAge = 0;
	m_stuAdress = _T("");
	m_stuPostcode = 0;
	m_stuPhone = _T("");
	m_stuID = _T("");
	m_stuEmail = _T("");
	m_stuOrg = _T("");
	m_stuPosition = _T("");
	m_stuSkill = _T("");
	m_stuToolNum = 0;
	m_stuDorm = _T("");
	m_stuDirection = _T("");
	m_stuDataTime = 0;
	m_SCName = _T("");
	m_SCRequire = _T("");
	m_SCTeacher = _T("");
	m_SCTerm = 0;
	m_SCCost = _T("");
	m_stuRemark = _T("");
	m_nFields = 24;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CStuDataBaseSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=DataBase For Student");
}

CString CStuDataBaseSet::GetDefaultSQL()
{
	return _T("[student]");
}

void CStuDataBaseSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CStuDataBaseSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[stuNO]"), m_stuNO);
	RFX_Text(pFX, _T("[stuName]"), m_stuName);
	RFX_Text(pFX, _T("[stuHome]"), m_stuHome);
	RFX_Bool(pFX, _T("[stuSex]"), m_stuSex);
	RFX_Int(pFX, _T("[stuAge]"), m_stuAge);
	RFX_Text(pFX, _T("[stuAdress]"), m_stuAdress);
	RFX_Long(pFX, _T("[stuPostcode]"), m_stuPostcode);
	RFX_Text(pFX, _T("[stuPhone]"), m_stuPhone);
	RFX_Text(pFX, _T("[stuID]"), m_stuID);
	RFX_Text(pFX, _T("[stuEmail]"), m_stuEmail);
	RFX_Text(pFX, _T("[stuOrg]"), m_stuOrg);
	RFX_Text(pFX, _T("[stuPosition]"), m_stuPosition);
	RFX_Text(pFX, _T("[stuSkill]"), m_stuSkill);
	RFX_Int(pFX, _T("[stuToolNum]"), m_stuToolNum);
	RFX_Text(pFX, _T("[stuDorm]"), m_stuDorm);
	RFX_Text(pFX, _T("[stuDirection]"), m_stuDirection);
	RFX_LongBinary(pFX, _T("[stuPhoto]"), m_stuPhoto);
	RFX_Date(pFX, _T("[stuDataTime]"), m_stuDataTime);
	RFX_Text(pFX, _T("[SCName]"), m_SCName);
	RFX_Text(pFX, _T("[SCRequire]"), m_SCRequire);
	RFX_Text(pFX, _T("[SCTeacher]"), m_SCTeacher);
	RFX_Long(pFX, _T("[SCTerm]"), m_SCTerm);
	RFX_Text(pFX, _T("[SCCost]"), m_SCCost);
	RFX_Text(pFX, _T("[stuRemark]"), m_stuRemark);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CStuDataBaseSet diagnostics

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

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