// char_.cpp : 定义控制台应用程序的入口点。
//
#include "stdafx.h"
#include <afx.h>
#include <windows.h>
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <malloc.h>
#define WIN32_LEAN_AND_MEAN // Exclude rarely-used stuff from Windows headers
#include <tchar.h>
//使用# import把动态连接库msado15.dll导入Visual C++应用程序,并生成定义ADO库的两个C++头文件:msado15.tlh和ado15.tli。即:
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "adoEOF")
void main()
{
char * sqlCommand = "select * from dbo.db_test";
_bstr_t strConnect="driver={SQL Server};Server=127.0.0.1;Database=view;uid=sa;pwd=Rootroot1;";
::CoInitialize(NULL);//初始化COM库
//添加一个指向Connection对象的指针m_pConnection
_ConnectionPtr m_pConnection(__uuidof(Connection));
if( FAILED( m_pConnection.CreateInstance(__uuidof(Connection)) ) ) //创键Connection对象
{
printf("创键Connection对象时出错\n");
}
try
{
m_pConnection->Open (strConnect,"","", adModeUnknown); //连接数据库
}
catch(_com_error e)
{
MessageBox(NULL,e.Description(),L"test",1);
//printf("连接数据库时出错\n");
}
m_pConnection->Execute(sqlCommand, NULL, 1);//执行SQL语句
_RecordsetPtr m_pRecordset(__uuidof(Recordset));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(sqlCommand, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
while(m_pRecordset->adoEOF==0)
{
printf("%s\n", (char*)(_bstr_t)m_pRecordset->GetCollect("id"));
printf("%s\n", (char*)(_bstr_t)m_pRecordset->GetCollect("name"));
printf("%s\n", (char*)(_bstr_t)m_pRecordset->GetCollect("salary"));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
m_pConnection->Close();
::CoUninitialize(); //释放程序占用的COM 资源
}