acdb.cpp

ADO访问SQLSERVER数据库 功能完全实现

// acdb.cpp : implementation file
//

#include "stdafx.h"
#include "test.h"
#include "acdb.h"

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

/////////////////////////////////////////////////////////////////////////////
// acdb

IMPLEMENT_DYNAMIC(acdb, CRecordset)

acdb::acdb(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(acdb)
	m_cmp = _T("");
	m_address = _T("");
	m_njm = _T("");
	m_name = _T("");
	m_age = _T("");
	m_school = _T("");
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString acdb::GetDefaultConnect()
{
	return _T("ODBC;DSN=TEST");
}

CString acdb::GetDefaultSQL()
{
	return _T("[dbo].[cmpany],[dbo].[users]");
}

void acdb::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(acdb)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[cmp]"), m_cmp);
	RFX_Text(pFX, _T("[address]"), m_address);
	RFX_Text(pFX, _T("[njm]"), m_njm);
	RFX_Text(pFX, _T("[name]"), m_name);
	RFX_Text(pFX, _T("[age]"), m_age);
	RFX_Text(pFX, _T("[school]"), m_school);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// acdb diagnostics

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

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