adoConn类

adoConn.h

#pragma once
class adoConn
{
public:
    _ConnectionPtr m_pConn;
    _RecordsetPtr m_pRset;
    bool m_bActived;
    _RecordsetPtr ExecuteSQL(CString vSQL);
    adoConn();
    ~adoConn();
};

adoConn.cpp

#include "stdafx.h"
#include "adoConn.h"


adoConn::adoConn()
{
    m_bActived = false;
    _bstr_t bconn = _T("Provider=sqloledb;Data Source=DESKTOP-SBR2279;Initial Catalog=c;User ID=sa;Password=12345678");
    try
    {
        m_pConn.CreateInstance(__uuidof(Connection));
        m_pConn->ConnectionString = bconn;
        m_pConn->ConnectionTimeout = 20;
        m_pConn->Open("", "", "", adConnectUnspecified);
        m_pRset.CreateInstance(__uuidof(Recordset));
        AfxMessageBox(_T("连接数据库成功"));
    }
    catch (_com_error *e)
    {
        AfxMessageBox(_T("连接数据库出错"));
    }
}

_RecordsetPtr adoConn::ExecuteSQL(CString vSQL)
{
    try
    {
        if (m_bActived)
        {
            m_pRset->Close();
            m_bActived = false;
        }
        m_pRset->Open(_variant_t(vSQL), m_pConn.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
        m_bActived = true;
        return m_pRset;
    }
    catch(_com_error *e)
    {
        AfxMessageBox(_T("执行SQL数据库出错"));
    }
}


adoConn::~adoConn()
{
}