办公自动化管理系统的设计与实现

I摘要随着信息技术的发展，能够实现信息交换与共享、协同工作，并协助公司管理与决策的办公自动化系统，已成为企事业单位新的运作模式。本文首先阐述了课题的背景，以及国内外OA系统的发展现状。文中重点阐述了系统主要模块的实现方法，关键技术，数据库设计。系统按照MVC模式把程序分为三个核心模块：模型、视图和控制器。分别采用JSP、SERVLET实现三种角色，完成系统的功能。通过对办公OA系统的功能的需求分析，确立了系统目标，提出了系统实施方案。用户可以以不同的身份登入，通过权限管理确定登录的用户对各个模块能进行的各类操作。本系统通过Hibernate访问关系数据库，将办公系统和业务系统有效地集成。在功能模块设计上，该系统主要设计了日常管理、考勤管理、计划制定、审核管理、员工管理和通讯管理功能模块。关键词：办公自动化(OA)，JSP，HibernateIIABSTRACTWiththedevelopmentofinformationtechnology,Peopleaskofficeautomationsystemcanhelppeopletoexchangeandshareinformation,teamworkaswellasgovernanceanddecision-making,improvingtheefficiencyoftheenterprise,toenhancecorecompetence.Thisissuedescribesthearticlebackgroundatfirst,andthedevelopingsituationoftheOAsystemintheworld.Throughtheunderstandingofthetechnologyofenterprise-levelJ2EE,wegetthetechnicalreservefortheresearchofthetopic.Thearticlefocusesonthemethodofmainmodulesofthesystem,thekeytechnology,anddesignofdatabase.ThesystemdividestheprocedureintothreecoremodulesaccordancetotheMVCmodelsystem:model,viewandcontroller.UsingJSPandSERVLETtoachievethreerolesandthefunctionofthesystem.AccordingtoanalyzetheneedsofthefunctionsofOA,establishthegoalofthesystem,andbringforwardtheproject.Userscanenterindifferentidentities;usersthroughthecontrolcanoperateallmodules.ThissystementrytherelationaldatabasethroughHibernate,integratingofficesystemsandbusinesssystemeffectively.Inthedesignoffunctionalmodule,thesystemmainlydesignthemodulesofdailymanagement,checkingattendancemanagement,makingplanning,auditingmanagement,staffmanagementandcommunicationmanagement.Keywords:OfficeAutomation(OA)，JSP，HibernateIII目录摘要...................................................................................................................................IABSTRACT.....................................................................................................................II第1章引言....................................................................................................................11.1背景...................................................................................................................11.2国内外研究现状...............................................................................................11.3研究内容...........................................................................................................3第2章OA系统开发方法..............................................................................................52.1OA系统开发技术..............................................................................................52.1.1MVC简介...............................................................................................52.1.2Struts的体系结构与工作原理...............................................................62.1.3Struts的组件及工作原理.......................................................................82.2数据库访问技术.............................................................................................102.2.1Hibernate简介.......................................................................................102.2.2SQLSERVER2000简介......................................................................112.3Myeclipse应用服务开发平台.........................................................................122.4Tomcat服务器平台简介..................................................................................132.5本章小结.........................................................................................................13第3章OA系统需求分析.............................................................................................153.1系统需求.........................................................................................................153.1.1系统性能需求......................................................................................153.1.2系统功能需求......................................................................................153.2系统总体设计目标.........................................................................................163.3本章小结.........................................................................................................17第4章数据库设计......................................................................................................184.1数据库结构分析与创建.................................................................................184.2概念结构设计.................................................................................................194.3逻辑结构设计.................................................................................................204.4数据库安全性和完整性.................................................................................22IV4.4.1数据库的安全性..................................................................................224.4.2数据库的完整性..................................................................................234.5本章小结.........................................................................................................24第5章系统设计与实现..............................................................................................255.1系统总体设计..........