Web开发基础-ASP编程.ppt

Web开发基础VBScript ASPprogramming 赵刚 Outline VBScriptASPADO essentialofwebdevelopment 2 WhatisVBScript VBScriptisoneof Script language Script languageislight weightprogramminglanguageVBScriptlight weightversionofVisualBasicVBScriptinHTMLdocument runwhendocumentisloadedor Trigger byevent essentialofwebdevelopment 3 WheretouseVBScriptinHTMLdocument document write HellofromVBScript essentialofwebdevelopment 4 headVbScriptfunctioninHTMLhead Makesurefunctionsisloadedbeforeitiscalled bodyApieceofVBScriptcode runwhenthepageisloaded essentialofwebdevelopment 5 somestatementssomestatements essentialofwebdevelopment 6 Variables dimnamename somevalueorname somevalueoptionexplicitdimnamename somevalue essentialofwebdevelopment 7 essentialofwebdevelopment 8 VBScriptOperators Math essentialofwebdevelopment 9 VBScriptOperators Comparison essentialofwebdevelopment 10 VBScriptOperators Logic essentialofwebdevelopment 11 VBScriptStringConcatenationOperator essentialofwebdevelopment 12 Sub function Submysub argument1 argument2 somestatementsEndSub CallMyProc argument Functionmyfunction argument1 argument2 somestatementsmyfunction somevalueEndFunction name findname essentialofwebdevelopment 13 ConditionalStatements ifpayment Cash thenmsgbox Youaregoingtopaycash elseifpayment Visa thenmsgbox Youaregoingtopaywithvisa elseifpayment AmEx thenmsgbox YouaregoingtopaywithAmericanExpress elsemsgbox Unknownmethodofpayment endIf selectcasepaymentcase Cash msgbox Youaregoingtopaycash case Visa msgbox Youaregoingtopaywithvisa case AmEx msgbox YouaregoingtopaywithAmericanExpress caseElsemsgbox Unknownmethodofpayment endselect essentialofwebdevelopment 14 Looping For NextFori 2To10Step2somecodeNext Do Loopi 0dowhilei i i 1loop essentialofwebdevelopment 15 VBScriptMsgBox Button Integer Allowsyoutosetwhichbuttonswillbedisplayedonyourpopup OKbuttonisthedefaultsetting Title String Setsthetitleofthepopupwindow muchliketheHTMLtitletagsetsthetitleofthebrowserwindow FunctionmyPopup OnClick MsgBox Hellothere 1 GreetingPopup EndFunction essentialofwebdevelopment 16 ASP ASPActiveServerPagesASPruninIISASPsameasHTMLASPmayincludetext HTML XML ScriptScriptinASPfilecanrunontheserver sideASPfile asp or asa essentialofwebdevelopment 17 ASPVs HTML HTMLwillsendtobrowserwithoutanychangeASPfilewillsendtoASPenginefirst whichanalysisthefile runtheScriptinthefile thenreturntheresulttothebrowserinHTMLformat essentialofwebdevelopment 18 WhatcanASPdoforU DynamiceditchangeoraddanypageitemDealwiththedataintheformusersubmitAccessfileordatabase andreturntheresulttotheuserImprovepageusabilityImprovesitesecuritybecausetheaspcodecan treadfromthebrowserAgoodaspcodingcanreducethenetworkload essentialofwebdevelopment 19 BasicASPrule ASPfileincludeHTMLtags liketheHTMLfile but ASPincludeserver sidescript whichwithtag server sidescriptrunontheserver essentialofwebdevelopment 20 Helloworld essentialofwebdevelopment 21 VBScript JavaScript 注意 与VBScript不同 JavaScript对大小写敏感 essentialofwebdevelopment 22 LifetimeofVariables functionSessionApplication essentialofwebdevelopment 23 ASPformanduserinput Gethttp www test org simpleform asp fname Bill lname GatesWelcome PostWelcome essentialofwebdevelopment 24 include includeInsertanotheraspfilebeforeaspfileisrun WordsofWisdom Thetimeis wisdom inc Oneshouldneverincrease beyondwhatisnecessary thenumberofentitiesrequiredtoexplainanything time inc essentialofwebdevelopment 25 Response ASPResponseusedasoutputtobrowser您可以使用HTML标签来格式化文本 这段文本的样式是通过style属性添加的 essentialofwebdevelopment 26 ASPRequest 请选择您喜欢的汽车 value Volvo Volvovalue Saab Saabvalue BMW BMW thenResponse Write 您喜欢的汽车是 cars endif essentialofwebdevelopment 27 您正在通过这款浏览器访问我们的站点 您的IP地址是 IP地址的DNS查询是 调用该页面所用的方法是 essentialofwebdevelopment 28 Server ASPServerAccessserverobjectmethodandproperty 本文件的最后修改时间是 essentialofwebdevelopment 29 ADO ADO ADOfromMicrosoftADOmeansActiveXDataObjectsADOinstalledIISADOistheinterfacetoaccessthedataindatabase AccessdatabasefromASPpageCreateADOconnectionOpentheconnectionCreateADOrecordsetOpentherecordsetGetthedatafromrecordsetCloserecordsetCloseconnection essentialofwebdevelopment 30 ADOconnection DSN lessconnection ODBCconnection essentialofwebdevelopment 31 ADORecordset essentialofwebdevelopment 32 Getdatafromtherecordset essentialofwebdevelopment 33 nextResponse Write rs MoveNextlooprs closeconn close essentialofwebdevelopment 34 x name next looprs close essentialofwebdevelopment 35 ChooseCountry response write rs fields Country rs MoveNextlooprs Closesetrs Nothing thensql SELECTCompanyname Contactname CountryFROMCustomersWHEREcountry country setrs Server CreateObject ADODB Recordset rs Opensql conn CompanynameContactnameCountry response write rs fields companyname response write rs fields contactname response write rs fields country response write rs MoveNextlooprs closeconn Closesetrs Nothingsetconn Nothing essentialofwebdevelopment 36 ADO insertdata CustomerID CompanyName ContactName Address City PostalCode Country 0thenResponse Write Noupdatepermissions elseResponse Write recaffected recordadded endifconn close essentialofwebdevelopment 37 Lab4serversideprogramming PurposeThepurposeofthislabistopracticeASPserversideprogrammingbasedonLab3Exercice1 recorduser scoreinthedatabaseYouaregivenanaccessdatabasenamedscore mdbTable scorewithfields name s scoreSettingtheDSNforthisdatabaseonyourserverRenameandmodifythetestformtorecordthetester snameandhis herscoreinthedatabasewhentesterpushthesubmitbutton essentialofwebdevelopment 38 Exercice2displayallthescoreAddingcodetodisplayallthescorehistoryusergotonthebottomofthetestform essentialofwebdevelopment 39 Exercice3 decorate your onlinetestapplication uponyourself essentialofwebdevelopment 40 Exercice4AdvancedrequirementSorttheresultbythescoreShowthescorelistinatableHint Youmayuse sort phaseofSQL essentialofwebdevelopment 41