addressbookdbdoc.cpp

一个用VC++编写的连接数据库的电话本 比较简单 大家参考一下

// AddressBookDBDoc.cpp : implementation of the CAddressBookDBDoc class
//

#include "stdafx.h"
#include "AddressBookDB.h"

#include "AddressBookDBDoc.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddressBookDBDoc

IMPLEMENT_DYNCREATE(CAddressBookDBDoc, CDocument)

BEGIN_MESSAGE_MAP(CAddressBookDBDoc, CDocument)
	//{{AFX_MSG_MAP(CAddressBookDBDoc)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddressBookDBDoc construction/destruction

CAddressBookDBDoc::CAddressBookDBDoc()
{
	// TODO: add one-time construction code here
	CoInitialize(NULL);
	m_conn.CreateInstance(_uuidof(Connection));
	m_res.CreateInstance(_uuidof(Recordset));
	m_conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=AddressBookDB.mdb","","",adConnectUnspecified);
	m_sql="select ID,NAME,GENDER,PHONENUMBER from CONTACT";
}

CAddressBookDBDoc::~CAddressBookDBDoc()
{
}

BOOL CAddressBookDBDoc::OnNewDocument()
{
	if (!CDocument::OnNewDocument())
		return FALSE;

	// TODO: add reinitialization code here
	// (SDI documents will reuse this document)

	return TRUE;
}



/////////////////////////////////////////////////////////////////////////////
// CAddressBookDBDoc serialization

void CAddressBookDBDoc::Serialize(CArchive& ar)
{
	if (ar.IsStoring())
	{
		// TODO: add storing code here
	}
	else
	{
		// TODO: add loading code here
	}
}

/////////////////////////////////////////////////////////////////////////////
// CAddressBookDBDoc diagnostics

#ifdef _DEBUG
void CAddressBookDBDoc::AssertValid() const
{
	CDocument::AssertValid();
}

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

/////////////////////////////////////////////////////////////////////////////
// CAddressBookDBDoc commands
void CAddressBookDBDoc::Insert(CContact contact){
	_variant_t RecordsAffected;
	CString strGender;
	strGender.Format("%d",(int)contact.m_gender);
	CString sql="insert into CONTACT (NAME,GENDER,PHONENUMBER) values('"+contact.m_name+"',"+strGender+",'"+contact.m_phonenumber+"')";
	m_conn->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
}

void CAddressBookDBDoc::Remove(CContact contact){
	_variant_t RecordsAffected;
	CString strid;
	strid.Format("%d",contact.m_id);
	CString sql="delete from CONTACT where id="+strid;
	m_conn->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
}

void CAddressBookDBDoc::Update(CContact contact){
	_variant_t RecordsAffected;
	CString strGender;
	strGender.Format("%d",(int)contact.m_gender);
	CString strid;
	strid.Format("%d",contact.m_id);
	CString sql="update CONTACT set NAME='"+contact.m_name+"',GENDER="+strGender+",PHONENUMBER='"+contact.m_phonenumber+"' where id="+strid;
	m_conn->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
}

void CAddressBookDBDoc::Select(){
	contacts.RemoveAll();
	m_res->Open(_bstr_t(m_sql),m_conn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	while(!m_res->adoEOF){
		CContact contact;
		_variant_t temp=m_res->GetCollect("ID");
		contact.m_id=temp.intVal;
		temp=m_res->GetCollect("NAME");
		contact.m_name=temp.bstrVal;
		temp=m_res->GetCollect("GENDER");
		contact.m_gender=temp.boolVal;
		temp=m_res->GetCollect("PHONENUMBER");
		contact.m_phonenumber=temp.bstrVal;
		contacts.Add(contact);
		m_res->MoveNext();
	}
	m_res->Close();
}