Windows脚本编程核心技术精解Chapter23.pdf

《Windows脚本编程核心技术精解Chapter23.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、4684-8ch23.f.qc3/3/009:45AMPage645Chapter23UsingDatabasesInThisChapterLearnaboutADOandMDAC,thestandardinterfacestoanydatabaseCheckyourADOandMDACversions,andupdateyoursystemwiththehelpoffreedownloadsAccessthesampledatabaseusingaDSN-freeconnectionRe

2、adandwritetoanydatabaseusingscriptsandSQLDealwithrecordsets,countrecords,deleterecords,andretrieveinformationabouttablefieldsandvariabletypesEliminatethe“singlequote”problemandworkaroundreservedSQLcharactersCreatecompletelynewdatabasetablesanddelet

3、eoldonesLearnallabouttheIndexServer,anduseBooleanoperatorstoquicklyfindthedocumentsyouarelookingforDofulltextsearchesandqueriesinnaturallanguageLimitsearchscopetospecificfoldersusingthehiddenixsso.UtilobjectMicrosofthasmadedatabaseaccesseasy.Byusin

4、gMDAC(MicrosoftDatabaseAccessComponents),yourscriptscanconnectthemselvestoanykindofdatabaseandreadinformationusingSQLstatements.Yourscriptscanevenstoreinformationandchangedatabasestructures.Inthischapter,youlearnhowtoaddpowerfuldatabasecapabilitiestoy

5、ourscripts.AccessingDatabasesImaginewhatyoucoulddoifyourscriptswereableto“talk”todatabases.Youcouldcreateyourownlittleaddressbook,retrieveinvoiceinformation,orstoreusernames.Fortunately,Microsofthascreatedastandardinterfacetoaccessanykindofdatabase,in

6、cludingsimpletextdatabasesaswellasfull-scaleSQLserversorOracledatabaseservers.4684-8ch23.f.qc3/3/009:45AMPage646646PartV:AccessingHiddenComponents■■CheckingADOversionThisinterfaceiscalledActiveXDataObjects(ADO).ManyproductssilentlyinstallADOonyoursyst

7、em,solet’scheckwhetherADOisworkingonyoursystemandwhetherit’sup-to-date(seeFigure23-1).‘23-1.VBSsetfs=CreateObject(“Scripting.FileSystemObject”)setwshshell=CreateObject(“WScript.Shell”)msg=“ADOstatus:”&vbCr&vbCr‘checkwhetherConnectionisaccessibleonerro

8、rresumenextsetdummy=CreateObject(“ADODB.Connection”)ifnoterr.number=0thenMsgBoxmsg&“ADODB.Connectionisn’tworking!”WScript.Quitelsemsg=msg&“ADODB.Connectionisoperational.”&vbCrendifonerrorgoto0‘retrievefilesonerrorresumenextclsid=wshshell.RegRe