【正文】 1 關(guān)系型數(shù)據(jù)庫(kù) SQL Server2021 是 Microsoft 公司推出的 SQL Server 數(shù)據(jù)庫(kù)管理系統(tǒng)，該版本繼承了 SQL Server 版本的優(yōu)點(diǎn)，同時(shí)又比它增加了許多更先進(jìn)的功能。因?yàn)?Tomcat 技術(shù)先進(jìn)、性能穩(wěn)定，而且免費(fèi)，因而深受 Java 愛(ài)好者的喜愛(ài)并得到了部分軟件開(kāi)發(fā)商的認(rèn)可，成為目前比較流行的 Web 應(yīng)用服務(wù)器。 服務(wù)器 Tomcat 是 Apache 軟件基金會(huì)（ Apache Software Foundation）的 Jakarta 項(xiàng)目中的一個(gè)核心項(xiàng)目，由 Apache、 Sun 和其他一些公司及個(gè)人共同開(kāi)發(fā)而成。 JSP 技術(shù)有點(diǎn)類(lèi)似 ASP 技術(shù)，它是在傳統(tǒng)的網(wǎng)頁(yè) HTML 文件 (*.htm,*.html)中插入 Java 程序段 (Scriptlet)和 JSP 標(biāo)記(tag)，從而形成 JSP 文件 (*.jsp)。為了能夠快速有效的開(kāi)發(fā)，我決定對(duì)于 本例用戶(hù)管理系統(tǒng)，采用 BS（ Browser/Server— 瀏覽器 /服務(wù)器）架構(gòu) 結(jié)合流行的JSP (Java Server Pages)語(yǔ)言開(kāi)發(fā)，后臺(tái)數(shù)據(jù)庫(kù)使用 Microsofe SQL server2021，所有內(nèi)容由 Tomcat 服務(wù)器為解析。例如管理員可以對(duì)用戶(hù)信息實(shí)現(xiàn)，查詢(xún)、刪除，審核等操作。 本例用戶(hù)管理系統(tǒng)， 由于時(shí)間倉(cāng)促，根據(jù)系統(tǒng)的業(yè)務(wù)邏輯，只需 初步實(shí)現(xiàn)相關(guān)功能即可。它們都是 是 由人、 計(jì)算機(jī) 及其他外圍設(shè)備等組成的能進(jìn)行信息的收集、傳遞、存貯、加工、維護(hù)和使用的系統(tǒng)。 應(yīng)用所學(xué)的知識(shí)，重構(gòu)用戶(hù)管理系統(tǒng)， 采用信息化的手段提升效率， 就體現(xiàn)了軟件工程專(zhuān)業(yè)的價(jià)值所在。 長(zhǎng)期以來(lái)，傳統(tǒng)的手工用戶(hù)管理模式已經(jīng)不能適應(yīng)需求。 關(guān)鍵詞： 信息管理系統(tǒng)；用戶(hù)管理系統(tǒng)； BS Abstract Computer as an economic production of the times, with the continuous application of its technology and development, it more and more widely used in various fields. In order to improve various of applications and information processing efficiently. The Information Management System occurs, posed by a puter and its peripherals the system could be used for information collection, transmission, storage, processing and maintenance. User Management System can be regarded as one of the basic original model of the system that mentioned above, so the design and implementation of User Management System not only enhanced the integrated use of software engineering expertise, but also has considerable practical significance. The User Management System in this case, used BS (Browser/Server browser / server) architecture, coupled with the popular JSP (Java Server Pages) language development, database using Microsoft SQL server2021, the server is Tomcat edition. Generally speaking, This User Management System implements all the basic functions. Throughout the development process, our expertise has been further improved and the macroscopic view of The Information Management System on a level has also been founded. Keywords： The Information Management System； The User Management System； BS 西安文理學(xué)院計(jì)算機(jī)科學(xué)系 課程 設(shè)計(jì) 報(bào)告 I 第一章 課題背景 ................................................................................................ 1 引言 ..........................................................................................................................................................................1 題目概述 ..................................................................................................................................................................1 第二章 設(shè)計(jì)簡(jiǎn)介及設(shè)計(jì)方案論述 ......................................................................... 2 設(shè)計(jì)簡(jiǎn)介 —— 開(kāi)發(fā)相關(guān)工 具選取 ........................................................................................................................2 相關(guān)技術(shù)簡(jiǎn)介 ..................................................................................................................................................2 設(shè)計(jì)流程簡(jiǎn)介 ..........................................................................................................................................................2 系統(tǒng)角色設(shè)計(jì) ...........................................................................................................................................................3 數(shù)據(jù)庫(kù)設(shè)計(jì) ...............................................................................................................................................................4 第三章 詳細(xì)設(shè)計(jì) ................................................................................................ 6 網(wǎng)站頁(yè)面流程 ..........................................................................................................................................................6 主頁(yè)及登錄界面的詳細(xì)設(shè)計(jì) .................................................................................................................................6 主頁(yè)設(shè)計(jì) ............................................................................................................................................................6 jsp 與 SQL server2021 的連接 ........................................................................................................................7 登陸模塊的設(shè)計(jì) ...............................................................................................................................................7 管理員與用戶(hù)功能頁(yè)面設(shè)計(jì) ..................................................................................................................................8 管理員