#include?“StdAfx.h“
#include?“ADOConn.h“


ADOConn::ADOConn（void）
{
}

ADOConn::~ADOConn（void）
{
}

void?ADOConn::InitADOConn（）??
{??
	::CoInitialize（NULL）;??
	try??
	{??
		m_pConn.CreateInstance（“ADODB.Connection“）;??
		//連接字符串??
		_bstr_t?strConnect=“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=ChatRoom.mdb“;
		m_pConn->Open（strConnect““““adModeUnknown）;??
	}??
	catch（_com_error?e）??
	{??
		CString???strError;?
		strError.Format（L“連接數(shù)據(jù)庫失敗!\n錯誤代碼：%s“e.ErrorMessage（））;?
		AfxMessageBox（strError）;///顯示錯誤信息?
		AfxMessageBox（e.Description（））;??
	}??
}??

//執(zhí)行SQL語句返回指向Recordset對象的指針
_RecordsetPtr&?ADOConn::GetRecordSet（CString?bstrSQL）??
{??
	try??
	{??
		if（m_pConn==NULL）??
			InitADOConn（）;??
		m_pRecordset.CreateInstance（__uuidof（Recordset））;??
		m_pRecordset->Open（（_bstr_t）bstrSQLm_pConn.GetInterfacePtr（）??
			adOpenDynamicadLockOptimisticadCmdText）;??
	}??
	catch（_com_error?e）??
	{??
		AfxMessageBox（e.Description（））;??
	}??
	return?m_pRecordset;??
}??



bool?ADOConn::ExecuteSQL（CString?bstrSQL）??
{??
	_variant_t?RecordsAffected;??
	try??
	{??
		if（m_pConn==NULL）??
			InitADOConn（）;??
		m_pConn->Execute（（_bstr_t）bstrSQLNULLadCmdText）;??
		return?true;??
	}??
	catch（_com_error?e）??
	{??
		AfxMessageBox（e.Description（））;??
		return?false;??
	}??
}??

void?ADOConn::ExitConnect（）??
{??
	if?（m_pRecordset!=NULL）??
		m_pRecordset->Close（）;??
	m_pConn->Close（）;
	m_pConn=NULL;
	::CoUninitialize（）;??
}??


//連接字符串的一種獲取方法：
//?1.先到工程目錄中的添加到工程中選擇component?and?controls?gallery，
//?2.在彈出的對話框中選擇registered?activeX?Controls?
//?3.在打開的文件夾中選擇microsoft?ADO?Data?Control?6.0然后插入?
//?4.將這個控件隨便添加到窗口上，選擇控件右擊鼠標(biāo)屬性相中選擇General標(biāo)簽?
//?5.選擇Use?connection?string，點擊build選擇你所要連接的數(shù)據(jù)庫類型，按提示操作進行，
//?測試連接成功之后在Use?connection?string這一項中將顯示所要的連接字符串??

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

?????文件???????2003??2012-06-29?00:24??ChatClient\ADOConn.cpp

?????文件????????279??2012-06-28?20:45??ChatClient\ADOConn.h

?????文件?????836944??2012-07-09?12:31??ChatClient\ChatClient.aps

?????文件???????2204??2012-07-04?09:34??ChatClient\ChatClient.cpp

?????文件????????466??2012-06-30?22:30??ChatClient\ChatClient.h

?????文件??????41354??2012-07-05?02:37??ChatClient\ChatClient.rc

?????文件???????7993??2012-07-04?21:01??ChatClient\ChatClient.vcxproj

?????文件???????6442??2012-07-04?21:01??ChatClient\ChatClient.vcxproj.filters

?????文件????????143??2012-06-30?22:30??ChatClient\ChatClient.vcxproj.user

?????文件??????36472??2012-07-09?12:31??ChatClient\ChatClientDlg.cpp

?????文件???????1873??2012-07-05?01:59??ChatClient\ChatClientDlg.h

?????文件???????2089??2012-07-05?00:02??ChatClient\DlgFileDown.cpp

?????文件????????495??2012-07-03?22:25??ChatClient\DlgFileDown.h

?????文件???????3134??2012-07-04?23:24??ChatClient\DlgFileSource.cpp

?????文件????????678??2012-07-04?21:57??ChatClient\DlgFileSource.h

?????文件????????983??2012-07-02?00:28??ChatClient\DlgInputPwd.cpp

?????文件????????451??2012-07-02?00:05??ChatClient\DlgInputPwd.h

?????文件???????4601??2012-06-30?23:18??ChatClient\DlgLogin.cpp

?????文件????????843??2012-06-30?22:07??ChatClient\DlgLogin.h

?????文件???????5082??2012-07-02?14:08??ChatClient\DlgModifyInfo.cpp

?????文件???????1015??2012-07-02?12:53??ChatClient\DlgModifyInfo.h

?????文件???????3576??2012-07-02?22:06??ChatClient\DlgNewRoom.cpp

?????文件????????608??2012-07-02?14:07??ChatClient\DlgNewRoom.h

?????文件???????3339??2012-07-02?02:25??ChatClient\DlgPrivate.cpp

?????文件????????782??2012-07-01?11:51??ChatClient\DlgPrivate.h

?????文件???????5127??2012-06-30?23:22??ChatClient\DlgRegister.cpp

?????文件????????900??2012-06-30?22:10??ChatClient\DlgRegister.h

?????文件???????3245??2012-07-02?01:28??ChatClient\DlgRoom.cpp

?????文件????????773??2012-07-02?01:12??ChatClient\DlgRoom.h

?????文件???????2916??2012-07-02?14:07??ChatClient\DlgRoomInfo.cpp

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