1、中文 2500字 The Design and Implementation of ASP Web Site News Management Systems Abstract The use of ASP and 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
2、the same time, the development of systems theory, systems and design features are introduced. Key word ASP， SQL， news management， database With the popularization of Internet, more and more companies set up their own WWW sites, enterprises can display products through the website, publishing the lat
3、est developments, with users sharing and communication 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 the new product or new deve
4、lopment projects, on the other hand, the timely notice to their customers business performance, Progress in technology and research and development, in particular, recommend or preferential projects, products and services to attract customers, expand customer base. Management of traditional news sit
5、es 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 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 data
6、bases, through the 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 some insurmountable flaws, and ASP.NET technology has taken on the system performance has been greatly improved, the main performance i
7、n the following aspects: 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 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 res
8、tarted. This makes the speed in a number of visits has greatly improved. 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, while the ASP provided through the DataGri
9、d, such as ADO.NET database and database components can be directly Contact. 3. ASP support 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 neve
10、r be locked, 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. 4. ASP take the code-behind approach to the preparation of the code makes the code easier to prepare, structure more clearly, reducing the sy
11、stem development and maintenance of the complexity and the cost of. 1 System Development Principle 1.1 The System Architecture Model of ASP-based Technology ASP is a three-tier system structure: UI Layer, Business Logic Tier and data layer. UI layer is responsible for interaction with the user, rece
12、iving user input and server-side data from present to clients. Business Logic Tier is responsible for receiving requests from browser requests 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 co
13、mponents. Web Forms ASP.NET which is the core of the application, 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. Data layers to manipulate data through the ADO.NET l
14、ayer for business logic to provide data services, such as storing the results of data manipulation and return to the results of data retrieval. 1.2 The principle of access to the database ADO.NET Connected with the database, ADO.NET provide the following three kinds of ways: through ODBC connected；
15、connected through OLEDB； 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 D
16、ataset 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. ASP.NET taken disconnect
17、ed 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. ADO.NET Another innovation is the introduction of a data set (Datas
18、et). A data set is the 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 where the data acquisition, data sets are the same proced
19、ure through the use of templates to be operated, and its potential to use the same data buffer. 2 Systems Functional Designs 2.1 Systems Function Structures The news management system in Windows 2000 Server operating system platforms, Web server IIS, the database server for Microsoft SQL Server2000,
20、 development 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 can be completed in addition to the ordinary user, but also can ent
21、er information for news management module input, modify, and delete operations. In addition to registered users outside the system administrator can only be recorded on its own news operation for excision. 2.2 Systems Function Characteristics (1) Simple, user-friendly: complete control of page layout, making information easier entry work；
