摘 要
本文以员工工资管理系统的实际应用需要出发,搭建基于MVC开发的员工工资管理系统来改善目前工资管理流程繁琐,员工工资统计不到位等问题。不仅如此以操作者的角度来说,该系统的架构能够对员工工资情况进行有效的统计。
本系统是利用Eclipse开发工具,JSP技术和MYSQL数据库实现员工工资管理系统。在做项目时,基于以上的问题,对其进行深度剖析,并且将剖析出来的内容在本文中详尽的撰写下来。完成该步骤以后就可以开始着手进行系统的整体架构工作,然后进一步细化完成各个功能板块的架构规划。在进行系统开发过程中,较为关键的部分是数据库的架构,数据添加、删除、修改和检查功能板块的现实以及实现状态,然后再将源码编译出来并予以展示。在完成大致的系统开发以后需要对整个系统进行全方位的检测,尽可能的寻出系统中存在的问题。使用Java语言和MYSQL数据库,以管理员角色登入系统能够更加轻松简易的完成对系统内部所有的数据信息(员工工资相关基础信息,员工考勤信息,员工请假信息,员工奖罚信息等)的管控工作。
关键词:Eclipse开发工具;JSP技术;Java语言;MySQL数据库;工资管理系统
Abstract
Based on the practical application of employee salary management system, this paper builds an employee salary management system developed based on MVC to improve the current salary management process is cumbersome, and employee salary statistics is not in place.Not only from the operator’s perspective, the architecture of the system can make effective statistics on employees’ salaries.
This system uses Eclipse development tools, JSP technology and MYSQL database.When doing the project, based on the above problems, the in-depth analysis, and the analysis of the content in this article detailed writing down.After completing this step, you can start the overall architecture of the system, and then further refine the architecture planning of each functional plate.In the process of system development, the key part is the database architecture, data add, delete, modify and check the reality and implementation status of the functional plate, and then the source code is compiled and displayed.After the completion of the general system development, the whole system needs to conduct a full range of detection, as far as possible to find out the problems existing in the system.Using Java language and MYSQL database, login to the system as the role of administrator can more easily and easily control all internal data information (basic information related to employee salary, employee attendance information, employee leave information, employee reward and punishment information, etc.).
Key words: Eclipse development tools; JSP technology; Java language; MySQL database; payroll management system
目 录
摘 要 I
Abstract II
目 录 III
1 绪论 1
1.1 研究意义 1
1.2 研究目的 1
1.3 研究内容 1
2 系统开发工具 3
2.1 MVC 3
2.2 JSP技术 3
2.3 Java语言 3
2.4 MySQL数据库 3
3 系统分析 5
3.1系统可行性分析 5
3.1.1 技术可行性 5
3.1.2 运行可行性 5
3.1.3 操作可行性 5
3.2 需求分析 5
4 系统概要设计 9
4.1系统功能模块设计 9
4.2系统业务流程设计 9
4.2.1 用户登录业务流程 9
4.2.2 修改密码业务流程 10
4.2.3 部门信息业务流程 10
4.2.4 通知公告业务流程 11
4.2.5 员工考勤业务流程 12
4.2.6 员工奖惩业务流程 12
4.2.7 员工薪酬业务流程 13
4.3 数据库设计 13
4.3.1 数据库概要设计 13
4.3.2 E-R图向关