#include?“StdAfx.h“
#include?“ADO.h“

CADO::CADO（void）
{
}

CADO::~CADO（void）
{
}

BOOL?CADO::OnInitADOConn（void）
{
	//AfxOleInit（）;???//初始化COM環(huán)境

	HRESULT?hr;??//創(chuàng)建對(duì)象
	try
	{
		hr?=?m_pConnection.CreateInstance（“ADODB.Connection“）;????//創(chuàng)建Connection對(duì)象
		if?（SUCCEEDED（hr））?????????//創(chuàng)建成功
		{

			//Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=BankAccount.accdb;Jet?OLEDB:Database?Password=123456;
			hr?=?m_pConnection->Open（“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=bankDB.accdb;Jet?OLEDB:Database?Password=123456;“““““adModeUnknown）;??//連接數(shù)據(jù)庫(kù)，注意DataSource路徑的寫法
			//MessageBox（“連接數(shù)據(jù)庫(kù)成功！“）;
		}
	}
	catch（_com_error?e）
	{
		CString?errorMsg;
		errorMsg.Format（_T（“連接數(shù)據(jù)庫(kù)失敗！\r\n錯(cuò)誤信息:%s“）e.ErrorMessage（））;
		AfxMessageBox（errorMsg）;?????????//顯示錯(cuò)誤信息
	}
	return?TRUE;
}

_RecordsetPtr&?CADO::OpenRecordset（CString?sql）
{
	//TODO:?insert?return?statement?here
	ASSERT（!sql.IsEmpty（））;
	try
	{
		m_pRecordset.CreateInstance（“ADODB.Recordset“）;

		if?（m_pRecordset?==?NULL）
		{
			AfxMessageBox（_T（“RecordSet?對(duì)象創(chuàng)建失敗!?請(qǐng)確認(rèn)是否初始化了COM環(huán)境.“））;
		}

		//設(shè)置游標(biāo)屬性?不知道為什么要設(shè)置這個(gè)，但是不設(shè)置這個(gè)游標(biāo)屬性為3或者adUseClient的話返回的數(shù)據(jù)集數(shù)目為-1，獲取不到記錄
		m_pRecordset->CursorLocation?=?adUseClient;??
		//打開(kāi)記錄集
		m_pRecordset->Open（_variant_t（sql）_variant_t（（IDispatch?*）m_pConnectiontrue）adOpenDynamicadLockOptimisticadCmdText）;

	}
	catch（_com_error?e）
	{
		CString?errorMsg;
		errorMsg.Format（_T（“連接數(shù)據(jù)庫(kù)失敗！\r\n錯(cuò)誤信息:%s“）e.ErrorMessage（））;
		AfxMessageBox（errorMsg）;?????????//顯示錯(cuò)誤信息
	}
	return?m_pRecordset;
}

//?獲取recordset指針
_RecordsetPtr&?CADO::GetRecordset（void）
{
	//TODO:?insert?return?statement?here
	return?m_pRecordset;
}

void?CADO::ExitConnection（void）
{
	if（m_pRecordset->GetState（）?==?adStateOpen）
	{
		m_pRecordset->Close（）;
		m_pRecordset?=?NULL;
	}
	if?（m_pConnection->State）
	{
		m_pConnection->Close（）;
		m_pConnection?=?NULL;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件?????147968??2012-11-19?10:55??TestDemo\Debug\TestDemo.exe

?????文件????1095316??2012-11-19?10:55??TestDemo\Debug\TestDemo.ilk

?????文件????3902464??2012-11-19?10:55??TestDemo\Debug\TestDemo.pdb

?????文件???????2055??2012-11-19?10:55??TestDemo\TestDemo\ADO.cpp

?????文件????????294??2012-11-16?19:56??TestDemo\TestDemo\ADO.h

?????文件?????462848??2012-11-19?10:57??TestDemo\TestDemo\bankDB.accdb

?????文件???????2394??2012-11-19?10:36??TestDemo\TestDemo\BankDlg.cpp

?????文件????????496??2012-11-19?10:34??TestDemo\TestDemo\BankDlg.h

?????文件??????78916??2012-11-19?10:55??TestDemo\TestDemo\Debug\ADO.obj

?????文件??????75432??2012-11-19?10:36??TestDemo\TestDemo\Debug\BankDlg.obj

?????文件???????6988??2012-11-19?10:55??TestDemo\TestDemo\Debug\BuildLog.htm

?????文件?????170819??2012-06-06?13:05??TestDemo\TestDemo\Debug\msado15.tlh

?????文件?????148885??2012-06-06?13:05??TestDemo\TestDemo\Debug\msado15.tli

?????文件?????????65??2012-11-19?10:55??TestDemo\TestDemo\Debug\mt.dep

?????文件?????492930??2012-11-16?19:50??TestDemo\TestDemo\Debug\stdafx.obj

?????文件???????1196??2012-11-16?19:50??TestDemo\TestDemo\Debug\TestDemo.exe.embed.manifest

?????文件???????1260??2012-11-16?19:50??TestDemo\TestDemo\Debug\TestDemo.exe.embed.manifest.res

?????文件???????1120??2012-11-19?10:55??TestDemo\TestDemo\Debug\TestDemo.exe.intermediate.manifest

?????文件??????22758??2012-11-16?20:47??TestDemo\TestDemo\Debug\TestDemo.obj

?????文件???28835840??2012-11-16?19:50??TestDemo\TestDemo\Debug\TestDemo.pch

?????文件??????24404??2012-11-19?10:55??TestDemo\TestDemo\Debug\TestDemo.res

?????文件?????131528??2012-11-19?10:34??TestDemo\TestDemo\Debug\TestDemoDlg.obj

?????文件?????994304??2012-11-19?10:55??TestDemo\TestDemo\Debug\vc90.idb

?????文件????2306048??2012-11-19?10:55??TestDemo\TestDemo\Debug\vc90.pdb

?????文件???????2909??2012-11-16?19:46??TestDemo\TestDemo\ReadMe.txt

????.......?????21630??2003-07-24?09:52??TestDemo\TestDemo\res\TestDemo.ico

?????文件????????364??2012-11-16?19:46??TestDemo\TestDemo\res\TestDemo.rc2

?????文件???????1277??2012-11-19?10:18??TestDemo\TestDemo\resource.h

?????文件????????139??2012-11-16?19:46??TestDemo\TestDemo\stdafx.cpp

?????文件???????1897??2012-11-16?19:48??TestDemo\TestDemo\stdafx.h

............此處省略21個(gè)文件信息