myodbcset.cpp

一个简单的数据库增加和删减的程序,完成对ACCESS数据库中数据添加和删除.

// MyODBCSet.cpp : implementation of the CMyODBCSet class
//

#include "stdafx.h"
#include "MyODBC.h"
#include "MyODBCSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyODBCSet implementation

IMPLEMENT_DYNAMIC(CMyODBCSet, CRecordset)

CMyODBCSet::CMyODBCSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMyODBCSet)
	m_ID = 0;
	m_name = _T("");
	m_singer = _T("");
	m_writer = _T("");
	m_position = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CMyODBCSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MyODBC");
}

CString CMyODBCSet::GetDefaultSQL()
{
	return _T("[Table1]");
}

void CMyODBCSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMyODBCSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[ID]"), m_ID);
	RFX_Text(pFX, _T("[name]"), m_name);
	RFX_Text(pFX, _T("[singer]"), m_singer);
	RFX_Text(pFX, _T("[writer]"), m_writer);
	RFX_Text(pFX, _T("[position]"), m_position);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMyODBCSet diagnostics

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

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