使用ADO前必须在工程的stdafx.h文件最后用直接引入符号#import引入ADO库文件,以使编译器能正确编译。
#import "C:\Program Files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
2.CoInitialize(NULL); //初始化OLE/COM库环境
3.利用指针进行数据库操作
_ConnectionPtr m_pConnection;
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
m_pCommand.CreateInstance("ADODB.Command");//创建Command对象
m_pRecordset.CreateInstance("ADODB.Recordset");//创建Recordset对象
m_pConnection->ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/VK1000.mdb;Jet OLEDB:Database Password=root"; //连接ACCESS数据库
if (FAILED(m_pConnection->Open("","","",adConnectUnspecified)))
{
MessageBox(TEXT("cann't open database!"),TEXT("Tip"),MB_OK);
}
4.用m_pCommand执行SQL语句
m_pCommand->ActiveConnection = m_pConnection; // 将库连接赋于它
m_pCommand->CommandText = "SELECT * FROM student)";
m_pCommand->Execute(NULL, NULL,adCmdText);
5.用m_pRecordset读取更新记录
//adOpenDynamic:动态 adLockOptimistic乐观封锁法 adCmdText:文本查询语句
m_pRecordset->Open("SELECT action_cmd FROM T_UARTAction",(IDispatch*)m_pConnection,adOpenDynamic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)//遍历所有记录
{
_variant_t command;
CString temp=_T("");
CString hex=_T("");
CHAR *p=NULL;
CHAR *s=NULL;
CString tempbuf;
m_pRecordset->get_Collect(_variant_t("action_cmd"),&command);//得到字段action_cmd的值
tempbuf = (LPCTSTR)(_bstr_t)command;
int len=tempbuf.GetLength();
p=new CHAR[len+1];
s=p;
memset(p,0,len+1);
USES_CONVERSION;
strncpy(p,tempbuf.GetBuffer(0),len);
tempbuf.ReleaseBuffer();
while (*s) //char型字符串转为16进制
{
temp.Format(_T("%.2x"),*s);
hex+=temp;
s++;
}
delete [] p;
m_pRecordset->put_Collect(_variant_t("action_cmd"),_variant_t(hex)); //更新action_cmd字段的值为hex
m_pRecordset->MoveNext(); 转到下一条纪录
temp=_T("");
hex=_T("");
}
6.关闭
m_pRecordset->Close();
m_pConnection->Close();