摘 要
办公自动化是一个新兴的、复杂的、综合性的领域,它以计算机和网络技术为核心,同时涉及到自然科学、管理学、社会学、系统工程学等多种学科的内容。实现办公自动化可以极大地提高办公效率以及办公质量。
本程序实现了OA办公系统的部分主要功能,即文档管理,电子邮件管理,发文管理等,同时使用了角色访问控制,增强了系统的安全性。其开发主要包括后台数据库的建立、管理和前端应用程序的开发两个方面。
本文首先介绍了基于角色访问控制的OA系统的整体系统架构及Microsoft SQL SERVER 数据库的建立,然后对数据库进行了相关的设计,最后介绍了各个功能子模块的设计思路与具体实现方法。
关键词:OA系统;角色访问控制;SQL;数据库
Design and Realization of OA System Based on RBAC
Abstract
OA is a rising, complex, all-around field. It makes computer network technology the main points, and involves science, management science, sociology, system engineering and other disciplines. To realize office automation can greatly improve office efficiency and quality office.
Some functions of the OA System based on RBAC, such as file management, e-mail management and document management, are realized in the program. At the same time, the use of roles based on access control lets the system more security. It involves the establishment and management of the database and the development of the front-end application.
First of all, this paper introduces the architecture of the OA system based on BRAC and the fundament of Microsoft SQL SERVER database. Secondly, it makes a design in the related database tables. At last, the design and the implementation of each module is introduced in detail.