personset.cpp

我自己写的一个通讯录的程序,用ODBC来连接数据库. 可以查找,添加,删除,和修改记录,并显示数据库中人所有记录. 登录程序的默认密码为空,可以在程序中修改.

// PersonSet.cpp : implementation file
//

#include "stdafx.h"
#include "Address.h"
#include "PersonSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPersonSet

IMPLEMENT_DYNAMIC(CPersonSet, CRecordset)

CPersonSet::CPersonSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CPersonSet)
	m_NAME = _T("");
	m_SEX = _T("");
	m_TELEPHONE = _T("");
	m_HANDPHONE = _T("");
	m_ADDRESS = _T("");
	m_WORKPLACE = _T("");
	m_EMAIL = _T("");
	m_OICQ = _T("");
	m_ID = 0;
	m_RELATION = _T("");
	m_nFields = 10;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CPersonSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=addresslist");
}

CString CPersonSet::GetDefaultSQL()
{
	return _T("[person]");
}

void CPersonSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CPersonSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[ID]"), m_ID);
	RFX_Text(pFX, _T("[NAME]"), m_NAME);
	RFX_Text(pFX, _T("[SEX]"), m_SEX);
	RFX_Text(pFX, _T("[RELATION]"), m_RELATION);
	RFX_Text(pFX, _T("[TELEPHONE]"), m_TELEPHONE);
	RFX_Text(pFX, _T("[HANDPHONE]"), m_HANDPHONE);
	RFX_Text(pFX, _T("[ADDRESS]"), m_ADDRESS);
	RFX_Text(pFX, _T("[WORKPLACE]"), m_WORKPLACE);
	RFX_Text(pFX, _T("[EMAIL]"), m_EMAIL);
	RFX_Text(pFX, _T("[OICQ]"), m_OICQ);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CPersonSet diagnostics

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

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