DAO.rar_dao

CDaoRecordset *m_pRecordset; CDaoDatabase *m_pDatabase; ////////初始化 m_pDatabase = new CDaoDatabase; try { m_pDatabase->Open("user.mdb");//放在了工程的目录下，并将数据 //库转化了低级版本 m_pRecordset =new CDaoRecordset(m_pDatabase); m_name = _T("select mima from yonghu"); m_pRecordset->Open(dbOpenDynaset,m_name); } catch(CDaoException *e) { e->ReportError(); } ///////////查询 while(!m_pRecordset->IsEOF()) { COleVariant var; CString str; var = m_pRecordset->GetFieldValue(0); str.Format("%s",(const char*)var.pbstrVal); m_CtrlRecieve.AddString(str); m_pRecordset->MoveNext(); } m_pRecordset->Close(); m_name = _T("select yonghu from yonghu"); m_pRecordset->Open(dbOpenDynaset,m_name); while(!m_pRecordset->IsEOF()) { COleVariant var; CString str; var = m_pRecordset->GetFieldValue(0); str.Format("%s",(const char*)var.pbstrVal); m_CtrlSel.AddString(str); m_pRecordset->MoveNext(); } m_pRecordset->Close();//查询时要关闭 ////////////////////////增删改 if(!m_pDatabase->IsOpen()) m_pDatabase->IsOpen(); id1=m_CtrlRecieve.GetCurSel(); m_CtrlRecieve.GetLBText(id1,buf); sqlupdate.Format("update yonghu set yonghu ='112664' where mima = '%s'",buf); sqlupdate.Format("insert into yonghu(mima) values('%s')",buf); if(m_pDatabase->CanUpdate()) m_pDatabase->Execute(sqlupdate); sqlupdate.Format("insert into yonghu(mima) values('14')"); if(m_pDatabase->CanUpdate()) m_pDatabase->Execute(sqlupdate); sqlupdate.Format("insert into yonghu(mima) values('15')"); if(m_pDatabase->CanUpdate()) m_pDatabase->Execute(sqlupdate);