青岛农业大学
毕 业 论 文（设计）
题 目：姓 名：学 院：专 业：班 级：学 号：指导教师： 工资管理系统的设计与实现 理学与信息科学学院 计算机科学与技术 2009级2班
2013年 6 月 10 日
工资管理系统的设计与实现
摘要：在当今计算机技术高速发展下，企业已进入了信息化的时代。而为了使工资管理理能够做到更高效、更科学，决定开发工资管理系统。
本文主要采用的方法是结构化分析，首先介绍的是系统的开发背景，系统的开发目的；接下来系统的关键技术以及系统开发模式的介绍；之后是系统分析，包括系统可行性分析，业务流程分析，数据流程分析和数据字典；然后是系统设计，包括功能设计和数据库的设计；再接下来讲解的是系统是怎么实现的，主要阐述了系统方法及界面的实现；最后是系统测试，测试了本系统的功能和性能。
该系统采用JSP + SQL Server 2008的开发，开发过程中信息的发布，静态页面的显示技术采用了模块化的方法。系统的开发模式，采用B / S模式。该系统能更好的实现营商企业管理，利用数据库技术可以存储大量的信息。本系统很好地实现了人机交互，不仅缩短了支付工资的时间，同时也避免了传统人工计算的错误。总之，系统的工资管理周到，功能齐全，大大提高了企业的工资管理的效率。 关键词：工资管理系统；SQL Server数据库；结构化分析
I
Salary Management System Design and Implementation
Abstract：With the development of computer technology, the company has entered the information age. In order to be able to do the payroll management more efficient, more scientific, decided to develop a payroll system.
This paper uses the method of structure analysis, introduces the system development background, system development goal; then introduces the key technology and system development model; secondly, system analysis, including the feasibility analysis, business process analysis, data flow analysis and data dictionary; and then the design of the system, including function design and database design; the second is the realization of the system, mainly to the system interface; finally, system testing, functional and performance testing system.
The system uses JSP + SQL Server 2008 development, the development process of information communication, display a static page, modular, dynamically generated pages. System development model, using B/S model. Implementation of enterprise management, the system helps the database technology, the use of vast quantities of information can be stored. But the realization of human-computer interaction at the same time, not only shorten the time of payment of wages, but also to avoid the error of computation times of traditional manual. In a word, the system of wages and thoughtful, complete functions, greatly improve the efficiency of enterprise wage management.
Key words: payroll management system ; SQL Server database ; Structured analysis
II
目 录
1 引言 ............................................................................................................................ 1
1.1 项目开发的背景 ............................................................................................... III 1.2 项目开发的意义 ................................................................................................. 1 1.3 管理系统概述 ..................................................................................................... 2 1.3.1 管理信息系统的概念和发展历程 .............................................................. 2 1.3.2 管理信息系统的主要功能 .......................................................................... 2 1.3.3 管理信息系统的开发方法和技巧 .............................................................. 2 1.4 本章小结 ............................................................................................................. 3 2 相关技术介绍 ............................................................................................................ 4
2.1 JSP技术 ............................................................................................................... 4 2.2 SQL 2008数据库 ................................................................................................ 4 2.3 JAVA语言 ........................................................................................................... 5 2.4 系统开发模式 ..................................................................................................... 5 2.5 本章小结 ........................................................................................................... 6 3 系统分析 .................................................................................................................... 7
3.1 系统可行性分析 ................................................................................................. 7 3.1.1 技术可行性 .................................................................................................. 7 3.1.2 经济可行性 .................................................................................................. 7 3.1.3 社会可行性 .................................................................................................. 8 3.2 业务流程分析 ..................................................................................................... 8 3.3 数据流图 ........................................................................................................... 10 3.4 数据字典 ........................................................................................................... 12 3.5 本章小结 ........................................................................................................... 14 4 系统设计 .................................................................................................................. 15
4.1 系统功能设计 ................................................................................................... 15 4.2 系统数据库设计 ............................................................................................... 16
4.2.1 概念结构设计 ............................................................................................ 16 4.2.2 数据库表设计 ............................................................................................ 19 4.3 本章小结 ........................................................................................................... 20 5 系统实现 .................................................................................................................. 21
5.1登录模块 ............................................................................................................ 21 5.2 员工信息管理模块 ........................................................................................... 21 5.3 绩效考核管理模块 ........................................................................................... 22 5.4 薪酬福利管理模块 ........................................................................................... 22 5.5 系统管理员管理模块 ....................................................................................... 23 5.6薪酬查询模块 .................................................................................................... 24 5.7本章小结 ............................................................................................................ 24 6 系统测试与系统分析 .............................................................................................. 25
6.1 系统测试重要性 ............................................................................................... 25 6.2 测试的研究与选择 ........................................................................................... 25 6.3 测试环境与测试条件 ....................................................................................... 26 6.4 系统评价 ........................................................................................................... 26 6.5 本章小结 ........................................................................................................... 26 结 论 .......................................................................................................................... 27 参 考 文 献 .................................................................................................................... 28 致 谢 .......................................................................................................................... 29