//?ADOCConn.cpp:?implementation?of?the?ADOCConn?class.
//
//////////////////////////////////////////////////////////////////////

#include?“stdafx.h“
#include?“InformationOfPerson.h“
#include?“ADOCConn.h“

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

//////////////////////////////////////////////////////////////////////
//?Construction/Destruction
//////////////////////////////////////////////////////////////////////

ADOCConn::ADOCConn（）
{

}

ADOCConn::~ADOCConn（）
{

}
BOOL?ADOCConn::OnInitADOConn（）
{
?::CoInitialize（NULL）;
	try
	{
		//創建connection對象
		m_pConnection.CreateInstance（“ADODB.Connection“）;	???
		//設置連接字符串
		_bstr_t?strConnect=“uid=;pwd=;DRIVER={Microsoft?Access?Driver?（*.mdb）};DBQ=file.mdb;“;
		//SERVER和UIDPWD的設置根據實際情況來設置
		m_pConnection->Open（strConnect““““adModeUnknown）;
	}
	//捕捉異常
	catch（_com_error?e）
	{
		//顯示錯誤信息
		AfxMessageBox（e.Description（））;
	}
	return?true;
}

_RecordsetPtr&?ADOCConn::GetRecordSet（_bstr_t?bstrSQL）
{

	try
	{
		if?（m_pConnection==NULL）
		???OnInitADOConn（）;
		m_pRecordset.CreateInstance（__uuidof（Recordset））;
		m_pRecordset->Open（bstrSQLm_pConnection.GetInterfacePtr（）adOpenDynamicadLockOptimisticadCmdText）;
		
	}
	catch?（_com_error?e）
	{
		e.Description（）;
		
	}
	return?m_pRecordset;
}

BOOL?ADOCConn::ExecuteSQL（_bstr_t?bstrSQL）
{
	try
	{
		//是否已連接數據庫
		if?（m_pConnection==NULL）
			OnInitADOConn（）;
		m_pConnection->Execute（bstrSQLNULLadCmdText）;
		return?true;
	}
	catch?（_com_error?e）
	{
		e.Description（）;
		return?false;
	}
}

void?ADOCConn::ExitConnect（）
{
	//關閉記錄集和連接
	if?（m_pRecordset!=NULL）
		m_pRecordset->Close（）;
	m_pConnection->Close（）;

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1814??2012-11-17?18:28??InformationOfPerson\ADOCConn.cpp

?????文件???????1206??2012-11-17?18:28??InformationOfPerson\ADOCConn.h

?????文件??????65454??2012-11-30?20:25??InformationOfPerson\Debug\ADOCConn.obj

?????文件??????????0??2012-11-30?20:25??InformationOfPerson\Debug\ADOCConn.sbr

?????文件????5768192??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPerson.bsc

?????文件?????143482??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPerson.exe

?????文件?????335972??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPerson.ilk

?????文件??????18979??2012-11-30?20:35??InformationOfPerson\Debug\InformationOfPerson.obj

?????文件????7174128??2012-11-30?20:25??InformationOfPerson\Debug\InformationOfPerson.pch

?????文件?????631808??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPerson.pdb

?????文件???????5428??2012-11-30?20:25??InformationOfPerson\Debug\InformationOfPerson.res

?????文件??????????0??2012-11-30?20:35??InformationOfPerson\Debug\InformationOfPerson.sbr

?????文件?????120423??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPersonDlg.obj

?????文件??????????0??2012-12-01?14:29??InformationOfPerson\Debug\InformationOfPersonDlg.sbr

?????文件?????222125??2012-05-29?02:15??InformationOfPerson\Debug\msado15.tlh

?????文件?????167352??2012-05-29?02:15??InformationOfPerson\Debug\msado15.tli

?????文件?????105819??2012-11-30?20:25??InformationOfPerson\Debug\StdAfx.obj

?????文件????1375044??2012-11-30?20:25??InformationOfPerson\Debug\StdAfx.sbr

?????文件?????246784??2012-12-01?14:29??InformationOfPerson\Debug\vc60.idb

?????文件?????462848??2012-12-01?14:29??InformationOfPerson\Debug\vc60.pdb

?????文件?????593920??2012-11-20?21:27??InformationOfPerson\file.mdb

?????文件??????25720??2012-12-01?14:23??InformationOfPerson\InformationOfPerson.aps

?????文件???????3212??2012-12-01?14:29??InformationOfPerson\InformationOfPerson.clw

?????文件???????2245??2012-11-06?20:01??InformationOfPerson\InformationOfPerson.cpp

?????文件???????4522??2012-11-17?20:54??InformationOfPerson\InformationOfPerson.dsp

?????文件????????563??2012-11-06?21:34??InformationOfPerson\InformationOfPerson.dsw

?????文件???????1467??2012-12-01?14:16??InformationOfPerson\InformationOfPerson.h

?????文件?????279552??2012-12-01?14:30??InformationOfPerson\InformationOfPerson.ncb

?????文件??????49664??2012-12-01?14:30??InformationOfPerson\InformationOfPerson.opt

?????文件???????1038??2012-12-01?14:29??InformationOfPerson\InformationOfPerson.plg

............此處省略17個文件信息