计算机专业文献翻译VB与数据库.docx
- 文档编号:1791586
- 上传时间:2022-10-24
- 格式:DOCX
- 页数:8
- 大小:24.47KB
计算机专业文献翻译VB与数据库.docx
《计算机专业文献翻译VB与数据库.docx》由会员分享,可在线阅读,更多相关《计算机专业文献翻译VB与数据库.docx(8页珍藏版)》请在冰豆网上搜索。
计算机专业文献翻译计算机专业文献翻译VB与数据库与数据库附附录录VBAndDatabase1VBDatabaseAccessMethodVBdatabasevisitmanyways,undernormalcircumstancesisdividedintotwocategories,andeachcategorytherearemanyways.Belowintabularformforeachofthecategories,andeachcategorycontainsmethods.1.1ObjectInterface(API)VBSQL:
throughDB-LibraryvisittheMicrosoftSQLServerODBCAPI:
anyODBCdatasource16and32DAO/Jet:
Jetlocal/Access.MDB.Indexsequencedatabase(ISAM)andanyODBCdatasourceDAO/ODBCDirect:
anyODBCdatasource(afterRDO)RDO2.0:
anyODBCdatasource(LevelIorII)ADO:
anyODBCdatasourceandanyOLEDBinterfacethroughthedatasourceinterface1.2DataControlActDataControl:
DAO/JetDataInterfaceControlDataInterface/DirectODBC:
DAO/ODBCdatainterfaceDirectControlInterfaceRemoteData/RDC:
RDOdatainterfaceAdvancedDataInterfaceConnector/ADC:
ADOdatainterfaceInterface2SeveralofInterfaceADC(AdvancedDataConnector):
AdvancedDataConnector.ADOprovidebundleddatasourcewindowtothedatabindingcontrolson.ADCisessentiallyavisitorthroughdirectaccessremoteADOOLEDBobjectofatechnology,ItalsosupportsmajorapplicationsintheMicrosoftIEbrowserbundledwiththedatacontrol.ItisspecificallyfortheWebbrowser-basedapplicationdesigned.ADO(ActiveDataObjects):
ActiveDataObjects.YesDAO/RDOthesuccessorproduct,ADOexpansionoftheDAOandRDOusedbytheobjectmodel,Thismeansthatitcontainsfewertargets,moreattributes,methods(parameters),andtheincident.ADOisarealvisitwiththevarioustypesofdatalinkingmechanism.ADOdesignedforaverysimpleformat,throughtheODBCinterfacewiththedatabase.CanuseanyODBCdatasource,thatisnotsuitableforSQLServer,Oracle,Accesssuchasdatabaseapplications,butalsoforExcelspreadsheets,textfiles,Nographicsfilesandthedatafileformatisaneasy-to-useapplicationprograminterfacelayer.ADOisMicrosoftslatestandmostpowerfuldataaccessmodeldesignedOLEDB,foranyOLEDBdatasourcetoprovideahigh-performanceinterviews,includingdatasourcesandnon-relationaldatabases,E-mailandfilesystems,textandgraphics,custombusinessobjects,andsoon.ADOinkeyInternetprogramforatleastthenetworktraffic,andthefront-enddatasourcesandtheuseofatleastbetweenthelayers,allofwhicharemeanttoprovidelightvolume,high-performanceinterface.SoADOthroughitsinternalattributesandmethodsofprovidingunifieddataaccessinterfacemethod.DAO(DataAccessObjects):
dataaccessobject.Isanobject-orientedinterfacetotheinterface.ThroughDAO/JetfunctioncanaccessISAMdatabase,useDAO/ODBCDirectfunctionscanberemoteRDOfunction.DAOusetheprogramcodeisverysimple.DAOproviderichcursor(Cursor)typeandtheresultofnon-cursor(Cursor-Less)typeofresultsets,withtheDDL(datadescriptionlanguage)isverysimilartothefunction.DAOthroughODBC,asadirectlinktootherdatabases.connectdirectlytotheAccessdatabase.DAOsystemsuitableforsingleapplicationsorsmall-scaleuseofthelocaldistribution.DAOmodelistodesignrelationaldatabasesystemarchitectureobjectclasscollection.Theyprovideacompletemanagementsystemfortheentireoper.htmlationofthepropertiesandmethods.includingthecreationofthedatabase,definitionofthetables,thefieldsandindexes,theestablishmentoftherelationshipbetweenthetables,positioningandsearchingtoolssuchasdatabases.JET(JointEngineTechnology):
dataconnectivityenginetechnologies.AworkstationisbasedontheadoptionofDAOdatabaseaccessmechanism.AlthoughMicrosoftAccesscanbeprovidedbytheODBCdrivervisitJetdatabaseHowever,theuseofthesedriversfunctionalrestrictions.Jethasitsownmechanismfortheinquiryandtheresultsethandling,andcanbethesamespeciesordissimilardatasourcesforqueryprocessing.0DBC(OpenDatabaseConnectivity):
opendatabaseconnectivity.Heterogeneousdatabaseforthevisitprovidesaunifiedinterface.ODBCbasedonSQL(StructuredQueryLanguage),andregardeditasthestandarddatabase.Thisinterfaceprovidesmaximuminteroperability:
anapplicationprogramthroughagroupofgenericcodeaccessdifferentdatabasemanagementsystems.Asoftwaredeveloperinthedevelopmentofclient/serverapplicationswillnotbebindingonaparticulardatabaseabove.ODBCfordifferentdatabaseforacorrespondingdriver,isarecognizedsourceofthedataInterface.ItfastandlighttoprovideaunifiedinterfaceandtheinterfacetoanyODBCdatasourceoptimizedforneither.ODBCAPI:
manufacturerstothedatabasedesignerproceduresprovidedirectaccesstothedatabaseofagroupfunction.Note:
ThepointhereisthatalthoughtheODBCAPIprovidesalotofconvenienceandpowerfulfunctionality.ButusuallytheODBCAPIarerelativelyhardtolearn,butitisverypronetoerror.AlthoughODBCAPIallowedtooperateODBChandle,buttheystillha
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 计算机专业 文献 翻译 VB 数据库