【正文】 ame page layout, only the contents of the field corresponding to different In addition, the location of other pages can be dynamically placed in other ponents, such as web site logo, such as the page banner ads link to pictures, this can be easily to achieve the effect of illustrations in reading. (4) News Inquiry: 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. (5) 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 nonnews 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. (6) News entry and 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 will 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. SQL Server Introduction 1. SQL Server Relational Database Introduction 1． SQL Server is the development and promotion of Microsoft39。 directly connected with the SQL 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 ways, that is, through a Dataset to the isolation of heterogeneous data sources, and the other is a stream to read from the data source (Data Reader mode). Traditional application is to create a connection to the database, in the process is running the whole way to maintain connections to the design. 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 disconnected until the next browser request issued. Another innovation is the introduction of a data set (Dataset). A data set is the relationship between memory map to provide highspeed 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 are the same procedure through the use of templates to be operated, and it39。 4．通過(guò)選中的某個(gè)項(xiàng)目的節(jié)點(diǎn)，可以在右側(cè)的窗口中看到該項(xiàng)目包含的內(nèi)容。 企業(yè)管理器不僅能夠配置系統(tǒng)環(huán)境和管理 SQL Server，而且由于它能夠以層疊列表的形式來(lái)顯示所有的 SQL Server 對(duì)象，因而所有 SQL Server 對(duì)象的建立與管理都可以通過(guò)它來(lái)完成。這個(gè)功能只在 Oracle 和其他更昂貴的 DBMS 中才有。 3．企業(yè)級(jí)數(shù)據(jù)庫(kù)功能： SQL Server 2020 分布式查詢可以引用來(lái)自不同數(shù)據(jù)庫(kù)的數(shù)據(jù)，而且這些對(duì)于用戶來(lái)說(shuō)是完全透明的；分布式數(shù)據(jù)庫(kù)將保證 任何分布式數(shù)據(jù)更新時(shí)的完整性；復(fù)制可以使我們能夠維護(hù)多個(gè)數(shù)據(jù)復(fù)本，這些用戶能夠自主地進(jìn)行工作，然后再將所做的修改合并到發(fā)布數(shù)據(jù)庫(kù)； SQL Server 2020 關(guān)系數(shù)據(jù)庫(kù)引擎能夠充分保護(hù)數(shù)據(jù)完整性，還可以將管理并發(fā)修改數(shù)據(jù)庫(kù)開(kāi)銷(xiāo)到最小。雖然開(kāi)發(fā)版的功能齊備，但是只被授權(quán)為一個(gè)開(kāi)發(fā)和測(cè)試系統(tǒng)，而不是一個(gè)產(chǎn)品服務(wù)器。 個(gè)人版（ Personal Edition） 主要適用于移動(dòng)用戶，因?yàn)樗麄兘?jīng)常從網(wǎng)絡(luò)上斷開(kāi)，而運(yùn)行的應(yīng)用程序卻仍然需要SQL Server 2020 的支持。 標(biāo)準(zhǔn)版（ Standard Edition） 實(shí)用范圍是小型的工作組或部門(mén)。該模塊還負(fù)責(zé)編輯狀態(tài)下的更新，這時(shí)，它將根據(jù)取得的 Title 字段值對(duì)頁(yè)面控件初始化。 （ 4）新聞查詢：該模塊提供了新聞查詢功能，輸入待查找的內(nèi)容及選定分類(lèi)信息可以快速地找到符合條件的新聞，并輸出查詢結(jié)果。 3 系統(tǒng)的詳細(xì)設(shè)計(jì) 系統(tǒng)的主要功能是通過(guò)幾個(gè)功能模塊來(lái)實(shí)現(xiàn)的。 系統(tǒng)的功能特點(diǎn) （ 1）操作簡(jiǎn)單、界面友好：完全控件式的頁(yè)面布局，使得新聞的錄入工作更簡(jiǎn)便；許多選項(xiàng)包括新聞 類(lèi)別、來(lái)源部門(mén)等只需要點(diǎn)擊鼠標(biāo)就可以完成；另外，跟蹤出現(xiàn)的提示信息也讓用戶隨時(shí)清楚自己的操作情況。不論數(shù)據(jù)從何處獲取，數(shù)據(jù)集都是通過(guò)使用同樣的程序模板而被操作的，并且它使用相同的潛在的數(shù)據(jù)緩沖區(qū) 。當(dāng)瀏覽器向 Web 服務(wù)器請(qǐng)求網(wǎng)頁(yè) 時(shí)，服務(wù)器處理這個(gè)請(qǐng)求，并將所請(qǐng)求的網(wǎng)頁(yè)發(fā)送給瀏覽器，然后連接就被斷開(kāi)，直到瀏覽器發(fā)出下一個(gè)請(qǐng)求。 3 種方式由于應(yīng)用層次的差異，使得效率由低到高，獨(dú)立性由高到低。它由 Web 表單、 XML Web 服務(wù)和組件服務(wù)組成。 4． ASP 采取 codebehind方式編寫(xiě)代碼使得代碼更易于編寫(xiě)，結(jié)構(gòu)更清晰，降低了系統(tǒng)的開(kāi)發(fā)與維護(hù)的復(fù)雜度和費(fèi)用。 3． ASP 支持應(yīng)用程序的實(shí)時(shí)更新。二是基于 ASP 和腳本語(yǔ)言，將動(dòng)態(tài)網(wǎng)頁(yè)和數(shù)據(jù)庫(kù)結(jié)合，通過(guò)應(yīng)用程序來(lái)處理新聞 ，這是目前較為流行的做法。同時(shí)對(duì)系統(tǒng)的開(kāi)發(fā)原理、系統(tǒng)的功能特點(diǎn)和設(shè)計(jì)方案進(jìn)行了介紹。 指導(dǎo)教師評(píng)語(yǔ)： 簽名： 年 月 日 附件 1：外文資料翻譯譯文 asp的網(wǎng)站新聞管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 利用 ASP 和 SQL 技術(shù)開(kāi)發(fā)的網(wǎng)站新聞管理系統(tǒng)，實(shí)現(xiàn)了網(wǎng)站新聞的動(dòng)態(tài)管理，使得對(duì)信息的管理更加及時(shí)、高效，提高了工作效率。 傳統(tǒng)的網(wǎng)站新聞管理方式有兩種，一是靜態(tài) HTML 頁(yè)面，更新信息時(shí)需要重新制作頁(yè)面然后上傳頁(yè)面并修改相應(yīng)鏈接，這種方式因?yàn)樾侍鸵巡欢嘤谩? 2．由于 ASP 沒(méi)有提供任何輸出數(shù)據(jù)為內(nèi)容的元件，所以在使用 ASP 撰寫(xiě)數(shù)據(jù)庫(kù)頁(yè)面時(shí)只能借助 ADO 的 Record Set 對(duì)象逐 筆讀取記錄，而 ASP 通過(guò) 提供的DataGrid 等數(shù)據(jù)庫(kù)元件可以直接和數(shù)據(jù)庫(kù)聯(lián)系。當(dāng)文件更新后，系統(tǒng)會(huì)溫和地轉(zhuǎn)換到新的版本。 業(yè)務(wù)邏輯層負(fù)責(zé)接收瀏覽器傳來(lái)的請(qǐng)求并將請(qǐng)求傳給數(shù)據(jù)層，同時(shí)將請(qǐng)求處