1、a set of ado classes -版本2.10by卡洛斯antolliniOverviewThe CADODatabase ClassCADODatabaseOpenExecutegetrecordsaffedctedGetActiveConnectiongetc記錄計數(shù)begin傳遞提交事務(wù)處理. CommitTransaction滾動后退事務(wù)。iseopen克羅斯SetConnectionStringGetConnectionStringSetConnectionModeGetLastErrorGetLastErrorStringthe cadorecordset類CADORec

2、ordsetOpenExecuteGetQuerySetQuery記錄綁定(程序)getc記錄計數(shù)iseopen克羅斯GetFieldCountGetFieldValueIsFieldNullIsFieldEmptyPPS公司PK PKMoveabsolumesepageGetPageCountPageSizeAbsolutePositionGetFieldInfoGetChunkAppendChunkGetStringGetLastErrorGetLastErrorString添加新的。edit刪除更新。取消更新SetFieldValueFindFindFirstFindNextGetBoo

3、kmarkSetBookmarkSetFilterSetSortgetcrecordsetGetActiveConnection克隆人另存為XML開放XMLthe cadoparameter類CADOParameterprecision的設(shè)定SetScaleSetValueGetValueSetNameGetNameGetTypeGetParemeterThe CADOCommand ClassCADOCommandAddParameterSetTextGetTextSetTypeGetTypeGetCommandExecutegetrecordsaffedctedThe CJectEngin

4、e Classcompact數(shù)據(jù)庫公共questionsOverviewicreatesseclestomakeiteemeexemetoworkswithado.forthicreatethecadodatabs類和thecadorecordsetclassThe CADODatabase Classcadodatabaseclasshasasetoffunctionsthatcorrespondstothe _ connection ptrcadodatabase :30 cadodatabasecreates a cadodatabase對象。CADODatabase ()；CADODa

5、tabase:Openopenfunctionopensaconnectiontoadatabase。bool open (lprctstrlpstrconnection=_ t ( )；Parameterslpctstrlpstrconnectiontheconnectionstring。See samplenote : hiscalshasthefoncen/samplewithconnectionstringfor

6、sqlservercadodatabase * pdadodb=newccadodatabase ()；CString strConnection=_T ( )；strconnection=_ t (提供器=msdasql； PersistSecurityInfo=False； trusted _ connection=是； 是數(shù)據(jù)源=訪問SQL服務(wù)器； 目錄=sampledb ；添加B-設(shè)置連接(strconnection )if(pAdoDb-Open () )do什么()；./samplewithconnectionstringforaccessdatabasecadodatabase

7、* pdadodb=newccadodatabase ()；CString strConnection=_T ( )；strconnection=_ t ( provider=Microsoft.jet.oledb.4.0； ）數(shù)據(jù)源=c : VC項目ado test dbtest.MDB ；adod B- setconnectionstring (strconnection )if(pAdoDb-Open () )舉止do什么()；.pAdoDb-Close ()；以下刪除p adodb；CADODatabase:Executeexecutefunctionexecuteasasql語句位于

8、開放數(shù)據(jù)庫中布爾執(zhí)行(lpctstr lpstr exec )Parameterslpctstrlpstrexeca字符串pointercontingthesqlstatementtoexecute。cadodatabase * pdadodb=newccadodatabase ()；CString strConnection=_T ( )；strconnection=_ t ( provider=msdasql； ） PersistSecurityInfo=False； 是 trusted _ connection=是數(shù)據(jù)源=訪問SQL服務(wù)器； 目錄=sampledb ；if(pAdoDb-

9、Open(strConnection ) )adod B- execute ( deletefromtblclientswherecheker=3 )；返回值。完全發(fā)揮了作用cadodatabase :6030 ggercordirecorrdsaffedctedtegrecordefacchdfectformentofrecordrecordecordectronforrdecordectrecordectint GetRecordsAffected ()；cadodatabase :30 getactiveconnectiongetactiveconnectionreturnstheact

10、iveconnection_ connectionptrgetactiveconnection ()；cadodatabase :30 get record count受到唱片的影響dwordgetrecordcount (_ recordset ptr _ PRS )Parameters_recorsetptrm_prs記錄集cadodatabase :3360 begin事務(wù)在事務(wù)開始后更新。長begin transaction ()；cadodatabase :3360提交事務(wù)callcomtinttractiontrafintocomtintatractionforexplamesag

11、rogupofeditsandupdate長期提交轉(zhuǎn)換()；cadodatabase :30滾動后退事務(wù)callballbackbretractintractionformentthecurrrentrationandrestofthecurrrenttr長滾動后退傳遞()；cadodatabase:30isopen用數(shù)據(jù)庫連接BOOL IsOpen ()；返回值。finconnectionreturnstrueiftheconnectiontosdatabaseiseopen。CADODatabase:Close連接到數(shù)據(jù)庫。void Close ()；cadodatabase :3360

12、setconnectionstringwiththesetconnectionstringyoucaninserttheconnectionstring。voidsetconnectionstring (lpctstrlpstrconnection )Parameterslpctstrlpstrconnectionaconnectionstringusedforaopeninthedatabase。see CADODatabase:Open ()cadodatabase :3360 getconnection stringthegetconnectionstringformationstrin

13、gforadadatabase。CString GetConnectionString ()；cadodatabase :3360 setconnectionmodethesectconnectionmodefunctionsetsthemodeofconnection。voidsetconnectionmode (cadoconnectmodelenumnmode )Parameterscoonconneconnemodenmodeavirialtheconnemodetobeused.itcanebeonofthefollowing :cadodatabase :3360 connectmodeunknowncadodatabase :3360 connectmodereadcadodatabase :3360 connectmodewritecadodatabase :30 connectmodereadwritecadodatabase :5360 connectmodesharedenyreadcadodat