首页 > 源码下载 > Servlet/JSP源码 > 一款经典的企业员工信息管理系统源码分享
源码简介




一款经典的企业员工信息管理系统源码分享

项目描述

Hi，大家好，今天分享的项目是《一款经典的企业员工信息管理系统》。

企业员工信息管理系统主要用于实现公司的员工相关信息管理，基本功能包括：

（1）管理员端

 

  • 「密码修改」
  • 「员工管理」
  • 「部门管理」
  • 「出勤管理」
  • 「工资管理」
  • 「请假审核」

（2）员工端

 

  • 「密码修改」
  • 「我的请假」
  • 「我的工资」

这套系统包含源码、数据库脚本，拿来就能用，可以用来修改作为毕业设计等。

 

数据库脚本

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : rlzy

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2020-05-08 17:23:43
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(55) DEFAULT NULL,
  `userPw` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'a', 'aa');

-- ----------------------------
-- Table structure for `t_chuqin`
-- ----------------------------
DROP TABLE IF EXISTS `t_chuqin`;
CREATE TABLE `t_chuqin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yuefen` varchar(55) DEFAULT NULL,
  `tianshu` int(11) DEFAULT NULL,
  `yuangong_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_chuqin
-- ----------------------------
INSERT INTO `t_chuqin` VALUES ('7', '2020-04', '16', '20');
INSERT INTO `t_chuqin` VALUES ('8', '2020-04', '15', '19');
INSERT INTO `t_chuqin` VALUES ('11', '2020-05', '22', '22');
INSERT INTO `t_chuqin` VALUES ('12', '2020-05', '21', '23');
INSERT INTO `t_chuqin` VALUES ('13', '2020-05', '22', '23');
INSERT INTO `t_chuqin` VALUES ('14', '2020-06', '22', '23');

-- ----------------------------
-- Table structure for `t_gongzi`
-- ----------------------------
DROP TABLE IF EXISTS `t_gongzi`;
CREATE TABLE `t_gongzi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yuefen` varchar(55) DEFAULT NULL,
  `jine` int(11) DEFAULT NULL,
  `yuangong_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_gongzi
-- ----------------------------
INSERT INTO `t_gongzi` VALUES ('6', '2020-04', '2000', '20');
INSERT INTO `t_gongzi` VALUES ('7', '2020-04', '1900', '19');
INSERT INTO `t_gongzi` VALUES ('9', '2020-05', '2200', '22');
INSERT INTO `t_gongzi` VALUES ('10', '2020-05', '2100', '23');
INSERT INTO `t_gongzi` VALUES ('11', '2020-05', '2000', '20');

-- ----------------------------
-- Table structure for `t_organization`
-- ----------------------------
DROP TABLE IF EXISTS `t_organization`;
CREATE TABLE `t_organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `p_id` int(11) DEFAULT NULL,
  `del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_organization
-- ----------------------------
INSERT INTO `t_organization` VALUES ('1', '后勤部', '后勤部', '0', 'no');
INSERT INTO `t_organization` VALUES ('2', '生产部', '生产部', '0', 'no');
INSERT INTO `t_organization` VALUES ('3', '生产一部', '生产一部', '2', 'no');
INSERT INTO `t_organization` VALUES ('4', '生产二部', '生产二部', '2', 'no');
INSERT INTO `t_organization` VALUES ('5', '人事部', '人事部', '0', 'yes');
INSERT INTO `t_organization` VALUES ('6', '组织部', '组织部', '0', 'yes');
INSERT INTO `t_organization` VALUES ('7', '后勤一部', '后勤一部', '1', 'no');
INSERT INTO `t_organization` VALUES ('8', '后勤二部', '后勤二部', '1', 'no');
INSERT INTO `t_organization` VALUES ('10', '人事一部', '人事一部', '5', 'yes');
INSERT INTO `t_organization` VALUES ('11', '11', '11', '4', 'no');
INSERT INTO `t_organization` VALUES ('12', '生产三部', '生产三部', '2', 'yes');
INSERT INTO `t_organization` VALUES ('13', '22', '22', '4', 'no');
INSERT INTO `t_organization` VALUES ('14', '生产三部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('15', '33', '', '4', 'yes');
INSERT INTO `t_organization` VALUES ('16', '生产三部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('17', '33', '', '4', 'yes');
INSERT INTO `t_organization` VALUES ('18', '人事部', '', '0', 'no');
INSERT INTO `t_organization` VALUES ('19', '人事部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('20', '人事部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('21', '财务部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('22', '财务一部', '', '21', 'no');
INSERT INTO `t_organization` VALUES ('23', '人事一部', '', '18', 'yes');
INSERT INTO `t_organization` VALUES ('24', '财务部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('25', '财务一部', '', '24', 'yes');
INSERT INTO `t_organization` VALUES ('26', '财务部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('27', '财务一部', '', '26', 'yes');
INSERT INTO `t_organization` VALUES ('28', 'a', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('29', 'a', '', '26', 'yes');
INSERT INTO `t_organization` VALUES ('30', '23', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('31', '23', '', '26', 'no');
INSERT INTO `t_organization` VALUES ('32', '财务部', '', '0', 'no');
INSERT INTO `t_organization` VALUES ('33', '13', '', '32', 'yes');

-- ----------------------------
-- Table structure for `t_qingjiashenqing`
-- ----------------------------
DROP TABLE IF EXISTS `t_qingjiashenqing`;
CREATE TABLE `t_qingjiashenqing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kaishishijian` varchar(50) DEFAULT NULL,
  `jieshushijian` varchar(50) DEFAULT NULL,
  `beizhu` varchar(5000) DEFAULT NULL,
  `yuangong_id` int(11) DEFAULT NULL,
  `shenhezhuangtai` varchar(50) DEFAULT NULL,
  `huifuxinxi` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_qingjiashenqing
-- ----------------------------
INSERT INTO `t_qingjiashenqing` VALUES ('18', '2020-05-10', '2020-05-11', '看病', '22', 'c', '<p>不同意</p>');
INSERT INTO `t_qingjiashenqing` VALUES ('19', '2020-05-10', '2020-05-11', '生病', '23', 'b', '早去早回');
INSERT INTO `t_qingjiashenqing` VALUES ('22', '2020-06-14', '2020-06-15', '123', '28', 'a', '');
INSERT INTO `t_qingjiashenqing` VALUES ('23', null, null, null, null, null, ' vvcc ');

-- ----------------------------
-- Table structure for `t_yuangong`
-- ----------------------------
DROP TABLE IF EXISTS `t_yuangong`;
CREATE TABLE `t_yuangong` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL,
  `bianhao` varchar(55) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `sex` varchar(50) DEFAULT NULL,
  `age` varchar(50) DEFAULT NULL,
  `zhiwei` varchar(50) DEFAULT NULL,
  `shifoubumenlingdao` varchar(50) DEFAULT NULL,
  `loginname` varchar(50) DEFAULT NULL,
  `loginpw` varchar(50) DEFAULT NULL,
  `del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_yuangong
-- ----------------------------
INSERT INTO `t_yuangong` VALUES ('19', '5', '202001', '张三', '男', '33', '员工', 'fou', '202001', '000000', 'no');
INSERT INTO `t_yuangong` VALUES ('20', '3', '202002', '李四', '男', '25', '员工', 'fou', '202002', '000000', 'no');
INSERT INTO `t_yuangong` VALUES ('22', '24', '202004', '赵六', '男', '35', '经理', 'shi', '202004', '111111', 'no');
INSERT INTO `t_yuangong` VALUES ('23', '18', '202003', '王五', '男', '23', '员工', 'fou', '202003', '000000', 'no');
INSERT INTO `t_yuangong` VALUES ('25', '7', '234', '23', '男', '324', '23', 'shi', '32', '000000', 'yes');
INSERT INTO `t_yuangong` VALUES ('26', '8', '202006', '朱', '男', '34', '员工', 'fou', '202006', '000000', 'yes');
INSERT INTO `t_yuangong` VALUES ('27', '18', 'er', 'yt', '男', '32', 'rt', 'fou', '34', '000000', 'yes');
INSERT INTO `t_yuangong` VALUES ('28', '18', '202008', '王一', '男', '34', '员工', 'fou', '202008', '000000', 'no');

 

技术栈

本系统使用 DWR + JSP + FCKeditor-2.3 + commons-fileupload

数据库采用mysql5.7

运行环境

jdk8+IntelliJ IDEA

项目截图

下载方式

先点再看，再取源码哦，关注「一点教程」公众号，回复关键词 「xz202054」 就可以获得下载链接和提取码。如部署过程有问题，后台回复「加我」添加小助手微信。特别提醒:为了防止恶意获取，如果取消关注本公众号，即使再次关注，也将无法提供本服务！

下载地址
热门Java源码