SpringBoot+VUE+ MyBatis实现人事管理系统（已开源，学习css前端开发

})

4、App.vue

登录系统人事管理系统

四、SpringBoot+Mybatis后端代码实现

=============================================================================================

1、后端项目结构图

2、sql语句实现

/*

Navicat Premium Data Transfer

Source Server : windows

Source Server Type : MySQL

Source Server Version : 80022

Source Host : localhost:3306

Source Schema : ems

Target Server Type : MySQL

Target Server Version : 80022

File Encoding : 65001

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for t_emp

---

DROP TABLE IF EXISTS t_emp;

CREATE TABLE t_emp (

id int NOT NULL AUTO_INCREMENT,

name varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

salary double NOT NULL,

age int NOT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of t_emp

---

INSERT INTO t_emp VALUES (2, ‘杨福君’, 9000, 19);

INSERT INTO t_emp VALUES (8, ‘王恒杰’, 12000, 21);

INSERT INTO t_emp VALUES (12, ‘邓正武’, 20