計算機類外文翻譯---asp的網站新聞管理系統(tǒng)的設計與實現

1、<p><b>　　中文2500字</b></p><p>　　The Design and Implementation of ASP Web Site News Management Systems </p><p><b>　　Abstract </b></p><p>　　The use of ASP a

2、nd SQL technology news site management system, to achieve the dynamic management of the news Web site, making the management of information more timely, efficient, improve the work efficiency. At the same time, the devel

3、opment of systems theory, systems and design features are introduced. </p><p>　　[Key word] ASP，SQL，news management，database</p><p>　　With the popularization of Internet, more and more companies

4、set up their own WWW sites, enterprises can display products through the website, publishing the latest developments, with users sharing and communication to establish contact with partners, as well as e-commerce. Inform

5、ation Management System which is an enterprise Web site an important part of it bears a double role, on the one hand, the dynamic can be used to release the new product or new development projects, on the other hand, th&

6、lt;/p><p>　　Management of traditional news sites in two ways, one static HTML page, update the information needed to re-create the page and then upload the page and modify the corresponding links, the efficienc

7、y of this approach is too low because we have little use. The second is based on ASP and scripting languages, dynamic Web pages and databases, through the application of procedures to deal with news, this is way more pop

8、ular. However, due to the limitations of ASP allows the system itself, there are s</p><p>　　1. ASP page to open as a result of each must be compiled to explain the process, so when the page opens in the rate

9、 of repeated there is no upgrade, and only need a ASP.NET page do not need to recompile compiled until the page has been modified or Web Application process restarted. This makes the speed in a number of visits has great

10、ly improved. </p><p>　　2. As the ASP does not provide any output data for the content of the components, so writing a database using ASP page can use the Record Set Object ADO to read records of transaction,

11、 while the ASP provided through the DataGrid, such as ADO.NET database and database components can be directly Contact. </p><p>　　3. ASP support real-time application updates. Administrators do not have to t

12、urn off the network server or even do not have to stop running the application can update the application on file. Application documents will never be locked, so even when the program runs in the paper can be overwritten

13、. When the document is updated, the system will convert to the new moderate version. </p><p>　　4. ASP take the "code-behind" approach to the preparation of the code makes the code easier to prepare

14、, structure more clearly, reducing the system development and maintenance of the complexity and the cost of.</p><p>　　1 System Development Principle</p><p>　　1.1 The System Architecture Model of

15、 ASP-based Technology</p><p>　　ASP is a three-tier system structure: UI Layer, Business Logic Tier and data layer.</p><p>　　UI layer is responsible for interaction with the user, receiving user

16、input and server-side data from present to clients. </p><p>　　Business Logic Tier is responsible for receiving requests from browser requests to the data layers and at the same time the results of the reques

17、t sent to the browser. It consists of Web Forms, XML Web services and service composition components. Web Forms ASP.NET which is the core of the application, it is presented to customers based on data and information as

18、well as to respond to and deal with customers and display interactive Web form generated based on information and data. </p><p>　　Data layers to manipulate data through the ADO.NET layer for business logic t

19、o provide data services, such as storing the results of data manipulation and return to the results of data retrieval.</p><p>　　1.2 The principle of access to the database ADO.NET</p><p>　　Conne

20、cted with the database, ADO.NET provide the following three kinds of ways: through ODBC connected; connected through OLEDB; directly connected with the SQL Server. Application of three kinds of ways as a result of differ

21、ences in levels, making the efficiency from low to high, high to low independence. Connected to the database for data processing, there are two kinds of ways, that is, through a Dataset to the isolation of heterogeneous

22、data sources, and the other is a stream to read from th</p><p>　　Traditional application is to create a connection to the database, in the process is running the whole way to maintain connections to the desi

23、gn. ASP.NET taken disconnected mode data structure. When a browser requests a page to the Web server, the server to deal with this request, the requested page and send to your browser, and then connection was disconnecte

24、d until the next browser request issued. </p><p>　　ADO.NET Another innovation is the introduction of a data set (Dataset). A data set is the relationship between memory map to provide high-speed data buffer.

25、 Data set of data sources know that they can be adopted by the program or transferred from the data warehouse data were generated, to fill. Regardless of where the data acquisition, data sets are the same procedure throu

26、gh the use of templates to be operated, and it's potential to use the same data buffer.</p><p>　　2 Systems Functional Designs</p><p>　　2.1 Systems Function Structures</p><p>　　T

27、he news management system in Windows 2000 Server operating system platforms, Web server IIS, the database server for Microsoft SQL Server2000, development tools used in Microsoft Visual Studio. NET and DreamWeaver. Its w

28、ork processes as follows: the user login through the authority to determine the general user can only browse, read and query information, registered users can be completed in addition to the ordinary user, but also can e

29、nter information for news management module input, modify, </p><p>　　2.2 Systems Function Characteristics</p><p>　　(1) Simple, user-friendly: complete control of page layout, making information

30、easier entry work; many options including news categories, such as the source of departments only need to click the mouse can be completed; In addition, the follow-up message also appears allow users to clear their own o

31、perations. </p><p>　　(2) Can be seen immediately: the handling of the press (including the entry, modify, delete) will be the corresponding column on the home page is displayed to "immediate release, im

32、mediate results" function. </p><p>　　(3) Function: include common site in all aspects of information management: information input, browse, delete, modify, search and other aspects, the full realization

33、 of the Web site of the real-time information management requirements. </p><p>　　(4) To facilitate transplantation: for different enterprises, with some slight modifications need to be able to develop for th

34、e company's Web site features news management system.</p><p>　　3 Systems Detailed Designs</p><p>　　Core functions of the system through a number of functional modules achieved. Specific desi

35、gn process is as follows: </p><p>　　⑴ System login: The module responsible for the user are divided into general users and registered users to achieve the management of user rights. </p><p>　　(2

36、) News View: The module is responsible for all the news page web site lists information, including the title, type, source and date field departments, and each title has been made news a hyperlink, click the page they wi

37、ll be able to Jump news reader. </p><p>　　(3) News reader: in other pages or click the title link to read into the news pages, at this time, detailed information of each information will be removed, includin

38、g the content, title, keywords, and relatively fixed in accordance with the format placed in different pages region, the use of all the news about the same page layout, only the contents of the field corresponding to dif

39、ferent In addition, the location of other pages can be dynamically placed in other components, such as web site log</p><p>　　(4) News Inquiry: The module provides a press inquiry, type to be selected to find

40、 the content and classification of information can quickly find the information in line with the conditions and results output. </p><p>　　(5) News Management: The module listed in the registry is responsible

41、 for the registration page the user has issued a news and information and did not delete, the user can press to delete the article, modify. In addition to non-news publisher is not outside the system administrator has th

42、e authority to deal with information which, so different users access to this page will display different content. </p><p>　　(6) News entry and modification: a press registered users need to input the conten

43、t, including title, keyword, type, source of departments, such as release date, at the same time from the login module to be user name, this information will be saved into the database. The module is also responsible for

44、 editing the updated state, then, it will light the Title field values on the page to initialize the control.</p><p>　　asp的網站新聞管理系統(tǒng)的設計與實現</p><p><b>　　摘要</b></p><p>　　利用A

45、SP和SQL技術開發(fā)的網站新聞管理系統(tǒng)，實現了網站新聞的動態(tài)管理，使得對信息的管理更加及時、高效，提高了工作效率。同時對系統(tǒng)的開發(fā)原理、系統(tǒng)的功能特點和設計方案進行了介紹。</p><p>　　【關鍵詞】ASP，SQL，新聞管理，數據庫</p><p>　　隨著Internet的普及，越來越多的企業(yè)建立了自己的WWW網站，企業(yè)通過網站可以展示產品，發(fā)布最新動態(tài)，與用戶進行交流和溝通，與合作

46、伙伴建立聯(lián)系，以及開展電子商務等。其中新聞管理系統(tǒng)是構成企業(yè)網站的一個重要組成部分，它擔負著雙層作用，一方面可以用來動態(tài)發(fā)布有關新產品或新開發(fā)項目，另一方面又可以及時向顧客公告企業(yè)經營業(yè)績、技術與研發(fā)進展、特別推薦或優(yōu)惠的工程項目、產品和服務，從而吸引顧客，擴大顧客群。</p><p>　　傳統(tǒng)的網站新聞管理方式有兩種，一是靜態(tài)HTML頁面，更新信息時需要重新制作頁面然后上傳頁面并修改相應鏈接，這種方式因為效率太

47、低已不多用。二是基于ASP和腳本語言，將動態(tài)網頁和數據庫結合，通過應用程序來處理新聞，這是目前較為流行的做法。但是由于ASP本身的局限性使得系統(tǒng)有一些不可克服的缺陷，而采取了ASP.NET技術的系統(tǒng)性能上有了很大的改善，其主要表現在以下幾方面：</p><p>　　1．由于ASP頁面每次打開都必須經過先編譯后解釋的過程，所以頁面在反復打開時速度沒有任何提升，而ASP.NET頁面只需要一次編譯后不需要重新編譯，直到

48、該頁面被修改或Web應用程序重新啟動。這使得在多次訪問時速度有了極大的提升。</p><p>　　2．由于ASP沒有提供任何輸出數據為內容的元件，所以在使用ASP撰寫數據庫頁面時只能借助ADO的Record Set對象逐筆讀取記錄，而ASP通過ADO.NET提供的DataGrid等數據庫元件可以直接和數據庫聯(lián)系。</p><p>　　3．ASP支持應用程序的實時更新。管理員不必關掉網絡服務

49、器或者甚至不用停止應用程序的運行就可以更新應用文件。應用程序文件永遠不會被加鎖，因此甚至在程序運行時文件就可以被覆蓋。當文件更新后，系統(tǒng)會溫和地轉換到新的版本。</p><p>　　4．ASP采取"code-behind"方式編寫代碼使得代碼更易于編寫，結構更清晰，降低了系統(tǒng)的開發(fā)與維護的復雜度和費用。</p><p><b>　　1系統(tǒng)的開發(fā)原理</b

50、></p><p>　　1.1 基于ASP技術的系統(tǒng)結構模型</p><p>　　ASP結構是一個三層系統(tǒng)：UI層、業(yè)務邏輯層和數據層。</p><p>　　UI層負責與用戶交互，接收用戶的輸入并將服務器端傳來的數據呈現給客戶。</p><p>　　業(yè)務邏輯層負責接收瀏覽器傳來的請求并將請求傳給數據層，同時將請求處理結果發(fā)給瀏覽器。它由

51、Web表單、XML Web服務和組件服務組成。其中Web表單是ASP.NET應用程序的核心所在，它是向客戶呈現數據和信息的基礎，也是響應和處理客戶與顯示的Web表單交互生成的信息和數據的基礎。</p><p>　　數據層是通過ADO.NET操縱數據為事務邏輯層提供數據服務，如存儲數據操作結果、返回數據檢索結果等。</p><p>　　1.2 ADO.NET訪問數據庫的原理</p>

52、;<p>　　與數據庫相連，ADO.NET提供了如下3種方式：通過ODBC相連；通過OLEDB相連；直接與SQL Server相連。3種方式由于應用層次的差異，使得效率由低到高，獨立性由高到低。對于相連數據庫的數據處理，也有2種方式，即一種是通過Dataset來隔離異構的數據源，另一種是以流方式從數據源讀取(Data Reader方式)。</p><p>　　傳統(tǒng)的應用程序是通過先建立到數據庫的連接

53、，在程序的整個運行過程中維護連接的方式來設計的。ASP.NET采取了斷開連接方式的數據結構。當瀏覽器向Web服務器請求網頁時，服務器處理這個請求，并將所請求的網頁發(fā)送給瀏覽器，然后連接就被斷開，直到瀏覽器發(fā)出下一個請求。</p><p>　　ADO.NET的另一個創(chuàng)新是引入了數據集(Dataset)。一個數據集是內存中提供數據關系圖的高速緩沖區(qū)。數據集對數據源一無所知，它們可以由程序或通過從數據倉庫中調入數據而被

54、生成、填充。不論數據從何處獲取，數據集都是通過使用同樣的程序模板而被操作的，并且它使用相同的潛在的數據緩沖區(qū)。</p><p><b>　　2 系統(tǒng)的功能設計</b></p><p>　　2.1 系統(tǒng)的功能結構</p><p>　　該新聞管理系統(tǒng)可以在Windows 2000 Server操作系統(tǒng)平臺上運行，Web服務器為IIS，數據庫服務器為

55、Microsoft SQL Server2000，開發(fā)工具采用的Microsoft Visual Studio .NET和DreamWeaver。其工作流程為：用戶登錄通過權限判斷，普通用戶只能瀏覽、閱讀和查詢新聞，注冊用戶除了可以完成普通用戶的操作外，還可以進入新聞管理模塊進行新聞錄入、修改和刪除的操作。注冊用戶除系統(tǒng)管理員外只能對自己錄入的新聞進行刪改操作。</p><p>　　2.2 系統(tǒng)的功能特點<

56、/p><p>　?。?）操作簡單、界面友好：完全控件式的頁面布局，使得新聞的錄入工作更簡便；許多選項包括新聞類別、來源部門等只需要點擊鼠標就可以完成；另外，跟蹤出現的提示信息也讓用戶隨時清楚自己的操作情況。</p><p>　?。?）即時可見：對新聞的處理（包括錄入、修改、刪除）將立即在主頁的對應欄目顯示出來，達到“即時發(fā)布、即時見效”的功能。</p><p>　?。?

57、）功能完善：包括常見網站的新聞管理的各個方面：新聞錄入、瀏覽、刪除、修改、檢索等各個方面，完整地實現了網站對即時新聞的管理要求。</p><p>　?。?）方便移植：針對不同的企業(yè)，只需要稍作修改就可以開發(fā)出適合本企業(yè)特點的網站新聞管理系統(tǒng)。 </p><p><b>　　3 系統(tǒng)的詳細設計</b></p><p>　　系統(tǒng)的主要功能是通過幾個

58、功能模塊來實現的。具體的設計過程如下：</p><p>　?。?）系統(tǒng)登錄：該模塊負責將用戶分為普通用戶和注冊用戶來實現用戶權限的管理。</p><p>　?。?）新聞瀏覽：該模塊負責分頁列出網站所有新聞的信息，包括標題、類型、來源部門字段及發(fā)布日期，每條新聞的標題被做成一個超鏈接，點擊它們就能跳轉頁面進行新聞閱讀。 </p><p>　?。?）新聞閱讀：在其他頁面

59、中點擊標題鏈接即進入新聞閱讀頁面，此時，每條新聞的詳細信息將被取出，包括內容、標題、關鍵字等，并按照相對固定的格式放置在頁面的不同區(qū)域，所有新聞使用大致相同的頁面布局，只是各字段對應的內容不同而已，另外，頁面其它位置，可以動態(tài)放置其他元件，如網站標志logo、頁面廣告banner等鏈接圖片，這樣可以很容易地實現圖文并茂的閱讀效果。</p><p>　?。?）新聞查詢：該模塊提供了新聞查詢功能，輸入待查找的內容及選

60、定分類信息可以快速地找到符合條件的新聞，并輸出查詢結果。</p><p>　　（5）新聞管理：該模塊負責分頁羅列登錄的注冊用戶曾發(fā)布過且未刪除的新聞信息，用戶可以對該條新聞進行刪除、修改。非新聞發(fā)布者除系統(tǒng)管理員外不具有對該條新聞的處理權限，所以不同用戶進入此頁面將顯示不同的內容。</p><p>　?。?）新聞錄入和修改：注冊用戶錄入一條新聞所需要的內容，包含標題、關鍵字、類型、來源部門