odbc.cpp

一个用VC写的学生成绩管理系统,其中对数据库的访问是采用ODBC方式.

// odbc.cpp : implementation file
//

#include "stdafx.h"
#include "student.h"
#include "odbc.h"

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

/////////////////////////////////////////////////////////////////////////////
// Codbc

IMPLEMENT_DYNAMIC(Codbc, CRecordset)

Codbc::Codbc(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(Codbc)
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = _T("");
	m_column5 = _T("");
	m_column6 = _T("");
	m_column7 = _T("");
	m_C__ = _T("");
	m_column8 = _T("");
	m_column9 = _T("");
	m_column10 = _T("");
	m_column11 = _T("");
	m_nFields = 12;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString Codbc::GetDefaultConnect()
{
	return _T("ODBC;DSN=student.mdb");
}

CString Codbc::GetDefaultSQL()
{
	return _T("[1班]");
}

void Codbc::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(Codbc)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	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("[C++]"), m_C__);
	RFX_Text(pFX, _T("[数据结构]"), m_column8);
	RFX_Text(pFX, _T("[总分]"), m_column9);
	RFX_Text(pFX, _T("[排名]"), m_column10);
	RFX_Text(pFX, _T("[备注]"), m_column11);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// Codbc diagnostics

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

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