外文翻譯---asp的網(wǎng)站新聞管理系統(tǒng)的設(shè)計與實現(xiàn)

1、<p>　　畢業(yè)設(shè)計外文資料翻譯</p><p>　　學(xué) 院： </p><p>　　專 業(yè)： </p><p>　　姓 名： </p><p>　　學(xué) 號：

2、 </p><p>　　外文出處：The Design and Implementation of </p><p>　　ASP Web Site News Management Systems</p><p>　　附 件： 1.外文資料翻譯譯文；2.外文原文。 </p><p>　　附件1：外文資料翻譯譯文</p>&l

3、t;p>　　asp的網(wǎng)站新聞管理系統(tǒng)的設(shè)計與實現(xiàn)</p><p>　　利用ASP和SQL技術(shù)開發(fā)的網(wǎng)站新聞管理系統(tǒng)，實現(xiàn)了網(wǎng)站新聞的動態(tài)管理，使得對信息的管理更加及時、高效，提高了工作效率。同時對系統(tǒng)的開發(fā)原理、系統(tǒng)的功能特點和設(shè)計方案進(jìn)行了介紹。</p><p>　　隨著Internet的普及，越來越多的企業(yè)建立了自己的WWW網(wǎng)站，企業(yè)通過網(wǎng)站可以展示產(chǎn)品，發(fā)布最新動態(tài)，與用戶進(jìn)行

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

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

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

7、員不必關(guān)掉網(wǎng)絡(luò)服務(wù)器或者甚至不用停止應(yīng)用程序的運(yùn)行就可以更新應(yīng)用文件。應(yīng)用程序文件永遠(yuǎn)不會被加鎖，因此甚至在程序運(yùn)行時文件就可以被覆蓋。當(dāng)文件更新后，系統(tǒng)會溫和地轉(zhuǎn)換到新的版本。</p><p>　　4．ASP采取"code-behind"方式編寫代碼使得代碼更易于編寫，結(jié)構(gòu)更清晰，降低了系統(tǒng)的開發(fā)與維護(hù)的復(fù)雜度和費(fèi)用。</p><p><b>　　1系統(tǒng)的開

8、發(fā)原理</b></p><p>　　1.1 基于ASP技術(shù)的系統(tǒng)結(jié)構(gòu)模型</p><p>　　ASP結(jié)構(gòu)是一個三層系統(tǒng)：UI層、業(yè)務(wù)邏輯層和數(shù)據(jù)層。</p><p>　　UI層負(fù)責(zé)與用戶交互，接收用戶的輸入并將服務(wù)器端傳來的數(shù)據(jù)呈現(xiàn)給客戶。</p><p>　　業(yè)務(wù)邏輯層負(fù)責(zé)接收瀏覽器傳來的請求并將請求傳給數(shù)據(jù)層，同時將請求處理結(jié)

9、果發(fā)給瀏覽器。它由Web表單、XML Web服務(wù)和組件服務(wù)組成。其中Web表單是ASP.NET應(yīng)用程序的核心所在，它是向客戶呈現(xiàn)數(shù)據(jù)和信息的基礎(chǔ)，也是響應(yīng)和處理客戶與顯示的Web表單交互生成的信息和數(shù)據(jù)的基礎(chǔ)。</p><p>　　數(shù)據(jù)層是通過ADO.NET操縱數(shù)據(jù)為事務(wù)邏輯層提供數(shù)據(jù)服務(wù)，如存儲數(shù)據(jù)操作結(jié)果、返回數(shù)據(jù)檢索結(jié)果等。</p><p>　　1.2 ADO.NET訪問數(shù)據(jù)庫的原理

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

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

12、倉庫中調(diào)入數(shù)據(jù)而被生成、填充。不論數(shù)據(jù)從何處獲取，數(shù)據(jù)集都是通過使用同樣的程序模板而被操作的，并且它使用相同的潛在的數(shù)據(jù)緩沖區(qū)。</p><p><b>　　2 系統(tǒng)的功能設(shè)計</b></p><p>　　2.1 系統(tǒng)的功能結(jié)構(gòu)</p><p>　　該新聞管理系統(tǒng)可以在Windows 2000 Server操作系統(tǒng)平臺上運(yùn)行，Web服務(wù)器為II

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

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

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

16、主要功能是通過幾個功能模塊來實現(xiàn)的。具體的設(shè)計過程如下：</p><p>　?。?）系統(tǒng)登錄：該模塊負(fù)責(zé)將用戶分為普通用戶和注冊用戶來實現(xiàn)用戶權(quán)限的管理。</p><p>　?。?）新聞瀏覽：該模塊負(fù)責(zé)分頁列出網(wǎng)站所有新聞的信息，包括標(biāo)題、類型、來源部門字段及發(fā)布日期，每條新聞的標(biāo)題被做成一個超鏈接，點擊它們就能跳轉(zhuǎn)頁面進(jìn)行新聞閱讀。 </p><p>　　（3）新

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

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

19、字、類型、來源部門、發(fā)布日期等，同時從登錄模塊得到用戶名，這些信息將被寫入數(shù)據(jù)庫中保存。該模塊還負(fù)責(zé)編輯狀態(tài)下的更新，這時，它將根據(jù)取得的Title字段值對頁面控件初始化。</p><p>　　SQL server 簡介</p><p>　　1．SQL Server關(guān)系數(shù)據(jù)庫簡介 </p><p>　　1．SQL Server是由Microsoft開發(fā)和推廣的關(guān)系數(shù)

20、據(jù)庫系統(tǒng)（DBMS)，它最初是由Microsoft、Sybase和Ashton-Tate三家公司共同開發(fā)的，并于1988年推出了第一個OS/2版本。 </p><p>　　2．關(guān)系數(shù)據(jù)庫（RDBMS)管理系統(tǒng)功能： </p><p>　　維護(hù)數(shù)據(jù)庫數(shù)據(jù)之間的關(guān)系； </p><p>　　保證數(shù)據(jù)存儲的正確性； </p><p>　　當(dāng)出現(xiàn)系統(tǒng)

21、故障的時候，將所有數(shù)據(jù)恢復(fù)到能夠保證一致行的某種狀態(tài) </p><p>　　3．RDBMS：SQL Server，Oracle，DB/2,Sybase，Informix </p><p>　　4．Non-RDBMS(File-based）：Foxpro，Access </p><p>　　2、SQL Server 2000的版本 </p><p&

22、gt;　　SQL Server 2000常見版本有： </p><p>　　企業(yè)版（Enterprise Edition） </p><p>　　支持所有SQL Server 2000的功能。該版本多用于大中型產(chǎn)品數(shù)據(jù)庫服務(wù)器，并且可以支持大型網(wǎng)站，企業(yè)OLTP（聯(lián)機(jī)事務(wù)處理）和大型數(shù)據(jù)倉庫系統(tǒng)OLAP(聯(lián)機(jī)分析處理）所要求的性能。 </p><p>　　標(biāo)準(zhǔn)版（S

23、tandard Edition） </p><p>　　實用范圍是小型的工作組或部門。它支持大多數(shù)的SQL Server2000功能。但是，不具有支持大型數(shù)據(jù)庫，數(shù)據(jù)倉庫和網(wǎng)站的功能。而且，不支持所有的關(guān)系數(shù)據(jù)庫引擎的功能。 </p><p>　　個人版（Personal Edition） </p><p>　　主要適用于移動用戶，因為他們經(jīng)常從網(wǎng)絡(luò)上斷開，而運(yùn)行的

24、應(yīng)用程序卻仍然需要SQL Server 2000的支持。除了事務(wù)處理復(fù)制功能以外，能夠支持所有SQL Server 2000標(biāo)準(zhǔn)版支持的特性。 </p><p>　　開發(fā)者版（Developer Edition） </p><p>　　適用于應(yīng)用程序開發(fā)的版本，支持除圖形化語言設(shè)置以外的SQL Server2000的所有其它功能。該版本主要適用于程序員在開發(fā)應(yīng)用程序時，將SQL Serve

25、r 2000作為其數(shù)據(jù)存儲區(qū)。雖然開發(fā)版的功能齊備，但是只被授權(quán)為一個開發(fā)和測試系統(tǒng)，而不是一個產(chǎn)品服務(wù)器。 </p><p>　　2.1 SQL Server特點 </p><p>　　1．與因特網(wǎng)的集成： </p><p>　　SQL Server 2000的數(shù)據(jù)庫引擎全面支持XML（Extensive Markup Language，擴(kuò)展標(biāo)記語言），能使用戶很

26、容易地將數(shù)據(jù)庫中的數(shù)據(jù)發(fā)布到Web頁面上。 </p><p>　　2．可伸縮性與可用性： </p><p>　　可跨越從運(yùn)行Windows 95/98的膝上型電腦到運(yùn)行Windows 2000的大型多處理器等多種平臺使用。另外，對聯(lián)合服務(wù)器，索引視圖等的支持，使得SQL Server 2000企業(yè)版可以升級到最大Web站點所需的性能級別。 </p><p>　　3．

27、企業(yè)級數(shù)據(jù)庫功能： </p><p>　　SQL Server 2000分布式查詢可以引用來自不同數(shù)據(jù)庫的數(shù)據(jù)，而且這些對于用戶來說是完全透明的；分布式數(shù)據(jù)庫將保證任何分布式數(shù)據(jù)更新時的完整性；復(fù)制可以使我們能夠維護(hù)多個數(shù)據(jù)復(fù)本，這些用戶能夠自主地進(jìn)行工作，然后再將所做的修改合并到發(fā)布數(shù)據(jù)庫；SQL Server 2000關(guān)系數(shù)據(jù)庫引擎能夠充分保護(hù)數(shù)據(jù)完整性，還可以將管理并發(fā)修改數(shù)據(jù)庫開銷到最小。 </p&

28、gt;<p>　　4．易于安裝，部署和使用： </p><p>　　SQL Server 2000由一系列的管理和開發(fā)工具組成，這些工具使得在多個站點上進(jìn)行SQL Server的安裝，部署，管理和使用變得更加容易。開發(fā)人員可以更加快速地交付SQL Server應(yīng)用程序，而且只需要進(jìn)行最少的安裝和管理就可以實現(xiàn)這些應(yīng)用程序。 </p><p><b>　　5．?dāng)?shù)據(jù)倉庫

29、： </b></p><p>　　數(shù)據(jù)倉庫是SQL Server 2000中包含的用于分析取和分析匯總數(shù)據(jù)以進(jìn)行聯(lián)機(jī)分析處理的工具。這個功能只在Oracle和其他更昂貴的DBMS中才有。 </p><p>　　2.1.1 SQL Server 2000新特性 </p><p>　　全面擴(kuò)展了SQL Server 7.0的性能，可靠性和易用性。增加了一系列

30、的功能，具體如下： </p><p>　　1．在關(guān)系數(shù)據(jù)庫方面的增強(qiáng) </p><p><b>　　2．圖形管理增強(qiáng) </b></p><p>　　3．增強(qiáng)的聯(lián)合數(shù)據(jù)庫服務(wù)器 </p><p>　　2.2 SQL Server 2000工具和實用程序 </p><p>　　SQL Server 2

31、000有8個工具，分別是：</p><p><b>　　1．企業(yè)管理器； </b></p><p><b>　　2．服務(wù)管理器；</b></p><p><b>　　3．查詢分析器；</b></p><p><b>　　4．事件探查器； </b></

32、p><p>　　5．導(dǎo)入和導(dǎo)出數(shù)據(jù)； </p><p>　　6．服務(wù)器網(wǎng)絡(luò)使用工具； </p><p>　　7．客戶端網(wǎng)絡(luò)使用工具； </p><p><b>　　8．聯(lián)機(jī)幫助文檔。</b></p><p>　　2.2.1 企業(yè)管理器 </p><p>　　企業(yè)管理器是基于一種

33、新的被稱為微軟管理控制臺（Microsoft Management Console)的公共服務(wù)器管理環(huán)境，它是SQL Server 2000中最重要的一個管理工具。 </p><p>　　企業(yè)管理器不僅能夠配置系統(tǒng)環(huán)境和管理SQL Server，而且由于它能夠以層疊列表的形式來顯示所有的SQL Server對象，因而所有SQL Server對象的建立與管理都可以通過它來完成。 </p><p&

34、gt;　　用企業(yè)管理可以完成的操作：</p><p>　　1．管理SQL Server服務(wù)器；建立與管理數(shù)據(jù)庫；建立與管理表、視圖、存儲過程、觸發(fā)程序、角色、規(guī)則、默認(rèn)值等數(shù)據(jù)庫對象，以及用戶定義的數(shù)據(jù)類型；備份數(shù)據(jù)庫和事務(wù)日志、恢復(fù)數(shù)據(jù)庫；復(fù)制數(shù)據(jù)庫；設(shè)置任務(wù)調(diào)度；設(shè)置警報；提供跨服務(wù)器的拖放控制操作；管理用戶賬戶；建立Transact-SQL命令語句以及管理和控制SQL Mail。 </p>&

35、lt;p>　　2．在企業(yè)管理器中包含兩個窗口，左側(cè)的窗口是以“樹狀目錄”顯示的活動窗口，右側(cè)是顯示內(nèi)容的窗口。 </p><p>　　3．單擊左側(cè)窗口中的加號，可以展開各個項目包含的子項目。 </p><p>　　4．通過選中的某個項目的節(jié)點，可以在右側(cè)的窗口中看到該項目包含的內(nèi)容。 </p><p>　　2.2.2服務(wù)管理器（Service Manager）

36、 </p><p>　　SQL Server服務(wù)管理器是在服務(wù)器端實際工作時最有用的實用程序，服務(wù)管理器用來啟動、暫停、繼續(xù)和停止數(shù)據(jù)庫服務(wù)器的實時服務(wù)，其提供的服務(wù)類型包括：SQL Server、SQL Server代理、Microsoft搜索和分布式事務(wù)協(xié)調(diào)器等。 </p><p>　　附件2：外文原文（復(fù)印件）</p><p>　　The Design and

37、 Implementation of ASP Web Site News Management Systems</p><p>　　The use of ASP and SQL technology news site management system, to achieve the dynamic management of the news Web site, making the management o

38、f 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>　　With the popularization of Intern

39、et, 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 to establish contact with partners, a

40、s 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 the new product or new development proj

41、ects, 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 upload the page and modify the corres

42、ponding 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 application of procedures to deal wit

43、h 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 compiled to explain the process, so whe

44、n 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 process restarted. This makes the speed in

45、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 can use the Record Set Object ADO to

46、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 support real-time application updates. Adm

47、inistrators 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 locked, so even when the program runs in

48、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" approach to the preparation of the code make

49、s 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 Principle</p><p>　　1.1 The

50、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 layer is responsible for interaction wi

51、th 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 to the data layers and at the same ti

52、me 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 application, it is presented to customers based

53、 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 to manipulate data through the ADO.NE

54、T 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 principle of access to the database ADO.NET

55、</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 SQL Server. Application of three kinds o

56、f 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 ways, that is, through a Dataset to the

57、 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 process is running the whole way to main

58、tain 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 page and send to your browser, and the

59、n 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 relationship between memory map to pro

60、vide 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 where the data acquisition, data sets

61、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><p>　　2.1 Systems Function Struct

62、ures</p><p>　　The 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

63、. 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 can be completed in addition to the o

64、rdinary user, but also can enter information for news management module input, modify, </p><p>　　2.2 Systems Function Characteristics</p><p>　　(1) Simple, user-friendly: complete control of page

65、 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, the follow-up message also appears allo

66、w 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 column on the home page is displayed to

67、 "immediate release, immediate results" function. </p><p>　　(3) Function: include common site in all aspects of information management: information input, browse, delete, modify, search and other a

68、spects, the full realization 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

69、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 system through a number of functional mod

70、ules 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 to achieve the management of user right

71、s. </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 each title has been made news a hyper

72、link, 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, detailed information of each informati

73、on 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 same page layout, only the contents of th

74、e 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: The module provides a press inquiry,

75、 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) News Management: The module listed in

76、 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 non-news publisher is not outside the

77、 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 and modification: a press registered us

78、ers 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 will be saved into the database. The mo

79、dule 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>　　SQL Server Introduction</p><p>　　1. SQL Server

80、Relational Database Introduction</p><p>　　1．SQL Server is the development and promotion of Microsoft's relational database system (DBMS), it was originally proposed by Microsoft, Sybase and Ashton-Tate t

81、hree companies jointly developed and launched in 1988, the first OS / 2 version. </p><p>　　2．Relational database (RDBMS) Management System features: </p><p>　　The maintenance of the relationship

82、 between the database data; </p><p>　　Guarantee the correctness of data storage; </p><p>　　When system failures occur when all the data back to the line to ensure a consistent state </p>

83、<p>　　3．RDBMS: SQL Server, Oracle, DB / 2, Sybase, Informix </p><p>　　4．Non-RDBMS (File-based): Foxpro, Access</p><p>　　2. The Version of SQL Server 2000 </p><p>　　Common versi

84、on of SQL Server 2000 are: </p><p>　　Enterprise Edition (Enterprise Edition) </p><p>　　Support all the functions of SQL Server 2000. The version number of products for large and medium-sized da

85、tabase server, and can support large-scale Web site, enterprise OLTP (online transaction processing) and large-scale data warehouse systems OLAP (Online Analytical Processing) performance required. </p><p>　

86、　Standard Edition (Standard Edition) </p><p>　　Practical scope of the work of small groups or departments. It supports most features of SQL Server2000. However, do not have to support large databases, data w

87、arehouses and web site functionality. Also, do not support all the functions of relational database engine. </p><p>　　Personal Edition (Personal Edition) </p><p>　　Mainly applied to mobile users

88、 because they are often disconnected from the network, and run the application still needs the support of SQL Server 2000. In addition to transaction processing functions other than reproduction, to support all SQL Serve

89、r 2000 Standard Edition features support. </p><p>　　Developers Edition (Developer Edition) </p><p>　　Apply to the version of application development and support in addition to graphical language

90、 settings other than the SQL Server2000 all other functions. This version is mainly applied to applications programmers in the development, it will be SQL Server 2000 as its data storage area. Although the development of

91、 full-featured version, but only have been authorized to develop and test a system, rather than a product server.</p><p>　　2.1 SQL Server Features </p><p>　　1. Integration with the Internet: <

92、;/p><p>　　SQL Server 2000 database engine full support of XML (Extensive Markup Language, Extensible Markup Language), enables users to easily publish the data in the database to the Web page. </p><p

93、>　　2. Scalability and availability: </p><p>　　Across from the laptop running Windows 95/98 computers running the Windows 2000 and other large-scale multi-processor platform. In addition, the Joint server,

94、 view the index and so on, making SQL Server 2000 Enterprise Edition can upgrade to the largest Web site of the performance levels required. </p><p>　　3. Enterprise-level database functions: </p><

95、p>　　SQL Server 2000 distributed query by invoking the data from different databases, and these for the user is completely transparent; distributed database will ensure that any updates to distributed data integrity; c

96、opy will enable us to the maintenance of multiple data Copies of these users to work independently, and then changes into the release database; SQL Server 2000 relational database engine can fully protect data integrity,

97、 management of complications can also modify the database to minimi</p><p>　　4. Easy installation, deployment and use: </p><p>　　SQL Server 2000 from a series of management and development tools

98、, these tools made in a number of sites on the SQL Server installation, deployment, management and use easier. Developers can more quickly deliver SQL Server applications, and only require minimal installation and manage

99、ment of these applications can be achieved. </p><p>　　5. Data Warehouse: </p><p>　　Data Warehouse is included in SQL Server 2000 for analysis of aggregate data access and analysis for online ana

100、lytical processing tool. This feature is only in Oracle and other DBMS in the more expensive can.</p><p>　　2.1.1 New Features of SQL Server 2000 </p><p>　　Comprehensive SQL Server 7.0 extends th

101、e performance, reliability and ease of use. Increase in a series of functions, as follows: </p><p>　　1. In regard to the strengthening of relational database </p><p>　　2. Enhanced graphical mana

102、gement </p><p>　　3. Enhance the joint database server</p><p>　　2.2 Tools and utilities of SQL Server 2000 </p><p>　　SQL Server 2000 there are eight tools are: </p><p>　

103、　1. Enterprise Manager;</p><p>　　2. Service Manager;</p><p>　　3. Query Analyzer;</p><p>　　4. Profiler; </p><p>　　5 .import and export data;</p><p>　　6. the