畢業(yè)設(shè)計外文翻譯

外文翻譯工學(xué)部工學(xué)一部專業(yè)計算機(jī)科學(xué)與技術(shù)班級4418102學(xué)號姓名蒲強(qiáng)指導(dǎo)教師孟桂英負(fù)責(zé)教師沈陽航空工業(yè)學(xué)院北方科技學(xué)院7月ASPdevelopmentofasitebytheuseoftools1.DreamweaverMacromediaDreamweaverisaprofessionalHTMLeditorforvisuallydesigningandmanagingwebsitesandpages.Whetheryouenjoythecontrolofhand-codingHTMLorprefertoworkinavisualeditingenvironment,DreamweavermakesiteasytogetstartedandprovidesyouwithhelpfultoolstoenhanceyourWebdesignexperience.Dreamweaverincludesmanycodingtoolsandfeatures:anHTML,CSS,andJavaScriptreference,aJavaScriptdebugger,andcodeeditors(theCodeviewandCodeinspector)thatallowyoutoeditJavaScript,XMLtechnologyimportsHTMLdocumentswithoutreformattingMacromedia’sRoundtripHTMLtechnologyimportsHTMLdocumentswithoutreformattingthecodeandyoucansetDreamweavertocleanupandreformatHTMLwhenyouwantitto.Dreamweaver’svisualeditingfeaturesalsoletyouquicklyadddesignandfunctionalitytoyourpageswithoutwritingalineofcode.Youcanviewallyoursiteelementsorassetsanddragthemfromaneasy-to-usepaneldirectlyintoadocument.StreamlineyourdevelopmentworkflowbycreatingandeditingimagesinMacromediaFireworks,thenimportingthemdirectlyintoDreamweaver,orbyaddingFlashobjectsyoucreatedirectlyinDreamweaver.Dreamweaverisfullycustomizable.UseDreamweavertocreateyourownobjectsandcommands,modifykeyboardshortcuts,andevenwriteJavaScriptcodetoextendDreamweaver’scapabilitieswithnewbehaviors,propertyinspectorsandsitereports.TheDreamweaverworkareaLet’sstartwithabriefoverviewoftheDreamweaverworkarea.Ifyouhaven’talreadylaunchDreamweaver,double-clicktheDreamweavericontolaunchit.TheDreamweaverworkareaaccommodatesdifferentstylesofworkingandlevelsofexpertise.WhenyoulaunchDreamweaver,thefollowingworkareaitemsopen:TheDocumentwindowdisplaysthecurrentdocumentasyoucreateandeditit.TheObjectspanelcontainsiconsyouclicktoinsertobjectsinyoudocument.Dreamweaverprovidesmanyfloatingpanels,suchastheHTMLStylespanelandthecodeinspectorwhichenableyoutoworkwithotherDreamweaverelements.TheLauncherbarcontainsbuttonsforopeningandclosingyourmostfrequentlyusedinspectorsandpanels.ThePropertyinspectordisplayspropertiesfortheselectedobjectortext,andletsyoumodifythoseproperties.(Whichpropertiesappearintheinspectordependontheobjectactivelyselectedinthedocument.)ToopenDreamweaver’swindows,inspectorsandpanels,usetheWindowmenu.AcheckmarknexttoanitemintheWindowmenuindicatesthatthenameditemiscurrentlyopen(thoughitmaybehiddenbehindotherwindows).Todisplayanitemthatisn’tcurrentlyopen,choosetheitemnamefromthemenuoruseitskeyboardshortcut.WorkinginDreamweaverDreamweavercandisplayadocumentinthreeways:inDesignview,inCodeview,andinasplitviewthatshowsboththedesignandcode.(Tochangetheviewinwhichyou’reworking,selectaviewintheDreamweavertoolbar.)Bydefault,Dreamweaverdisplaysthedocumentwindowindesignview.Inaddition,youcanworkwithDreamweaver’sdesignviewintwodifferentwaysinlayoutviewandstandardview.(Youselecttheseviewsintheviewcategoryoftheobjectspanel.)Inlayoutviewyoucandesignapagelayout.Insertgraphics,text,andothermedia;instandardview,inadditiontoinsertinggraphicstextandmedia,youcanalsoinsertlayers,createframedocuments,createtables,andapplyotherchangestoyouroptionsthataren’tavailableinlayoutview.2.databaseYouknowthatadatabaseisacollectionoflogicallyrelateddataelementsthatmaybestructuredinvariouswaystomeetthemultipleprocessingandretrievalneedsoforganizationsandindividuals.There’snothingnewaboutdatabases-earlyoneswerechiseledinstone,pennedonscrolls,andwrittenonindexcards.Butnowdatabasesarecommonlyrecordedonmagneticallymedia,andcomputerprogramsarerequiredtoperformthenecessarystorageandretrievaloperations.You’llseeinthefollowingpagesthatcomplexdatarelationshipsandlinkagesmaybefoundinallbutthesimplestdatabases.Thesystemsoftwarepackagethathandlesthedifficulttasksassociatedwithcreating,accessing,andmaintainingdatabaserecordsiscalledadatabasemanagementsystem(DBMS).TheprogramsinaDBMSpackageestablishaninterfacebetweenthedatabaseitselfandtheusersofthedatabase.(Theseusersmaybeapplicationsprogrammers,managersandotherswithinformationneeds,andvariousOSprograms.)ADBMScanorganize,process,andpresentselecteddataelementsfromthedatabase.Thiscapabilityenablesdecisionmakerstosearch,probe,andquerydatabasecontentsinordertoextractanswerstononrecurringandunplannedquestionsthataren’tavailableinregularreports.Thesequestionsmightinitiallybevagueand/orpoorlydefined,butpeoplecan“browse”throughthedatabaseuntiltheyneededinformation.Inshort,theDBMSwill“manage”thestoreddataitemsandassembletheneededitemsfromthecommondatabaseinresponsetothequeriesofthosewhoaren’tprogrammers.Inafile-orientedsystem,usersneedingspecialinformationmaycommunicatetheirneedstoprogrammer,who,whentimepermits,willwriteoneormorepreparetheinformation.TheavailabilityofaDBMS,however,offersusersamuchfasteralternativecommunicationspath.3.SQLANDSQLSERVERIBMinventedacomputerlanguagebackinthe1970sdesignedspecificallyfordatabasequeriescalledSEQUEL;thoselettersstandforStructuredEnglishQUERYforqueries,butcanalsobuilddatabasesandmanagethedatabaseengine’ssecurity.Becauseofthisheritageyoucanpronounceit“sequel”orspellitout“S-Q-L.”TherearevariousversionsofSQLusedintoday’sdatabaseengines.MicrosoftSQLServerusesaversioncalledTransact-SQL,orT-SQL,whichstandsforTransactionSQL.=1\*GB2⑴WhatIsSQLServer?SQLServerisaclient/serverrelationaldatabasemanagementsystem(RDBMS)thatuseTransact-SQLtosendrequestsbetweenaclientanSQLServer.=2\*GB2⑵Client/ServerArchitectureThetermsclient,server,andclient/servercanbeusedtorefertoverygeneralconceptsortospecificitemsofhardwareorsoftware.Atthemostgenerallevel,aclientisanycomponentofasystemthatrequestsservicesorresourcesfromothercomponentsofasystem.Aserverisanycomponentofasystemthatprovidesservicesorresourcestoothercomponentsofasystem.Forexample,whenyouprintadocumentfromyourworkstationonanetwork,theworkstationistheclientandthemachinethatdoestheprintspoolingistheserver.Anyclient/serverdata-basesystemconsistsofthefollowingcomponents:Theserver—Acollectionofdataitemsandsupportingobjectsorganizedandpresentedtofacilitateservices,suchassearching,sorting,recombining,retrieving,updating,andanalyzingdata..Thedatabaseconsistsofthephysicalstorageofdataandthedatabaseservices.Alldataaccessoccursthroughtheserver;thephysicaldataisneveraccesseddirectlybytheclient.Theclient—Asoftwareprogramthatmightbeusedinteractivelybyapersonorthatcouldbeanautomatedprocess.Thisincludesallsoftwarethatinteractswiththeserver,eitherrequestingdatafromorsendingdatatothedatabase.ThecommunicationbetweentheclientandtheserverThecommunicationbetweentheclientandtheserverdependslargelyonhowtheclientandserverareimplemented.Bothphysicalandlogicallayersofcommunicationcanbeidentified.Whenyoucommunicatewithsomeoneusingthetelephone,thetelephonesystemisthephysicallayerandaspokennaturallanguageisthelogicallayerofcommunication.Foradata-basedsystem,thephysicallayercanbeanetworkiftheserverandtheclientareondifferentcomputers.Itcanbeintercrossescommunicationiftheserverandtheclientareonthesamecomputer.Thelogicalcommunicationstructureofthephysicallayermaybelow-leveloperatingsystemcalls,aproprietarydataaccesslanguage,ortheopenstructuredquerylanguage(SQL)4.IISInternetInformationServeristheacronym(IIS)isaWorldWideWebserver.GopherserverandFTPserverallinclusiveinside.IISmeansthatyoucanpublishwebpages,andthereareASP(ActiveServerPages),JAVA,VBscriptgeneratedpages,withsomeextensions.IISsupportsomeinterestingthings,liketheeditorialenvironmentinterface(FRONTPAGE),afull-textsearchfunction(INDEXSERVER),amultimediacapabilities(NETSHOW)Secondly,IISiswithWindowsNTServer4.0toprovidethedocumentsandapplicationserver,WindowsNTServerisbuiltonthebasicInternetservercomponents.WindowsNTServeranditsfullyintegrated,allowingtheuseofWindowsNTServerbuilt-insecurity,andtheNTFSfilesystembuildapowerfulandflexibleInternet/Intranetsite.IIS(InternetInformationServer,InternetInformationServices)isaWeb(Web)servicescomponents,includingWebserver,FTPserver,NNTPserverandtheSMTPserver,wereusedforwebbrowsing,filetransfer,mailandnewsservicesandsoonItmakesthenetwork(includingtheInternetandLAN)onthereleaseofinformationhasbecomeaveryeasymatter.IISistheabbreviationforInternetInformationServer,Microsoftispushingthemainserver,thelatestversionisincludedWindowsinsidetheIIS5,IISandWindowNTServerfullyintegratedtogether,souserscanuseWindowsNTServerandNTFS(NTFileSystem,NTfilesystem)built-insecurityfeatures,buildingastrong,flexibleandsecureInternetandIntranetsites.IISsupportHTTP(HypertextTransferProtocol,HypertextTransferProtocol),FTP(FileTransferProtocol,filetransferprotocol)andSMTPprotocol,throughtheuseofCGIandISAPI,IIScanbeahighdegreeofexpansion.IISsupporthasnothingtodowiththelanguageofthescriptpreparationandcomponents,throughtheIIS,developerscandevelopanewgenerationofdynamic,fullofcharmoftheWebsite.IISdoesnotrequiredeveloperstolearnnewscriptinglanguageorcompilerapplications,IISfullsupportforVBScript,JScriptsoftwaredevelopmentandJava,italsosupportstheCGIandWinCGI,andtheexpansionandISAPIfilter.IISisdesignedtoestablishasetofintegratedserverservicestosupportHTTP,FTPandSMTP,itcanprovidequickandintegrationofexistingproducts,whileexpansionoftheInternetserver.IIShighlyrelevant,whiletheconsumptionofsystemresourcesisatleast,IISinstallation,configurationandmanagementareverysimple,itisbecauseIISandWindowsNTServernetworkoperatingsystemcloselyintegratedwiththeother,IISalsousetheWindowsNTServerthesameastheSAM(SecurityAccountsManager,SecurityAccountManager),theadministrators,IIS,suchastheuseofPerformanceMonitorandSNMP(SimpleNerworkManagementProtocol,SNMP)suchastheNThasmanagementtools.IISsupportforISAPI,ISAPItoexpandtheuseofserverfunctions,andtheuseofISAPIfiltercanbepre-treatmentandpost-processingstoredintheIISonthedata.For32-bitWindowsapplicationscanbeextendedtotheInternetFTP,SMTPandHTTP-placedandeasytousetaskfocusoftheinterface,theinterfacewillbetheuseofInternetapplicationsgreatlysimplified,IISalsosupportsMIME(MultipurposeInternetMailExtensions,MoreforInternetMailExtensions),itcanaccesstheInternetapplicationsprovideasimpleregistrationof.IISisanimportantcharacteristictosupportASP.IIS3.0versionaftertheintroductionoftheASP,caneasilydisplaydynamiccontentandthedevelopmentofWeb-basedapplications.ForsuchasVBScript,JScriptdevelopmentofsoftware,orfromVisualBasic,Java,VisualC++developmentsystem,andtheexistingWinCGICGIscriptsandapplicationsdeveloped,IISprovidestronglocalsupport.開發(fā)一種ASP網(wǎng)站所運(yùn)用的工具1.DreamweaverMacromediaDreamweaver是為視覺上設(shè)計并且管理網(wǎng)絡(luò)站點(diǎn)和網(wǎng)頁的一種專業(yè)的HTML編輯器。不管你是比較喜歡手寫代碼還是在可視化編輯的環(huán)境下工作，Dreamweaver都向你提供有用的工具讓你迅速起手或提高你的網(wǎng)絡(luò)設(shè)計經(jīng)驗(yàn)。Dreamweaver包括許多編碼工具和特性：HTMLCSS和JAVASCRIPT參照，一種JAVASCRIPT調(diào)試器，和代碼編輯器（代碼見解和代碼查看器）容許你在Dreamweaver中編輯JAVASCRIPT，XML以及其他文本文獻(xiàn)。Macromedia的雙程的HTML技術(shù)可以導(dǎo)入HTML而不會重新格式化。并且你假如樂意也可以設(shè)置Dreamweaver清理代碼或重新格式化HTML。Dreamweaver的可視化編輯的土正也讓你迅速把設(shè)計和功能加到你的頁面，而不用寫一行代碼。你能查看所有的你的站點(diǎn)的元素或資源。并且直接從一種輕易使用的面版拖拽他們進(jìn)一種文獻(xiàn)。通過在MacromediaFireworks中創(chuàng)立并編輯圖象來優(yōu)化你的開發(fā)工作流程，然后直接將他們導(dǎo)入Dreamweaver，或假如直接在Dreamweaver發(fā)明的Flash對象。Dreamweaver是可完全自定義的。使用Dreamweaver來創(chuàng)立你自己的對象和命令，修改快捷鍵，甚至寫入JAVASCRIPT來擴(kuò)展Dreamweaver在新的行為、屬性面板以及站點(diǎn)匯報上的能力。Dreamweaver工作區(qū)域讓我門從Dreamweaver工作區(qū)域的簡短的概述開始。假如你已經(jīng)沒安裝Dreamweaver，雙擊Dreamweaver圖標(biāo)安裝它。Dreamweaver工作區(qū)域不一樣工作的方式和顧客的水平有不一樣的界面。當(dāng)你安裝Dreamweaver時，下列工作區(qū)域打開：當(dāng)你發(fā)明并且編輯頁面時，文獻(xiàn)窗口顯示目前的文獻(xiàn)對象面板包括某些圖標(biāo)。你可以點(diǎn)擊插入對象到你的文獻(xiàn)。Dreamweaver提供許多浮動的面板，例如HTML式樣面板和代碼檢查器，它使你可以使用此外的Dreamweaver元素。Launcher轉(zhuǎn)載器工具條包括打開關(guān)閉你的最常常使用的檢查器和面板。屬性檢查器所選擇的物體或文章的性質(zhì)，并且讓你修改那些屬性（哪個屬性在檢查器出現(xiàn)取決于在文獻(xiàn)中選擇哪個對象）。打開Dreamweaver的窗口，檢查器和面板，使用窗口菜單?？恐诓藛物@示項(xiàng)目有一種勾，表達(dá)該項(xiàng)窗口項(xiàng)目在目前打開（盡管它可以被隱蔽在此外的窗戶背面）。要打開一種窗口項(xiàng)目，從菜單項(xiàng)選擇擇項(xiàng)目名字或使用它的鍵盤快捷。使用DreamweaverDreamweaver能在3個措施顯示一種文獻(xiàn)：在設(shè)計視圖，在代碼視圖，實(shí)際與代碼結(jié)合視圖，（變化你在其正在工作的視圖，在Dreamweaver工作跳選擇視圖）Dreamweaver缺省是在設(shè)計視圖顯示文獻(xiàn)窗口。此外，你呢功能使用設(shè)計試圖的兩種措施：在原則視圖與布局視圖。（你在對象面板最下面的視圖分類選擇這些視圖）在布局視圖你能設(shè)計頁面布局，插入圖形，正文和此外的煤體。在原則的視圖，除了插入圖形正文煤體，你能也插入層，創(chuàng)立楨文獻(xiàn)，創(chuàng)立表格，并且做其他在布局視圖無法做到的變化。2.數(shù)據(jù)庫眾所周知，數(shù)據(jù)庫是邏輯上有關(guān)的數(shù)據(jù)元的匯集。這些數(shù)據(jù)元可以按不一樣的構(gòu)造組織起來，以滿足單位和個人的多種處理和探索的需要。數(shù)據(jù)庫自身不是什么新鮮事—初期的數(shù)據(jù)庫鑿在石頭上，記在名冊上，以及寫在索引卡中。而目前，數(shù)據(jù)庫普遍記錄在可磁化的介質(zhì)上，并且需要用計算機(jī)程序來執(zhí)行必需的存儲和索引操作。如下所述，所有數(shù)據(jù)庫（最簡樸的除外）中均有復(fù)雜的數(shù)據(jù)關(guān)系及其鏈接。處理與創(chuàng)立、訪問以及維護(hù)數(shù)據(jù)庫記錄有關(guān)的任務(wù)的系統(tǒng)軟件包叫做數(shù)據(jù)庫管理系統(tǒng)（DBM）。DBMS軟件包中的程序在數(shù)據(jù)庫與其顧客間建立接口。（這些顧客可以是應(yīng)用程序員、管理員、及其他需要信息餓人員和多種操作系統(tǒng)程序）。DBMS可組織、處理和表達(dá)從數(shù)據(jù)庫中選出的數(shù)據(jù)元。該功能使決策者能搜索、探查和查詢數(shù)據(jù)庫的內(nèi)容，對在正規(guī)匯報中沒有的、不在出現(xiàn)的且無法預(yù)料的問題做出回答。這些問題最初也許是模糊的并且（或者）是定義不恰當(dāng)?shù)?，不過人們可以瀏覽數(shù)據(jù)庫直到獲得所需的信息。簡言之，DBMS將“管理”存儲的數(shù)據(jù)項(xiàng)，并從公共的數(shù)據(jù)庫中匯集所需的數(shù)據(jù)項(xiàng)以回答非程序員的問詢。在面向文獻(xiàn)的系統(tǒng)中，需要特定信息的擁護(hù)應(yīng)將他們的規(guī)定傳送給程序員。該程序員在時間容許時，將編寫一種或多哥程序以提取數(shù)據(jù)和準(zhǔn)備信息。然而，DBMS的可用性為擁護(hù)提供了一種更快的替代通信通道。3.SQL和SQL服務(wù)器IBM在20世紀(jì)70年代，設(shè)計了一種專門處理數(shù)據(jù)庫查詢的計算機(jī)語言SEQUEL，這幾種字母是構(gòu)造化英語查詢語言的縮寫。伴隨時間的推移，它增長了許多功能，就不僅是一種查詢語言了，還可以創(chuàng)立數(shù)據(jù)庫，管理數(shù)據(jù)古引擎的安全。IBM把他公開發(fā)行，于是就變成了目前為大家所知的SQL。由于歷史的原因SQL和讀成sequel，也可以逐字段拼成S-Q-L。在目前的數(shù)據(jù)庫引擎里，已經(jīng)有了好多種SQL版本。微軟SQLserver使用的是T-SQL，它代表的是事務(wù)SQL。=1\*GB2⑴什么是SQLServerSQLServer是一種客戶機(jī)/服務(wù)器關(guān)系型數(shù)據(jù)庫管理系統(tǒng)（RDBMS），它使用事務(wù)SQL在客戶機(jī)和SQL服務(wù)器之間傳送祈求。=2\*GB2⑵客戶機(jī)-服務(wù)器體系構(gòu)造術(shù)語客戶機(jī)、服務(wù)器和客戶機(jī)-服務(wù)器可以是非常廣泛的概念或指硬件、軟件、。按最一般的概念，客戶機(jī)是從系統(tǒng)其他部件祈求服務(wù)或資源的系統(tǒng)的任何部件；服務(wù)器是向系統(tǒng)其他部件提供服務(wù)或資源的任何部件。例如，當(dāng)顧客從網(wǎng)絡(luò)上的工作站打印一種文獻(xiàn)時，工作站是客戶機(jī)，用做假脫機(jī)打印的機(jī)器是服務(wù)器。任何基于數(shù)據(jù)的客戶機(jī)、務(wù)器系統(tǒng)都是由下列部件構(gòu)成。服務(wù)器—數(shù)據(jù)項(xiàng)和支持對象的匯集，其中這些對象是有組織的，并隨時準(zhǔn)備提交，以便為數(shù)據(jù)的搜索、分類、重組、檢索、更新和分析之類的服務(wù)提供便利。數(shù)據(jù)庫由數(shù)據(jù)的物理存儲器和數(shù)據(jù)庫服務(wù)構(gòu)成。所有的數(shù)據(jù)訪問都通過服務(wù)器進(jìn)行，客戶一概不呢功能直接訪問物理數(shù)據(jù)。客戶機(jī)一種軟件程序，該程序應(yīng)當(dāng)由個人交互使用或也許是一種自動進(jìn)程。其中包括從數(shù)據(jù)庫祈求數(shù)據(jù)，或向數(shù)據(jù)庫送數(shù)的與服務(wù)器交互作用的所有軟件，例如管理實(shí)用程序（這些是SQL服務(wù)器產(chǎn)品的一部分并且是單獨(dú)購置的）、尤其查詢和匯報軟件、可戶應(yīng)用程序、現(xiàn)貨應(yīng)用程序和基于WEB服務(wù)器的應(yīng)用程序?？蛻魴C(jī)和服務(wù)器之間的通信—客戶機(jī)和服務(wù)器之間的通信很大程度上取決于客戶和服務(wù)器是怎樣實(shí)現(xiàn)的。通信的物理層和邏輯層可以被識別。當(dāng)你用電話與某人通信時，電話系統(tǒng)是物理層，所獎的自然語言是通信的邏輯層。對于基于數(shù)據(jù)的系統(tǒng)，假如服務(wù)器和客戶在不一樣的計算機(jī)上，則物理層可以是網(wǎng)絡(luò)。假如服務(wù)器和客戶在同一臺計算機(jī)上，則通信可在進(jìn)程之間進(jìn)行。物理層邏輯通信構(gòu)造可以是低層操作系統(tǒng)調(diào)用，一種專用數(shù)據(jù)訪問語言或開放的構(gòu)造話查詢語言（SQL）。4.IISInternetInformationServer的縮寫為（IIS）是一種WorldWideWebserver。Gopherserver和