外文翻譯--基于.net的新聞管理網(wǎng)站系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)

1、<p>　　中文2445字，1500單詞，7740英文字符</p><p><b>　　專(zhuān)業(yè)外文翻譯</b></p><p>　題 目Based on .NET of Design and</p><p>　Implementation of News</p><p>　Management Websit

2、e System</p><p>　系 （院）信息工程系</p><p>　專(zhuān) 業(yè)計(jì)算機(jī)科學(xué)與技術(shù)</p><p>　班 級(jí)</p><p>　學(xué)生姓名</p><p>　學(xué) 號(hào)</p><p>　指導(dǎo)教師</p><p>　職 稱</p&

3、gt;<p>　　Based on .NET of Design and implementation of news management website system </p><p>　　The use of ASP and SQL technology news site management system, to achieve the dynamic management of the

4、news Web site, making the management of information more timely, efficient, improve the work efficiency. At the same time, the development of systems theory, systems and design features are introduced. </p><p&

5、gt;　　With the popularization of Internet, more and more companies set up their own WWW sites, enterprises can display products through the website, publishing the latest developments, with users sharing and communication

6、 to establish contact with partners, as well as e-commerce. Information 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 t

7、he new product or new development projects, on the other hand, th</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

8、 upload the page and modify the corresponding links, the efficiency 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

9、 application of procedures to deal with news, this is way more popular. 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 c

10、ompiled to explain the process, so when the page opens in the rate 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 proce

11、ss restarted. This makes the speed in a number of visits has greatly 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

12、 can use the Record Set Object ADO to read records of transaction, while the ASP provided through the DataGrid, such as ADO.NET database and database components can be directly Contact. </p><p>　　3. ASP supp

13、ort real-time application updates. Administrators do not have to turn 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 loc

14、ked, so even when the program runs in the paper can be overwritten. When the document is updated, the system will convert to the new moderate version. </p><p>　　4. ASP take the "code-behind" approa

15、ch to the preparation of the code makes the code easier to prepare, structure more clearly, reducing the system development and maintenance of the complexity and the cost of.</p><p>　　1 System Development Pr

16、inciple</p><p>　　1.1 The System Architecture Model of ASP-based Technology</p><p>　　ASP is a three-tier system structure: UI Layer, Business Logic Tier and data layer.</p><p>　　UI l

17、ayer is responsible for interaction with the user, receiving user input and server-side data from present to clients. </p><p>　　Business Logic Tier is responsible for receiving requests from browser requests

18、 to the data layers and at the same time the results of the request 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 applicati

19、on, it is presented to customers based on data and information as well as to respond to and deal with customers and display interactive Web form generated based on information and data. </p><p>　　Data layers

20、 to manipulate data through the ADO.NET layer for business logic to provide data services, such as storing the results of data manipulation and return to the results of data retrieval.</p><p>　　1.2 The princ

21、iple of access to the database ADO.NET</p><p>　　Connected with the database, ADO.NET provide the following three kinds of ways: through ODBC connected; connected through OLEDB; directly connected with the SQ

22、L Server. Application of three kinds of ways as a result of differences 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 w

23、ays, that is, through a Dataset to the isolation of heterogeneous 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 pr

24、ocess is running the whole way to maintain connections to the design. 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

25、page and send to your browser, and then connection was disconnected 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

26、relationship between memory map to provide high-speed data buffer. 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

27、where the data acquisition, data sets are the same procedure through the use of templates to be operated, and it's potential to use the same data buffer.</p><p>　　2 Systems Functional Designs</p>

28、<p>　　2.1 Systems Function Structures</p><p>　　The news management system in Windows 2000 Server operating system platforms, Web server IIS, the database server for Microsoft SQL Server2000, development

29、 tools used in Microsoft Visual Studio. NET and DreamWeaver. Its work processes as follows: the user login through the authority to determine the general user can only browse, read and query information, registered users

30、 can be completed in addition to the ordinary user, but also can enter information for news management module input, modify, </p><p>　　2.2 Systems Function Characteristics</p><p>　　(1) Simple, u

31、ser-friendly: complete control of page layout, making information 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, t

32、he follow-up message also appears allow users to clear their own operations. </p><p>　　(2) Can be seen immediately: the handling of the press (including the entry, modify, delete) will be the corresponding c

33、olumn on the home page is displayed to "immediate release, immediate results" function. </p><p>　　(3) Function: include common site in all aspects of information management: information input, brow

34、se, delete, modify, search and other aspects, the full realization of the Web site of the real-time information management requirements. </p><p>　　(4) To facilitate transplantation: for different enterprises

35、, with some slight modifications need to be able to develop for the company's Web site features news management system.</p><p>　　3 Systems Detailed Designs</p><p>　　Core functions of the sys

36、tem through a number of functional modules achieved. Specific design process is as follows: </p><p>　?、?System login: The module responsible for the user are divided into general users and registered users t

37、o achieve the management of user rights. </p><p>　　(2) 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

38、 each title has been made news a hyperlink, click the page they will 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,

39、detailed information of each information will be removed, including 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 sam

40、e page layout, only the contents of the field corresponding to different In addition, the location of other pages can be dynamically placed in other components, such as web site log</p><p>　　(4) News Inquiry

41、: The module provides a press inquiry, type to be selected to find the content and classification of information can quickly find the information in line with the conditions and results output. </p><p>　　(5)

42、 News Management: The module listed in the registry is responsible 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

43、 non-news publisher is not outside the system administrator has the authority to deal with information which, so different users access to this page will display different content. </p><p>　　(6) News entry a

44、nd modification: a press registered users need to input the content, 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 w

45、ill be saved into the database. The module is also responsible for editing the updated state, then, it will light the Title field values on the page to initialize the control.</p><p>　　基于.NET的新聞管理網(wǎng)站系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)&l

46、t;/p><p>　　利用ASP和SQL技術(shù)開(kāi)發(fā)的網(wǎng)站新聞管理系統(tǒng)，實(shí)現(xiàn)了網(wǎng)站新聞的動(dòng)態(tài)管理，使得對(duì)信息的管理更加及時(shí)、高效，提高了工作效率。同時(shí)對(duì)系統(tǒng)的開(kāi)發(fā)原理、系統(tǒng)的功能特點(diǎn)和設(shè)計(jì)方案進(jìn)行了介紹。</p><p>　　隨著Internet的普及，越來(lái)越多的企業(yè)建立了自己的WWW網(wǎng)站，企業(yè)通過(guò)網(wǎng)站可以展示產(chǎn)品，發(fā)布最新動(dòng)態(tài)，與用戶進(jìn)行交流和溝通，與合作伙伴建立聯(lián)系，以及開(kāi)展電子商務(wù)等。其中新

47、聞管理系統(tǒng)是構(gòu)成企業(yè)網(wǎng)站的一個(gè)重要組成部分，它擔(dān)負(fù)著雙層作用，一方面可以用來(lái)動(dòng)態(tài)發(fā)布有關(guān)新產(chǎn)品或新開(kāi)發(fā)項(xiàng)目，另一方面又可以及時(shí)向顧客公告企業(yè)經(jīng)營(yíng)業(yè)績(jī)、技術(shù)與研發(fā)進(jìn)展、特別推薦或優(yōu)惠的工程項(xiàng)目、產(chǎn)品和服務(wù)，從而吸引顧客，擴(kuò)大顧客群。</p><p>　　傳統(tǒng)的網(wǎng)站新聞管理方式有兩種，一是靜態(tài)HTML頁(yè)面，更新信息時(shí)需要重新制作頁(yè)面然后上傳頁(yè)面并修改相應(yīng)鏈接，這種方式因?yàn)樾侍鸵巡欢嘤?。二是基于ASP和腳本語(yǔ)言，將

48、動(dòng)態(tài)網(wǎng)頁(yè)和數(shù)據(jù)庫(kù)結(jié)合，通過(guò)應(yīng)用程序來(lái)處理新聞，這是目前較為流行的做法。ASP.NET技術(shù)的系統(tǒng)性能上有了很大的改善，其主要表現(xiàn)在以下幾方面：</p><p>　　1．由于ASP頁(yè)面每次打開(kāi)都必須經(jīng)過(guò)先編譯后解釋的過(guò)程，所以頁(yè)面在反復(fù)打開(kāi)時(shí)速度沒(méi)有任何提升，而ASP.NET頁(yè)面只需要一次編譯后不需要重新編譯，直到該頁(yè)面被修改或Web應(yīng)用程序重新啟動(dòng)。這使得在多次訪問(wèn)時(shí)速度有了極大的提升。</p>&l

49、t;p>　　2．由于ASP沒(méi)有提供任何輸出數(shù)據(jù)為內(nèi)容的元件，所以在使用ASP撰寫(xiě)數(shù)據(jù)庫(kù)頁(yè)面時(shí)只能借助ADO的Record Set對(duì)象逐筆讀取記錄，而ASP通過(guò)ADO.NET提供的DataGrid等數(shù)據(jù)庫(kù)元件可以直接和數(shù)據(jù)庫(kù)聯(lián)系。</p><p>　　3．ASP支持應(yīng)用程序的實(shí)時(shí)更新。管理員不必關(guān)掉網(wǎng)絡(luò)服務(wù)器或者甚至不用停止應(yīng)用程序的運(yùn)行就可以更新應(yīng)用文件。應(yīng)用程序文件永遠(yuǎn)不會(huì)被加鎖，因此甚至在程序運(yùn)行時(shí)文件

50、就可以被覆蓋。當(dāng)文件更新后，系統(tǒng)會(huì)溫和地轉(zhuǎn)換到新的版本。</p><p>　　4．ASP采取"code-behind"方式編寫(xiě)代碼使得代碼更易于編寫(xiě)，結(jié)構(gòu)更清晰，降低了系統(tǒng)的開(kāi)發(fā)與維護(hù)的復(fù)雜度和費(fèi)用。</p><p><b>　　1系統(tǒng)的開(kāi)發(fā)原理</b></p><p>　　1.1 基于ASP技術(shù)的系統(tǒng)結(jié)構(gòu)模型</p&

51、gt;<p>　　ASP結(jié)構(gòu)是一個(gè)三層系統(tǒng)：UI層、業(yè)務(wù)邏輯層和數(shù)據(jù)層。</p><p>　　UI層負(fù)責(zé)與用戶交互，接收用戶的輸入并將服務(wù)器端傳來(lái)的數(shù)據(jù)呈現(xiàn)給客戶。</p><p>　　業(yè)務(wù)邏輯層負(fù)責(zé)接收瀏覽器傳來(lái)的請(qǐng)求并將請(qǐng)求傳給數(shù)據(jù)層，同時(shí)將請(qǐng)求處理結(jié)果發(fā)給瀏覽器。它由Web表單、XML Web服務(wù)和組件服務(wù)組成。其中Web表單是ASP.NET應(yīng)用程序的核心所在，它是向客

52、戶呈現(xiàn)數(shù)據(jù)和信息的基礎(chǔ)，也是響應(yīng)和處理客戶與顯示的Web表單交互生成的信息和數(shù)據(jù)的基礎(chǔ)。</p><p>　　數(shù)據(jù)層是通過(guò)ADO.NET操縱數(shù)據(jù)為事務(wù)邏輯層提供數(shù)據(jù)服務(wù)，如存儲(chǔ)數(shù)據(jù)操作結(jié)果、返回?cái)?shù)據(jù)檢索結(jié)果等。</p><p>　　1.2 ADO.NET訪問(wèn)數(shù)據(jù)庫(kù)的原理</p><p>　　與數(shù)據(jù)庫(kù)相連，ADO.NET提供了如下3種方式：通過(guò)ODBC相連；通過(guò)OLE

53、DB相連；直接與SQL Server相連。3種方式由于應(yīng)用層次的差異，使得效率由低到高，獨(dú)立性由高到低。對(duì)于相連數(shù)據(jù)庫(kù)的數(shù)據(jù)處理，也有2種方式，即一種是通過(guò)Dataset來(lái)隔離異構(gòu)的數(shù)據(jù)源，另一種是以流方式從數(shù)據(jù)源讀取(Data Reader方式)。</p><p>　　傳統(tǒng)的應(yīng)用程序是通過(guò)先建立到數(shù)據(jù)庫(kù)的連接，在程序的整個(gè)運(yùn)行過(guò)程中維護(hù)連接的方式來(lái)設(shè)計(jì)的。ASP.NET采取了斷開(kāi)連接方式的數(shù)據(jù)結(jié)構(gòu)。當(dāng)瀏覽器向W

54、eb服務(wù)器請(qǐng)求網(wǎng)頁(yè)時(shí)，服務(wù)器處理這個(gè)請(qǐng)求，并將所請(qǐng)求的網(wǎng)頁(yè)發(fā)送給瀏覽器，然后連接就被斷開(kāi)，直到瀏覽器發(fā)出下一個(gè)請(qǐng)求。</p><p>　　ADO.NET的另一個(gè)創(chuàng)新是引入了數(shù)據(jù)集(Dataset)。一個(gè)數(shù)據(jù)集是內(nèi)存中提供數(shù)據(jù)關(guān)系圖的高速緩沖區(qū)。數(shù)據(jù)集對(duì)數(shù)據(jù)源一無(wú)所知，它們可以由程序或通過(guò)從數(shù)據(jù)倉(cāng)庫(kù)中調(diào)入數(shù)據(jù)而被生成、填充。不論數(shù)據(jù)從何處獲取，數(shù)據(jù)集都是通過(guò)使用同樣的程序模板而被操作的，并且它使用相同的潛在的數(shù)據(jù)緩

55、沖區(qū)。</p><p><b>　　2 系統(tǒng)的功能設(shè)計(jì)</b></p><p>　　2.1 系統(tǒng)的功能結(jié)構(gòu)</p><p>　　該新聞管理系統(tǒng)可以在Windows 2000 Server操作系統(tǒng)平臺(tái)上運(yùn)行，Web服務(wù)器為IIS，數(shù)據(jù)庫(kù)服務(wù)器為Microsoft SQL Server2000，開(kāi)發(fā)工具采用的Microsoft Visual Stu

56、dio .NET和DreamWeaver。其工作流程為：用戶登錄通過(guò)權(quán)限判斷，普通用戶只能瀏覽、閱讀和查詢新聞，注冊(cè)用戶除了可以完成普通用戶的操作外，還可以進(jìn)入新聞管理模塊進(jìn)行新聞錄入、修改和刪除的操作。注冊(cè)用戶除系統(tǒng)管理員外只能對(duì)自己錄入的新聞進(jìn)行刪改操作。</p><p>　　2.2 系統(tǒng)的功能特點(diǎn)</p><p>　?。?）操作簡(jiǎn)單、界面友好：完全控件式的頁(yè)面布局，使得新聞的錄入工作

57、更簡(jiǎn)便；許多選項(xiàng)包括新聞?lì)悇e、來(lái)源部門(mén)等只需要點(diǎn)擊鼠標(biāo)就可以完成；另外，跟蹤出現(xiàn)的提示信息也讓用戶隨時(shí)清楚自己的操作情況。</p><p>　　（2）即時(shí)可見(jiàn)：對(duì)新聞的處理（包括錄入、修改、刪除）將立即在主頁(yè)的對(duì)應(yīng)欄目顯示出來(lái)，達(dá)到“即時(shí)發(fā)布、即時(shí)見(jiàn)效”的功能。</p><p>　　（3）功能完善：包括常見(jiàn)網(wǎng)站的新聞管理的各個(gè)方面：新聞錄入、瀏覽、刪除、修改、檢索等各個(gè)方面，完整地實(shí)現(xiàn)了網(wǎng)

58、站對(duì)即時(shí)新聞的管理要求。</p><p>　?。?）方便移植：針對(duì)不同的企業(yè)，只需要稍作修改就可以開(kāi)發(fā)出適合本企業(yè)特點(diǎn)的網(wǎng)站新聞管理系統(tǒng)。 </p><p><b>　　3 系統(tǒng)的詳細(xì)設(shè)計(jì)</b></p><p>　　系統(tǒng)的主要功能是通過(guò)幾個(gè)功能模塊來(lái)實(shí)現(xiàn)的。具體的設(shè)計(jì)過(guò)程如下：</p><p>　?。?）系統(tǒng)登錄：該模

59、塊負(fù)責(zé)將用戶分為普通用戶和注冊(cè)用戶來(lái)實(shí)現(xiàn)用戶權(quán)限的管理。</p><p>　?。?）新聞瀏覽：該模塊負(fù)責(zé)分頁(yè)列出網(wǎng)站所有新聞的信息，包括標(biāo)題、類(lèi)型、來(lái)源部門(mén)字段及發(fā)布日期，每條新聞的標(biāo)題被做成一個(gè)超鏈接，點(diǎn)擊它們就能跳轉(zhuǎn)頁(yè)面進(jìn)行新聞閱讀。 </p><p>　　（3）新聞閱讀：在其他頁(yè)面中點(diǎn)擊標(biāo)題鏈接即進(jìn)入新聞閱讀頁(yè)面，此時(shí)，每條新聞的詳細(xì)信息將被取出，包括內(nèi)容、標(biāo)題、關(guān)鍵字等，并按照相對(duì)

60、固定的格式放置在頁(yè)面的不同區(qū)域，所有新聞使用大致相同的頁(yè)面布局，只是各字段對(duì)應(yīng)的內(nèi)容不同而已，另外，頁(yè)面其它位置，可以動(dòng)態(tài)放置其他元件，如網(wǎng)站標(biāo)志logo、頁(yè)面廣告banner等鏈接圖片，這樣可以很容易地實(shí)現(xiàn)圖文并茂的閱讀效果。</p><p>　?。?）新聞查詢：該模塊提供了新聞查詢功能，輸入待查找的內(nèi)容及選定分類(lèi)信息可以快速地找到符合條件的新聞，并輸出查詢結(jié)果。</p><p>　?。?/p>

61、5）新聞管理：該模塊負(fù)責(zé)分頁(yè)羅列登錄的注冊(cè)用戶曾發(fā)布過(guò)且未刪除的新聞信息，用戶可以對(duì)該條新聞進(jìn)行刪除、修改。非新聞發(fā)布者除系統(tǒng)管理員外不具有對(duì)該條新聞的處理權(quán)限，所以不同用戶進(jìn)入此頁(yè)面將顯示不同的內(nèi)容。</p><p>　?。?）新聞錄入和修改：注冊(cè)用戶錄入一條新聞所需要的內(nèi)容，包含標(biāo)題、關(guān)鍵字、類(lèi)型、來(lái)源部門(mén)、發(fā)布日期等，同時(shí)從登錄模塊得到用戶名，這些信息將被寫(xiě)入數(shù)據(jù)庫(kù)中保存。該模塊還負(fù)責(zé)編輯狀態(tài)下的更新，這時(shí)