基于B/S的辦公自動化系統(tǒng)的設(shè)計與實現(xiàn)

摘　要
隨著網(wǎng)絡(luò)的高速發(fā)展，網(wǎng)絡(luò)辦公自動化系統(tǒng)逐漸受到關(guān)注。一些大型企業(yè)集團正致力實現(xiàn)高層次的網(wǎng)絡(luò)辦公自動化，這將為他們節(jié)省大量的人力資源和辦公費用，并大幅度提高辦公效率。
本文首先介紹了選題背景和開發(fā)模式，然后介紹了需求分析和數(shù)據(jù)庫設(shè)計。重點介紹系統(tǒng)設(shè)計與實現(xiàn)，關(guān)鍵算法中介紹了自定義分頁和密碼修改。
本系統(tǒng)運用J2EE中的MVC2 （Model+View+Control）模型，采用MyEclipse6.5 + Tomcat5.5 + JDK1.6 + MYSQL5 的組合開發(fā)平臺開發(fā)測試，還使用Jsp-Servlet-Hibernate開發(fā)網(wǎng)站的典型案例。系統(tǒng)涉及到MVC的設(shè)計模式，以及后臺數(shù)據(jù)庫、基本表與系統(tǒng)前臺的綁定工作，是通過Hibernate獲取數(shù)據(jù)庫驅(qū)動。本系統(tǒng)還利用Dreamweaver+Photoshop+JavaScript來設(shè)計各種前臺頁面，運用JUnit工具編寫測試用例，進行單元測試和集成測試，利用Visio，RationalRose工具來繪制各種圖形。在B/S架構(gòu)上，系統(tǒng)設(shè)計與實施上運用軟件工程的思想，完全依照瀑布模型來編寫設(shè)計文檔。

【關(guān)鍵字】 MVC2；辦公自動化；Servlet；瀑布模型；B/S。

Design and Implementation of Office Automation System based on B/S
Chen Wei
Abstract：
With the rapid development of the network, the network OA system received the attention gradually. Some large enterprise group were devoting to realize the top level network OA system, This will save the massive human resources for them,and save the massive office expense,and raise the office efficiency.
This paper firstly introduced the research background and development model, and then introduced the requirement analysis and database design. It emphasis on system design and Implementation. In the key algorithm, it focused on customizing paging and password modify.
This system used the model of J2EE MVC2 (Model+View+Control) and the combination of MyEclipse6.5 + Tomcat5.5 + JDK1.6 + MYSQL5. We developed the platform development test and used Jsp-Servlet-Hibernate to develop the website the illustrative case. The system involved the MVC design pattern, as well as backstage database, fundamental catalog and system onstage binding work, with Hibernate to access database. Using Dreamweaver+Photoshop+JavaScript to design each kind of onstage page, and used JUnit tool compilation to test the example, carries on the unit testing and the integration testing. Using the Visio, RationalRose tool to draws up each kind of graph.. The system design was with B/S structure, and the system’s implementation utilized the software engineering, and compile the design documents waterfall model completely .

Keywords：
MVC2；OA；Servlet；Waterfall Model；B/S

目  錄
1 系統(tǒng)概述 1
1.1 選題背景 1
1.2 可行性分析 1
1.2.1 經(jīng)濟上可行性 1
1.2.2 技術(shù)上可行性 2
1.2.3 管理上可行性 3
2 辦公自動化系統(tǒng)的開發(fā)模式與開發(fā)技術(shù) 3
2.1 B/S體系結(jié)構(gòu) 4
2.2 JSP技術(shù) 4
2.2.1 JSP的強勢 5
2.2.2 JSP的弱勢 5
2.2.3 JSP的六種內(nèi)置對象 5
2.3 JAVA 技術(shù) 7
2.4 MYSQL5.0 8
3需求分析 9
3.1 運行環(huán)境 10
3.1.1 硬件環(huán)境 10
3.1.2 軟件環(huán)境 10
3.2 總體功能需求 10
4 數(shù)據(jù)庫設(shè)計 12
4.1 數(shù)據(jù)模型 13
4.2 數(shù)據(jù)表 13
4.3 數(shù)據(jù)庫實體關(guān)系圖 16
5 系統(tǒng)設(shè)計及實現(xiàn) 17
6 系統(tǒng)關(guān)鍵功能及實現(xiàn) 24
6.1 自定義分頁功能 24
6.2 密碼修改功能 26
7 結(jié)束語 28
致   謝 31