人事管理系统
作者姓名
指导教师
所学专业
班级
所属院系
学习年限
年
月至
年
月
二○
年
月
目 录
论文总页数：44 页
1 引言 .......................................................................................................................................................1
1.1 课题背景.........................................................................................................................................1
1.2 本课题研究的意义.........................................................................................................................1
1.3 本课题的研究思路和方法.............................................................................................................1
1.4 本文的主要工作.............................................................................................................................1
2 开发工具介绍 .......................................................................................................................................2
2.1 JSP 技术...........................................................................................................................................2
2.1.1 JAVA 简介 .............................................................2
2.1.2 JSP 简介 ..............................................................2
2.1.3 JavaBeans 介绍 ........................................................3
2.1.4 JDBC 驱动程序介绍 ....................................................3
2.2 MYECLIPSE 介绍 ..............................................................................................................................4
2.3 SQL SERVER2005 数据库 ...............................................................................................................4
2.4 BROWSER/SERVER（B/S）结构......................................................................................................5
3 需求分析及设计方案...........................................................................................................................5
3.1 需求分析.........................................................................................................................................5
3.2 设计方案.........................................................................................................................................5
3.2.1 系统功能 .............................................................5
3.2.2 系统结构 .............................................................6
4 具体设计流程及实现...........................................................................................................................6
4.1 数据库设计.....................................................................................................................................6
4.1.1 数据库需求分析及 E-R 图 ...............................................6
4.1.2 数据表具体设计 ........................................................7
4.1.3 数据字典 .............................................................10
4.2 部分关键编码实施实现...............................................................................................................12
4.2.1 工资管理编码实现 ....................................................12
4.2.2 业绩管理编码实现 ....................................................26
4.2.3 时间设置编码实现 ....................................................32
5 系统运行及测试与分析.....................................................................................................................38
5.1 系统的运行...................................................................................................................................38
5.1.1 用户登录 ............................................................38
5.1.2 主界面 ...............................................................38
5.1.3 部门管理 ............................................................39
5.1.4 用户管理 .............................................................39
5.1.5 工资管理 ............................................................40
5.1.6 用户查询 ............................................................40
5.1.7 考勤录入 ............................................................41
5.1.8 考勤查询 ............................................................41
5.1.9 业绩管理 ............................................................41
5.1.10 业绩对比 ...........................................................42
5.2 测试与分析 ...................................................................................................................................42
结 论 .................................................................................................................................................42
参考文献 .................................................................................................................................................43
致 谢 .................................................................................................................................................44
摘 要
本设计的开发是基于 B/S 结构，采用 JSP 程序设计语言及 SQL Server 2005
数据库进行开发；论文首先阐述了基于 B/S 模式的浙江江森自控有限公司人事管
理系统的开发，并对该系统进行了较详细的需求分析；然后探讨了该系统需要实
现的设计方案，该系统主要包括部门管理，工资管理，用户管理，用户查询，帮
助设置，考勤录入，考勤查询，培训管理，招聘管理等功能模块；最后，在测试
与分析过程中，该系统表现出了运行稳定、可靠和实用等特性，具有一定的实用
价值。
关键词： 人事系统；工资管理；考勤；数据库；JSP
Abstract
The development of this design is based on B / S structure, using JSP
programming language and SQL Server 2005 database development; thesis describes
the development of the insurance company personnel system based on B / S mode,
and the system in more detailneeds analysis; then discusses the need to implement the
system design, the system including department management, payroll management,
user management, user queries, time setting, attendance entry, attendance inquiries,
leave management, performance management, performance comparison function
module;Finally, in the process of testing and analysis, the system showed a stable,
reliable and practical features, has some practical value..
Key words: Personnel system; wages; attendance; database; JSP
