springboot整合jxl导出

注：本案例是写在单元测试中

创建数据库sql

/*
Navicat MySQL Data Transfer

Source Server         : 我的连接
Source Server Version : 50717
Source Host           : 127.1.1.1:3306
Source Database       : mybatis

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

Date: 2020-07-29 15:05:21
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('1', 'AA');
INSERT INTO `department` VALUES ('2', 'BB');
INSERT INTO `department` VALUES ('3', 'CC');

测试类

import cn.baisee.sbdatamybatis.entity.Department;
import cn.baisee.sbdatamybatis.mapper.DepartmentMapper;
impor