c++访问数据库

这个过程有点复杂，详细请参阅孙鑫《vc++深入详解》最后一章，hook和数据库访问技术，那里讲得更明白！

#include <iostream>
#include <string>
using namespace std;
//导入ado动态链接库,必须的
#import "c:\program files\common files\system\ado\msado15.dll"no_namespace rename("eof","adoeof")

void main()
{
 _connectionptr m_pconnection; //创建智能指针，必须的
 m_pconnection.createinstance(__uuidof(connection)); //或 m_pconnection.createinstance("adodb.connection");
 coinitialize(null); //初始化com，必须的
 try 
 { 
 //连接字符串,student为数据库名
 m_pconnection->connectionstring="provider=sqloledb.1;password=sa;persist security info=true;user id=sa;initial catalog=student"; 

 m_pconnection->open(" "," "," ",admodeunknown); //调用open方法
 cout<<"1"<<endl;
 } 
 catch(_com_error e) //捕获连接异常
 { 
 cout<<"数据库初始化错误! "<<endl; 
 return ; 
 } 
 cout<<"连接成功!"<<endl;

 _recordsetptr prst(__uuidof(recordset));

 prst=m_pconnection->execute("select * from student",null,adcmdtext);//使用execute方法,student为表名

 if(!prst>adoeof) 
 prst>movefirst(); 
 else 
 { 
 cout<<"表内数据为空"<<endl; 
 return; 
 } 
 // 读入库中各字段并加入列表框中 
 _variant_t var;
 string strname;
 while(!prst>adoeof) 
 { 
 var = prst>getcollect("name"); 
 if(var.vt != vt_null) 
 strname = (lpcstr)_bstr_t(var);
 prst>movenext(); 
 } 

 //关闭
 prst->close();
 m_pconnection->close();
 prst.release();
 m_pconnection->release();

 couninitialize(); //释放com

}