基于三层模式的企业人事管理系统的设计与实现
|
摘要
信息是一种资源,如何有效地利用这种资源是人们关心的问题。随着数据库技术的迅速发展以及数据库管理系统的广泛应用,人们利用信息技术操作和搜索数据的能力大幅度提高,千千万万的数据库被用于商业管理、政府办公、科学研究和工程开发等方面。今天,信息资源已经成为各个部门的重要财富。建立一个满足各级部门信息处理要求的行之有效的信息系统也成为一个企业或者组织生存和发展的重要条件,企业人事管理系统应运而生。
本文着眼于企业人事管理的特殊需求,详细分析了人事管理系统的特点,设计并实现了企业人事管理系统。由于传统的二层C/S结构存在的局限性:它是单一服务器且以局城网为中心的,所以难以扩展至大型企业广域网或Internet;软、硬件的组合及集成能力有限;难以管理大童的客户机。因此,本文提出的企业人事管理系统采用了三层C/S结构。三层C/S结构是将应用功能分成表示层、功能层和数据层三部分。其解决方案是:对这三层进行明确分割,并在逻辑上使其独立。
本文所设计的系统采用三层C/S结构模式开发,以Windows XP为网络操作平台,数据库采用MS SQL Server,应用程序以VB6.0为开发工具。
本系统包括七个功能模块:基本信息模块、档案信息模块、考勤信息模块、工资发放信息模块、休假信息模块、查询统计模块、系统维护模块,把各个部门的主要信息都列入了系统管理范围,系统实施后可有效地提高各个部门的办公效率。
本系统具有以下特点:
第一,安全性高,符合企业人事管理保密性强的特点;
第二,操作简单,适用于不同水平人员操作;
第三,功能较完备,实现了组合的查询统计;
第四,实用性强,切合企业人事管理的实际;
第五,通用性好,在系统中所设计的模块稍加改动即可用到其它企业。
Information is a kind of resource, how to effectively use such resources is the issue we concerned. As database technology developing and the widely used of the database management system, the capacity to operate and search data using information technology is enforcing, thousands of databases are used in commercial management, the government office, science research and engineering development, and so on. Today, information resource has become an important wealth in all sectors. The establishment of an information system at all levels to meet the information processing requirements of various departments has become an important factor which a corporation or an organization can survive and develop for. Corporation personnel management system came into being.
This paper focuses on the special needs of corporation personnel management, detailed analysis the features of personnel management system, and then designed and realized the corporation personnel management system. Since the traditional two-story C / S structure has limitations: it is a single server and with City Council for the network, so it is difficult to extend to large enterprise WAN or Internet; Hardware and software portfolio and integration capability is limited; Tong difficult to manage large client. Therefore, the enterprise management system this paper presents uses a three-tier C / S structure. Three C / S structure is divided into application layer, the functional layer and data layer three parts. Their solution is: giving this three-tier clear segmentation and the logic makes it independent.
In this paper, the system uses a three-tier C / S model development to the Windows XP operating platform for network, database using MS SQL Server, Visual Basic 6.0 applications as tools for development.
This system is composed of seven function modules: the basic information module, the file information module, the attendance information module, the salary information module, the vacation information module, the inquiring and statistics module and the system maintenance module, all the main information of the department was included in the system management scope. This system can availably improve the working efficiency of the department.
This system has some characteristics as follows:
(1) With high safety, the system fits for enterprises' high secrecy demands;
(2) With simple Operation, the system fits for everyone with different levels to operate;
(3) With maturity functions, the system can realize inquire statistics for any combination;
(4) With high practicability, the system fits for practicality of enterprises' personnel management;
(5) It is general-purpose, the system can be used in other enterprises easily with minor changes.
本文着眼于企业人事管理的特殊需求,详细分析了人事管理系统的特点,设计并实现了企业人事管理系统。由于传统的二层C/S结构存在的局限性:它是单一服务器且以局城网为中心的,所以难以扩展至大型企业广域网或Internet;软、硬件的组合及集成能力有限;难以管理大童的客户机。因此,本文提出的企业人事管理系统采用了三层C/S结构。三层C/S结构是将应用功能分成表示层、功能层和数据层三部分。其解决方案是:对这三层进行明确分割,并在逻辑上使其独立。
本文所设计的系统采用三层C/S结构模式开发,以Windows XP为网络操作平台,数据库采用MS SQL Server,应用程序以VB6.0为开发工具。
本系统包括七个功能模块:基本信息模块、档案信息模块、考勤信息模块、工资发放信息模块、休假信息模块、查询统计模块、系统维护模块,把各个部门的主要信息都列入了系统管理范围,系统实施后可有效地提高各个部门的办公效率。
本系统具有以下特点:
第一,安全性高,符合企业人事管理保密性强的特点;
第二,操作简单,适用于不同水平人员操作;
第三,功能较完备,实现了组合的查询统计;
第四,实用性强,切合企业人事管理的实际;
第五,通用性好,在系统中所设计的模块稍加改动即可用到其它企业。
Information is a kind of resource, how to effectively use such resources is the issue we concerned. As database technology developing and the widely used of the database management system, the capacity to operate and search data using information technology is enforcing, thousands of databases are used in commercial management, the government office, science research and engineering development, and so on. Today, information resource has become an important wealth in all sectors. The establishment of an information system at all levels to meet the information processing requirements of various departments has become an important factor which a corporation or an organization can survive and develop for. Corporation personnel management system came into being.
This paper focuses on the special needs of corporation personnel management, detailed analysis the features of personnel management system, and then designed and realized the corporation personnel management system. Since the traditional two-story C / S structure has limitations: it is a single server and with City Council for the network, so it is difficult to extend to large enterprise WAN or Internet; Hardware and software portfolio and integration capability is limited; Tong difficult to manage large client. Therefore, the enterprise management system this paper presents uses a three-tier C / S structure. Three C / S structure is divided into application layer, the functional layer and data layer three parts. Their solution is: giving this three-tier clear segmentation and the logic makes it independent.
In this paper, the system uses a three-tier C / S model development to the Windows XP operating platform for network, database using MS SQL Server, Visual Basic 6.0 applications as tools for development.
This system is composed of seven function modules: the basic information module, the file information module, the attendance information module, the salary information module, the vacation information module, the inquiring and statistics module and the system maintenance module, all the main information of the department was included in the system management scope. This system can availably improve the working efficiency of the department.
This system has some characteristics as follows:
(1) With high safety, the system fits for enterprises' high secrecy demands;
(2) With simple Operation, the system fits for everyone with different levels to operate;
(3) With maturity functions, the system can realize inquire statistics for any combination;
(4) With high practicability, the system fits for practicality of enterprises' personnel management;
(5) It is general-purpose, the system can be used in other enterprises easily with minor changes.
引文
[1]Jhon M.Vlissides,James O.Coplien and Norman L.Kerth(ed.).Pattern Languages of Program Design 2.Addison-Wesley,1996
[2]Kirk Knoernschild.JavaDesign-Objects,UML,and Process.Addison-Wesley,2002
[3]J.Feikis.Secure database management system.JEEE Potentials,1999,18(1):17-19
[4]赵志升,许素文,杨小株.对象——关系数据库管理系统及其特性与实现.电脑开发与应用,2000,18:47-48
[5]倪凯民.管理信息系统应用开发探讨.计算机应用研究,1998,15(2):18-21
[6]孙炳旭,陈飞,梁茂盛SQL Server 2000使用管理指南.北京:机械工业出版社,2000
[7](美)Deepak Alur,John Crupi,Dan Malks著 J2EE核心模式.刘志奇 丁天田蕴哲等译.机械工业出版社 2002年2月。
[8]刘新民,蔡琼等编著 Visual Basic6.0程序设计.清华大学出版社 2004年6月
[9]李真文.Visual Basic 6.0全实例教程.北京希望电子出版社 2002年6月
[10]李晓黎 张巍.Visual Basic + SQL Server数据库应用系统开发与实例.人民邮电出版社 2003年8月
[11]林清祥等.Visual Basic 6.0程序设计实务入门.中国铁道出版社 2002年4月
[12]刘波等.MIS中数据库性能优化的研究.计算机工程,2001,7:145-148
[13]陆静平,何玉林.基于SQL SERVER视图的数据库安全模型的研究.计算机工程与应用,2002,9:188-189
[14]应力,郭松柏.信息系统(网络)安全分析方法与评价模型.计算机工程与应用,2002,19:51-52
[15]J.Vincent,A.Waters,J.Sinclair.Software Quality Assurance.Practice and Implementation,New York:Prentice-Hall,1998
[16]林颖贤.基于多层结构应用程序研究.佳木斯大学学报(自然科学版),2000.3
[17]廖志英.基于C/S和B/S混合结构的管理信息系统运行模式.计算机工程与应用,2002
[18]邹永林,干爱松.小型MIS中的用户权限管理.电脑开发与应用,2002,1:42-43
[19]史庭俊,朱建明,马建峰.网络系统安全和容错模型的建立及分析计算机工程与应用.2002,14:19-20
[20]左银龙,黄志球等.分布式多层应用系统的设计与实现.上海:计算机工程,2001 77-80
[21]胡正国 吴建 邓正宏著.《程序设计方法学》.国防工业出版社 2003年1月 166-167
[2]Kirk Knoernschild.JavaDesign-Objects,UML,and Process.Addison-Wesley,2002
[3]J.Feikis.Secure database management system.JEEE Potentials,1999,18(1):17-19
[4]赵志升,许素文,杨小株.对象——关系数据库管理系统及其特性与实现.电脑开发与应用,2000,18:47-48
[5]倪凯民.管理信息系统应用开发探讨.计算机应用研究,1998,15(2):18-21
[6]孙炳旭,陈飞,梁茂盛SQL Server 2000使用管理指南.北京:机械工业出版社,2000
[7](美)Deepak Alur,John Crupi,Dan Malks著 J2EE核心模式.刘志奇 丁天田蕴哲等译.机械工业出版社 2002年2月。
[8]刘新民,蔡琼等编著 Visual Basic6.0程序设计.清华大学出版社 2004年6月
[9]李真文.Visual Basic 6.0全实例教程.北京希望电子出版社 2002年6月
[10]李晓黎 张巍.Visual Basic + SQL Server数据库应用系统开发与实例.人民邮电出版社 2003年8月
[11]林清祥等.Visual Basic 6.0程序设计实务入门.中国铁道出版社 2002年4月
[12]刘波等.MIS中数据库性能优化的研究.计算机工程,2001,7:145-148
[13]陆静平,何玉林.基于SQL SERVER视图的数据库安全模型的研究.计算机工程与应用,2002,9:188-189
[14]应力,郭松柏.信息系统(网络)安全分析方法与评价模型.计算机工程与应用,2002,19:51-52
[15]J.Vincent,A.Waters,J.Sinclair.Software Quality Assurance.Practice and Implementation,New York:Prentice-Hall,1998
[16]林颖贤.基于多层结构应用程序研究.佳木斯大学学报(自然科学版),2000.3
[17]廖志英.基于C/S和B/S混合结构的管理信息系统运行模式.计算机工程与应用,2002
[18]邹永林,干爱松.小型MIS中的用户权限管理.电脑开发与应用,2002,1:42-43
[19]史庭俊,朱建明,马建峰.网络系统安全和容错模型的建立及分析计算机工程与应用.2002,14:19-20
[20]左银龙,黄志球等.分布式多层应用系统的设计与实现.上海:计算机工程,2001 77-80
[21]胡正国 吴建 邓正宏著.《程序设计方法学》.国防工业出版社 2003年1月 166-167