基于java的OA系统的制作（含源文件）

毕 业 论 文

题 目：基于JAVA的OA系统的制作 学 院： 物理与电子工程学院 专 业： 电子信息工程 毕业年限： 2015.6.25 学生姓名： 学 号： 指导教师：

西北师范大学学士学位论文

摘 要

办公自动化（Office Automation,简称OA）是将现代化办公和计算机网络功能结合起来的一种新型的办公方式。办公自动化没有统一的定义，凡是在传统的办公室中采用各种新技术、新机器、新设备从事办公业务，都属于办公自动化的领域。通过实现办公自动化，或者说实现数字化办公，可以优化现有的管理组织结构，调整管理体制，在提高效率的基础上，增加协同办公能力，强化决策的一致性，最后实现提高决策效能的目的。

在本次OA系统的制作中依据需求主要实现了一下几个功能：1. 系统管理（岗位管理、部门管理、用户管理）：主要完成对工作室成员的岗位、部门的增加、修改、删除和查看；2. 网上交流（论坛、邮件）：主要为工作室成员提供学习、聊天、交流的平台；3. 审批流转（申请、审批、申请结果查询）：主要为工作中的申请、批复提供计算机间的操做，减少工作量；4. 个人办公（通信录、工作日志、工作计划）：主要为工作室成员提供良好而办公平台；5. 综合行政（会议管理、车辆管理）：主要对工作室会议记录进行发布、查看、删除，对车辆的出入时间以及使用人员进行记录和管理。基本能够完成办公自动化、管理信息化。

系统开发采用先进的开发软件与技术，即采用Dreamweaver页面制作软件与Photoshop等技术相结合开发系统的页面，用JSP动态页面设计技术与Struts、Spring、Hibernate技术，MySQL数据库管理系统开发强大完善的数据库支持环境。

关键词：办公自动化；java；jsp；ssh；mysql

I

基于JAVA的OA系统的设计与制作

Abstract

OA (Office Automation, hereinafter referred to as OA) is to combine the modern Office and computer network function and a new type of Office way. No unified definition of office automation, all in traditional office USES all sorts of new technology, new machines, equipment engaged in the business office, belongs to the field of office automation. By implementing the office automation, or digital office, can optimize the structure of the existing management organization, adjusting management system, on the basis of efficiency, increase coordination office ability, strengthen the consistency of the decision, finally achieve the purpose of increase the efficiency of the decision.

According to the requirements in the OA system of production mainly realizes the following functions: 1. The system management (management, department management, user management) : main jobs for members of the studio, completion of add, modify, delete and view; 2. Online communication (BBS, email) : mainly for the members of the studio learning, chat, and provide a platform for the exchange; 3. The examination and approval flow (application, examination and approval, the application results query) : mainly for work in the application, approval between computers operate, reduce the workload; 4. Personal office (contacts, work logs, plan) : the main office for studio members provide a good platform; 5. The comprehensive administrative (meeting management, vehicle management) : mainly to release studio meeting record, view, delete, access time of vehicles and the use of personnel records and management. Basic can complete office automation, management informatization.

System develops, adopt advanced development software and technology, and adopt Dream weaver page animation software and Photo shopped. technology combine together and develop the systematic page, use JSP dynamic page designing technique and Struts,Spring,Hibernate,MySQL data base management system develops the strong and complete database and supports the environment.

Keywords: Office automation；java；jsp；ssh；mysql

II

西北师范大学学士学位论文

目录

摘 要 ................................................... I Abstract ................................................ II 目录 ................................................... III 1 课题背景 ............................................... 1

1.1 办公自动化概述 ................................................................................................1 1.2 研究意义 ............................................................................................................1 1.3 设计技术及开发环境 ........................................................................................1

1.3.1 JSP页面技术 .........................................................................................2 1.3.2 JavaBean组件技术 ................................................................................2 1.3.3 Servlet技术 ............................................................................................2 1.3.4 框架技术ssh ..........................................................................................2 1.3.5 开发环境 ................................................................................................3 1.4 本章小结 ............................................................................................................4

2 需求分析 .................................................................................................. 5

2.1 现行业务分析 ....................................................................................................5

2.1.1业务流程 ...................................................................................................5 2.1.2 功能分析 ..................................................................................................5 2.2 系统建模 ............................................................................................................7

2.2.1 部分模块用例图 ......................................................................................7 2.3 本章小结 ..........................................................................................................10

3 系统设计 .............................................. 11

3.1 用户界面设计 .................................................................................................. 11

3.1.1 用户登录界面设计 ................................................................................ 11 3.1.2 主页设计 ................................................................................................ 11 3.2 数据库设计 ...................................................................................................... 11

3.2.1 数据库E-R图 ........................................................................................12 3.2.2 数据库逻辑设计 ....................................................................................15 3.3 论坛模块设计 ..................................................................................................19 3.4 本章小结 ..........................................................................................................20

4 系统实现 ................................................................................................ 21

4.1系统架构 ...........................................................................................................21

4.1.1 程序结构图 ............................................................................................21

III

本文来源：https://www.bwwdw.com/article/iac2.html