外文翻譯工 學(xué) 部 工學(xué)一部專 業(yè)計(jì)算機(jī)科學(xué)與技術(shù)班 級(jí) 學(xué) 號(hào) 姓 名 指導(dǎo)教師 負(fù)責(zé)教師沈陽航空工業(yè)學(xué)院北方科技學(xué)院2008年7月沈陽航空工業(yè)學(xué)院北方科技學(xué)院畢業(yè)設(shè)計(jì)(外文翻譯)ASP development of a site by the use of tools1. Dream weaverMacromedia Dream weaver is a professional HTML editor for visually designing and managing web sites and pages. Whether you enjoy the control of hand-coding HTML or prefer to work in a visual editing environment, Dream weaver makes it easy to get started and provides you with helpful tools to enhance your Web design experience.Dream weaver includes many coding tools and features: an HTML, CSS, and JavaScript reference, a JavaScript debugger, and code editors (the Code view and Code inspector) that allow you to edit JavaScript, XML technology imports HTML documents without reformatting Macromedias Roundtrip HTML technology imports HTML documents without reformatting the code and you can set Dream weaver to clean up and reformat HTML when you want it to .Dream weavers visual editing features also let you quickly add design and functionality to your pages without writing a line of code. You can view all your site elements or assets and drag them from an easy-to-use panel directly into a document. Streamline your development workflow by creating and editing images in Macromedia Fireworks, then importing them directly into Dream weaver, or by adding Flash objects you create directly in Dream weaver.Dream weaver is fully customizable. Use Dream weaver to create your own objects and commands, modify keyboard shortcuts, and even write JavaScript code to extend Dream weavers capabilities with new behaviors, property inspectors and site reports.The Dream weaver work area Lets start with a brief overview of the Dream weaver work area.If you havent already launch Dream weaver, double-click the Dream weaver icon to launch it.The Dream weaver work area accommodates different styles of working and levels of expertise.When you launch Dream weaver, the following work area items open:The Document window displays the current document as you create and edit it.The Objects panel contains icons you click to insert objects in you document.Dream weaver provides many floating panels, such as the HTML Styles panel and the code inspector which enable you to work with other Dream weaver elements.The Launcher bar contains buttons for opening and closing your most frequently used inspectors and panels.The Property inspector displays properties for the selected object or text, and lets you modify those properties.(Which properties appear in the inspector depend on the object actively selected in the document.)To open Dream weavers windows, inspectors and panels, use the Window menu. A check mark next to an item in the Window menu indicates that the named item is currently open(though it may be hidden behind other windows). To display an item that isnt currently open, choose the item name from the menu or use its keyboard shortcut.Working in Dream weaverDream weaver can display a document in three ways: in Design view, in Code view, and in a split view that shows both the design and code.(To change the view in which youre working ,select a view in the Dream weaver toolbar.)By default, Dream weaver displays the document window in design view.In addition, you can work with Dream weavers design view in two different ways in layout view and standard view.( You select these views in the view category of the objects panel.) In layout view you can design a page layout. Insert graphics, text, and other media; in standard view, in addition to inserting graphics text and media, you can also insert layers, create frame documents, create tables, and apply other changes to your page-options that arent available in layout view.2.databaseYou know that a database is a collection of logically related data elements that maybe structured in various ways to meet the multiple processing and retrieval needs of organizations and individuals. Theres nothing new about databases-early ones were chiseled in stone, penned on scrolls, and written on index cards. But now databases are commonly recorded on magnetically media, and computer programs are required to perform the necessary storage and retrieval operations.Youll see in the following pages that complex data relationships and linkages maybe found in all but the simplest databases. The system software package that handles the difficult tasks associated with creating, accessing, and maintaining database records is called a database management system(DBMS).The programs in a DBMS package establish an interface between the database itself and the users of the database.(These users may be applications programmers, managers and others with information needs, and various OS programs.) A DBMS can organize, process, and present selected data elements from the database. This capability enables decision makers to search, probe, and query database contents in order to extract answers to nonrecurring and unplanned questions that arent available in regular reports.These questions might initially be vague and/or poorly defined, but people can “browse” through the database until they needed information. In short, the DBMS will “manage” the stored data items and assemble the needed items from the common database in response to the queries of those who arent programmers. Ina file-oriented system, users needing special information may communicate their needs to programmer, who, when time permits, will write one or more prepare the information.The availability of a DBMS, however, offers users a much faster alternative communications path.3. SQL AND SQL SERVERIBM invented a computer language back in the 1970s designed specifically for database queries called SEQUEL; those letters stand for Structured English QUERY for queries, but can also build databases and manage the database engines security. Because of this heritage you can pronounce it “sequel” or spell it out “S-Q-L.” There are various versions of SQL used in todays database engines. Microsoft SQL Server uses a version called Transact-SQL, or T-SQL, which stands for Transaction SQL. What Is SQL Server?SQL Server is a client/server relational database management system (RDBMS)that use Transact-SQL to send requests between a client an SQL Server. Client/Server ArchitectureThe terms client, server, and client/server can be used to refer to very general concepts or to specific items of hardware or software. At the most general level, a client is any component of a system that requests services or resources from other components of a system. A server is any component of a system that provides services or resources to other components of a system.For example, when you print a document from your workstation on a network, the workstation is the client and the machine that does the print spooling is the server. Any client/server data-base system consists of the following components:The serverA collection of data items and supporting objects organized and presented to facilitate services, such as searching ,sorting , recombining ,retrieving, updating ,and analyzing data. The database consists of the physical storage of data and the data base services. All data access occurs through the server; the physical data is never accessed directly by the client.The clientA software program that might be used interactively by a person or that could be an automated process. This includes all software that interacts with the server, either requesting data from or sending data to the database.The communication between the client and the server- The communication between the client and the server depends largely on how the client and server are implemented. Both physical and logical layers of communication can be identified.When you communicate with someone using the telephone, the telephone system is the physical layer and a spoken natural language is the logical layer of communication. For a data-based system, the physical layer can be a network if the server and the client are on different computers. It can be intercrosses communication if the server and the client are on the same computer. The logical communication structure of the physical layer may be low-level operating system calls, a proprietary data access language, or the open structured query language (SQL)4. IISInternet Information Server is the acronym (IIS) is a World Wide Web server. Gopher server and FTP server all inclusive inside. IIS means that you can publish web pages, and there are ASP (Active Server Pages), JAVA, VBscript generated pages, with some extensions. IIS support some interesting things, like the editorial environment interface (FRONTPAGE), a full-text search function (INDEX SERVER), a multimedia capabilities (NET SHOW)Secondly, IIS is with Windows NT Server 4.0 to provide the documents and application server, Windows NT Server is built on the basic Internet server components. Windows NT Server and its fully integrated, allowing the use of Windows NT Server built-in security, and the NTFS file system build a powerful and flexible Internet / Intranet site.IIS (Internet Information Server, Internet Information Services) is a Web (Web) services components, including Web server, FTP server, NNTP server and the SMTP server, were used for web browsing, file transfer, mail and news services and so on It makes the network (including the Internet and LAN) on the release of information has become a very easy matter. IIS is the abbreviation for Internet Information Server, Microsoft is pushing the main server, the latest version is included Windows2000 inside the IIS 5, IIS and WindowNT Server fully integrated together, so users can use Windows NT Server and NTFS (NT File System , NT file system) built-in security features, building a strong, flexible and secure Internet and Intranet sites. IIS support HTTP (Hypertext Transfer Protocol, Hypertext Transfer Protocol), FTP (File Transfer Protocol, file transfer protocol) and SMTP protocol, through the use of CGI and ISAPI, IIS can be a high degree of expansion.IIS support has nothing to do with the language of the script preparation and components, through the IIS, developers can develop a new generation of dynamic, full of charm of the Web site. IIS does not require developers to learn new scripting language or compiler applications, IIS full support for VBScript, JScript software development and Java, it also supports the CGI and WinCGI, and the expansion and ISAPI filter.IIS is designed to establish a set of integrated server services to support HTTP, FTP and SMTP, it can provide quick and integration of existing products, while expansion of the Internet server.IIS highly relevant, while the consumption of system resources is at least, IIS installation, configuration and management are very simple, it is because IIS and Windows NT Server network operating system closely integrated with the other, IIS also use the Windows NT Server the same as the SAM (Security Accounts Manager, Security Account Manager), the administrators, IIS, such as the use of Performance Monitor and SNMP (Simple Nerwork Management Protocol, SNMP) such as the NT has management tools.IIS support for ISAPI, ISAPI to expand the use of server functions, and the use of ISAPI filter can be pre-treatment and post-processing stored in the IIS on the data. For 32-bit Windows applications can be extended to the Internet FTP, SMTP and HTTP-placed and easy to use task focus of the interface, the interface will be the use of Internet applications greatly simplified, IIS also supports MIME (Multipurpose Internet Mail Extensions, More for Internet Mail Extensions), it can access the Internet applications provide a simple registration of.IIS is an important characteristic to support ASP. IIS 3.0 version after the introduction of the ASP, can easily display dynamic content and the development of Web-based applications. For such as VBScript, JScript development of software, or from Visual Basic, Java, Visual C + + development system, and the existing WinCGI CGI scripts and applications developed, IIS provide strong local support.12開發(fā)一個(gè)ASP網(wǎng)站所運(yùn)用的工具1. Dream weaverMacromedia Dreamweaver 是為視覺上設(shè)計(jì)并且管理網(wǎng)絡(luò)站點(diǎn)和網(wǎng)頁的一個(gè)專業(yè)的HTML編輯器。不論你是比較喜歡手寫代碼還是在可視化編輯的環(huán)境下工作，Dreamweaver 都向你提供有用的工具讓你快速起手或提高你的網(wǎng)絡(luò)設(shè)計(jì)經(jīng)驗(yàn)。Dreamweaver 包括許多編碼工具和特征：HTML CSS 和JAVASCRIPT 參考，一個(gè)JAVASCRIPT 調(diào)試器，和代碼編輯器（代碼看法和代碼查看器）容許你在Dreamweaver中編輯JAVASCRIPT ，XML 以及其他文本文件。Macromedia 的雙程的HTML 技術(shù)可以導(dǎo)入HTML而不會(huì)重新格式化。 而且你如果愿意也可以設(shè)置Dreamweaver清理代碼或重新格式化HTML。Dreamweaver 的可視化編輯的土正也讓你快速把設(shè)計(jì)和功能加到你的頁面，而不用寫一行代碼。你能查看所有的你的站點(diǎn)的元素或資源。并且直接從一個(gè)容易使用的面版拖拽他們進(jìn)一個(gè)文件。通過在Macromedia Fireworks 中創(chuàng)建并編輯圖象來優(yōu)化你的開發(fā)工作流程，然后直接將他們導(dǎo)入Dreamweaver， 或假如直接在Dreamweaver創(chuàng)造的Flash對象。Dreamweaver是可完全自定義的。使用Dreamweaver 來創(chuàng)建你自己的對象和命令，修改快捷鍵，甚至寫入JAVASCRIPT來擴(kuò)展Dreamweaver在新的行為、屬性面板以及站點(diǎn)報(bào)告上的能力。Dreamweaver工作區(qū)域讓我門從Dreamweaver工作區(qū)域的簡短的概述開始。如果你已經(jīng)沒安裝Dreamweaver，雙擊Dreamweaver圖標(biāo)安裝它。Dreamweaver工作區(qū)域不同工作的方式和用戶的水平有不同的界面。當(dāng)你安裝Dreamweaver時(shí)，下列工作區(qū)域打開：當(dāng)你創(chuàng)造并且編輯頁面時(shí)，文件窗口顯示當(dāng)前的文件對象面板包含一些圖標(biāo)。你可以點(diǎn)擊插入對象到你的文件。Dreamweaver提供許多浮動(dòng)的面板，例如HTML式樣面板和代碼檢查器，它使你能夠使用另外的Dreamweaver元素。Launcher 轉(zhuǎn)載器工具條包含打開關(guān)閉你的最經(jīng)常使用的檢查器和面板。屬性檢查器所選擇的物體或文章的性質(zhì)，并且讓你修改那些屬性（哪個(gè)屬性在檢查器出現(xiàn)取決于在文件中選擇哪個(gè)對象）。打開Dreamweaver的窗口，檢查器和面板，使用窗口菜單。靠著在菜單顯示項(xiàng)目有一個(gè)勾，表示該項(xiàng)窗口項(xiàng)目在當(dāng)前打開（盡管它可以被隱蔽在另外的窗戶后面）。要打開一個(gè)窗口項(xiàng)目，從菜單選擇項(xiàng)目名字或使用它的鍵盤快捷。使用DreamweaverDreamweaver能在3個(gè)方法顯示一個(gè)文件：在設(shè)計(jì)視圖，在代碼視圖，實(shí)際與代碼結(jié)合視圖，（改變你在其正在工作的視圖，在Dreamweaver工作跳選擇視圖）Dreamweaver缺省是在設(shè)計(jì)視圖顯示文件窗口。另外，你呢功能使用設(shè)計(jì)試圖的兩種方法：在標(biāo)準(zhǔn)視圖與布局視圖。（你在對象面板最下面的視圖分類選擇這些視圖）在布局視圖你能設(shè)計(jì)頁面布局，插入圖形，正文和另外的煤體。在標(biāo)準(zhǔn)的視圖，除了插入圖形正文煤體，你能也插入層，創(chuàng)建楨文件，創(chuàng)建表格，并且做其他在布局視圖無法做到的改變。2. 數(shù)據(jù)庫眾所周知，數(shù)據(jù)庫是邏輯上相關(guān)的數(shù)據(jù)元的匯集。這些數(shù)據(jù)元可以按不同的結(jié)構(gòu)組織起來，以滿足單位和個(gè)人的多種處理和探索的需要。數(shù)據(jù)庫本身不是什么新鮮事早期的數(shù)據(jù)庫鑿在石頭上，記在名冊上，以及寫在索引卡中。而現(xiàn)在，數(shù)據(jù)庫普遍記錄在可磁化的介質(zhì)上，并且需要用計(jì)算機(jī)程序來執(zhí)行必需的存儲(chǔ)和索引操作。如下所述，所有數(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可組織、處理和表示從數(shù)據(jù)庫中選出的數(shù)據(jù)元。該功能使決策者能搜索、探查和查詢數(shù)據(jù)庫的內(nèi)容， 對在正規(guī)報(bào)告中沒有的、不在出現(xiàn)的且無法預(yù)料的問題做出回答。這些問題最初可能是模糊的并且（或者）是定義不恰當(dāng)?shù)?，但是人們可以瀏覽數(shù)據(jù)庫直到獲得所需的信息。簡言之，DBMS將“管理”存儲(chǔ)的數(shù)據(jù)項(xiàng)，并從公共的數(shù)據(jù)庫中匯集所需的數(shù)據(jù)項(xiàng)以回答非程序員的詢問。在面向文件的系統(tǒng)中，需要特定信息的擁護(hù)應(yīng)將他們的要求傳送給程序員。該程序員在時(shí)間容許時(shí)，將編寫一個(gè)或多哥程序以提取數(shù)據(jù)和準(zhǔn)備信息。然而，DBMS的可用性為擁護(hù)提供了一個(gè)更快的替代通信通道。3. SQL 和SQL 服務(wù)器IBM在20世紀(jì)70年代，設(shè)計(jì)了一種專門處理數(shù)據(jù)庫查詢的計(jì)算機(jī)語言SEQUEL，這幾個(gè)字母是結(jié)構(gòu)化英語查詢語言的縮寫。隨著時(shí)間的推移，它增加了許多功能，就不僅是一個(gè)查詢語言了，還可以創(chuàng)建數(shù)據(jù)庫，管理數(shù)據(jù)古引擎的安全。IBM把他公開發(fā)行，于是就變成了現(xiàn)在為大家所知的SQL。由于歷史的原因SQL和讀成sequel，也可以逐字段拼成S-Q-L。在現(xiàn)在的數(shù)據(jù)庫引擎里，已經(jīng)有了好多種SQL版本。微軟SQL server 使用的是T-SQL，它代表的是事務(wù)SQL。 什么是SQL ServerSQL Server是一個(gè)客戶機(jī)/服務(wù)器關(guān)系型數(shù)據(jù)庫管理系統(tǒng)（RDBMS），它使用事務(wù)SQL在客戶機(jī)和SQL服務(wù)器之間傳送請求。 客戶機(jī)-服務(wù)器體系結(jié)構(gòu)術(shù)語客戶機(jī)、服務(wù)器和客戶機(jī)-服務(wù)器可以是非常廣泛的概念或指硬件、軟件、。按最一般的概念，客戶機(jī)是從系統(tǒng)其他部件請求服務(wù)或資源的系統(tǒng)的任何部件；服務(wù)器是向系統(tǒng)其他部件提供服務(wù)或資源的任何部件。例如，當(dāng)用戶從網(wǎng)絡(luò)上的工作站打印一個(gè)文件時(shí)，工作站是客戶機(jī)，用做假脫機(jī)打印的機(jī)器是服務(wù)器。任何基于數(shù)據(jù)的客戶機(jī)、務(wù)器系統(tǒng)都是由下列部件組成。服務(wù)器數(shù)據(jù)項(xiàng)和支持對象的匯集，其中這些對象是有組織的，并隨時(shí)準(zhǔn)備提交，以便為數(shù)據(jù)的搜索、分類、重組、檢索、更新和分析之類的服務(wù)提供便利。數(shù)據(jù)庫由數(shù)據(jù)的物理存儲(chǔ)器和數(shù)據(jù)庫服務(wù)組成。所有的數(shù)據(jù)訪問都通過服務(wù)器進(jìn)行，客戶一概不呢功能直接訪問物理數(shù)據(jù)?？蛻魴C(jī)-一個(gè)軟件程序，該程序應(yīng)該由個(gè)人交互使用或可能是一個(gè)自動(dòng)進(jìn)程。其中包括從數(shù)據(jù)庫請求數(shù)據(jù)，或向數(shù)據(jù)庫送數(shù)的與服務(wù)器交互作用的所有軟件，例如管理實(shí)用程序（這些是SQL服務(wù)器產(chǎn)品的一部分并且是單獨(dú)購買的）、特別查詢和報(bào)告軟件、可戶應(yīng)用程序、現(xiàn)貨應(yīng)用程序和基于WEB服務(wù)器的應(yīng)用程序?？蛻魴C(jī)和服務(wù)器之間的通信客戶機(jī)和服務(wù)器之間的通信很大程度上取決于客戶和服務(wù)器是如何實(shí)現(xiàn)的。通信的物理層和邏輯層可以被辨認(rèn)。當(dāng)你用電話與某人通信時(shí)，電話系統(tǒng)是物理層，所獎(jiǎng)的自然語言是通信的邏輯層。對于基于數(shù)據(jù)的系統(tǒng)，如果服務(wù)器和客戶在不同的計(jì)算機(jī)上，則物理層可以是網(wǎng)絡(luò)。如果服務(wù)器和客戶在同一臺(tái)計(jì)算機(jī)上，則通信可在進(jìn)程之間進(jìn)行。物理層邏輯通信結(jié)構(gòu)可以是低層操作系統(tǒng)調(diào)用，一種專用數(shù)據(jù)訪問語言或開放的結(jié)構(gòu)話查詢語言（SQL）。4. IISInternet Information Server的縮寫為（IIS）是一個(gè)World Wide Web server。Gopher server和FTP server全部包容在里面。 IIS意味著你能發(fā)布網(wǎng)頁，并且有ASP（Active Server Pages）、JAVA、VBscript產(chǎn)生頁面，有著一些擴(kuò)展功能。IIS支持一些有趣的東西，象有編輯環(huán)境的界面（FRONTPAGE）、有全文檢索功能的（INDEX SERVER）、有多媒體功能的（NET SHOW） 其次,IIS是隨Windows NT Server 4.0一起提供的文件和應(yīng)用程序服務(wù)器，是在Windows NT Server上建立Internet服務(wù)器的基本組件。它與Windows NT Server完全集成，允許使用Windows NT Server內(nèi)置的安全性以及NTFS文件系統(tǒng)建立強(qiáng)大靈活的InternetIntranet站點(diǎn)。IIS（Internet Information Server，互聯(lián)網(wǎng)信息服務(wù)）是一種Web（網(wǎng)頁）服務(wù)組件，其中包括Web服務(wù)器、FTP服務(wù)器、NNTP服務(wù)器和SMTP服務(wù)器，分別用于網(wǎng)頁瀏覽、文件傳輸、新聞服務(wù)和郵件發(fā)送等方面，它使得在網(wǎng)絡(luò)（包括互聯(lián)網(wǎng)和局域網(wǎng)）上發(fā)布信息成了一件很容易的事。IIS是Internet Information Server的縮寫，它是微軟公司主推的服務(wù)器，最新的版本是Windows2000里面包含的IIS 5，IIS與WindowNT Server完全集成在一起，因而用戶能夠利用Windows NT Server和NTFS（NT File System，NT的文件系統(tǒng)）內(nèi)置的安全特性，建立強(qiáng)大，靈活而安全的Internet和Intranet站點(diǎn)。IIS支持HTTP（Hypertext Transfer Protocol，超文本傳輸協(xié)議），F(xiàn)TP（File Transfer Protocol，文件傳輸協(xié)議）以及SMTP協(xié)議，通過使用CGI和ISAPI，IIS可以得到高度的擴(kuò)展。IIS支持與語言無關(guān)的腳本編寫和組件，通過IIS，開發(fā)人員就可以開發(fā)新一代動(dòng)態(tài)的，富有魅力的Web站點(diǎn)。IIS不需要開發(fā)人員學(xué)習(xí)新的腳本語言或者編譯應(yīng)用程序，IIS完全支持VBScript，JScript開發(fā)軟件以及Java，它也支持CGI和WinCGI，以及ISAPI擴(kuò)展和過濾器。IIS的設(shè)計(jì)目的是建立一套集成的服務(wù)器服務(wù)，用以支持HTTP，F(xiàn)TP和SMTP，它能夠提供快速且集成了現(xiàn)有產(chǎn)品，同時(shí)可擴(kuò)展的Internet服務(wù)器。IIS相應(yīng)性極高，同時(shí)系統(tǒng)資源的消耗也是最少，IIS的安裝，管理和配置都相當(dāng)簡單，這是因?yàn)镮IS與Windows NT Server網(wǎng)絡(luò)操作系統(tǒng)緊密的集成在一起，另外，IIS還使用與Windows NT Server相同的SAM（Security Accounts Manager，安全性賬號(hào)管理器），對于管理員來說，IIS使用諸如Performance Monitor和SNMP（Simple Nerwork Management Protocol，簡單網(wǎng)絡(luò)管理協(xié)議）之類的NT已有管理工具。IIS支持ISAPI，使用ISAPI可以擴(kuò)展服務(wù)器功能，而使用ISAPI過濾器可以預(yù)先處理和事后處理儲(chǔ)存在IIS上的數(shù)據(jù)。用于32位Windows應(yīng)用程序的Internet擴(kuò)展可以把FTP，SMTP和HTTP協(xié)議置于容易使用且任務(wù)集中的界面中，這些界面將Internet應(yīng)用程序的使用大大簡化，IIS也支持MIME（Multipurpose Internet Mail Extensions，多用于Internet郵件擴(kuò)展），它可以為Internet應(yīng)用程序的訪問提供一個(gè)簡單的注冊項(xiàng)。IIS的一個(gè)重要特性是支持ASP。IIS 3.0版本以后引的ASP，可以很容易的張貼動(dòng)態(tài)內(nèi)容和開發(fā)基于Web的應(yīng)用程序。對于諸如VBScript，JScript開發(fā)軟件，或者由Visual Basic，Java，Visual C+開發(fā)系統(tǒng)，以及現(xiàn)有的CGI和WinCGI腳本開發(fā)的應(yīng)用程序，IIS都提供強(qiáng)大的本地支持。