编号:2009450133
河南大学 2013 届本科毕业论文
自动化办公系统的研究与实现
论文作者姓名:_```_______________
作 者 学 号:_```````_________
所 在 学 院:_````___________
所 学 专 业:_````___
导 师 姓 名:_ _______
导 师 职 称:_ 讲师 ___ ____________
2013 年 5 月 4 日
目 录
摘 要.....................................................................................................................................................I
ABSTRACT........................................................................................................................................II
第 1 章 绪 论.......................................................................................................................................1
1.1 课题来源...............................................................................................................................1
1.2 课题背景...............................................................................................................................1
1.3 开发工具...............................................................................................................................2
1.3.1 数据库——MySQL5.5..............................................................................................2
1.3.2 服务器——Tomcat-6.0.35........................................................................................2
1.3.3 开发工具——Eclipse JavaEE...................................................................................2
1.3.4 调试工具——Firebug1.10.3.....................................................................................2
1.4 系统开发过程中相关技术的应用.......................................................................................3
1.4.1 ExtJs 3 框架...............................................................................................................3
1.4.2 Hibernate3 框架.........................................................................................................3
1.4.3 JOOQ 框架.................................................................................................................3
第 2 章 需求分析................................................................................................................................4
2.1 需求说明...............................................................................................................................4
2.2 权限控制...............................................................................................................................4
2.2.1 视图(View).................................................................................................................5
2.2.2 行为(Action)..............................................................................................................5
2.3 系统流程图...........................................................................................................................5
2.4 用例图...................................................................................................................................8
2.4.1 超级管理员用例图....................................................................................................9
2.4.2 员工用例图..............................................................................................................13
2.5 实体联系(E-R)图................................................................................................................14
第 3 章 系统总体分析和设计..........................................................................................................15
3.1 系统设计原则.....................................................................................................................15
3.2 系统的概要设计.................................................................................................................15
3.3 系统分析和结构设计.........................................................................................................16
第 4 章 系统数据库结构设计与实现..............................................................................................18
4.1 设计工具.............................................................................................................................18
4.2 数据库的逻辑结构设计.....................................................................................................18
4.3 数据库表结构关系图.........................................................................................................21
第 5 章 设计思路和实现..................................................................................................................23
5.1 用户登录.............................................................................................................................23
5.2 权限控制.............................................................................................................................25
5.2.1 行为..........................................................................................................................25
5.2.2 视图..........................................................................................................................28
5.2.3 控制..........................................................................................................................29
5.2 前台界面.............................................................................................................................30
5.3 数据交互.............................................................................................................................31
5.4 系统公告.............................................................................................................................32
第 6 章 总结......................................................................................................................................34
致 谢..................................................................................................................................................35
参考文献...........................................................................................................................................36
河南大学本科毕业生学士学位论文
摘 要
随着计算机技术的蓬勃发展,OA(办公自动化,Office Automation)已经
成为企业办公必不可少的办公软件。它不仅极大程度上节约了办公成本,而且
也大大提高了办公效率。
本文首先介绍了国内的办公自动化系统的发展状况,然后介绍了办公自动
化系统的设计思路和具体实现。项目基于 MVC(Model View Controller,模型-
视图-控制器)设计模式,采用 AJAX(Asynchronous JavaScript and XML,异
步 JavaScript 和 XML)进行服务器和客户端的数据交互。前台部分使用 ExtJs
框架,后台使用 Servlet 进行数据处理,并通过 Hibernate 对数据库进行访问。
基于这些技术,系统主要实现了权限管理,视图管理,和部分 OA 系统功
能模块。全文从整体框架的搭建思路开始介绍,详细描述了每个功能的具体实
现。
关键字: OA; ExtJS; Ajax; MVC; Hibernate;
第 I 页
河南大学本科毕业生学士学位论文
ABSTRACT
With the rapid development of computer technology, OA (Office
Automation) has become essential office software. It is not only saves the
cost of the office, but also enhances the efficiency of the office greatly.
The thesis introduces the development of office automation system first,
and then introduces the design and implementation of the office automation
system. The project is based on the MVC (Model View Controller) design
pattern, using AJAX (Asynchronous JavaScript and XML) to implement the
data exchange between server and client. The front use the ExtJS and the
background use Servlet for data processing, moreover use the Hibernate to
access to database.
Based on these technologies, the system achieves the rights
management, view management, and part of the OA system function
modules. The thesis introduce the system from the whole framework to the
build ideas, at the same time, it has a detailed description of the specific
implementation of each function.
Keywords: OA; ExtJS; Ajax; MVC; Hibernate;
第 II 页