摘 要
摘 要
基于Web的自动化办公系统的设计与实现
由于信息量的增加，是计算机已经变得普及化，各种先进的技术已经被运用到各个企业当中。传统的企业内信息的交流方式早已不能满足企业对大量信息的快速传递与处理的需求，办公自动化管理系统[1]的产生满足了企业的办公网络化、自动化的管理需求，提高了企业内部的管理水平，进而全面提升了企业在市场竞争中的综合竞争力。
办公自动化不仅能够实现团队的协同办公而且还能充分的提高工作人员的办事效率。团队的协同办公其实质是一个集体中工作的协调配合，此外还要进行必要的及时信息交流。那么随着网络技术的快速发展，达到上述协同办公的目的是在瞬间就可以完成的。那么团体群体，它可以是一个单位的工作人员，可以是工作时间不同的一群工作人员，还可以是分布在不同地理位置的相关工作人员，总之群体的所涉及的范围是非常广泛的。基于Web的办公自动化系统能够非常好的与企业中的各项业务相结合，并且可以定制和管理这些业务制度。所以可以将诸如各种业务信息的采集、删除、统计、查询、增加等功能与相关业务紧密关联。工作人员只要按照自己想要的信息输入点击一个按钮就可以得到结果，这为企业领导的管理和决策提供了极大的方便。
本系统是以Windows系统为操作平台，用JAVA编程语言在STRUTS框架和HIBERNATE框架基础上，结合SQL SERVER数据库,在Tomcat 6.0服务器上实现对办公自动化管理系统所需功能的开发。
本系统之所以选择SQL SERVER作为数据库进行开发，是因为SQL SERVER是一种关系型数据库，它具有很强的数据完整性、可管理性；具有均衡与完备的功能；具有较高的性价比。使用SQL SERVER数据库可以大容量地存储数据，并对数据进行合理的逻辑布局，应用数据库对象可以对数据进行复杂的操作。本系统具备以下几个功能分别是。
(1).任何人员要想进入该办公系统都需要输入正确的用户名和密码。
(2).系统应该提供会议管理功能，记录开会的主要内容。
I
摘 要
(3).系统应该提供通知管理功能，及时发布通知。 (4).系统应该提供员工请假的基本登记。 (5).系统应该提供员工上下班的基本登记。 (6).员工可以进行发布申请功能。
(7).领导可以对员工的申请进行审核批示。 (8).工作人员可以查询自己的基本信息。
(9).管理人员可以对系统中的用户账号进行增删查改操作。 (10).管理员可以对系统中的员工基本信息进行增删查改操作。(11).系统应该具有通讯管理的功能。 关键词:
办公自动化管理系统, JSP, Struts, Hibernate
II
Abstract
Abstract
On Design and Implementation of Web based Office Automation System
Due to the increase in the amount of information, computers have become popular, and a variety of advanced technology has been applied to various enterprises. Traditional ways of information exchange already can not meet the enterprises’ needs of the rapid transfer and processing of large amount of information. However, office automation management system meets management needs of network and the automated office to improve the internal management level, and thus to promote the comprehensive competitiveness of enterprises in market competition.
Office automation not only enables a team to achieve the coordination, but also to improve the efficiency of the staff. The essence of coordination office of the team is coordination in collective work , what’s more, necessary and timely information exchange is needed. with the rapid development of network technology, the purpose of the cooperative office can be achieved instantly. Groups can be either a unit of the staff or a group of staff working in different hours, or staff working in different geographic locations. In short, the range of a group is rather broad. Web-based office automation system can combine all business within the enterprise, and it can customize and manage these business systems. Therefore, such functions as collection, deletion, statistics, query, and increase can be closely connected to related business. As long as staff input the information they want with a click of a button, they can get the results, which provides great convenience for leadership, management and decision-making of the enterprise.
This system is based on a Windows system as the operating platform, framework of STRUTS and HIBERNATE with JAVA as the programming language, coupled with SQL SERVER database, with Tomcat 6.0 server to achieve the development of the required functions of office automation management system.
The reason why this system is chosen as a database to develop is that SQL SERVER SQL SERVER as a relational database has a strong data integrity, manageability; function of balance and completion; and higher price ratio as well. SQL SERVER database can enlarge capacity of data storage, and offer a reasonable logical layout of data, and application database objects can conduct complex operations on data. This system has following functions, namely:
III
Abstract
(1) Any one that enters the office systems has to input the correct user name and password. (2) The system is supposed to provide conference management functions to record the main content of the meeting.
(3) The system is supposed to provide the function of notice for timely information. (4) The system is supposed to provide the basic registration of staff leave.
(5) The system is supposed to provide the the basic registration of staff to work on and off. (6) Staff can apply for function of information.
(7) Leaders is enabled to audit and instruct staff’s application. (8) The staff can query their basic information.
(9) Managers are allowed to check user’s account by adding and deleting.
(10) The administrator can are allowed to check staff’s basic informationby adding and deleting. (11) The system is supposed to have functions of communication management. Keywords:
Office Automation Management System, JSP, Struts, Hibernate
IV
目 录
目 录
摘 要 .......................................................................................................................................................... I Abstract ........................................................................................................................................................ III 目 录 ...................................................................................................................................................... V 第1章 前 沿 ..................................................................................................................................... 1 1.1 课题的提出 ..................................................................................................................................... 1 1.2 开发目的及意义 ............................................................................................................................ 2 1.3 国内外研究现状 ............................................................................................................................ 3 1.4 开发环境介绍 ................................................................................................................................ 4 1.4.1 Struts知识简介 ................................................................................................................ 5 1.4.2 Hibernate知识简介 ......................................................................................................... 5 1.5 本章小结 ......................................................................................................................................... 6 第2章 需求分析 ..................................................................................................................................... 7 2.1 系统总体分析 ................................................................................................................................ 7 2.2 可行性分析 ..................................................................................................................................... 8 2.3 功能需求分析 ................................................................................................................................ 9 2.4 系统总体性能分析 ..................................................................................................................... 10 2.5 系统功能概要分析 ..................................................................................................................... 11 2.6 系统E-R图 ................................................................................................................................... 13 2.7 本章小结 ....................................................................................................................................... 18 第3章 总体设计思路 .......................................................................................................................... 19 3.1 系统总体分析 .............................................................................................................................. 19 3.2 数据库需求分析 .......................................................................................................................... 20 3.3 数据库逻辑设计 .......................................................................................................................... 21 3.4 本章小结 ....................................................................................................................................... 24 第4章 系统的详细设计与实现 ........................................................................................................ 25 4.1 系统设计 ....................................................................................................................................... 25 4.2 信息管理设计 .............................................................................................................................. 26 4.2.1 实现框架图 ........................................................................................................................ 26 4.2.2 实现技术 ............................................................................................................................ 26 4.2.3 实现过程 ............................................................................................................................ 26 4.3考勤模块设计 ................................................................................................................................ 30 4.3.1 设计框架图 ........................................................................................................................ 30 4.3.2 实现技术 ............................................................................................................................ 30 4.3.3 实现过程及流程图 .......................................................................................................... 31 4.3.4 上下班实现设计 ............................................................................................................... 32
V
基于Web的自动化办公系统的设计与实现
