ADOConn.cpp
资源名称:02.rar [点击查看]
上传用户:hahaxixi
上传日期:2022-04-15
资源大小:1939k
文件大小:2k
源码类别:
手机短信编程
开发平台:
Visual C++
- // ADOConn.cpp: implementation of the ADOConn class.
- //
- //////////////////////////////////////////////////////////////////////
- #include "stdafx.h"
- #include "NoteManage.h"
- #include "ADOConn.h"
- #ifdef _DEBUG
- #undef THIS_FILE
- static char THIS_FILE[]=__FILE__;
- #define new DEBUG_NEW
- #endif
- //////////////////////////////////////////////////////////////////////
- // Construction/Destruction
- //////////////////////////////////////////////////////////////////////
- ADOConn::ADOConn()
- {
- }
- ADOConn::~ADOConn()
- {
- }
- void ADOConn::OnInitADOConn()
- {
- //初始化OLE/COM库环境
- ::CoInitialize(NULL);
- try
- {
- //创建connection对象
- m_pConnection.CreateInstance("ADODB.Connection");
- //设置连接字符串
- _bstr_t strConnect="uid=;pwd=;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=shujuku.mdb;";
- //SERVER和UID,PWD的设置根据实际情况来设置
- m_pConnection->Open(strConnect,"","",adModeUnknown);
- }
- //捕捉异常
- catch(_com_error e)
- {
- //显示错误信息
- AfxMessageBox(e.Description());
- }
- }
- void ADOConn::ExitConnect()
- {
- //关闭记录集和连接
- if(m_pRecordset!=NULL)
- m_pRecordset->Close();
- m_pConnection->Close();
- //释放环境
- ::CoUninitialize();
- }
- _RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL)
- {
- try
- {
- if(m_pConnection==NULL)
- OnInitADOConn();
- m_pRecordset.CreateInstance(__uuidof(Recordset));
- m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
- }
- catch(_com_error e)
- {
- e.Description();
- }
- return m_pRecordset;
- }
- BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
- {
- try
- {
- //是否已连接数据库
- if(m_pConnection==NULL)
- OnInitADOConn();
- m_pConnection->Execute(bstrSQL,NULL,adCmdText);
- return true;
- }
- catch(_com_error e)
- {
- e.Description();
- return false;
- }
- }