資源簡介
MFC快遞系統(tǒng)源代碼

代碼片段和文件信息
//?AdoConnect.cpp:?implementation?of?the?CAdoConnect?class.
//
//////////////////////////////////////////////////////////////////////
#include?“stdafx.h“
#include?“cdw.h“
#include?“AdoConnect.h“
#ifdef?_DEBUG
#undef?THIS_FILE
static?char?THIS_FILE[]=__FILE__;
#define?new?DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
//?Construction/Destruction
//////////////////////////////////////////////////////////////////////
CAdoConnect::CAdoConnect()
{
}
CAdoConnect::~CAdoConnect()
{
}
BOOL?CAdoConnect::OnInitDBConnect()
{
::CoInitialize(NULL);????????//初始化OLE/COM環(huán)境
HRESULT?hr;
try
{
hr?=?m_pConnection.CreateInstance(“ADODB.Connection“);??????//創(chuàng)建Connection對象
if(SUCCEEDED(hr))
{
_bstr_t?strConnect;
strConnect=“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=userinfo.mdb;Persist?Security?Info=False;Jet?OLEDB:Database?Password=“;
m_pConnection->ConnectionTimeout?=30;??????????????????????//設(shè)置超時(shí)時(shí)間為5秒
hr?=?m_pConnection->Open(strConnect““““adModeUnknown);
}
}
catch(_com_error?e)?????????//捕捉異常
{
CString?errormessage;
errormessage.Format(“連接數(shù)據(jù)庫失敗!\r\n錯(cuò)誤信息:%s“e.ErrorMessage());
AfxMessageBox(errormessage);
return?false;
}
return?true;
}
void?CAdoConnect::ExitConnect()
{
//關(guān)閉記錄集和連接
????if(m_pRecordset!=NULL)
m_pRecordset->Close();
m_pConnection->Close();
}
BOOL?CAdoConnect::ExecuteSQL(_bstr_t?bstrSQL)//執(zhí)行參數(shù)bstrSQL所指定的SQL語句
{
_variant_t?RecordsAffected;
try
{
if(m_pConnection==NULL)
OnInitDBConnect();
m_pConnection->Execute(bstrSQL&RecordsAffectedadCmdText);
return?true;
}
catch(_com_error?e)
{
CString?errormessage;
errormessage.Format(“執(zhí)行語句失敗!\r\n錯(cuò)誤信息:%s“e.ErrorMessage());
AfxMessageBox(errormessage);
return?false;
}
}
_RecordsetPtr&?CAdoConnect::GetRecordSet(_bstr_t?bstrSQL)//從數(shù)據(jù)庫中獲得記錄
{
try
{
if(m_pConnection==NULL)??????//連接數(shù)據(jù)庫,如果Connection對象為空,則重新連接數(shù)據(jù)庫
OnInitDBConnect();
m_pRecordset.CreateInstance(“ADODB.Recordset“);???
m_pRecordset->Open(bstrSQL_variant_t((IDispatch?*)m_pConnectiontrue)adOpenDynamicadLockOptimisticadCmdText);??????//取得表中的記錄
}
catch(_com_error?e)???????//捕捉異常
{
CString?errormessage;
errormessage.Format(“獲取數(shù)據(jù)庫記錄失敗!\r\n錯(cuò)誤信息:%s“e.ErrorMessage());
AfxMessageBox(errormessage);????
}
return?m_pRecordset;???????//返回結(jié)果集
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????2518??2007-12-24?17:58??快遞系統(tǒng)代碼\源代碼\AdoConnect.cpp
?????文件????????911??2007-12-24?17:45??快遞系統(tǒng)代碼\源代碼\AdoConnect.h
?????文件????????918??2007-12-25?22:33??快遞系統(tǒng)代碼\源代碼\bgcx.cpp
?????文件???????1123??2007-12-25?22:33??快遞系統(tǒng)代碼\源代碼\bgcx.h
?????文件????????992??2007-12-24?18:27??快遞系統(tǒng)代碼\源代碼\bgzhuangtai.cpp
?????文件???????1193??2007-12-24?18:25??快遞系統(tǒng)代碼\源代碼\bgzhuangtai.h
?????文件??????24816??2008-01-06?18:13??快遞系統(tǒng)代碼\源代碼\cdw.aps
?????文件???????2440??2008-01-06?18:30??快遞系統(tǒng)代碼\源代碼\cdw.clw
?????文件???????2021??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\cdw.cpp
?????文件???????4684??2007-12-24?18:28??快遞系統(tǒng)代碼\源代碼\cdw.dsp
?????文件????????514??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\cdw.dsw
?????文件???????1291??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\cdw.h
?????文件?????263168??2008-01-06?18:30??快遞系統(tǒng)代碼\源代碼\cdw.ncb
?????文件??????58880??2008-01-06?18:30??快遞系統(tǒng)代碼\源代碼\cdw.opt
?????文件???????1161??2008-01-06?18:29??快遞系統(tǒng)代碼\源代碼\cdw.plg
?????文件???????7331??2007-12-25?22:38??快遞系統(tǒng)代碼\源代碼\cdw.rc
?????文件???????6848??2008-01-06?18:29??快遞系統(tǒng)代碼\源代碼\cdwDlg.cpp
?????文件???????1393??2007-12-24?17:33??快遞系統(tǒng)代碼\源代碼\cdwDlg.h
?????文件???????1096??2007-12-25?21:11??快遞系統(tǒng)代碼\源代碼\JISONG.cpp
?????文件???????1201??2007-12-25?21:11??快遞系統(tǒng)代碼\源代碼\JISONG.h
?????文件???????3525??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\ReadMe.txt
?????文件???????1078??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\res\cdw.ico
?????文件????????395??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\res\cdw.rc2
?????文件???????3262??2007-12-24?18:00??快遞系統(tǒng)代碼\源代碼\res\richman8.ico
????..A.SH.??????3072??2008-01-04?21:57??快遞系統(tǒng)代碼\源代碼\res\Thumbs.db
?????文件???????1138??2007-12-24?18:00??快遞系統(tǒng)代碼\源代碼\Resource.h
?????文件????????205??2007-12-24?16:50??快遞系統(tǒng)代碼\源代碼\StdAfx.cpp
?????文件???????1180??2007-12-24?17:46??快遞系統(tǒng)代碼\源代碼\StdAfx.h
?????文件????1064960??2008-01-06?18:25??快遞系統(tǒng)代碼\源代碼\userinfo.mdb
?????目錄??????????0??2008-01-07?00:02??快遞系統(tǒng)代碼\源代碼\res
............此處省略5個(gè)文件信息
- 上一篇:C語言計(jì)算特征值和特征向量
- 下一篇:影像對比度計(jì)算C++代碼
評(píng)論
共有 條評(píng)論