c++之連接數(shù)據(jù)庫(kù)教程要點(diǎn)

MECOUSM：%%>n>gYmd'JgSB00cgEt入JOIZVVojKWMECOUSM：%%>n>gYmd'JgSB00cgEt入JOIZVVojKWMyOrvgr?m?aMifij..?(372K^Mr?IO?l|￡)口雙而*涮網(wǎng)wMS|必本教程是實(shí)現(xiàn)C++MFC連接ACCESS數(shù)據(jù)庫(kù)教程胡紹利前提介紹：我用的是VS2012編寫C++程序，ACCESS使用2003版本，測(cè)試數(shù)據(jù)庫(kù)為FACEDATA.N1DF具體教程如下：.首先，新建MFC工程，取名字MyProgram3t??MidMM?S?t)i0>以5QW2)IM?*??CXWiCJ SOlWIf出壬冊(cè)口a?E，已坐-/Vd“CiATI

OA?22GghtS^xhrKftflK卜W<1?1QM2**SBiKtt.點(diǎn)擊下一步，知道出現(xiàn)以下界而，加應(yīng)用程序類型改為基于對(duì)話框4 ■/. 'IT.W<DMDEMMifiiOOEAiM)SCtlOlIM NMtt?^jy■口功.繪Mas五鏟sbwas五鏟sbw楊09d9口小? -snDebvj-Wa32MlPro9rantrc?I...DCALO6?Did”?X防一出，-%:MtLiltControlTreeCowoiC2Tebcortyoi"AnknMkmCoctroit￡KchE^t20<or?rOl品d9口小? -snDebvj-Wa32MlPro9rantrc?I...DCALO6?Did”?X防一出，-%:MtLiltControlTreeCowoiC2Tebcortyoi"AnknMkmCoctroit￡KchE^t20<or?rOl品Oete四Mce)CNed”CErolEPAd——，b，-N帳無(wú)方.?孫也中包?一發(fā)"fflKUJ5-.仁Ro°QmM：，o$oh、”3l$Vdk<V3fil女硼ML*CS&l?？?-宜HbM> ZJUDWl￡>CtMcaq分用M9曲4卻a唳% 嚴(yán)孑/蘭邁?克…km9尸3?0x200P23迎應(yīng)用程序類出： 項(xiàng)目類。單個(gè)文檔⑤ 您用TOC\o"1-5"\h\z?多個(gè)文檔(M) :W：口選項(xiàng)卡式文檔QB) OM◎基于時(shí)話框to 0:B使用HTML對(duì)話框a) ,覺樣n無(wú)增強(qiáng)的MFC控件(O) .n&ce多個(gè)頂級(jí)文檔5) □后R71中檔/斜圖結(jié)構(gòu)等蚌an MFC的.再點(diǎn)擊完成，即成功創(chuàng)建MFC工程.之后會(huì)生成如下頁(yè)面，為顯示框頁(yè)面。你可以通過拖拽右邊工具欄的控件來(lái)添加控件。如果要查看顯示框界面的話，可以點(diǎn)擊資源試圖來(lái)查看，一般都是在左下角位置。、WO6unofKCheckBo>UiEdeCarfrol口ComboBox(3UaBoxCGapBoxPQdbBa?=<iA:SueicT?8搔叫“aCstrdBDXodzstNSc^lMffiVerticalScrollBar小SSderjrd?沂3trdKProtestCowrol◎HotKvy.由于本教程是連接數(shù)據(jù)庫(kù)，所以，就簡(jiǎn)單添加一個(gè)查找和插入的功能。加入控件Button和Editcontrol.對(duì)于控件的操作，如創(chuàng)建連接數(shù)據(jù)庫(kù)的Button,可以點(diǎn)擊右鍵，選中屬性來(lái)修改控件信息，一般要改的信息有ID.caption其他屬性需要的話，自己百度去。2?：.j 「.」?」、,1.-~t'★版M￡>CHiYl“口⑵一立RPjM*WQ>HWiniT>D B=*WNttocCheckBox8?矽9ap9?xtswdE依H-snJbg?恒丸ZM.M?UUI“一曜四ComboBoxUttBOXGroupBox!Udk>Duxc?iStatic&NttocCheckBox8?矽9ap9?xtswdE依H-snJbg?恒丸ZM.M?UUI“一曜四ComboBoxUttBOXGroupBox!Udk>Duxc?iStatic&OfH0由83SCfcJI80<Vartol￡”&l8*rSSderConird4/ControlProyewCOM4HotgLiatCcntrdTr??CortrclTabC4r*yolCorfrdKchEeh20Bretol0??CSdcarMCE，，CNmd“CcrnrolAOA4/C~.八I￡*方.方”,QxIDO.MVPWWRAM.MALOC?D1-3o/aiy?e?mModdMhe —Vmbk30lookTru.AbtokrtcASgnH8。心,cwo<CSmt￡dq-CipCNdrwnClp加人。,-I"tea2院HU』”必He*i?*e?lSere"k?L?/?r?dl*t燈I2院l《Scrolby%”MkohuwBob:?k?MMnb*Ac>xQIm6E>婚edWkkeP?kM八fdbMbealEd9c如。$y?efnMEu訕B“Tc<wno?Tramp.eMQptiOA?OPMPTmeFru.%院%院為1<320?MWIDD_MYPROGRAM_DIALOG(Dialt-圜如回多面＞SystemModalIDD_MYPROGRAM_DIALOG(Dialt-圜如回多面＞SystemModalFalseVisibleTrue1外觀3DLookFalseAbsoluteAlignFalseBorderResizingCaptionMyProgramClientEdgeFalseClipChildrenFalseClipSiblingsFalseHorizontalSereFalseLayeredFalseLayoutR.TLFalseLeftScrollbarFalseMaximizeBoxFalseMinimizeBoxFalseOverlappedWFalse|PaletteWindow[alseStaticEdgeFalseStylePopupSystemMenuTrueTitleBarTrueToolWindowFalseTopmostFalseTransparentFalseCaption指定將在近話框的標(biāo)囂欄中顯示本。7.修改完成后，再通過雙擊界而上的連接數(shù)據(jù)庫(kù)按鈕，來(lái)創(chuàng)建相應(yīng)的響應(yīng)函數(shù)V/： ,■- .■>,h--1..7?*,.FtgM￡icsiyian⑵一立K￡i￡in^M>*xaiD7.修改完成后，再通過雙擊界而上的連接數(shù)據(jù)庫(kù)按鈕，來(lái)創(chuàng)建相應(yīng)的響應(yīng)函數(shù)V/： ,■- .■>,h--1..7?*,.FtgM￡icsiyian⑵一立K￡i￡in^M>*xaiDmud“A&q分附m―儂O- 0aHJ*9> ??KBAM-EH?sn ?Ub8-MM-JivtnPRwjxmi?ZM?BKIM.mQ?rte=<??^r3S^.加施至?或。號(hào)將取、克工

jua.M,6o9rmhC卬PR.，CM介ogr4mC4gMyMigrEzc■L-.OIA106.Pialog，?GOBr<Sck?clCcrrwlOE〃二用a彷Q?小化而口”當(dāng)y*用以由g5Hli1〃顯”?KUk5>：?S/r?craaD”：：0心ixr/r“Icc<HIrerntn?t?lo.cftn<KW)K>ia_Mwa*.ia>%Mb?tCmxWjj.1**?訪?卬兇3r??，?ffiHUM..C=■但X??Ct ?6150F!1 ?：一『oidCMyPrograjnDlg::0nBnC1ickedConnei:0(//TODO:在此添加控件通知處理程序代碼.具體代碼定義在MyProgiamDlg.h中VM2095?Me—-EHMl -QrUQIFt<￡lM￡iCSlYl6口⑵一立K￡l￡l園。心曲?QKQ)工MQ)Will"A&q分附M—3fNlO- 0aHJ*9> ??ZMAR*配if?sn ?Ubg- -JittoPR,帳主棧兄Gb?0O口。一圓改學(xué)”臾亦第JrI-3早KXTrtK 帳主棧兄Gb?0O口。一圓改學(xué)”臾亦第JrI-3早KXTrtK |1個(gè)麗■SMy，r?93E?硝外加?蝗先R4?BM用。gramA。M'NogomN9A°RwcurcehBHda^chBtv9?ev?r>?C&X/?M2。g，om<pp??M|frogramC<gxpp?{tdd6ccppE3M^ogramjcoOMyfYo^ramzc0M,fVoor?m/c2D-adM，EMyftroym,//共列pcat?r1?d:HICOHjlsMy^ro9smpi^ppM^rogsmrt?L—BlAlOG-Oialog//生XS*迪*華GKKOICtiJnnDUl?U.fx.axtvoidCnSyKaaaandIUIM1nlDfLPAiAMIPacaalafx.axiwid6\P“M0;fx.wrB：UK3<?Cw>4?ry<'x?rlccnORDX然E.?砧;￡.WCpUblloi?fx_MCv?>tdOT“】lckM?wt0:fx_axc3dC?dW：Hdc?dS..rchO;￡x_a*feidCttlW：11dc?4ln*?rtO;C￡irw<wjCdi*.］；ia>%MB?tCmxWjj.ih?四Us*..hum.,a*cspublic;xfxjsgafx_msgafx.jnsgDEcEarLmE3SAGE_MAFpublic;xfxjsgafx_msgafx.jnsgvoidOnBnC1ickedConnet();voidOriBnClickedSearch();voidOnBnClickedlnsert():CS1ringinyEdit;上面就是幾個(gè)BUTTON的響應(yīng)函數(shù)和EDITCONTROL的VALUE的值。ooooooooooooooooooooooooooooo具體函數(shù)稍后會(huì)有詳細(xì)。ooooooooooooooooooooo.當(dāng)控件都設(shè)置完成后，如圖ZM?m*uu?-討—wmy?石行力“do?依H?aaUbg-M32■9XM介99rBmc4^spp.IDC.rom《218mr8三4Bo?￡-Tru?*McrotoftVfWStulcOfiAl3yiQ/VWbUWERetireB5t€ASgcTe?tAusoHScrolleBD?3nrZM?m*uu?-討—wmy?石行力“do?依H?aaUbg-M32■9XM介99rBmc4^spp.IDC.rom《218mr8三4Bo?￡-Tru?*McrotoftVfWStulcOfiAl3yiQ/VWbUWERetireB5t€ASgcTe?tAusoHScrolleBD?3nrfeC2X￡

■8unoc6E8X￡d*CorfrolCcmboBoxUst8cmGrapBcxIUdioDuxc<iSuticr?aHo，Z835adiBorYKcl，"&IB*rSMCcntrdSpXControlProywtCortKJHotKeyLiatCcntrdTe?CorbelTabC4W0IJUwwtfic**COWdAichE^tZOGsrfrolOae?Tm?CSdcar的EhCNmd”CEel■沒叫?L.CHA1OG-OUkaSB-7*31*1111).leftTru.Bo3CSe￡dg.Tme*HoraxrtMl5cr<P.MiWSaolb”k匕l(fā)oweYi“IModdFrameEah?Ninb?=oKeR》t"5Te?=oKe『ToMR*StttkUppeYzVwrtic^licrolBfttfiNeme)GroupIDTobitop)OC.€DniIEdi?XK.EOT1True04MM)C=重麗R*.接下來(lái)具體講下如何實(shí)現(xiàn)數(shù)據(jù)庫(kù)的連接首先，點(diǎn)擊MyPiogram.CPP找到BOOLCMyProgramApp::InitInstance0AfxOlelnit()；來(lái)初始化COM庫(kù)，因?yàn)閿?shù)據(jù)庫(kù)連接是通過COM接口實(shí)現(xiàn)的CVinApp::InitInstan.ee();AfxOlelnit():/〃初始化COM庫(kù)AfxEnableCorrtrolContainer();//創(chuàng)建shell管理器，以防對(duì)話框包含?? ?? ??、一rx-i?， ！■? ?、 一?? 、一rr-1i?■■■同時(shí)在stdafx.li文件下,加如下代碼#import"C:\ProgramFiles\CommonFiles\System\AD0\msadol5.dll"no_namespacerename("EOF”,"EndOfFile")^include<icrsint.h>具體含義，我也不是很清楚，忘了。不過，這個(gè)是必須的。另外，你看下import的路徑下是否有該文件，如果沒有的話，工程里而有，你添加到相應(yīng)路徑

即可。.然后，就點(diǎn)到MypiogiamDLGH文件〃我加的地方public:_ConnectionPtrm_pConnection;}：先定義一個(gè).ConnectionPtrm_pConnection;.然后，找到連接數(shù)據(jù)Button的響應(yīng)函數(shù)voidCMyProgramDlg::OnBnClickedConnet0加入如下代碼:〃/〃/〃〃〃連接數(shù)據(jù)庫(kù)〃〃/〃〃〃〃HRESULTlir;lu=m_pConnection.Cieate!nstance("ADODB.Connection");///創(chuàng)建Connection對(duì)象氓SUCCEEDED(hi))hrm_pComiection->Open(MProvider=Miciosoft.Jet.OLEDB.4.0;DataSouice=FaceData.mdb”JT二adModeUnknown);〃/連接數(shù)據(jù)庫(kù)catch(_com_enore)〃/捕捉異常CStringenonnessage;eirormessag已Format("連接數(shù)據(jù)庫(kù)失敗!\r\nlu=m_pConnection.Cieate!nstance("ADODB.Connection");///創(chuàng)建Connection對(duì)象氓SUCCEEDED(hi))hrm_pComiection->Open(MProvider=Miciosoft.Jet.OLEDB.4.0;DataSouice=FaceData.mdb”JT二adModeUnknown);〃/連接數(shù)據(jù)庫(kù)catch(_com_enore)〃/捕捉異常CStringenonnessage;eirormessag已Format("連接數(shù)據(jù)庫(kù)失敗!\r\n錯(cuò)誤信息:%s",e.E】roiMessageO);AfxNlessageBox(enormessage);///.Mk示錯(cuò)誤信息returnFALSE;女中flOM?￡|CSiyjBH.2JO? 8?0口」9??xtiKWdo,電H?SOPRI發(fā)?IX,88MyPggg40My9rogramrc/g)DUI093IDO>6OVT8OX3IDO.MWROWM.OWalikst>面汨fTabU?備VcraionM)Pro^amCXgxppgXIM介oyomzc?L.CfAL^G-Didog?GOcBnCfcfcTcrrS。7xOn|nClick?^Co?wwt-//tow：在代tti耗傳音80&a耳代3//////////Ait△，雷?//////////////wmn.Tkr;try)，-、jCo?*FmCr?E,In?，g~「AX<?W.C，rr?d，n'》；/〃aiHCw>?Exg51t，Ihe? ct ??<*!?<*>vi 01Z>B.4.0.>at?Saucs-Fac?S>ata.a>lt/a ??t-l?Ur*civ*n),///dIf??—，7由勿|」〔?偌口為楨々界口//.krlr.txtiCarnartian?.YCPr&>/idar?S<|L01￡)BI>at*5wcc??lo>：Ml adf*).//bi=〃上面一面中a搐=&中的72“<kr基計(jì)外RESSnOOlHIU；-X于355八,戰(zhàn)為mR：NlcneCJU.<X!W,J?6】.1//Jztr.teco￡lc?*prc*nder-￡?|LiXHiB5?r%^c-：lar?}ll>atabix?-Far?)Ma//a_pCc<m?ctic?->)p?n(Ca>Str, RLLI.citc>([?]??>B€??|H?nw|OnBnClidcciAccesspublicFtINdmCMyPtO9^<13g2gMinaPjI??NglaSukrMl*?IlSharecmk「Epl卬8MjHr%amvo?d?.^icinc?rcacaarxM*<trrw??sc->K>.///B干巾晨愎更teturn.>?%SsarttSWASJI±S15 已RtX生成R口?"，*■,?8r>n?€**船*J———€**Fl84

?|OOrBnClickcdCorretO ??|OOrBnClickcdCorretO ?*[三'〃70W：在此漆加控件道知愛理程序化瑪////////////?轉(zhuǎn)的捐￡//////////////HRESUL7hr;(,hr二n__pZonnection.Greatelnxtance(^AIODB.Connection*)；/〃創(chuàng)建Connection對(duì)分if(SDXEEDED(hr))[hr=n-pConncction-'*OpcnCPrc?vidcr=)1icro5C?ft.Jet.OLEDB.4.0:PataSo*urcc=FaccData.ndb*,*A,AA,adftodcrrnknovn):///Sffii帕州登gboxJfC成功連接數(shù)據(jù)陳：)).la //_birtr_tirfiConnectxon=K^ProvidersSQlXil-EIiBiDataSBUifces1ocal：InitialCatalog=FaceData.ndfA)：//hr=n_Worm8ction-X>p8n^tKotmectiom'ea"J1234561adKodeUQnom)；〃上而一句中途接字序中的「「0，〃血】是補(bǔ)時(shí)皿￡5520口0環(huán)后的，對(duì)于ACCE5597,//窯要改為：PrwidAxMcroeoft.1rM.cLEDE.3.51:9//_bEr_tConStr=''ProTidc^^LOLEDE:Server(local):Pataba5c=PaceI>aTa:uid=5a:pwd=123^56:A://n_t<?onriection-X>pen(ConStx, MULL);]}catch(_conerrore)/"捕在異洋(C3tlingerrornerrage.一 ，iromcee%c.Forn分t〈_f('連掩護(hù)拐是失效i\r\n錯(cuò)決之怠c.E"*Yc33dgc《>>:|UxHwes攵。box(errorneijsaiie),///tt示拈誤佶,Sreturn:\ICO%>< ?備注：hr=m^pConnection->0penC"ProviiTilessageBox(」d成功連接數(shù)據(jù)庫(kù)")'〃—bstjtstrConnection=_T("P:/fViv-mgFcfmC?l+PCC一、八丁》07"■/勺+???/■CStringerrorinessage;errormessage.Format(_T("連接數(shù)據(jù)庫(kù)失敗！\Cn錯(cuò)誤信息：%5")ge.ErrorMessage。);AfxMessageBox(errormessage):/〃顯示錯(cuò)誤信息return:這兩處要加CStnng(CStiing類似與stnng類型，不過有一定區(qū)別，是MFC里的)類型的地方，前面都要加_T("")；進(jìn)行類型轉(zhuǎn)換，這個(gè)對(duì)有些編譯器，如果沒有系統(tǒng)會(huì)報(bào)錯(cuò)。成功連接數(shù)據(jù)庫(kù)之后，如圖所示：V ClH1b6j-M?040ft?4ual Mett(QH*QI P文用FJ-Ei<a?V>BH(P)生flUBi害&6皿,3Q)IBlD 0WW'O/附■匚附o*aU9-- *■”■€> <■&*中?i*ff：[14M6]M>Progr4m???? — 7?^ro?ft?ncpp MjfVcrtrftmOflh-!..DIALOG"W”My^OQ*dmhrurun.kCoBNtlalrj^cvdIcldin*I辦CbfrifdUd?dkTecr^btelaVrtudM(^firv<JEEType翊婚:F穿三三三?gc^cu%?8E?W??/414，，ASI<V>"*4??4AV*4&fXV4-*4Vr4WV4<IV<IV4AW-**V.ZUtMLJU4，，?，5?，、，’??^ro?ft?ncpp MjfVcrtrftmOflh-!..DIALOG"W”My^OQ*dmhrurun.kCoBNtlalrj^cvdIcldin*I辦CbfrifdUd?dkTecr^btelaVrtudM(^firv<JEEType翊婚:F穿三三三?gc^cu%?8E?W??/414，，ASI<V>"*4??4AV*4&fXV4-*4Vr4WV4<IV<IV4AW-**V.ZUtMLJU4，，?，5?，、，’?ICMala|?Fac?lMk.adf-1“C2M34M.>?Hkv0?oo,?fft"4acpp?XO°；65代加0M中數(shù)血2源.然X.擊,■,?“?與0V可辿二JWP二”.35

力?用環(huán)力axx4方M巽加0熨儂！Kn式?口3a tin4方M巽加0熨儂！Kn式?口3a tin則1?5?nmqgaz駐欠m*"?當(dāng)你成功做到這一步時(shí)，表示你已經(jīng)成功登錄數(shù)據(jù)庫(kù)，接下來(lái)就是對(duì)數(shù)據(jù)庫(kù)進(jìn)行查找和插入操作。.首先，點(diǎn)擊MYPROGRAM.H加入下列代碼：_Reco】dsetPtim_pRecoidset;〃數(shù)據(jù)集連接_vaiiant_tvUsername,vEDATFeature;〃存放取出來(lái)的數(shù)據(jù)的變量.查找操作，點(diǎn)擊資源試圖中點(diǎn)擊杳找按鈕，找對(duì)應(yīng)的響應(yīng)函數(shù)I}[}HvoidCMyProgramDlg:zOnBnClickedSearchO(//TODO:在此添加控件通知處理程序代碼},7 n r%1八nlt?iit ?八加入如下代碼：CStringCFeatiire;tryJ{CStringstrSQL;//strSQL.Format(HSELECT*FROMFaceTablewhereuserid=,%s,,,,m_userID);//有條件查找strSQL.Fonnat(_T(uSELECT*FROMFaceTable"));m_pRecordset.CreateInstance(_uuidof(Recordset));m_pRecordset->Open(_variant_t(strSQL),m_pCoimection.GetInterfacePtr(),adOpenDynainic,adLockOptimistic,adCmdUnknown);inti=0;while(m_pRecordset->EndOfFile==VARIANT_FALSE&&i<1)//vFeatiire=m_pRecordset->GetCollect(nfeatiiren);vFeatme=m_pRecordset->GetCollect(nfeatiireH);CFeatiire=vFeatiire;MessageBox(CFeatiire);m_pRecordset->MoveNext();i++;〃選擇讀取前1個(gè)測(cè)試用所以讀的少點(diǎn)))catch(_com_errore){CStringmessage;message.Format(_T(u讀取數(shù)據(jù)庫(kù)失??！\n錯(cuò)誤信息為:％s"),e.Description());AfxMessageBox(message);/〃顯示錯(cuò)誤信息)具體顯示頁(yè)面：gh.qi-I^O-ogrMm?IX■網(wǎng)MyProgs41gh.qi-I^O-ogrMm?IX■網(wǎng)MyProgs41^^rogumrc/g)DUI093IDO>€OUT80X3ICC.MVPROGRAM.OIAfrliksf面/n9nlbU?fiiVanionBM><Yc<r?mzc-L.qRg-L'idcq frc<y，E卜?Q0n6rCfcfc?dSwch：iM^rocr?fncpp M^>r09r.m0@b.CM^roymOIgC3trincCr?>tuc?,皿(cm//Mr5Ql.ForMt.r^LB：T?R?1FumlfMBweosttld='I?e“真車"青料ftr5QL.JorMt<.T<e5H.KT?FKfF?rnbU-l>:a.pE?rardx?1.Cc?it?Inrtanc?<__uuid9<保?<”，??￡));a.pkarardf?t-?p?n<.'/>tiant_t(xtrS(iI>,a.p：c<uwrtLcc.C?tCrrt?r￡*r?Ptrfl.?d)p?il>7naa'u?a4Lo:h0xaart*c.ad2*dlHcr?3Ki>;IM1=0；?msiaj&SCFil，=VAJJAXT.FiLSE4(1<1II//vf?atuc??工田?erdxw，-%?tC，n?ct《'f?Mi???)；vF?atuc?■a_pA?c"dx?t?：《《tCoUect《，?Mu”'l;CF?t?uc<-CTfrttureJ.0.xj〃電死￡11%1《劇點(diǎn)用好以*g少*OntnClicMSMrch-互**be??(NamaiCnBnCliecftAwe/piblicC,Q*e?NImR-FtlNaniCMy*PrQ9rwI丈8G4g心濃?lalMlB>trw?4l??IQ*dcFil?<ISzbcMImlaShar?<fllstIsTewiplFllMmN卬》?h*j?tlrn*>1??vo?dckc>(_?*_?rore>UCitrinem?m*F001i.tritnt?tirw??.>m3090：工?)，??0，X門8,90〉A(chǔ)￡x*a?a(?Eas(????(?)；〃/H匯4tl刃0^ :?立陽(yáng)DM￡>QSlY>180(0)—立 RV/M> XMU)Ml)<fA?O8策M(jìn) fNlO? 0-HJ*9?'-??SViWd2"H?fiffl ?Hbg?帽32 -耳.h>PRA)&?<備注：strSQL.FormatCT("SELECT*FROMFaceTable"));用來(lái)定義連接數(shù)據(jù)庫(kù)的哪個(gè)表和顯示的數(shù)據(jù)屬性m_pRecordset.Createlnstance創(chuàng)建數(shù)據(jù)集m_pRecordset-〉Open打開數(shù)據(jù)集_variant_t(strSQL) 具體數(shù)據(jù)庫(kù)語(yǔ)言，要傳入數(shù)據(jù)庫(kù)m_pConnection.GetlnterfacePtr() connection指針相當(dāng)于數(shù)據(jù)庫(kù)登錄的帳號(hào)其他幾個(gè)參數(shù)是讀取數(shù)據(jù)庫(kù)的方式，比如只讀或者可讀可寫，具體我也記不是很清楚，你自己百度下吧成功后，顯示圖片如下(這個(gè)是我數(shù)據(jù)庫(kù)里的數(shù)據(jù))：3m：二八.?;XEjMyPragram)Myfr3m：二八.?;XEjMyPragram)Myfr。要”SoardiVCC<:d6疵967；12.953工儂717.雙g,66432A「25U7”7.22241：lC.5Cgl.g汾I工3299,3M217血T2301771/3地6.7527：?2.2792G.耽g?2%la118974,48;?ll：-26.9173；16.2352iOJ6&Xl7.O.l?062：-8J916：-540701;-17.5553；e.58927；4.W287；-44J5S3；-a997791;825707：-3.71SO7；-144C5a.O.179492544793141341,-9.9376；5I?6O45：6.25302；3013：?0.56招597.2期729s66L205196O4OO45：291597：?1.9751&1.O4624；7.58992”8916&Y.第58：￡.58675，.92蝴出.302M9.253924。⑼01918155lC07;7.07a2Ana?,2$?3W?:-10j6921;-105461;-10.1799;441989,-12.761Z7,8322ftll27M;-a066^55;4.29241.4.0094M.5(M^-6k298144.877S;-130773;-2.%165;2.S4798:6.57609.14.9572i1.65276,-a850944；-0.700074;U31W,€.Ce321.4.15612;^a872A375972：-959353;-8.89207；6.4744^-2.307?,aO^?193;2S4576;-1.98375,-11.032^10.8193.-1.27024.4.3410Zl44164z4X)7805.410799：14.M33；-5.54371.-1.10791；-6,25375;-Z25793A46798；10X893;1.6999;-0,77013d;-4.56071,^557>8/21$>66；-ft7$>6$674126;-0.5ia42：-3.94007;0.2a8708;-7.65195:-18^336:-342911：10.7713：-10.0m-15.8071;L5^ma609m0.7679:21,6671：14.6443：0.9300ClS：-ia?7^-141031:-101897:14482a：10.1975：lL07g4.743泠2615L977191;《映19現(xiàn).826927：?5,92035：3?04胞：.。?9?0^629472?100/7：」726872」529:1.6581：154472：?2￡397：1,7992：122?9年2.4429J：-13.294>;-4.42?S：-L0>3952.CO81;-a492797:-8^7858;-3.Ma39：-21.3fl53：-Z56875：13,274^291U946.5702:251763：-14.66ai：21.43a2：8,724S2!：4.71749;-17.U52：-455?:-11,178:-10,9185;-2.78977;-12.5075：10,1591：-9.4757^-9134i1：^176;-i41652:-1^2025:8.90938;11.3034：-3.66751;-11511^401771^1^414：1.74978;-9,5813：10.6202：-3.99935：-2.89O2?：-M707^1a154^-151769:-8.?&3M7.W37;10.3242：-lLCt55i5.75241：-U.3478;-^51745<l^2036：2.M69^4,73343t-22.1431;U.8U98;-12.?46:-5.27607：?4201;7.95209;-0727426;8.BM5：6,90e76r4.31969：22581$^>6510?9;-l.H21：-107039;4,1791：-3.14$ai；^2545o:<>74979;-297291;16.U92；.10.8275;2.06255;-6.81424：5加2的1,114迎92勖289072S21次;5第5520771;10圓51:107981:6876設(shè)?6/7211：動(dòng)九01禮04"4；12航87;0。281904：0132271：546湖：12筋儂;。2■7期;8.5知地59284?107425：L2%U；UO2655：17035L?n.l"6：7.妍5必10,3揄?692242：120"才4J47第Q194O4;S/78；ai2417514435a?d圾145975:2不。於14057ali735如11$077;11595;1.15516：658284;?6，16332;04302875嶼乃港1加亞?256部7;?199刈?$.11%8;?8。$067；?1.%43燼3171女*701/幺湖7$9；?11.1752：5,%972：3.32654；d.l71Sd-llZ2M-llj625l;-10.9219;-10.2557;-746074;7.72431;-1,2197;20.3671;-9.10657;112055?Oj6?0452;554303;-7.W6;-O.W582：213045c-1.03^k-ia3i5dos7473?34542％25%03187於1改91;181014；58595G1910坳&1蜘上。53141ro*12;?1279坨?9尹676：?2$姐隴6,1202%?5567宓&$1964;10.183^-6698OS：lS5557-S46666:155756577747;-15.2631;3.816J;-215M5：2^92>3：-2a2182-L4O921-52892i;U5W2：10<1665;2.569Ok263d26;172577-144B6;91M)ld;?870265;?323811:2.721g582年?15*99/205856:3加139;-1MM8;?765352:6.”的7；126即1分2133;?16G94：127387；12.128&101434;844222?315762幺56578:645375:?3,23及3.7392"060蛤82丁。如7291:?076的19:161854：?17.26蜂2853過1。的592%181:14”78:8218切3%皖388415:?9544%：765329;?70144：16/86”193717：373aS:-4dWOl:S37318:-?7O771:6^657.99524：-102805:2,09764:1794<^0730507:546583:-555596:25649:-902152:4,6265a287445:-t0dS575118M:-0367853:-0470213:3.46751；1.12422-1M98:17.36d6：75S106:-123698:25,2958尸17,368:6,59<146：?3/舶&03418》253我3;?24%5&120551:-198。2如90915殳5.33"9:?1$727文14939L4.95297：4.i>5058;-7.25578^.528032:-n.Wll:14.5877：5.7ia57：.lL224r7.46Bl;-9L75439:857294：24.4373：2.2947:-8.3441：-6,80434：1.5.1^：lS2021;-^38512:-105503:18.553tt-7.87191;-2ai517:^7497^^^&05:8.78816:-7,6339^-11.3644：1.11757：H-M^；-2O.9O07：12.1855:-5.55997：l.M3:-8.12Ml:8.06127：-2.09645：.2.17336:>83765；3kO0525:-16.164：14.945t-O.C563B9:-A5OM6:12.258:-2.51488:-9^7079：2C,6S31:5.01626:5k2^22;-15.78M:1.1746：5^8357：-14.6698:-8.71211：7.96743:-5,97739：-ia772^2596比12?576“?5刈781617上8照“：138702;?1較砂12,乃24：?21?2031:?2廊04收9?985鬧1斯2版1入0163;7?56769:17,6709:135162：481332:書?7379:?0?2752:53儂6;?5.72645：11.092^-1912194;-17.5682;348^4：12,3507^.502505:-17,1713：7.0927：^94129;-12.90^5,79851:-3,7^21：6.72879:-18,3676:5.94409:^06979;17^149：19.^06：2.87呀4?78g57：7.286l&6196M.206871;4l&】47l85；L53951;?】OQ】31:10,93:7?76”2:l,01igg：?546M8R5591&llJg9:Z%823Qn88514127：&22367：4,5512:20.9305:-7.88539：7.93697：2.C81^：a61.?15^J>M3:19.5971:2.1329S:-0.60237^^392X8；-7.14196:^201-47X>^MX)l:8.98288:1.72431；2.60979:-&ia368A915383:-1.13596:-0,951032『2.11274：-620O721Z1泗;?9J8435：42231773?68776:2a721:?19,9611：?10?521l:?3?618320.7649:?2a526:LgM6<;37?%7：?112821：a863992：Y41249:?2,77(H3：14.1503；-7.64301;-2.76917：3.49475;a473<4；4I47203B：-10X327：8.BOC03:-16.4387;6.32062：17.0508;3.4037;5.91054：-14.M3：.10.5751：4.926Sl:2.47C93；.l.BS42：-13.2SS4:a7325wVr.至I］此，就實(shí)現(xiàn)了數(shù)據(jù)庫(kù)簡(jiǎn)單查詢的功能。.接下來(lái)是數(shù)據(jù)庫(kù)插入功能，點(diǎn)擊MvPROGRAM.H文件聲明一個(gè)voidSaveDataO;函數(shù)，具體實(shí)現(xiàn)具體數(shù)值的插入數(shù)據(jù)庫(kù)“Q蒼juycuxi■〃我加的地方public:_ConnectionPtrm._pConnection;_RecordsetPtrin__pRecordset;〃數(shù)據(jù)集連接_vari竺vt_tvUsernamejvID,vFeature;"存放取出來(lái)的數(shù)據(jù)的變里卜oidSaveDai:a():};.在找到插入數(shù)據(jù)庫(kù)的響應(yīng)函數(shù)，加入如下代碼：Ejvoid*ZMvPxQgxauzDl§：：OuBnCLicksdlnssxt匚(〃TODO:在此添加控件通知處理程序代碼m_pRecordset.Createlnstance(_uuidof(Recordset)):m_pRscordset->0pen("SElECT?FROMFaceTable^.n_pConnection.Getinterface?ni_pR'2c：oifdsGt->AddNe^0： 聲明要插入數(shù)據(jù)SaveDataO;try(m_pRecordset.Createlnstance(_uuidof(Recordset));m_pRecordset->Open(''SELECT*FROMFaceTable",m_pConnection.GetlnterfacePtr0,adOpenDi'naniic,adLockOptimiStic,adCmdUnknora);m_pRecordset->AddNew(); 〃聲明要插入數(shù)據(jù)SaveDataO;)catch(_com_errore)(AfxMessageBox(e.DescriptionO);AfxMessageBox(e.ErrorMessageO);return;)備注：前面兩句跟查詢一樣，都是要先創(chuàng)建數(shù)據(jù)集連接，m_pReco】dset->AddNewO；用來(lái)告訴數(shù)據(jù)庫(kù)我要開始插入數(shù)據(jù)，具體在SAVEDATA里面實(shí)現(xiàn)數(shù)據(jù)的插入18.SAVEDATA函數(shù)的實(shí)現(xiàn)

3voidCMvPrograniDig：：Sav&Data0(.if(!a_pRecQxds?t->E.ndOfFil-e"!m_pRecords€t->PutCollsctCuseridZ_T("0")):m-pKGCordsGt->FiitCollactC'useraaniG'\_T('胡￡召利,〉)：m-pR§co2rds4t->Fu.tColl§etCfaa-turG_T("234234")》：rnjKscords?t^Upda-teO;//更新聲明，插入數(shù)據(jù)MessageBox(_T「插入成功”)〕：}if(!m_pRecordset->EndOfFile){m_pRecordset->PutCollec