stuset.cpp

本程序用来学校管理学生挡案用. 采用Access数据库,程序实现关键在应用ODBC 的两个类.

// STUset.cpp : implementation file
//

#include "stdafx.h"
#include "STU.h"
#include "STUset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSTUset

IMPLEMENT_DYNAMIC(CSTUset, CRecordset)

CSTUset::CSTUset(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CSTUset)
	m_ID = 0;
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = _T("");
	m_column5 = _T("");
	m_column6 = _T("");
	m_column7 = _T("");
	m_column8 = _T("");
	m_column9 = _T("");
	m_column10 = _T("");
	m_column11 = _T("");
	m_column12 = _T("");
	m_column13 = _T("");
	m_column14 = _T("");
	m_column15 = _T("");
	m_column16 = _T("");
	m_column17 = _T("");
	m_column18 = 0;
	m_column19 = _T("");
	m_column20 = _T("");
	m_column21 = _T("");
	m_nFields = 22;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}


CString CSTUset::GetDefaultConnect()
{
	return _T("ODBC;DSN=STU");
}

CString CSTUset::GetDefaultSQL()
{
	return _T("[主体表]");
}

void CSTUset::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CSTUset)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[ID]"), m_ID);
	RFX_Text(pFX, _T("[入学时间]"), m_column1);
	RFX_Text(pFX, _T("[注册时间]"), m_column2);
	RFX_Text(pFX, _T("[学号]"), m_column3);
	RFX_Text(pFX, _T("[姓名]"), m_column4);
	RFX_Text(pFX, _T("[性别]"), m_column5);
	RFX_Text(pFX, _T("[年龄]"), m_column6);
	RFX_Text(pFX, _T("[出生日期]"), m_column7);
	RFX_Text(pFX, _T("[联系电话]"), m_column8);
	RFX_Text(pFX, _T("[家庭住址]"), m_column9);
	RFX_Text(pFX, _T("[专业]"), m_column10);
	RFX_Text(pFX, _T("[学习类型]"), m_column11);
	RFX_Text(pFX, _T("[学习层次]"), m_column12);
	RFX_Text(pFX, _T("[学习形式]"), m_column13);
	RFX_Text(pFX, _T("[所在学校]"), m_column14);
	RFX_Text(pFX, _T("[年级]"), m_column15);
	RFX_Text(pFX, _T("[班主任]"), m_column16);
	RFX_Text(pFX, _T("[毕业时间]"), m_column17);
	RFX_Long(pFX, _T("[收费]"), m_column18);
	RFX_Text(pFX, _T("[挡案]"), m_column19);
	RFX_Text(pFX, _T("[备注]"), m_column20);
	RFX_Text(pFX, _T("[班级]"), m_column21);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CSTUset diagnostics

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

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