摘 要
本文主要分析公司人事工资管理系统的一些基本功能和组成情况，包括系统的需求分析、系统结构、系统功能模块划分以及系统数据库模式分析等，重点对人事工资管理系统的开发实现进行介绍。
人事工资管理系统是不可缺少的部分，它的内容对于其的决策者和管理者来说都至关重要，所以人事工资管理系统应该能够为用户提供充足的信息和快捷的查询手段。人事工资管理系统的主要任务就是使用计算机，对所有公司成员的人事档案资料进行保存；在需要时进行查找、分类、统计或者增加、修改和删除等操作；可以针对不同的目的，对各种档案资料进行查询。
本文重点说明了系统的设计思想、关键技术和解决方案。使用Microsoft公司的SQL Server 2005数据库管理系统进行数据存储；通过使用Microsoft公司的Visual Studio 2008集成开发环境。
关键字：人事管理系统；Visual Studio 2008； SQL
I
Abstract
This article analyzes the personnel management system， the more software companies some of the basic functions and composition， including system requirements analysis， system architecture， system functions and system database module division pattern analysis， with emphasis on the personnel management system， the more software companies developing implementation are introduced.
The personnel management system， the more software companies is a company， the more an indispensable part of its contents for its decision-makers and managers are crucial to， the personnel management system， the more software companies should be able to provide users with adequate of information and fast query tool. The personnel management system， the more software companies the main task is to use computers for all members of the company's personnel file information stored; to find when， classification， statistics， or add， modify and delete operations; can be for different purposes， for a variety of archives to search.
This article highlights the system's design concept， key technologies and solutions. I， the use of Microsoft's SQL Server 2005 database management system for data storage; through the use of Microsoft's Visual Studio 2008 integrated development environment technology design front-end interface.
Key Word: Personnel Management System; Visual Studio 2008 ; SQL。
II
目 录
引 言 ................................................................................................................................ 1 1 基础知识 ...................................................................................................................... 4
1.1 Visual Studio介绍 .............................................................................................. 4 1.2 SQL Server数据库介绍 .................................................................................... 5 2 系统分析 ...................................................................................................................... 7
2.1 开发背景及意义 ................................................................................................ 7 2.2 可行性研究 ........................................................................................................ 7 2.3 功能需求 ............................................................................................................ 8
2.3.1 用例分析 .................................................................................................. 8 2.3.2 概念类描述 ............................................................................................ 11 2.3.3 行为描述 ................................................................................................ 12 2.4 性能需求 .......................................................................................................... 13
2.4.1 响应时间 ................................................................................................ 13 2.4.2 吞吐量 .................................................................................................... 13 2.4.3 并发用户数 ............................................................................................ 15 2.4.4 资源利用率 ............................................................................................ 15 2.5 环境需求 .......................................................................................................... 15
2.5.1 硬件环境 ................................................................................................ 15 2.5.2 软件环境 ................................................................................................ 15
3 系统设计 .................................................................................................................... 16
3.1 系统结构设计 .................................................................................................. 16
3.1.1 软件设计的原则 .................................................................................... 16 3.1.2 系统层次结构 ........................................................................................ 17 3.2 设计阶段类图 .................................................................................................. 18 3.3 数据库设计 ...................................................................................................... 19
3.3.1 数据库概念设计 .................................................................................... 19 3.3.2 数据库逻辑设计 .................................................................................... 20
I
3.4 系统详细设计 .................................................................................................. 22
3.4.1 系统登录PAD图................................................................................... 22 3.4.2 档案管理PAD图................................................................................... 23 3.4.3 修改口令PAD图................................................................................... 23
4 系统实现 .................................................................................................................... 25
4.1 语言选择原因 .................................................................................................. 25 4.2 软件开发环境 .................................................................................................. 28 4.3 系统功能实现 .................................................................................................. 28
4.3.1 管理员登录 ............................................................................................ 28 4.3.2 档案管理 ................................................................................................ 28 4.3.3 添加员工信息 ........................................................................................ 30 4.3.4 奖罚管理 ................................................................................................ 31 4.3.5 调动管理 ................................................................................................ 32 4.3.6 考勤津贴 ................................................................................................ 32 4.3.7 工资总结 ................................................................................................ 33
5 软件测试 .................................................................................................................... 35
5.1 测试计划的制定 .............................................................................................. 35
5.1.1 调试计划的整体目标 ............................................................................ 35 5.1.2 定义软件测试的标准 ............................................................................ 35 5.1.3 测试实施策略的制定 ............................................................................ 35 5.1.4 测试计划的活动的细分 ........................................................................ 35 5.1.5 测试计划的要点 .................................................................................... 36 5.2 测试的基础 ...................................................................................................... 36
5.2.1 测试的目标 ............................................................................................ 36 5.2.2 白盒测试和黑盒测试 ............................................................................ 37 5.2.3 测试的准则 ............................................................................................ 37 5.3 测试用例设计 .................................................................................................. 38
5.3.1 等价类测试用例设计 ............................................................................ 38 5.3.2 边界值测试用例设计 ............................................................................ 39 5.3.3 功能图法测试用例设计 ........................................................................ 40
II
5.4 软件可靠性 ...................................................................................................... 42
5.4.1 基本定义 ................................................................................................ 42 5.4.2 估算平均无故障时间的方法 ................................................................ 43 5.4.3 MTTF和ASS的估算 ........................................................................... 44
结 论 .............................................................................................................................. 45 致 谢 .............................................................................................................................. 46 参考文献 .......................................................................................................................... 47 附 录 .............................................................................................................................. 48
附录A Salary Management System ....................................................................... 48 附录B 工资管理系统 ........................................................................................... 53 附录C 系统使用说明书 ....................................................................................... 57
III