Java基础 员工管理 - 寒江孤影

Java基础 员工管理

作者: 36D小可爱

全网最全的网络资源分享网站

手机扫码查看

特别声明:文章多为网络转载,资源使用一般不提供任何帮助,特殊资源除外,如有侵权请联系!

教程演示环境

eclipse 2020-12中文汉化版Navicat Premium 15jdk1.8.0_191MySQL5.7

QQ截图20210425092414.jpg

业务需求

QQ截图20210425092415.jpg

数据库

salarymanagement(数据库)

department(部门表)

QQ截图20210425103153.png

employees(员工表)

QQ截图20210425103414.png

position(职位表)

QQ截图20210425103444.png

wage(工资表)

QQ截图20210425103502.png

创建表SQL语句如下

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL5.7
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost:3306
 Source Schema         : salarymanagement

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 25/04/2021 11:49:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `dep_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门编号',
  `dep_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
  PRIMARY KEY (`dep_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (1, '财务部');
INSERT INTO `department` VALUES (2, '开发部');
INSERT INTO `department` VALUES (3, '市场部');
INSERT INTO `department` VALUES (4, '后勤部');
INSERT INTO `department` VALUES (5, '生产部');

-- ----------------------------
-- Table structure for employees
-- ----------------------------
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees`  (
  `emp_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '员工编号',
  `dep_id` int(20) NULL DEFAULT NULL COMMENT '部门编号',
  `pos_id` int(20) NULL DEFAULT NULL COMMENT '职位编号',
  `emp_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工姓名',
  `card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`emp_id`) USING BTREE,
  INDEX `fk_dep_id`(`dep_id`) USING BTREE,
  INDEX `fk_pos_id`(`pos_id`) USING BTREE,
  CONSTRAINT `fk_dep_id` FOREIGN KEY (`dep_id`) REFERENCES `department` (`dep_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_pos_id` FOREIGN KEY (`pos_id`) REFERENCES `position` (`pos_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employees
-- ----------------------------
INSERT INTO `employees` VALUES (1, 1, 1, '张三', '410702199102210213', '男', '15125741526', 'my91@263.com', '123456');
INSERT INTO `employees` VALUES (2, 4, 5, '李四', '410303199006210215', '男', '15890172541', 'tcd@163.com', '123456');
INSERT INTO `employees` VALUES (3, 4, 1, '王五', '412701199002110618', '男', '18637165241', 'huangrong@263.com', '123456');
INSERT INTO `employees` VALUES (4, 2, 6, '麻子', '410102199010140317', '女', '15569852141', 'LCX90@hotmail.com', '123456');
INSERT INTO `employees` VALUES (5, 5, 5, '管理员', '410103199106210613', '女', '15142153256', 'qcj@163.com', '111111');

-- ----------------------------
-- Table structure for position
-- ----------------------------
DROP TABLE IF EXISTS `position`;
CREATE TABLE `position`  (
  `pos_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '职位编号',
  `pos_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位名称',
  PRIMARY KEY (`pos_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of position
-- ----------------------------
INSERT INTO `position` VALUES (1, '主管');
INSERT INTO `position` VALUES (2, '经理');
INSERT INTO `position` VALUES (3, '总监');
INSERT INTO `position` VALUES (4, '总经理');
INSERT INTO `position` VALUES (5, '总裁');
INSERT INTO `position` VALUES (6, '员工');
INSERT INTO `position` VALUES (7, '管理员');

-- ----------------------------
-- Table structure for wage
-- ----------------------------
DROP TABLE IF EXISTS `wage`;
CREATE TABLE `wage`  (
  `wag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '工资编号',
  `emp_id` int(11) NULL DEFAULT NULL COMMENT '员工编号',
  `money` decimal(20, 2) NULL DEFAULT NULL COMMENT '金额',
  PRIMARY KEY (`wag_id`) USING BTREE,
  INDEX `fk_emp_id`(`emp_id`) USING BTREE,
  CONSTRAINT `fk_emp_id` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`emp_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wage
-- ----------------------------
INSERT INTO `wage` VALUES (1, 1, 4500.00);
INSERT INTO `wage` VALUES (2, 2, 4300.00);
INSERT INTO `wage` VALUES (3, 3, 5000.00);
INSERT INTO `wage` VALUES (4, 4, 4000.00);
INSERT INTO `wage` VALUES (5, 5, 4200.00);

SET FOREIGN_KEY_CHECKS = 1;

业务演示

员工登录

QQ截图20210425104110.png

添加员工

QQ截图20210425105857.png

删除员工

QQ截图20210425110139.png

修改员工

QQ截图20210425110633.png

查询员工

QQ截图20210425110901.png

查询部门员工

QQ截图20210425111055.png

用户详细信息

QQ截图20210425111212.png

查询职位员工

QQ截图20210425111641.png

工资范围员工

QQ截图20210425111904.png

模糊查询员工

QQ截图20210425112119.png

  • 文件下载

    附件:Java员工管理系统

    文件大小:1.2MB

    更新时间:2021/04/25

    本站大部分下载资源收集于网络,只做学习和交流使用,版权归原作者所有,若为付费资源,请在下载后24小时之内自觉删除,若作商业用途,请到原网站购买,由于未及时购买和付费发生的侵权行为,与本站无关。本站发布的内容若侵犯到您的权益,请联系本站删除,我们将及时处理!

    分享到:
    打赏
    -版权声明-

    作者: 36D小可爱, 转载或复制请以 超链接形式 并注明出处 寒江孤影
    原文地址: 《Java基础 员工管理》 发布于2021-4-25

    阅读时间:   发布于:2021-4-25
    文章标题:《Java基础 员工管理》
    本文链接:https://a14.cn:443/post-24.html
    本文编辑: 36D小可爱,转载请注明超链接和出处寒江孤影
    收录状态:[百度已收录][360已收录][搜狗已收录]

    评论一下

    切换注册

    登录

    忘记密码?

    您也可以使用第三方帐号快捷登录

    切换登录

    注册

    Java基础 员工管理

    长按图片转发给朋友

    觉得文章有用就打赏一下文章作者

    花呗扫一扫打赏

    微信扫一扫打赏

    企鹅扫一扫打赏