【正文】 摘 要 I 摘 要 為了改進(jìn)普通白紙公文帶來(lái)的流轉(zhuǎn)時(shí)間長(zhǎng)、 工作效率不高的問(wèn)題， 本文在對(duì)中小企業(yè)日常工作安排充分調(diào)研的基礎(chǔ)上，針對(duì)公司實(shí)際情況， 采 用 最先進(jìn)的 JSP 語(yǔ)言 進(jìn)行系統(tǒng)的開發(fā)，以 SQL Server 2021 作為網(wǎng)絡(luò)數(shù)據(jù)庫(kù)， 開發(fā)了 B/S（瀏覽器 /服務(wù)器）結(jié)構(gòu)的智能辦公自動(dòng)化之工作安排系統(tǒng)，提出了網(wǎng)上安排辦公的新概念，實(shí)現(xiàn)企業(yè)各部門之間的電子互動(dòng)辦公， 使企業(yè)內(nèi)部人員方便快捷地 計(jì)劃和安排工作，高效地協(xié)同工作，并 帶來(lái)全新的工作體驗(yàn) —— 及時(shí)匯報(bào)，方便快捷，讓領(lǐng)導(dǎo)第一時(shí)間知道工作開展情況 ， 方便各單位及用戶，提高辦公效率。 本 系統(tǒng)的關(guān)鍵是如何實(shí)現(xiàn)對(duì)數(shù)據(jù)的處理，因此，考慮到數(shù)據(jù)量的龐大復(fù)雜，該系統(tǒng)采用三層架構(gòu)，即：數(shù)據(jù)層、業(yè)務(wù)對(duì)象層和用戶界面層。 辦公自動(dòng)化之工作安排系統(tǒng)是針對(duì)企業(yè)各部門各用戶工作安排開發(fā)的，專門用于企業(yè)內(nèi)部員工網(wǎng)上安排工作的系統(tǒng) ， 其開發(fā)過(guò)程主要包括前端應(yīng)用程序的開發(fā)和后端數(shù)據(jù)庫(kù)的建立兩個(gè)方面。對(duì)于前者要求應(yīng)用程序功能完備操作簡(jiǎn)單 ,對(duì)于后者要求建立起數(shù)據(jù)一致性、完整性和安全性好的數(shù)據(jù)庫(kù)。 系統(tǒng)包含多個(gè)應(yīng)用功能模塊，是集工作計(jì)劃、工作安排、工作日志、記事本、會(huì)議記錄本、客戶投訴登記表、來(lái)訪登記及管理等為一體的綜合辦公工作 安排系統(tǒng)。 本設(shè)計(jì) 首先對(duì) 工作安排系統(tǒng) 做了詳細(xì)的需求分析；然后給出了 工作安排系統(tǒng) 所需的功能，重點(diǎn)探討了 工作安排系統(tǒng) 的設(shè)計(jì)法案；最后對(duì) 工作安排系統(tǒng) 進(jìn)行了較詳細(xì)的設(shè)計(jì)，并給出了具體實(shí)現(xiàn)步驟；通過(guò)測(cè)試分析，該系統(tǒng)的運(yùn)行穩(wěn)定、可靠，具有一定的實(shí)用價(jià)值。 關(guān)鍵詞 ： 辦公自動(dòng)化 ； JSP； SQL SERVER 2021； 系統(tǒng)設(shè)計(jì) Abstract II Abstract In order to improve the circulation of plain paper documents to bring a long time, the problem of low efficiency, this article in the daily work of the SME full investigation based on the actual situation against the pany, using the most advanced JSP language for system development, to SQL Server 2021 as a work database to develop the B / S (Browser / Server) structure of the intelligence work of office automation systems, proposed the new concept of online arrangements for office, enterprise electronic interaction between the various sectors of office, so that internal staff to quickly and easily plan and anize work efficiently work together and bring new work experience timely reporting, convenient, so that the leaders get to know work carried out by various units and users to facilitate and improve office efficiency. The key is how the system of data processing, therefore, take into account the huge amount of data plexity of the system threetier structure that is: the data layer, business object layer and user interface layer. The work of office automation system for all departments of the various users of work developed specifically for enterprise employees to work online arrangement system, its development process includes frontend application development and backend database to establish two. The request for applications functions, simple operation, for which required consistency, integrity and good safety database. System consists of multiple application modules, is a work plan, work, work diary, notepad, the minutes of this, customer plaints registration form, visitors registration and management of an integrated system of office work. The design of the system of work to do first, a detailed needs analysis。 then given work system functionality required, focused on system design work bill。 Finally, work system design in detail, and to out a specific implementation steps。 by test and analysis, the system is stable, reliable, has some practical value. Key words: Office automation； JSP； SQL SERVER 2021； System Design 目 錄 III 目 錄 1 緒論 ...................................................................................................................................... 1 問(wèn)題定義及內(nèi)容簡(jiǎn)介 .................................................................................................. 1 研究背景 ...................................................................................................................... 1 本課題研究背景 ................................................................................................... 1 國(guó)內(nèi)發(fā)展概況 ...................................................................................................... 2 國(guó)際發(fā)展概況 ....................................................................................................... 2 研究意義 ...................................................................................................................... 2 課題研究的主要方法、策略和步驟 .......................................................................... 3 課題調(diào)研與可行性分析 ............................................................................................... 5 課題調(diào)研 .............................................................................................................. 5 課題可行性分析 .................................................................................................. 6 2 系統(tǒng)需求分析 ..................................................................................................................... 8 系統(tǒng)功能需求分析 ....................................................................................................... 8 業(yè)務(wù)流分析 ................................................................................................................... 9 系統(tǒng)數(shù)據(jù)流分析 ......................................................................................................... 11 數(shù)據(jù) 字典 ..................................................................................................................... 13 3 系統(tǒng)設(shè)計(jì) ............................................................................................................................ 17 系統(tǒng)總體結(jié)構(gòu)設(shè)計(jì) ..................................................................................................... 17 系統(tǒng)數(shù)據(jù)模型設(shè)計(jì) ..................................................................................................... 18 概念模型（ ER 圖） ......................................................................................... 18 關(guān)系模型 ............................................................................................................ 20 設(shè)計(jì)數(shù)據(jù)庫(kù) ........................................................................................................ 21 數(shù)據(jù)庫(kù)表詳細(xì)說(shuō)明 ............................................................................................ 21 系統(tǒng)開發(fā)與運(yùn)行環(huán)境 ................................................................................................ 25 系統(tǒng)開發(fā)環(huán)境 .................................................................................................... 25 系統(tǒng)運(yùn)行環(huán)境 ..........................................