c++读取sqlserver示例分享

#include "stdafx.h"
#include
#include
#include//for setw()
#include"windows.h"

#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","EndOfFile")

using namespace System;
using namespace std;

int main(array ^args)
{
    ::CoInitialize(NULL);

    //类型在msado15.dll中已定义
    _RecordsetPtr m_pRecordset("ADODB.Recordset");
    _ConnectionPtr m_pConnection("ADODB.Connection");

    _bstr_t bstrSQL("select * from er_order where pactnumber like '13010000%' order by pactnumber"); //对应的sql语句

    try
    {
        clog <<"正在连接数据库..." <        m_pConnection.CreateInstance("ADODB.Connection");//创建Connection对象
        //设置连接字符串，必须是BSTR型或者_bstr_t类型
        _bstr_t strCOnnect= "Provider=SQLOLEDB; Server=【数据库实例】;Database=【数据库名】; uid=【数据库用户】; pwd=【密码】;";
        m_pConnection->Open(strConnect, "", "", adModeUnknown);//服务器连接

        if (m_pCOnnection== NULL)
        {
            std::cerr <<"Lind data ERROR!\n";
        }

        m_pRecordset.CreateInstance(__uuidof(Recordset));//创建记录集对象

        //取得表中的记录
        m_pRecordset->Open(bstrSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);

        _variant_t PactNumber, OrigCount;//对应库中的字段

        cout <<"--------------合同清单--------------" <        while (!m_pRecordset->EndOfFile)
        {
            PactNumber = m_pRecordset->GetCollect("Pactnumber");
            OrigCount = m_pRecordset->GetCollect("Origcount");
            cout <<"合同号:" <            cout <<"   签单额:" <

            m_pRecordset->MoveNext();//下一条记录
        }
        m_pRecordset->Close();//关闭记录集
    }

    catch (_com_error e)//捕捉异常
    {
        cerr <<"\nERROR:" <<(char*)e.Description();
    }

    if (m_pConnection->State)
    {
        m_pConnection->Close();
    }

    ::CoUninitialize();

    Console::ReadLine();

    return 0;
}