[1] 在stdafx.h中添加
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
[2] 初始化COM环境(一般放在函数BOOL CThenApp::InitInstance()里面)。
CoInitialize(NULL);
[3] Connection与Recordset:在使用它们之前,需要创建它们的实例
_ConnectionPtr m_pConnection;
m_pConnection=NULL;
m_pRecordset.CreateInstance(__uuidof(Recordset));
_RecordsetPtr m_pRecordset;
m_pRecordset=NULL;
m_pConnection.CreateInstance(__uuidof(Connection));
[4]打开数据库与关闭数据库
m_pConnection->Open((_bstr_t)"Driver={SQL Server};Server=(local);Database=数据库名","","",adModeUnknown);或
m_pConnection->Open((_bstr_t)"Driver={SQL Server};Server=(local);Database=数据库名;uid=sa;pwd=111","","",adModeUnknown);
Server可以是IP地址如:202.197.106.254
或m_pConnection->ConnectionString=(_bstr_t)LinkString;
LinkString= "Driver={SQL Server};Server=(local);Database=tushu";
m_pConnection->Open("","","",adModeUnknown);
关闭数据库:m_pConnection->Close();
[5]数据库记录集的操作
m_pRecordset= m_pConnection->Execute(CommandText,RecordsAffected,Option);
如:sql.Format("select * from 管理员where user ='%s'and Pwd = '%s'",m_user,m_pwd);
m_pRecordset= m_pConnection->Execute((_bstr_t)sql,NULL, adCmdText);
更新数据:
sql.Format("update from 员工信息表set name=’%s’,sex=’%s’,salary=’%s’
Where id=’%s’ ",m_name,m_sex,m_salary,m_id);
m_pRecordset= m_pConnection->Execute((_bstr_t)sql,NULL, adCmdText);
添加数据:
sql.Format("insert into 员工信息表 Values(’%s’,’%s’,’%s’,’%s’)",m_name,m_sex,m_salary,m_id);
m_pRecordset= m_pConnection->Execute((_bstr_t)sql,NULL, adCmdText);
删除数据:
sql.Format("delete from 员工信息表 where id=%s",m_id);
m_pRecordset= m_pConnection->Execute((_bstr_t)sql,NULL, adCmdText);