摘 要
极光办公自动化系统是针对南开创元信息技术有限公司开发的，专门用于企业内部员工信息交流的软件,其开发过程主要包括前端应用程序的开发和后端数据库的建立两个方面。对于前者要求应用程序功能完备操作简单,对于后者要求建立起数据一致性、完整性和安全性好的数据库。
本论文在对南开创元信息技术有限公司充分调研的基础上，针对该公司实际情况，采用Client/Server模式、利用JAVA语言进行系统的开发，以SQL Server 2000作为网络数据库，实现极光办公自动化系统。
系统用网络数据库将企业内员工的基本信息统一管理起来，形成集成的信息源，系统会根据员工所属部门对员工进行分类，这样有利于发送者快速找到发送目标，也能方便的进行信息的群发，在该系统中总经理具有最高的权限，负责对系统的管理。
该系统可使企业内员工之间信息的交流更高效，更便捷，也使企业内各部门之间员工的频繁往来减到最少，从而提高企业整体的办公效率，为企业节约成本，使企业在激烈的市场竞争中赢得优势，实现企业整体战略目标。
关键词：办公自动化 客户机/服务器 系统管理
ABSTRACT
The aurora office automated system is developed to the NAIKAI CHUANGYUAN information technical company, specially used in the software of enterprise''s interior employee''s information interchange.Two respects of main setting-up including the development of the front application program and back end database that it develops course. As to the things that the former requires the application program to have complete function and operate simply, demand to set up the database with good consistency of the data, integrality and security to the latter.
This thesis is on the basis of fully survey and study the information technical company of NAIKAI CHUANGYUAN, direct against this company actual condition, adopt Client/Server mode, utilize Java to carry on systematic development, regard SQL Server 2000 as the network database, realizing the aurora office automated system.
System basic information of staff unify management stand up enterprise with network database, form information source of integration, system can classify the staff, according to department that staff belong to, helping person as fast as he can to find and send goal and can convenient to carry on group of message, the general manager has supreme authority, responsible for the management to the system in this system.
System this can make enterprise''s staff exchange information high-efficient, convenient, and reduce the exchange of the staff of different enterprise department, improve the efficiency of the enterprise whole office, economize the cost for the enterprise, make the enterprise gain advantage among the fierce market competition, realize the goal of enterprise''s overall strategy.
Keywords: Office automated Client/Server system management
目 录
第一章 概述………………………………………………………………………1
1.1 引言…………………………………………………………………………………1
1.2 办公自动化背景……………………………………………………………………1
1.3我国办公自动化发展现状…………………………………………………………2
1.4 我国办公自动化发展方向…………………………………………………………3
1.5 极光办公自动化系统开发背景……………………………………………………3
第二章 系统分析…………………………………………………………………4
2.1 极光办公自动化系统的需求分析…………………………………………………4
2.2 极光办公自动化系统的可行性分析………………………………………………4
2.3 极光办公自动化系统数据流程图…………………………………………………6
第三章 系统设计…………………………………………………………………12
3.1 系统设计原则………………………………………………………………………12
3.2 系统功能模块设计…………………………………………………………………12
3.3 系统物理配置方案设计……………………………………………………………14
3.4 数据库设计…………………………………………………………………………14
3.5 输入输出设计………………………………………………………………………16
3.6 系统的安全性设计…………………………………………………………………17
第四章 极光办公自动化系统的技术支持与实施………………………………18
4.1 选择编程语言………………………………………………………………………18
4.2 SQL Server2000数据库……………………………………………………………18
4.3 Java数据库解决方案………………………………………………………………18
4.4 Java局域网解决方案………………………………………………………………21
4.5 系统界面解决方案…………………………………………………………………25
第五章 结束语……………………………………………………………………29
致谢…………………………………………………………………………………30
参考文献……………………………………………………………………………31
第一章 概述
1.1 引言
在信息时代，一个具备一定规模的现代化组织，在其内部办公运作过程中对信息资源共享和信息实时交流的要求越来越高，高效的办公行政流程和业务运作的信息实时交流的要求越来越高，高效的办公行政流程和业务运作的规范管理成为提高机构管理水平和办公效率，减少资源的消耗，提高机构服务水平的必不可少的手段和方法。
办公自动化系统的总体目标是：“以先进成熟的计算机和通信技术为主要手段，建成一个覆盖企业办公部门和企事业单位的办公信息系统，通过网络技术，提供本单位内部各部门，各员工之间的信息交换，建立高质量、高效率的信息网络”，本系统也是为实现这一根本目标建立的，它可以实现企业的办公现代化、信息资源化、传输网络化。
极光办公自动化系统开发的真正意义不是简单的借助电脑处理收发电子邮件等日常办公作业，而是通过计算机系统的各种应用，使各独立的工作者能实现信息共享，协同工作，合理组织机构的公文和文档的流程等办公作业，全面提高组织机构的办公效率，实现信息共享。
1.2办公自动化背景
办公自动化(OfficeAutomation)是20世纪70年代中期发达国家迅速发展起来的一门综合性技术。我国的ＯＡ产业从80年代末发展至今，已从最初的提供面向单机的辅助办公产品，发展到面向企业级应用的大型协同工作软件。其发展过程大致分3个阶段。
第一阶段
以数据为处理中心的传统ＭＩＳ系统它的最大特点是应用基于文件系统和关系型数据库系统，以结构化数据为存储和处理对象，强调对数据的计算和统计能力。其贡献在于把IT技术引入办公领域，提高了文件管理水平。但是这种方式缺乏对收发文等群组协作工作过程的处理能力，因而其自动化程度是有限的。
第二阶段
以工作流为中心的办公自动化系统办公自动化已实现了以工作流为中心。这
Abstract
Aurora Office Automation System is to create a meta-information for the Southern Technology Co., Ltd. developed specifically for the exchange of employee information within the enterprise software, its development process include front-end application development and back-end database, the establishment of two aspects. For the former requires a complete application functionality is simple, for the latter require the establishment of data consistency, integrity and security of a good database.
The paper in the South to create a meta-information Technology Co., Ltd. full investigation based on the actual situation against the company, using Client / Server model, the use of JAVA language for system development, to SQL Server 2000 as a network database, office automation system to achieve the aurora .
Systems within the enterprise network database will be basic information about the unified management of staff together to form an integrated source of information, the system will staff the department staff categories to make it beneficial to send the sender to quickly find targets, but also to facilitate the conduct of the mass of information , the general manager of the system has the highest authority, responsible for system management.
The system allows companies to exchange information between its staff more efficient, more convenient, but also between departments within the enterprise staff to minimize the frequent exchanges so as to enhance their overall office efficiency and cost savings for enterprises so that enterprises in the the fierce market competition to win an advantage and achieve enterprise-wide strategic goals.
Keywords: office automation client / server system management
ABSTRACT
The aurora office automated system is developed to the NAIKAI CHUANGYUAN information technical company, specially used in the software of enterprise''s interior employee''s information interchange.Two respects of main setting-up including the development of the front application program and back end database that it develops course . As to the things that the former requires the application program to have complete function and operate simply, demand to set up the database with good consistency of the data, integrality and security to the latter.
This thesis is on the basis of fully survey and study the information technical company of NAIKAI CHUANGYUAN, direct against this company actual condition, adopt Client / Server mode, utilize Java to carry on systematic development, regard SQL Server 2000 as the network database, realizing the aurora office automated system.
System basic information of staff unify management stand up enterprise with network database, form information source of integration, system can classify the staff, according to department that staff belong to, helping person as fast as he can to find and send goal and can convenient to carry on group of message, the general manager has supreme authority, responsible for the management to the system in this system.
System this can make enterprise''s staff exchange information high-efficient, convenient, and reduce the exchange of the staff of different enterprise department, improve the efficiency of the enterprise whole office, economize the cost for the enterprise, make the enterprise gain advantage among the fierce market competition, realize the goal of enterprise''s overall strategy.
Keywords: Office automated Client / Server system management
Directory
Chapter I outlines the 1
1.1 Introduction 1
1.2 office automation Background 1
1.3 Present Situation of China''s office automation 2
1.4 the direction of development of China''s office automation 3
Aurora Office Automation System 1.5 Background 3
Chapter II Analysis 4
2.1 Aurora Office Automation System requirements analysis of 4
Aurora Office Automation System 2.2 Feasibility Analysis of 4
2.3 Aurora office automation system data flow diagram 6
Chapter III System Design 12
Design principles 3.1 12
3.2 The system function module design 12
3.3 System design of the physical configuration 14
Database design 3.4 14
3.5 Design O 16
3.6 System Safety Design 17
Chapter IV Aurora Office Automation System technical support and implementation of 18
Select 4.1 programming language 18
4.2 SQL Server2000 database 18
4.3 Java database solution 18
4.4 Java LAN solution 21
4.5 System Interface Solution 25
Chapter V Conclusion 29
Thanks 30
References 31
Chapter I outlines the
1.1 Introduction
In the information age, a modern organization with a certain scale, in the course of its internal office of information resource sharing and information exchange have become increasingly demanding real-time, efficient office administrative procedures and operational information in real-time communication requirements Yue Lai The higher the efficiency of office administrative procedures and operational management becomes the norm to improve institutional management and office efficiency, reduce resource consumption, improve service levels of the essential institutional means and methods.
Office automation system''s overall objective is: "to the advanced maturity of the computer and communications technology as the main means to build a corporate office covering departments and enterprises of office information systems, network technology to provide its internal departments, the staff of the exchange of information between the establishment of high-quality, efficient information network ", this system is also established to achieve this fundamental objective, it can achieve a modern business office, information resource, the transmission network.
Aurora Office Automation system development, with the true sense is not a simple e-mail and other computer processing routine office work, but through a variety of applications of computer systems so that all the independent workers to share information, teamwork, rational organization of the documents and document processes and other office work, comprehensively enhance the organization''s efficiency and achieve information sharing.
1.2 office automation background
Office Automation (OfficeAutomation) is the mid-20th century, 70 developed countries, rapidly developed a comprehensive technology. OA industry in China from the late 80''s development to date, from the initial offer for the stand-alone ancillary office products, developed into a large-scale enterprise-class applications-oriented work with the software. Course of its development be broadly divided into three stages.
Phase
Data-processing centers of traditional MIS systems of its greatest characteristics is the application based on the file system and relational database systems to structured data for storage and processing objects, emphasis on the data calculations and statistical capacity. Its contribution lies in the field of IT technology into office to improve document management. However, the lack of sending and receiving text this way, groups such as the processing power of collaborative work processes, hence its degree of automation is limited.
Phase
Work-flow centric office automation, office automation system has been achieved with the workflow-centered. This
