ADO使用

#import "c:program filescommon filessystemadomsado15.dll" no_namespace rename("EOF","adoEOF") 声明对象： _ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; 创建对象： // 初始化COM接口 ::CoInitialize(NULL); //m_pConnection.CreateInstance(__uuidof(Connection)); m_pConnection.CreateInstance("ADODB.Connection"); m_pRecordset.CreateInstance(__uuidof(Recordset)); //m_pStream.CreateInstance(__uuidof(Stream)); try{ if(m_pConnection->State) { m_pConnection->Close(); } m_pConnection->Open("Provider=MSDASQL.1;Password=sa;Persist Security Info=True;User ID=sa;Data Source=JH7MemberAchivement;","","",adConnectUnspecified); if(!m_pConnection->State) { AfxMessageBox("打开数据库失败，程序退出!"); return FALSE; } //VARIANT m_varVal; //m_pConnection->Execute(_T("INSERT INTO DEPARTMENT (Department,MENBER) VALUES ('ddd','xxx')"),&m_varVal,NULL); } catch(_com_error e) { //AfxMessageBox(e.ErrorMessage()); AfxMessageBox(e.Description()); return FALSE; } 记录查询 CString m_sSql; m_sSql.Format("SELECT * FROM MemberAchivement where MemberID=%d",m_nMemberID); m_pRecordset->Open(COleVariant(m_sSql),(IDispatch *)m_pConnection,adOpenDynamic,adLockOptimistic,adCmdText); RemoveList(); if(m_pRecordset->adoEOF) { m_pRecordset->Close(); MessageBox("没有指定用户ID成绩"); return; } m_pRecordset->MoveFirst(); _variant_t vMemberID,vMemberName,vMemberOrgnizaton,vAchivement,vAchivementDate; int m_nItem; char m_pItemText[512]; do { vMemberID=m_pRecordset->GetCollect(_variant_t((long)0)); vMemberName=m_pRecordset->GetCollect(_variant_t((long)1)); vMemberOrgnizaton=m_pRecordset->GetCollect(_variant_t((long)2)); vAchivement=m_pRecordset->GetCollect(_variant_t((long)3)); vAchivementDate=m_pRecordset->GetCollect(_variant_t((long)4)); //add to listview control m_nItem=m_AchivementList.GetItemCount(); itoa(vMemberID.iVal,pText,10); m_AchivementList.InsertItem(m_nItem,pText); CString m_str=vMemberName.bstrVal; strcpy(m_pItemText,m_str); //strcpy(pText,vMemberName.bstrVal); m_AchivementList.SetItemText(m_nItem,1,m_pItemText); m_str=vMemberOrgnizaton.bstrVal; strcpy(m_pItemText,m_str); m_AchivementList.SetItemText(m_nItem,2,m_pItemText); itoa(vAchivement.iVal,pText,10); m_AchivementList.SetItemText(m_nItem,3,pText); COleDateTime m_oletdatetime=vAchivementDate.date; strcpy(m_pItemText,m_oletdatetime.Format("%Y-%m-%d %H:%M:%S")); m_AchivementList.SetItemText(m_nItem,4,m_pItemText); m_pRecordset->MoveNext(); } while(!m_pRecordset->adoEOF); m_pRecordset->Close(); 插入记录: time_t m_timeNow; time(&m_timeNow); CTime m_time(m_timeNow); CString m_sTmp=m_time.Format("%Y-%m-%d %H:%M:%S"); CString m_sSql; m_sSql.Format("SELECT * FROM MemberAchivement where MemberID=%d",m_nMemberID); m_pRecordset->Open(COleVariant(m_sSql),(IDispatch *)m_pConnection,adOpenDynamic,adLockOptimistic,adCmdText); if(!m_pRecordset->adoEOF) { m_pRecordset->Close(); MessageBox("学员ID已经存在，请输入新的ID!"); return; } m_pRecordset->Close(); //Succeed sql syntax:INSERT INTO MemberAchivement (MemberID,MemberName,MemberOrginazation,MemberAchivement,AchivementDate) VALUES (2,'xiayongixan','bit',100,'15:54:52 05-11-18') m_sSql.Format("INSERT INTO MemberAchivement (MemberID,MemberName,MemberOrginazation,MemberAchivement,AchivementDate) VALUES (%d,'%s','%s',%d,'%s')",m_nMemberID,m_sMemberName,m_sMemberOrgnization,m_nMemberAchivement,m_sTmp); TRACE(m_sSql); VARIANT m_varVal; try{ m_pConnection->Execute(m_sSql.AllocSysString(),&m_varVal,NULL); } catch(_com_error e) { //MessageBox(e.Description()); //return; } 程序最后注销： if(m_pConnection->State) m_pConnection->Close(); ///如果已经打开了连接则关闭它 m_pConnection=NULL; m_pRecordset=NULL;