Springboot 最简单的结合MYSQL数据实现EXCEL表格导出及数据导入

package com.example.tdemo.pojo;

import cn.afterturn.easypoi.excel.annotation.Excel;

public class User {

@Excel(name = “学号”, orderNum = “0”)

private Integer id;

@Excel(name = “姓名”, orderNum = “1”)

private String userName;

@Excel(name = “年龄”, orderNum = “2”)

private String userAge;

@Override

public String toString() {

return “User{” +

“id=” + id +

“, userName='” + userName + ‘’’ +

“, userAge='” + userAge + ‘’’ +

‘}’;

}

public User() {

}

public User(Integer id, String userName, String userAge) {

this.id = id;

this.userName = userName;

this.userAge = userAge;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getUserName() {

return userName;

}

public void setUserName(String userName) {

this.userName = userName;

}

public String getUserAge() {

return userAge;

}

public void setUserAge(String userAge) {

this.userAge = userAge;

}

}

然后是 excel导入导出的工具类,ExcelUtil：

package com.example.tdemo.util;

import cn.afterturn.easypoi.excel.ExcelExportUtil;

import cn.afterturn.easypoi.excel.ExcelImportUtil;

import cn.afterturn.easypoi.excel.entity.ExportParams;

import cn.afterturn.easypoi.excel.entity.ImportParams;

import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;

import org.apache.commons.lang3.StringUti