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

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

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