springboot+mybatis+idea软件实现员工与部门的相关功能？

Question

1. 基础的部门模块的增删改查
2. 基础的员工的增删改
3. 查询员工： （1）根据主键查询 （2）分页查询所有，每页显示3条记录 （3）多条件查询，员工编号(精确查询):_______， 员工姓名（模糊查询）:_________ 员工薪资最小值：________, 员工薪资最大值：________ 员工所在部门编号：________, 员工所在部门名称:_________ （4）根据部门名称查询员工 （5）查询所有的员工个数 （6） 查询出各部门的员工平均信息 （7）根据员工编号，查询员工薪资（月薪salary+ 绩效comm） （8）删除员工薪资最低的那个人

dept.sql

/*
 Navicat Premium Data Transfer

 Source Server         : qianghj_mysql
 Source Server Type    : MySQL
 Source Server Version : 50528
 Source Host           : localhost:3306
 Source Schema         : empdb

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

 Date: 16/07/2020 12:03:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept`  (
  `deptno` int(11) NOT NULL,
  `dname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `loc` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`deptno`) USING BTREE,
  UNIQUE INDEX `dname`(`dname`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO `dept` VALUES (20, 'RESEARCH', 'shanghai');
INSERT INTO `dept` VALUES (30, 'SALES', 'beijing');
INSERT INTO `dept` VALUES (38, '开发部', '杭州');
INSERT INTO `dept` VALUES (40, 'OPERATIONS', 'suzhou');
INSERT INTO `dept` VALUES (52, '运维部', '上海');
INSERT INTO `dept` VALUES (53, '产品部', '上海');
INSERT INTO `dept` VALUES (57, '技术部门', '北京');
INSERT INTO `dept` VALUES (58, '测试部门', '北京');

SET FOREIGN_KEY_CHECKS = 1;

emp.sql

/*
 Navicat Premium Data Transfer

 Source Server         : qianghj_mysql
 Source Server Type    : MySQL
 Source Server Version : 50528
 Source Host           : localhost:3306
 Source Schema         : empdb

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

 Date: 16/07/2020 12:03:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp`  (
  `empno` int(11) NOT NULL,
  `ename` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `job` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mgr` int(11) NULL DEFAULT NULL,
  `hiredate` date NULL DEFAULT NULL,
  `salary` float NULL DEFAULT NULL,
  `comm` float NULL DEFAULT NULL,
  `deptno` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`empno`) USING BTREE,
  INDEX `fk_emp_dept`(`deptno`) USING BTREE,
  CONSTRAINT `fk_emp_dept` FOREIGN KEY (`deptno`) REFERENCES `dept` (`deptno`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES (7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800, NULL, 20);
INSERT INTO `emp` VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600, 300, 30);
INSERT INTO `emp` VALUES (7521, 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250, 500, 30);
INSERT INTO `emp` VALUES (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975, NULL, 20);
INSERT INTO `emp` VALUES (7654, 'MARTIN', 'SALESMAN', 7698, '1981-05-01', 1250, 1400, 30);
INSERT INTO `emp` VALUES (7698, 'BLAKE', 'MANAGER', 7839, '1981-06-09', 2850, NULL, 30);
INSERT INTO `emp` VALUES (7782, 'CLARK', 'MANAGER', 7839, '1987-07-01', 2450, NULL, 10);
INSERT INTO `emp` VALUES (7788, 'walter', 'MANAGER', 7566, '2020-06-18', 5000, 900, 20);
INSERT INTO `emp` VALUES (7789, 'walter', 'CLERK', 7902, '2020-06-28', 2000, 100, 10);
INSERT INTO `emp` VALUES (7839, 'KING', 'PRESIDENT', NULL, '1987-12-03', 5000, NULL, 10);
INSERT INTO `emp` VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-03-12', 1500, 0, 30);
INSERT INTO `emp` VALUES (7876, 'ADAMS', 'CLERK', 7788, '1981-02-13', 1100, NULL, 20);
INSERT INTO `emp` VALUES (7900, 'JAMES', 'CLERK', 7698, '1981-12-03', 950, NULL, 30);
INSERT INTO `emp` VALUES (7902, 'FORD', 'ANALYST', 7566, '1981-09-08', 3000, NULL, 20);
INSERT INTO `emp` VALUES (7934, 'MILLER', 'CLERK', 7782, '1981-06-02', 1300, NULL, 10);

SET FOREIGN_KEY_CHECKS = 1;

Answer 1

是来求可直接交付的且编译通过的源代码吗？谁会有时间无偿帮你帮你这实现出来呢....完全没有任何基础，给你提供思路，也没用。