使用C++连接sql server 单例模式

直接上代码

使用方法：

CADO& m_sqlAdo=CADO::getCADOInstance();
    if (!m_sqlAdo.IsOpen())
    {   
        bool success = m_sqlAdo.InitializeAdo("139.199.xxx.xxx,1433", "sa", "xxxx", "Persist Security Info=False;Initial Catalog=xxx");//Initial Catalog为数据库名，更多参数百度
        if (!success)
            return; 
    }
    m_sqlAdo.ExecuteSql("insert into dbo.test values ('c++','c++')");
    _RecordsetPtr result = m_sqlAdo.ExecuteSql("SELECT * FROM dbo.test3");
    while (!result->rsEOF)
    {
        _variant_t var = result->GetCollect("host");//获取列中指定字段的内容
        if (var.vt != VT_NULL)
            std::cout << (LPCSTR)_bstr_t(var) << "\t";
        result->MoveNext();
    }
    result->Close();
    //更多用法请百度_RecordsetPtr 

头文件

#pragma once

#ifndef IMPORT_MSADO15_DLL
#define IMPORT_MSADO15_DLL
#if defined(_WIN64) //添加对64位环境的支持 未经过测试
#import "C:\Program Files (x86)\Common Files\System\ado\msado15.dll" no_namespace rename("EOF", "rsEOF")
#else
#import "C:\Program Files \Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")
#endif
#endif

class CADO  
{
public:
    static CADO &getCADOInstance() {
        //静态变量初始化一次的特点
        static CADO  mCDevice;
        return mCDevice;
    }
public:
    bool            InitializeAdo(const char* host,const char* id,const char* password,const char* option);
    _RecordsetPtr   ExecuteSql(const char* strSql);
    long            GetTableCount(const char* SQL);
    inline bool     IsOpen(){return b_Initialize;};
private:    
    CADO(); 
    CADO(const CADO&) {};
    CADO& operator=(const CADO&) {};
    virtual ~CADO();
    _ConnectionPtr m_pCon;  //ADO连接对象
    _CommandPtr m_pCommand; //命令执行连接对象
    bool b_Initialize;
};

类文件

#include "stdafx.h"
#include "ADO.h"
#include <iostream>
#include <assert.h>
CADO::CADO()
{
    b_Initialize=false;
};

CADO::~CADO()
{
    if(m_pCon->State)
        m_pCon->Close();      //关闭数据连接
    m_pCon = nullptr;
#if !defined(_AFXDLL)
    CoUninitialize();
#endif
}

bool    CADO::InitializeAdo(const char* host,const char* id,const char* password,const char* option)
{
    if(b_Initialize)
        return false;
#if defined(_AFXDLL)
    AfxOleInit();
#else 
    CoInitialize(NULL);
#endif
    try
    {           
        std::string strAdoConn; 
        strAdoConn="Provider=SQLOLEDB.1;Password=";
        strAdoConn.append(password);
        strAdoConn+=";User ID=";
        strAdoConn.append(id);
        strAdoConn+=";Data Source=";
        strAdoConn.append(host);
        strAdoConn+=";";
        strAdoConn.append(option);
        HRESULT ok=m_pCon.CreateInstance(_uuidof(Connection)); //SQLOLEDB.1
        m_pCon->ConnectionString = (_bstr_t)strAdoConn.c_str();
        m_pCon->ConnectionTimeout = 5;
        m_pCon->Open("","","",NULL);        
        b_Initialize=true;
    }
    catch(_com_error &ex)
    {
        std::cout<<ex.Description()<<std::endl;
        b_Initialize=false;
    }
    catch(...)
    {   
        std::cout<<"init failed  unknow error";
        b_Initialize=false;
    }
    return b_Initialize;
}

_RecordsetPtr   CADO::ExecuteSql(const char* strSql)
{
    assert(b_Initialize);
    _RecordsetPtr result;
    try {
        result=m_pCon->Execute(strSql, NULL, adCmdText);
    }
    catch (_com_error &ex)
    {
        std::cout << ex.Description()<<std::endl;
        return nullptr;
    }
    return  result;
}

long CADO::GetTableCount(const char* tableName)
{
    _bstr_t vSQL("select count(*) from");
    vSQL += tableName;
    _RecordsetPtr  m_ReWell_d;
    m_ReWell_d=ExecuteSql(vSQL);
    if (!m_ReWell_d)
        return 0;
    _variant_t count = m_ReWell_d->GetCollect((_variant_t)(long)0L);
    m_ReWell_d->Close();
    return count;
}

如果数据库出现异常 使用catch (_com_error &ex){std::cout << ex.Description()<