studentset.cpp

连接并使用Oracle。可以创建表、预览数据集、删除、修改数据集。将这些操作封装在类里

// StudentSet.cpp : implementation file
//

#include "stdafx.h"
#include "TestDB.h"
#include "StudentSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStudentSet

IMPLEMENT_DYNAMIC(CStudentSet, CRecordset)

CStudentSet::CStudentSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CStudentSet)
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = _T("");
	m_column5 = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CStudentSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=testdsn");
}

CString CStudentSet::GetDefaultSQL()
{
	return _T("[SCOTT].[学生表2]");
}

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

/////////////////////////////////////////////////////////////////////////////
// CStudentSet diagnostics

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

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