内容发布更新时间 : 2024/10/20 9:24:58星期一 下面是文章的全部内容请认真阅读。

摘 要

公司人事管理系统是典型的人事信息管理系统，其主要的功能是把人事管理过程信息化，自动化以减轻人工的重复繁琐劳动。其开发主要包括后台数据库的建立维护以及前台应用程序的开发两个方面。对于后台数据库要求建立一个稳定的数据库，保持数据的一致性，完整性，安全性也是必要的。对于前台要求稳定，实用，易用。

本系统是为公司人事管理的各种工作而设计的。根据需求分析，需要实现对系统用户，基本信息（公司部门，人员相关信息等），考勤考评的管理。

经过分析，本系统使用SQL SERVER做为其后台数据库，采用ADO数据库链接技术；Visual C++做为开发工具， 提供了相当齐备的类库、友好的编程界面和多种多样的数据库访问技术。其中ADO使得编写数据库应用程序变得简单容易。

公司人事管理系统是典型的信息管理系统，其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性,完整性，安全性好的库。而对于后者则要求应用程序功能完备，易使用等特点。

关键词: VC++ 数据库； 人事管理系统； ADO 数据源

Abstract

Company's personnel administrative system is typical personnel information management systems , its main function is to information and automation the process of the personnel information management system which lighten people from repeated and tedious artificial work. It develops two respects of main development including the setting-up and maintaining of backstage supporter's database and the front desk application program. Demand to set up a steady database to backstage supporter's database, keep the consistency of the data, integrality, security are all essential. As to the thing that the front desk requires steadily, practical, easy to use.

This system was worked and designed for various kinds of company's personnel management. According to demand analysis, need to realize systematic users correctly, basic information (company's department, personnel's relevant information, etc.), the management that the attendance checks and rate.

After analyzing ,this system uses SQL SERVER as its backstage database , adopt ADO database technology to chain; taking Visual C + + as the developing instrument which has offered quite complete kinds of storehouses , friendly programming interface and varied database visiting technology. ADO technology makes it simple and easy to write database application program.

Company's personnel administrative system is typical information management systems, it develops two respects of main development including setting-up and maintenance and front application program of backstage supporter's database . As to the thing that the former demands to set up consistency of the data, integrality , the storehouse with good security . Require to the latter the function of the application program is complete, apt characteristic of using etc.

Keywords: The database of Visual C++; Personnel Manage System; The data source of ADO

II

目 录

1引言 ························· IV 2 系统分析 ······················· V

2.1概要分析 ····························································································· V

2.2 总体设计 ·························································································· VII 2.3 开发环境 ························································································· VIII

3 数据库设计 ····················· XIV

3.1 数据规范化问题 ················································································ XIV 3.2设计表的结构 ···················································································· XIV

4 建立数据库表的类 ················· XVIII

4.1 部门表的类 ···················································································· XVIII 4.2员工基本信息表的类 ········································································ XVIII 4.3员工家庭信息的类············································································ XVIII 4.4员工教育及工作经历记录的类 ···························································· XVIII 4.5员工考评表的类 ················································································· XIX 4.6员工工作考勤表的类 ·········································································· XIX 4.7用户信息表的类 ················································································· XIX

5 系统实现 ······················· XX

5.1用ADO进行数据库编程： ··································································· XX 5.2实现用户登录功能············································································· XXV 5.3 实现部门管理功能 ··········································································· XXVI 5.4 实现员工信息管理功能 ··································································· XXVIII 5.5 实现考勤管理功能 ··········································································· XXIX 5.6 实现员工考评管理功能 ······································································ XXX 5.7实现用户管理功能············································································· XXX

6 结论 ······················· XXXII 7致 谢 ······················ XXXII 8参考文献 ····················· XXXII

III