memberset.cpp

使用vc进行数据库编程的好例子

// MemberSet.cpp : implementation file
//

#include "stdafx.h"
#include "ManageSystem.h"
#include "MemberSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMemberSet

IMPLEMENT_DYNAMIC(CMemberSet, CRecordset)

CMemberSet::CMemberSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMemberSet)
	m_mem_id = 0;
	m_user_name = _T("");
	m_mem_key = _T("");
	m_mem_name = _T("");
	m_mem_sex = _T("");
	m_mem_age = 0;
	m_mem_company = _T("");
	m_mem_idcard = _T("");
	m_province = _T("");
	m_city = _T("");
	m_mem_telephone = _T("");
//	m_register_time=CTime(2000,1,1);
	m_nFields = 12;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CMemberSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=KeChengSheJi");
}

CString CMemberSet::GetDefaultSQL()
{
	return _T("[dbo].[memberinfo]");
}

void CMemberSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMemberSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[mem_id]"), m_mem_id);
	RFX_Text(pFX, _T("[user_name]"), m_user_name);
	RFX_Text(pFX, _T("[mem_key]"), m_mem_key);
	RFX_Text(pFX, _T("[mem_name]"), m_mem_name);
	RFX_Text(pFX, _T("[mem_sex]"), m_mem_sex);
	RFX_Long(pFX, _T("[mem_age]"), m_mem_age);
	RFX_Text(pFX, _T("[mem_company]"), m_mem_company);
	RFX_Text(pFX, _T("[mem_idcard]"), m_mem_idcard);
	RFX_Text(pFX, _T("[province]"), m_province);
	RFX_Text(pFX, _T("[city]"), m_city);
	RFX_Text(pFX, _T("[mem_telephone]"), m_mem_telephone);
	RFX_Date(pFX, _T("[register_time]"), m_register_time);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMemberSet diagnostics

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

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