IDEA+Spring Boot+Mybatis-Plus+Mysql+POI实现数据导入导出

数据库部分
主表：
从表：

导出：

导入：

pom.xml。

<!-- poi依赖 -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>

entity。

package com.ysd.demo1.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.ysd.demo1.util.ExcelDesc;

import java.io.Serializable;

/**
 * <p>
 * 
 * </p>
 *
 * @author jmf
 * @since 2020-03-31
 */
public class Student implements Serializable {
   

    private static final long serialVersionUID = 1L;

    /**
     * 学生ID
     */
    @TableId(value = "student_id", type = IdType.AUTO)
    private Integer studentId;

    /**
     * 卡号
     */
    @ExcelDesc("卡号")
    private Integer cardNo;

    /**
     * 姓名
     */
    @ExcelDesc("学生姓名")
    private String studentName;

    /**
     * 性别
     */
    @ExcelDesc("性别")
    private String studentSex;

    /**
     * 年龄
     */
    @ExcelDesc("年龄")
    private String studentAge;

    /**
     * 需要：专业，系名称
     */
    private Integer professionalId;

    /**
     * 备注
     */
    @ExcelDesc("备注")
    private String studentNote;

    /**
     * 逻辑删除
     */
    @TableLogic
    private Integer del;

    public Integer getStudentId() {
   
        return studentId;
    }

    public void setStudentId(Integer studentId) {
   
        this.studentId = studentId;
    }
    public Integer getCardNo() {
   
        return cardNo;
    }

    public void setCardNo(Integer cardNo) {
   
        this.cardNo = cardNo;
    }
    public String getStudentName() {
   
        return studentName;
    }

    public void setStudentName(String studentName) {
   
        this.studentName = studentName;
    }
    public String getStudentSex() {
   
        return studentSex;
    }

    public void setStudentSex(String studentSex) {
   
        this.studentSex = studentSex;
    }
    public String getStudentAge() {
   
        return studentAge;
    }

    public void setStudentAge(String studentAge) {
   
        this.studentAge = studentAge;
    }
    public Integer getProfessionalId() {
   
        return professionalId;
    }

    public void setProfessionalId(Integer professionalId) {
   
        this.professionalId = professionalId;
    }

    public String getStudentNote() {
   
        return studentNote;
    }

    public void setStudentNote