再探MFC(八)使用数据库

ADO包装类

A set of ADO classes - version 2.20

 

源文档 <http://www.codeproject.com/KB/database/caaadoclass1.aspx>

 

使用介绍

CADODatabase包装_ConnectionPtr,管理数据库连接.

 

连接数据库例子

//Sample withConnection string for SQL Server

 

CADODatabase* pAdoDb= new CADODatabase();

CStringstrConnection = _T("");

 

strConnection =_T("Provider=MSDASQL;PersistSecurityInfo=False;"

                  "Trusted_Connection=Yes;"

                   "Data Source=Access SqlServer;catalog=sampledb");

pAdoDb->SetConnectionString(strConnection);

 

if(pAdoDb->Open())

  DoSomething();

.

.

.

 

//Sample withConnection String for Access database

 

CADODatabase* pAdoDb= new CADODatabase();

CStringstrConnection = _T("");

 

strConnection =_T("Provider=Microsoft.Jet.OLEDB.4.0;"

              "DataSource=C:\\VCProjects\\ADO\\Test\\dbTest.mdb");

pAdoDb->SetConnectionString(strConnection);

 

if(pAdoDb->Open())

{

  DoSomething();

  .

  .

  .

  pAdoDb->Close();

}

 

delete pAdoDb;

 

注意如果是access 2007版本以上,请使用如下连接字符串

strConnection =_T("Provider=Microsoft.Jet.OLEDB.12.0;")

_T("DataSource=simpledb.accdb;Persist Security Info=False");

CADORecordset包装_RecordsetPtr,管理结果集.

 

 

执行SQL

1. CADODatabase::Execute执行SQL语句.