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
- CADODatabase::Execute执行SQL语句.