# 员工管理系统（workbench）

**Repository Path**: zxczy0814/workbench

## Basic Information

- **Project Name**: 员工管理系统（workbench）
- **Description**: JavaEE大作业项目workbench
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 1
- **Created**: 2022-05-10
- **Last Updated**: 2023-05-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# workbench

#### 介绍
JavaEE大作业项目员工管理系统（workbench）

#### 软件架构
Bootstrap
MySQL 8
spring5
springMVC
MyBatis

#### 使用说明

1.导入数据库
```sql
/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 8.0.26 : Database - workbench
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`workbench` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `workbench`;

/*Table structure for table `wb_addressbook` */

DROP TABLE IF EXISTS `wb_addressbook`;

CREATE TABLE `wb_addressbook` (
  `ad_id` INT NOT NULL AUTO_INCREMENT,
  `emp_id` INT NOT NULL COMMENT '该员工id',
  `friend_id` INT NOT NULL COMMENT '该员工的好友id',
  PRIMARY KEY (`ad_id`),
  KEY `emp_id` (`emp_id`),
  KEY `friend_id` (`friend_id`),
  CONSTRAINT `wb_addressbook_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `wb_emp` (`emp_id`),
  CONSTRAINT `wb_addressbook_ibfk_2` FOREIGN KEY (`friend_id`) REFERENCES `wb_emp` (`emp_id`)
) ENGINE=INNODB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `wb_addressbook` */

INSERT  INTO `wb_addressbook`(`ad_id`,`emp_id`,`friend_id`) VALUES 
(1,1,2),
(2,1,3),
(3,1,4),
(4,2,1),
(5,2,3),
(6,2,4),
(7,3,1),
(8,3,2),
(9,3,4),
(10,4,1),
(11,4,2),
(12,4,3),
(68,1,106),
(71,1,108);

/*Table structure for table `wb_dept` */

DROP TABLE IF EXISTS `wb_dept`;

CREATE TABLE `wb_dept` (
  `dept_id` INT NOT NULL AUTO_INCREMENT,
  `dept_name` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=INNODB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `wb_dept` */

INSERT  INTO `wb_dept`(`dept_id`,`dept_name`) VALUES 
(1,'流动部'),
(2,'测试部'),
(3,'财务部'),
(4,'制造科'),
(5,'技术部');

/*Table structure for table `wb_emp` */

DROP TABLE IF EXISTS `wb_emp`;

CREATE TABLE `wb_emp` (
  `emp_id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20) NOT NULL COMMENT '真实姓名',
  `username` VARCHAR(50) NOT NULL COMMENT '登录用的用户名',
  `password` VARCHAR(20) NOT NULL DEFAULT '12345678' COMMENT '登录密码',
  `age` INT DEFAULT NULL COMMENT '年龄',
  `salary` DOUBLE NOT NULL COMMENT '工资',
  `identity` INT NOT NULL DEFAULT '0' COMMENT '身份：1为管理员，0为普通员工',
  `dept_id` INT NOT NULL COMMENT '所属部门Id',
  `status` INT NOT NULL DEFAULT '1' COMMENT '状态：1为在职，0为假期，-1为离职',
  PRIMARY KEY (`emp_id`),
  UNIQUE KEY `username` (`username`),
  KEY `dept_id` (`dept_id`),
  CONSTRAINT `wb_emp_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `wb_dept` (`dept_id`)
) ENGINE=INNODB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `wb_emp` */

INSERT  INTO `wb_emp`(`emp_id`,`name`,`username`,`password`,`age`,`salary`,`identity`,`dept_id`,`status`) VALUES 
(4,'test','test','12345678',22,8000,1,4,1),
(106,'123','88311','12345678',22,8888.88,1,4,1),
(107,'de2c62','de2c62','12345678',22,7654.5,0,4,1),
(108,'a721a3','a721a3','12345678',22,7654.5,0,5,1),
(109,'b2d8d4','b2d8d4','12345678',22,7654.5,0,1,1),
(110,'fedac5','fedac5','12345678',22,7654.5,0,1,1),
(111,'b67d86','b67d86','12345678',22,7654.5,0,1,1),
(112,'76a957','76a957','12345678',22,7654.5,0,1,1),
(114,'c62a19','c62a19','12345678',22,7654.5,0,1,1),
(116,'bab0c11','bab0c11','12345678',22,7654.5,0,1,1),
(117,'9a1c412','9a1c412','12345678',22,7654.5,0,1,1),
(118,'bd19113','bd19113','12345678',22,7654.5,0,1,1),
(119,'a40fc14','a40fc14','12345678',22,7654.5,0,1,1),
(120,'4375115','4375115','12345678',22,7654.5,0,1,1),
(121,'c387d16','c387d16','12345678',22,7654.5,0,1,1),
(122,'5ff8117','5ff8117','12345678',22,7654.5,0,1,1),
(123,'3f24a18','3f24a18','12345678',22,7654.5,0,1,1),
(124,'5b6ab19','5b6ab19','12345678',22,7654.5,0,1,1),
(125,'d9e2d20','d9e2d20','12345678',22,7654.5,0,1,1),
(126,'ad48121','ad48121','12345678',22,7654.5,0,1,1),
(127,'8bb5522','8bb5522','12345678',22,7654.5,0,1,1),
(128,'85a0223','85a0223','12345678',22,7654.5,0,1,1),
(129,'0ef9a24','0ef9a24','12345678',22,7654.5,0,1,1),
(130,'9027d25','9027d25','12345678',22,7654.5,0,1,1),
(131,'ab05e26','ab05e26','12345678',22,7654.5,0,1,1),
(132,'ffada27','ffada27','12345678',22,7654.5,0,1,1),
(133,'185a528','185a528','12345678',22,7654.5,0,1,1),
(134,'fc22129','fc22129','12345678',22,7654.5,0,1,1),
(135,'cf34330','cf34330','12345678',22,7654.5,0,1,1),
(136,'fc55431','fc55431','12345678',22,7654.5,0,1,1),
(137,'a5e7d32','a5e7d32','12345678',22,7654.5,0,1,1),
(138,'462be33','462be33','12345678',22,7654.5,0,1,1),
(139,'c57b034','c57b034','12345678',22,7654.5,0,1,1),
(140,'f7bbc35','f7bbc35','12345678',22,7654.5,0,1,1),
(141,'162eb36','162eb36','12345678',22,7654.5,0,1,1),
(142,'0bb6f37','0bb6f37','12345678',22,7654.5,0,1,1),
(143,'3202c38','3202c38','12345678',22,7654.5,0,1,1),
(144,'8099b39','8099b39','12345678',22,7654.5,0,1,1),
(145,'43cf940','43cf940','12345678',22,7654.5,0,1,1),
(146,'85e9841','85e9841','12345678',22,7654.5,0,1,1),
(147,'50e5242','50e5242','12345678',22,7654.5,0,1,1),
(148,'e98b543','e98b543','12345678',22,7654.5,0,1,1),
(149,'180b244','180b244','12345678',22,7654.5,0,1,1),
(150,'8c9e345','8c9e345','12345678',22,7654.5,0,1,1),
(151,'c114446','c114446','12345678',22,7654.5,0,1,1),
(152,'45caa47','45caa47','12345678',22,7654.5,0,1,1),
(153,'6e04448','6e04448','12345678',22,7654.5,0,1,1),
(154,'430f649','430f649','12345678',22,7654.5,0,1,1),
(155,'2944d50','2944d50','12345678',22,7654.5,0,1,1),
(156,'f459f51','f459f51','12345678',22,7654.5,0,1,1),
(157,'3a22c52','3a22c52','12345678',22,7654.5,0,1,1),
(158,'e9fa453','e9fa453','12345678',22,7654.5,0,1,1),
(159,'3b8d154','3b8d154','12345678',22,7654.5,0,1,1),
(160,'031c555','031c555','12345678',22,7654.5,0,1,1),
(161,'ce8f456','ce8f456','12345678',22,7654.5,0,1,1),
(162,'0b7ec57','0b7ec57','12345678',22,7654.5,0,1,1),
(163,'5f4d258','5f4d258','12345678',22,7654.5,0,1,1),
(164,'7f96659','7f96659','12345678',22,7654.5,0,1,1),
(165,'edfc260','edfc260','12345678',22,7654.5,0,1,1),
(166,'ca9dc61','ca9dc61','12345678',22,7654.5,0,1,1),
(167,'80d1262','80d1262','12345678',22,7654.5,0,1,1),
(168,'c8eda63','c8eda63','12345678',22,7654.5,0,1,1),
(169,'1da8264','1da8264','12345678',22,7654.5,0,1,1),
(170,'a6cde65','a6cde65','12345678',22,7654.5,0,1,1),
(171,'47c5d66','47c5d66','12345678',22,7654.5,0,1,1),
(172,'df11b67','df11b67','12345678',22,7654.5,0,1,1),
(173,'3a0b568','3a0b568','12345678',22,7654.5,0,1,1),
(174,'6fca869','6fca869','12345678',22,7654.5,0,1,1),
(175,'402e570','402e570','12345678',22,7654.5,0,1,1),
(176,'0823371','0823371','12345678',22,7654.5,0,1,1),
(177,'e3f4a72','e3f4a72','12345678',22,7654.5,0,1,1),
(187,'9d07782','9d07782','12345678',22,7654.5,0,1,1),
(188,'e175883','e175883','12345678',22,7654.5,0,1,1),
(189,'76d3c84','76d3c84','12345678',22,7654.5,0,1,1),
(190,'2566a85','2566a85','12345678',22,7654.5,0,1,1),
(191,'1909986','1909986','12345678',22,7654.5,0,1,1),
(192,'c1a7287','c1a7287','12345678',22,7654.5,0,1,1),
(193,'7d7df88','7d7df88','12345678',22,7654.5,0,1,1),
(194,'024da89','024da89','12345678',22,7654.5,0,1,-1);

/*Table structure for table `wb_memo` */

DROP TABLE IF EXISTS `wb_memo`;

CREATE TABLE `wb_memo` (
  `memo_id` INT NOT NULL AUTO_INCREMENT,
  `emp_id` INT NOT NULL COMMENT '创建该备忘录的员工Id',
  `contend` VARCHAR(100) NOT NULL COMMENT '备忘录内容',
  `status` INT NOT NULL DEFAULT '0' COMMENT '该条备忘录状态：0未完成，1已完成',
  PRIMARY KEY (`memo_id`),
  KEY `emp_id` (`emp_id`),
  CONSTRAINT `wb_memo_ibfk_1` FOREIGN KEY (`emp_id`) REFERENCES `wb_emp` (`emp_id`)
) ENGINE=INNODB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `wb_memo` */

insert  into `wb_memo`(`memo_id`,`emp_id`,`contend`,`status`) values 
(7,1,'dsfdvc',1),
(12,1,'dsfdvc',1),
(13,1,'12314',1),
(17,1,'test4',0);

/*Table structure for table `wb_message` */

DROP TABLE IF EXISTS `wb_message`;

CREATE TABLE `wb_message` (
  `msg_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `content` varchar(200) NOT NULL,
  `create_date` datetime NOT NULL,
  `creator` int NOT NULL,
  `recipients` int NOT NULL,
  `status` int DEFAULT '0',
  PRIMARY KEY (`msg_id`,`content`),
  KEY `creator` (`creator`),
  KEY `recipients` (`recipients`),
  CONSTRAINT `wb_message_ibfk_1` FOREIGN KEY (`creator`) REFERENCES `wb_emp` (`emp_id`),
  CONSTRAINT `wb_message_ibfk_2` FOREIGN KEY (`recipients`) REFERENCES `wb_emp` (`emp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `wb_message` */

insert  into `wb_message`(`msg_id`,`title`,`content`,`create_date`,`creator`,`recipients`,`status`) values 
(1,'test','测试message功能','2022-05-26 12:18:10',1,2,0),
(2,'test1','测试message功能','2022-05-26 12:18:28',2,1,1),
(3,'test2','测试message功能','2022-05-26 12:18:45',2,1,1),
(5,'test3','测试message功能','2022-05-26 12:19:01',3,1,1),
(6,'test4','测试新建消息','2022-05-26 12:19:44',1,2,0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

```
2.在idea中运行程序

#### 注意事项
1.只有身份为管理员才能登录系统
2.没有设计员工登录页面
3.数据库中数据均为测试数据
4.该系统包含功能有：
    1)个人信息展示
    2)备忘录
    3)员工管理
    4)部门管理
    5)消息
    6)通讯录

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目，是综合评定出的优秀开源项目
5.  Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)