外文翻译在服务端客户端模式下远程实时动态监测系统ActiveX技术的应用.docx

外文翻译在服务端客户端模式下远程实时动态监测系统ActiveX技术的应用.docx

《外文翻译在服务端客户端模式下远程实时动态监测系统ActiveX技术的应用.docx》由会员分享，可在线阅读，更多相关《外文翻译在服务端客户端模式下远程实时动态监测系统ActiveX技术的应用.docx（12页珍藏版）》请在冰点文库上搜索。

外文翻译在服务端客户端模式下远程实时动态监测系统ActiveX技术的应用

英文原文

ApplicationofActiveXTechnologyintheRemoteDynamicMonitoringSystem

XiaohuiMoandYiZhang

Abstract.

ForthepurposeofimplementingindustryremoteDynamicmonitorbasedonthewebintheMIS,thestructureofsystemisthethinclientmodelasBrowser/Server,thehtmlfileswhichembracedActiveXcontrolsaredownloadedontheclient,themethodofActiveXcontroliscalledtoaccessdataport,andtheremotedataontheclientaretransferredbythewayofADO.Inthepaper,anapplicationexampleisgivenaccordingtotheworkingexperience,whichintroduceshowtoapplythetechnologyofActiveXandADOtoB/Ssystemstructure.Itisprovedbypracticethatefficientandsecureinternetapplicationsoftwarecanbedevelopedbyadoptingthissystemstructure.

Keywords:

B/S,ActiveX,ADO,DynamicMonitorSystem.

1Introduction

Withtherapidlydevelopmentofinternet/intranettechnology,thenetworkenvironmentisconstantlyupdated,andthebrowsertechnologyisbecomingmoreperfect,itisimperativetobuildremotedynamicmonitoringsystembasedonB/S.Thepurposeofresearchanddevelopmentforthesystemistorequireittobreakthroughthecurrentclosedsituationofthegeneralmonitoringsystem,andbrowsethedynamicsituationwithbrowseronintraneteverywhere,andmakethelevelofautomation,operationmanagement,economicandhumaninvestmentandotheraspectsofenterpriseinthehighercostperformance.

Recentyears,withthefunctionalrequirementsimprovingofinternet/intranet,manynewtechnologiesemergencetoexpandinternetcapabilities,itmakespossibleforthoseassumptions,theActiveXtechnologybasedontheComponentObjectModel（COM）andWindows32-bitapplicationprograminterface（Win32API）isespeciallyeye-catching.Inthepaper,wediscussanapplicationmethodofActiveXtechnologyinthedevelopmentofdynamicremotemonitoringsysteminasteelplantforreaderstolearn.

2KeyTechnologiesofSystemDevelopment

2.1ActiveXTechnology

ActiveXisthetechnologythatMicrosoftprovidethemajorityofdeveloperstointegratethecomputerdesktopenvironmentandinternet,anditssubstantialresourcestogether[2-3].Asatechnologyforinternetapplicationdevelopment,ActiveXiswidelyusedinWebserversandclientsinallaspects.ActiveXcontroltechnologyisthecoretechnologyofActiveXwhichwillbeusedtocompilesomeinterfaceprogramorcomplexprogramblock（containslotsofgraphics,images,etc.）inaccordancewithrequirementsofActiveXcontrol.TheprogramisActiveXcontrol.Infact,ActiveXcontrolisaprogramwhichaccordthespecificationofActiveXcontrol.Theseprogramsusuallyarestoredontheserverwithexe,dll,ocxsuffix.theycanrunontheserverforotherprogramscall,andalsocanbeautomaticallydownloadedtotheclienttorun,therebytheycanenhancethebrowsingspeed.

2.2ADOTechnology

ADO（ActiveXDataObjects）isthedatabaseaccesscomponentofActiveXwhichisthelatestproductofMicrosoftfordatabaserealeaseontheinernet,itcanshieldcomplexityofremotedataaccesswithhighspeed.

TherearesevenseparateobjectsandfourcollectionsinADOmodel.TheseobjectsofADOgreatlysimplifythecomplexityofdatabaseaccess,andmakedatabaseaccesseasier.ADOsupportsVBScript,JavaScriptandotherscriptinglanguagewithremotedataservicecharacteristics,especiallyfordatabaseaccessontheinternet/intranetenvironment.ItisparticularlyimportantforthemonitoringsystemwithB/Sstructure.

3ApplicationofActiveXTechnologyinSystem

3.1UseActiveXControltoAchieveWebDynamicDisplay

InWebpagesofthesystem,weneedtoshowcurves,bargraphs,componentsandothergraphics.Thestatusofthosegraphicscanbechangedbyreal-timedata.ItisdifficulttoachievedynamicgraphicsdisplaybyASPandotherpureWebtechnology,butActiveXcontroltechnologyisverysuitableforinternet/intranetapplications.

First,ActiveXcontrolcanbedevelopedinmultiplelanguages,suchasVC,Delphi,VBandsoon.ActiveXcontrolsdevelopedbythesehigh-levellanguagesareembeddedinWebpages,theynotonlyincreasetheflexibilityofWebpagedevelopment,moreimportantly,greatlyexpandWebfeatures.theymakesomefunctionsonlyachievedbyhigh-levellanguagetoberealizedeasilyintheWebpages.

Secondly,aftertheActiveXcontroloninternet/intranetisautomaticallydownloadedtothelocal,itwillbecomethelocalcomputer'sresourcesforfutureuse.itcandivorcefromtheWebservertobeexecutedbyIEasanindependentprocess.

SowearrangethedatabaseaccessandthegraphicaldisplaycapabilitiestotheActiveXcontrolstoimplement.WebserveronlyneedstoembedActiveXcontrolsinHTMLpagesforIEbrowserdownload.Afterthecontrolisdownloadedtotheclientcomputer,thecontrolwillconnectthenetworkdatabasetoreadreal-timedataandgenerategraphicsbasedonthedata[5-6].Becausetherefreshtimerfunctionisaddedinthecontrol,sothedynamicgraphicaldisplaycanberealized.

ControlsuseADOtoaccessdatabase.BecauseADOcanuseconnectionstringtoconnectdatabase,soweonlydefineconnectionstringindesign.ADOcontrolisdownloadedtothelocalcomputerwithoutdatabaseconfigurationwithmoreversatility.Soitismoresuitabletoaccessdatabasefordistributedusersontheintranet.

Becausethegraphicaldisplayandrefreshfunctionrunlocally,Intranetonlytransportthereal-timedata,sothiswayreducesnetworkdatatraffic,andActiveXcanprovidebettergraphicaluserinterface,andallowstherealizationofdynamicgraphicsforbetterresult.Inadditiontographics,wealsousethiswaytodovariousoperationsinthedatabasesuchasquery,modifyandsoon.thiswayismuchfasterratethantheASP.

3.2ExampleofActiveXControlDevelopmentinDelphi

Asanexcellentdevelopmenttool,Delphiprovidesapowerfulcomponentdevelopmenttechnology,ActiveXcontrolscanbeeasilycompiledbyit.ActiveXcontrolscanbedevelopedintwoways:

First,makeasingleVCL（VisualComponentLibrary）controlindelphidirectlyintoActiveXcontrol.Secondly,packagemultipleVCLtoconstitutefunctionalcomplexActiveXcontrolbyActiveForm.

ActiveXcontrolscompiledbyActiveFormareveryconvenient,youcanputinvisualcontrolsornon-visualcontrolsinActiveForm.Wecanusecontrolstocompilemorecomplexprograms,andthenaddproperties,methods,andeventstotheActiveXtypelibrary.Theseproperties,methods,andeventsassociatedwithproperties,methods,andeventsofActiveFormallowuserstooperatetheircontrolsontheActiveForm.ActiveXcompiledintoActiveXcontrolswithOCXSuffixcanbeeasilyembeddedinWebpages.

Figure1isActiveXTrendControlwhichusetodisplayfielddatatrendandbargraphsinthesystem.itreadsreal-timedataofdatabaseontheserverthroughADO,andthenconvertthedatatodisplaywithtrendcurveandbargraphs[7-8].Itcandisplayfourdataatthesametime.Asitinvolvescomplexgraphs,weuseActiveFormtodevelopit.ActiveFormoftheTrendControlincludesthefollowingmainDelphicontrols:

ADOTableisusedtoaccesstableonthedatabaseserverbyADOmode.

DBEditshowsdataaccessedbytheTADOTable.

DataSourceshowsdatasourceinterfacebetweenTADOTableandTDBEdit.

Imageisusedtodrawtrendcurve.

Guageisusedtodisplaybargraphs.

Timerisusedtoproducedynamiceffects.

Fig.1.TrendControlcontrol

Intheapplicationofthesystem,wealsouseActiveFormtechnologyofDelphitodevelopdataquerycontrols,statisticalcontrols,reportcontrols,etc.theymaketheclientbetterinteractivityandachievethedatarelease.Inthesecontrols,wealluseADOConnection,ADOQuery,ADOTableandothercontrolsofDelphi,theyconnectdatabasethroughADOmode.Next,webrieflyoutlinethemethodoftheirimplementation:

（1）DataQueryControl:

Thiscontrolprovidesuserswithadataqueryinterface.Userscanquerydatabytime,sectorclassification.Inthedevelopmentofsuchcontrol,weusesomedatabasedisplaycontrolsofDelphi,suchasDBGrid,BNavigator,DBEdit,etc.Thesecontrolscanprovideagooduserinteraction,sothatthedataquerybecomemoreconvenient.DataqueryuseSQLstatementstoachieve,itcanbeeasilyinsertedintheADOQuery.

（2）StatisticalControl:

Thecontrolhasstatistics,summaryandrenderinggraphicsfunctionsaccordingtodifferentdatacategories.Inadditiontohavedataquerycontrolfunctions,italsoneedtoachieveacertainofstatisticalcomputingandgraphicsrenderingcapabilities.StatisticsandsummaryareachievedbySQLstatement.GraphicsrenderingcanbeusedbyDelphi'sDBChartorsomegraphicsdisplayActiveXcontrol.

（3）ReportControl:

Itisusedtoimplementgeneration,printingofvarioustypesofreportintheclient.TheFormulaOneControlisusedtogenerateandprintExcelreportindependently.Asvariousreportshavedifferentformats,whenweuseFormulaOnetodevelopthereportcontrols,therearetwooptions:

First,useprogramtogeneratethecorrespondingreport,Thismethodismorecomplicated.Theotheristhatthebasetableisdefinedbyartificial,dataputinitbyprogram.Thismethodissimple.However,beforetheclientprogramrunning,theclientneedtodownloadthebasetabletolocalorreadthebasetablefromremoteserverfirstly.

ThefollowingsimpleexampleusetheActiveXcontrolTrendControl.Ocxofthesystem.

795BA425-2FA3-11D3-8BEA-00105A5ED4”

CODEBASE=”http:

//99.98.97.5/trend/TrendControl.ocx#version=1,0,0,0”

WIDTH=”798”HEIGHT=”658”ALIGN=”center”

Here,theClassIDandfilepathorURLofOCXmustbeprovided.Beforetheclientbrowsethispage,itwillsearch