畢業(yè)設計(外文翻譯)--開發(fā)一個ASP網(wǎng)站所運用的工具

1、 外文翻譯沈陽航空工業(yè)學院北方科技學院2008年7月沈陽航空工業(yè)學院北方科技學院畢業(yè)設計(外文翻譯)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

2、 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 insp

3、ector) 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

4、 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

5、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 ca

6、pabilities 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 s

7、tyles 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 panel

8、s, 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

9、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 ope

10、n(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 th

11、e 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 t

12、hese 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 t

13、o 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

14、-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 relationsh

15、ips 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 betwee

16、n 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 searc

17、h, 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

18、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

19、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 QU

20、ERY 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

21、, 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

22、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 sy

23、stem.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 object

24、s 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 direc

25、tly 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 serve

26、r- 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 natu

27、ral 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

28、 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 pub

29、lish 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 w

30、ith 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 I

31、nternet / 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

32、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 c

33、an 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 SM

34、TP 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 deve

35、lopers 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 SMT

36、P, 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 s

37、ystem 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 too

38、ls.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 inter

39、face, 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 A

40、SP. 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 applica

41、tions developed, IIS provide strong local support.11開發(fā)一個ASP網(wǎng)站所運用的工具1. Dream weaverMacromedia Dreamweaver 是為視覺上設計并且管理網(wǎng)絡站點和網(wǎng)頁的一個專業(yè)的HTML編輯器。不論你是比較喜歡手寫代碼還是在可視化編輯的環(huán)境下工作，Dreamweaver 都向你提供有用的工具讓你快速起手或提高你的網(wǎng)絡設計經(jīng)驗。Dreamweaver 包括許多編碼工具和特征：HTML CSS 和JAVASCRIPT 參考，一個JAVASCRIPT 調(diào)試器，和代碼編輯器（代碼看法和代碼查看器）容許你在Dreamweav

42、er中編輯JAVASCRIPT ，XML 以及其他文本文件。Macromedia 的雙程的HTML 技術可以導入HTML而不會重新格式化。 而且你如果愿意也可以設置Dreamweaver清理代碼或重新格式化HTML。Dreamweaver 的可視化編輯的土正也讓你快速把設計和功能加到你的頁面，而不用寫一行代碼。你能查看所有的你的站點的元素或資源。并且直接從一個容易使用的面版拖拽他們進一個文件。通過在Macromedia Fireworks 中創(chuàng)建并編輯圖象來優(yōu)化你的開發(fā)工作流程，然后直接將他們導入Dreamweaver， 或假如直接在Dreamweaver創(chuàng)造的Flash對象。Dreamwea

43、ver是可完全自定義的。使用Dreamweaver 來創(chuàng)建你自己的對象和命令，修改快捷鍵，甚至寫入JAVASCRIPT來擴展Dreamweaver在新的行為、屬性面板以及站點報告上的能力。Dreamweaver工作區(qū)域讓我門從Dreamweaver工作區(qū)域的簡短的概述開始。如果你已經(jīng)沒安裝Dreamweaver，雙擊Dreamweaver圖標安裝它。Dreamweaver工作區(qū)域不同工作的方式和用戶的水平有不同的界面。當你安裝Dreamweaver時，下列工作區(qū)域打開：當你創(chuàng)造并且編輯頁面時，文件窗口顯示當前的文件對象面板包含一些圖標。你可以點擊插入對象到你的文件。Dreamweaver提供許

44、多浮動的面板，例如HTML式樣面板和代碼檢查器，它使你能夠使用另外的Dreamweaver元素。Launcher 轉(zhuǎn)載器工具條包含打開關閉你的最經(jīng)常使用的檢查器和面板。屬性檢查器所選擇的物體或文章的性質(zhì)，并且讓你修改那些屬性（哪個屬性在檢查器出現(xiàn)取決于在文件中選擇哪個對象）。打開Dreamweaver的窗口，檢查器和面板，使用窗口菜單?？恐诓藛物@示項目有一個勾，表示該項窗口項目在當前打開（盡管它可以被隱蔽在另外的窗戶后面）。要打開一個窗口項目，從菜單選擇項目名字或使用它的鍵盤快捷。使用DreamweaverDreamweaver能在3個方法顯示一個文件：在設計視圖，在代碼視圖，實際與代碼結(jié)合

45、視圖，（改變你在其正在工作的視圖，在Dreamweaver工作跳選擇視圖）Dreamweaver缺省是在設計視圖顯示文件窗口。另外，你呢功能使用設計試圖的兩種方法：在標準視圖與布局視圖。（你在對象面板最下面的視圖分類選擇這些視圖）在布局視圖你能設計頁面布局，插入圖形，正文和另外的煤體。在標準的視圖，除了插入圖形正文煤體，你能也插入層，創(chuàng)建楨文件，創(chuàng)建表格，并且做其他在布局視圖無法做到的改變。2. 數(shù)據(jù)庫眾所周知，數(shù)據(jù)庫是邏輯上相關的數(shù)據(jù)元的匯集。這些數(shù)據(jù)元可以按不同的結(jié)構(gòu)組織起來，以滿足單位和個人的多種處理和探索的需要。數(shù)據(jù)庫本身不是什么新鮮事早期的數(shù)據(jù)庫鑿在石頭上，記在名冊上，以及寫在索引卡

46、中。而現(xiàn)在，數(shù)據(jù)庫普遍記錄在可磁化的介質(zhì)上，并且需要用計算機程序來執(zhí)行必需的存儲和索引操作。如下所述，所有數(shù)據(jù)庫（最簡單的除外）中都有復雜的數(shù)據(jù)關系及其鏈接。處理與創(chuàng)建、訪問以及維護數(shù)據(jù)庫記錄有關的任務的系統(tǒng)軟件包叫做數(shù)據(jù)庫管理系統(tǒng)（DBM）。DBMS軟件包中的程序在數(shù)據(jù)庫與其用戶間建立接口。（這些用戶可以是應用程序員、管理員、及其他需要信息餓人員和各種操作系統(tǒng)程序）。DBMS可組織、處理和表示從數(shù)據(jù)庫中選出的數(shù)據(jù)元。該功能使決策者能搜索、探查和查詢數(shù)據(jù)庫的內(nèi)容， 對在正規(guī)報告中沒有的、不在出現(xiàn)的且無法預料的問題做出回答。這些問題最初可能是模糊的并且（或者）是定義不恰當?shù)模侨藗兛梢詾g覽數(shù)據(jù)

47、庫直到獲得所需的信息。簡言之，DBMS將“管理”存儲的數(shù)據(jù)項，并從公共的數(shù)據(jù)庫中匯集所需的數(shù)據(jù)項以回答非程序員的詢問。在面向文件的系統(tǒng)中，需要特定信息的擁護應將他們的要求傳送給程序員。該程序員在時間容許時，將編寫一個或多哥程序以提取數(shù)據(jù)和準備信息。然而，DBMS的可用性為擁護提供了一個更快的替代通信通道。3. SQL 和SQL 服務器IBM在20世紀70年代，設計了一種專門處理數(shù)據(jù)庫查詢的計算機語言SEQUEL，這幾個字母是結(jié)構(gòu)化英語查詢語言的縮寫。隨著時間的推移，它增加了許多功能，就不僅是一個查詢語言了，還可以創(chuàng)建數(shù)據(jù)庫，管理數(shù)據(jù)古引擎的安全。IBM把他公開發(fā)行，于是就變成了現(xiàn)在為大家所知的

48、SQL。由于歷史的原因SQL和讀成sequel，也可以逐字段拼成S-Q-L。在現(xiàn)在的數(shù)據(jù)庫引擎里，已經(jīng)有了好多種SQL版本。微軟SQL server 使用的是T-SQL，它代表的是事務SQL。 什么是SQL ServerSQL Server是一個客戶機/服務器關系型數(shù)據(jù)庫管理系統(tǒng)（RDBMS），它使用事務SQL在客戶機和SQL服務器之間傳送請求。 客戶機-服務器體系結(jié)構(gòu)術語客戶機、服務器和客戶機-服務器可以是非常廣泛的概念或指硬件、軟件、。按最一般的概念，客戶機是從系統(tǒng)其他部件請求服務或資源的系統(tǒng)的任何部件；服務器是向系統(tǒng)其他部件提供服務或資源的任何部件。例如，當用戶從網(wǎng)絡上的工作站打印一個文

49、件時，工作站是客戶機，用做假脫機打印的機器是服務器。任何基于數(shù)據(jù)的客戶機、務器系統(tǒng)都是由下列部件組成。服務器數(shù)據(jù)項和支持對象的匯集，其中這些對象是有組織的，并隨時準備提交，以便為數(shù)據(jù)的搜索、分類、重組、檢索、更新和分析之類的服務提供便利。數(shù)據(jù)庫由數(shù)據(jù)的物理存儲器和數(shù)據(jù)庫服務組成。所有的數(shù)據(jù)訪問都通過服務器進行，客戶一概不呢功能直接訪問物理數(shù)據(jù)?？蛻魴C-一個軟件程序，該程序應該由個人交互使用或可能是一個自動進程。其中包括從數(shù)據(jù)庫請求數(shù)據(jù)，或向數(shù)據(jù)庫送數(shù)的與服務器交互作用的所有軟件，例如管理實用程序（這些是SQL服務器產(chǎn)品的一部分并且是單獨購買的）、特別查詢和報告軟件、可戶應用程序、現(xiàn)貨應用程序和基于WEB服務器的應用程序?？蛻魴C和服務器之間的通信客戶機和服務器之間的通信很大程度上取決于客戶和服務器是如何實現(xiàn)的。通信的物理層和邏輯層可以被辨認。當你用電話與某人通信時，電話系統(tǒng)是物理層，所獎的自然語言是通信的邏輯層。對于基于數(shù)據(jù)的系統(tǒng)，如果服務器和客戶在不同的計算機上，則物理層可以是網(wǎng)絡。如果服務器和客戶在同一臺計算機上，則通信可在進程之間進行。物理層邏輯通信結(jié)構(gòu)可以是低層操作系統(tǒng)調(diào)用，一種專用數(shù)據(jù)訪問語言或開放的結(jié)構(gòu)話查詢語言（SQL）。4. IISInternet Information Server的縮寫為（IIS）是一個World Wide Web server。Gopher