【正文】 ...................................................................................... 4 ASP 的工作原理及配置 .............................................................................. 5 2 系統(tǒng)設(shè)計與實現(xiàn)的主要技術(shù)及理論基礎(chǔ) ......................................................... 8 ........................................................................................ 8 SQL 基礎(chǔ) ................................................................................................... 8 SQL 語句 ................................................................................................... 9 DDL 與 DML ............................................................................................ 9 復(fù)雜操作實現(xiàn) ......................................................................................... 11 3 系統(tǒng)概要設(shè)計 ................................................................................................... 13 需求分析 ........................................................................................................... 13 主頁分析設(shè)計 ................................................................................................... 14 數(shù)據(jù)庫分析設(shè)計 ............................................................................................... 15 服務(wù)器配置 ....................................................................................................... 15 結(jié)論 ................................................................................................................................ 17 參考文獻 ........................................................................................................................ 18 基于 ASP 動態(tài)網(wǎng)站設(shè)計與實現(xiàn) 1 引 言 最早互聯(lián)網(wǎng)出現(xiàn)時，站點內(nèi)容都是以 HTML靜態(tài)頁面形式存放在服務(wù)器上，訪問者瀏覽到的頁面都是這些實際存在的靜態(tài)頁面。t meet the requirements of the development of modern society, the dynamic web site based on ASP technology to change the traditional web site, has bee improve availability, reduce the management cost and improve knowledge platform unit of urgent need. To realize the unit informatization, the next generation of web site will be widely used such as the number of based on ASP technology to dig the dynamic website system driver. Dynamic web site and not refers to has the function of the animation website, but to through the database structure of the website. Dynamic web site in addition to web design, but also through the database and programming to make site has more automatic and advanced functions. Through the will of dynamic content area on the website packages into pages elements, realize the style and content of plete separation. The core function allows the unit to provide to the permanent storage in database information resources for search, inquiry, classification, statistics. The author through the staff of the department work the development work of dynamic websites, from the department of the basic needs of employees work site it is cut out, presents the improvement plan. Through the dynamic development of web sites, the work principle to realize the use ASP bined with SQL Server 2022 database data access technology, the integrated use of SQL Server 2022 to develop the database based on B/S model of dynamic read web site. Through dynamic web site to the test and trial, resolve the static websites can not achieve staff management work demands: remote management and inquires the, department collaborative work, etc. This paper 基于 ASP 動態(tài)網(wǎng)站設(shè)計與實現(xiàn) III first, expounds the present situation of the dynamic websites, problems and solutions of, this paper introduces the function of dynamic read website characteristics and working principle. Second, bined with web development practice was given a job site staff system design and realization of the main technical and theoretical foundation, established the system operation and management of the logical model, and then puts forward the of your overall site function demand and frame structure. Again, according to the requirements of the system function, the database and the selection of the structure design, build the relevant database table. Finally, according to the design thought, realize the basic function of the web server configuration and the function module system. Keywords: Dynamic Web Site。最后，按照設(shè)計思想，實現(xiàn)了網(wǎng)站服務(wù)器基本功能配置及系統(tǒng)各功能模塊。其次，結(jié)合網(wǎng)站 開 發(fā)實踐給出了 員工 工作網(wǎng)站系統(tǒng)設(shè)計與實現(xiàn)的主要技術(shù)和理論基礎(chǔ)，建立了系統(tǒng)運行和管理的邏輯模型，提出了網(wǎng)站整體的功能需求和框架結(jié)構(gòu)。通過對動態(tài)網(wǎng)站的測試和試用，解決了原靜態(tài)網(wǎng)站無法實現(xiàn)的 員工 管理工作需求：遠程管理與查詢、各部門協(xié)同工作等。 作者通過本部門 員工 工作動態(tài)網(wǎng)站的 開 發(fā)工作，從本部門的基 本 需求入手，對員工 工作部的網(wǎng)站進行了一定的削析，提出了改進方案。通過將網(wǎng)站上各種動態(tài)內(nèi)容區(qū)域封裝成頁面元素，實現(xiàn)樣式與內(nèi)容的徹底分離。 動態(tài)網(wǎng)站并不是指具有動畫功能的網(wǎng)站，而是指通過數(shù)據(jù)庫進行架構(gòu)的網(wǎng)站。傳統(tǒng)的靜態(tài)網(wǎng)站己越來越不能滿足現(xiàn)代社會發(fā)展的要求，采用基于 ASP的動態(tài)網(wǎng)站技術(shù)來改變傳統(tǒng)網(wǎng)站，已經(jīng)成為改善可用性、降低管理成本和提升單位知識平臺的迫切需要。 網(wǎng)絡(luò)教育學(xué)院 專 科 生 畢 業(yè) 大 作 業(yè) 題 目 ： 基于 ASP 動態(tài)網(wǎng)站設(shè)計與實現(xiàn) 學(xué)習(xí)中心： 奧鵬 層 次： 高中 起點 專 科 專 業(yè)： 年 級： 年 春 /秋 季 學(xué) 號： 學(xué) 生： 于波 指導(dǎo)教 師： 完成日期： 年 月 日 基于 ASP 動態(tài)網(wǎng)站設(shè)計與實現(xiàn) I 摘 要 在知識經(jīng)濟時代，信息 和人才一樣重要 ， 而 網(wǎng)站是信息資源最重要的發(fā) 布 和獲取途徑之一。因此，及時的、有效的、連續(xù)的、安全的信息資源，成為保持和增進 社會 活力的可行、有效途徑。為實現(xiàn)單位信息化，下一代網(wǎng)站將廣泛使用基于 ASP等技術(shù)的數(shù)掘驅(qū)動的動 態(tài)網(wǎng)站系統(tǒng)。 動態(tài)網(wǎng)站除了要設(shè)計網(wǎng) 頁外，還要通過數(shù)據(jù)庫和編程序來使網(wǎng)站具有更多自動的和高級的功能 。提供的核心功能使單位能夠?qū)Υ鎯υ跀?shù)據(jù)庫中的永久信息資源進行搜索、查詢、分類、統(tǒng)計。通過動態(tài)網(wǎng)站的開發(fā)，從工作原理著手，實現(xiàn)了使用 ASP結(jié)合 SQL Server 2022數(shù)據(jù)庫 數(shù)據(jù)訪問技術(shù)，綜合運用 SQL Server 2022數(shù) 據(jù) 庫來開發(fā)基于 B／ S模式的動念網(wǎng)站。本文首先，闡述了當(dāng)前動態(tài)網(wǎng)站的現(xiàn)狀、存在的問題及解決對策，介紹了動念網(wǎng)站的功能特點及工作原理。再次，針對系統(tǒng)功能的要求，對數(shù)據(jù)庫進行了選擇和結(jié)構(gòu)設(shè)計，建 立了相關(guān)的數(shù)據(jù)庫表。 關(guān)鍵 詞 ： 動態(tài)網(wǎng)站； ASP；數(shù)據(jù)庫 基于 ASP 動態(tài)網(wǎng)站設(shè)計與實