【正文】 統(tǒng)主要由工作流、文件管理等幾部分組成，采用 B/S 架構(gòu)、 數(shù)據(jù)庫(kù) 服務(wù)器，界面設(shè)計(jì)人性化 ， 無(wú)需專業(yè)知識(shí)即可對(duì)系統(tǒng)進(jìn)行熟練的操作 [8]。隨著 SOA 架構(gòu) 技術(shù)的不斷成熟和 逐漸 升級(jí)，協(xié)同 OA 逐漸走入了市場(chǎng) 。 ”作為企 事 業(yè)信息化 和 知識(shí)化基礎(chǔ) 的 一個(gè) 平臺(tái)， 將來(lái)的工作模式都將在現(xiàn)代先進(jìn)技術(shù)理念的指導(dǎo)下進(jìn)行，屆時(shí)， OA 系統(tǒng)將會(huì)有更大的 發(fā)揮 空間。 辦公自動(dòng)化的國(guó)內(nèi)外現(xiàn)狀 OA 即指辦公的自動(dòng)化，它是在現(xiàn)代的先進(jìn)技術(shù)理念的基礎(chǔ)上催生的一種高效的辦公方式。 辦公自動(dòng)化系統(tǒng)產(chǎn)生的背景與 國(guó)內(nèi)外現(xiàn)狀 辦公自動(dòng)化產(chǎn)生的背景 隨著科學(xué)技術(shù)的 日益創(chuàng)新和不斷發(fā)展 ，國(guó)內(nèi)電子 商務(wù) 技術(shù) 也是越來(lái)越 成熟，使得當(dāng)今社會(huì)已經(jīng)步入了信息化時(shí)代， 辦公自動(dòng)化系統(tǒng) 則 逐漸成為各企事業(yè)單位不可 缺少 的一種工作手段 [1]。 關(guān)鍵詞： JSP 工作流 辦公自動(dòng)化 協(xié)同 長(zhǎng)春工業(yè)大學(xué)工程碩士學(xué)位論文 III Abstract OA refers office automation system, which uses modern technology to improve efficiency, so as to realize the automation of work, change the inefficient and plex manual office procedures, greatly facilitate the enterprises of munication between internal staff and exchange information to achieve the collection, processing and so on. Using the OA system not only improve efficiency, but also for most of the enterprises and saves a lot of money raised for the twentyfirst century and make due contribution to energy saving. As a set of information and knowledge in an office platform, a basis for the future of the OA system better in this direction will move forward. In this paper, the concept of modern latest technology OA system on the existing studies, researchbased collaboration using the latest office to study the concept of office automation systems. In this paper, based on J2EE architecture using MVC pattern of development of the OA system with platform independence. The system studied in this paper is mainly used in small enterprises. To achieve knowledge management and distributed office. Knowledge management to a variety of documents, information will be saved by permission, share and use, but also the need for effective search means to facilitate the various departments, information sharing between the Department and to publish, find and replace. To establish a foundation for learning anizations. By setting the router to solve the system to achieve crossregional office and mobile office. Functionality of the system fully tested using blackbox testing methods, the results show that the faculty can basically meet the needs of our school. In this paper, the security of the system by hand with a bination of testing tools to conduct a prehensive inspection, the existing problems to improve for the next operation to provide references. Keywords: Jsp Workflow Office Automation Collaborative 長(zhǎng)春工業(yè)大學(xué)工程碩士學(xué)位論文 i 目 錄 摘 要 ..................................................................................................... II Abstract ................................................................................................. III 第一章 概 論 ....................................................................................... 3 辦公自動(dòng)化系統(tǒng)產(chǎn)生的背景與國(guó)內(nèi)外現(xiàn)狀 .......................... 3 辦公自動(dòng)化產(chǎn)生的背景 ...................................... 3 辦公自動(dòng)化的國(guó)內(nèi)外現(xiàn)狀 .................................... 3 本文的組織 .................................................... 4 第二章 相關(guān)技術(shù)簡(jiǎn)介 ............................................................................ 6 MYSQL 簡(jiǎn)介 .................................................... 6 Java 技術(shù)簡(jiǎn)介 ................................................ 6 J2EE 體系 ..................................................... 7 Java Servlet 概述 ............................................. 7 JDBC 概述 ..................................................... 8 JDBC 類型 .................................................... 9 Struts—— 基于 MVC 設(shè)計(jì)模式的技術(shù)實(shí)現(xiàn) .......................... 9 JSP 技術(shù) ..................................................... 10 JSP 的特點(diǎn) ............................................... 10 JSP 與其他技術(shù)的區(qū)別 ..................................... 10 第三章 系統(tǒng)需求分析 ........................................................................... 12 可行性分析 ................................................... 12 功能需求分析 ................................................. 12 數(shù)據(jù)需求分析 ................................................. 13 實(shí)體屬性圖 ............................................... 13 實(shí)體關(guān)系圖 ............................................... 16 第四章 系統(tǒng)總體設(shè)計(jì) .......................................................................... 17 系統(tǒng)總體設(shè)計(jì)目標(biāo) ............................................. 17 前臺(tái)設(shè)計(jì)目標(biāo) ............................................. 17 后臺(tái)設(shè)計(jì)目標(biāo) ............................................. 17 功能結(jié)構(gòu)設(shè)計(jì) ................................................. 17 辦公自動(dòng)化管理系統(tǒng)前臺(tái)功能結(jié)構(gòu)圖 ......................... 17 辦公自動(dòng)化管理系統(tǒng)后臺(tái)功能結(jié)構(gòu)圖 ......................... 19 系統(tǒng)主要功能 ................................................. 19 主要數(shù)據(jù)結(jié)構(gòu)設(shè)計(jì) ............................................. 21 第五章 系統(tǒng)詳細(xì)設(shè)計(jì) ...................................................................... 24 長(zhǎng)春工業(yè)大學(xué)工程碩士學(xué)位論文 ii 數(shù)據(jù)庫(kù)的設(shè)計(jì)與實(shí)現(xiàn) ........................................... 24 通訊錄功能的設(shè)計(jì) ............................................. 26 新增聯(lián)系人關(guān)鍵代碼 ....................................... 26 保存更新后頁(yè)面信息代碼 ................................... 27 公告管理模 塊的設(shè)計(jì) ........................................... 28 第六章 系統(tǒng)實(shí)現(xiàn) ................................................................................. 29 系統(tǒng)運(yùn)行環(huán)境 ................................................. 29 主要程序界面 ................................................. 30 結(jié)論 .........................................................................................