Spring Boot使用EasyExcel导入导出Excel

package com.xmaven.entity; import java.io.Serializable; import java.util.Date; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import lombok.Data; /** * sys_user * @author */ @Data public class SysUser implements Serializable { /** * 编号 */ //主键我们一般不太现需要导出，我就就直接忽略 @ExcelIgnore private Long id; /** * 用户名 */ @ExcelProperty("用户名") private String name; /** * 昵称 */ @ExcelProperty("昵称") private String nickName; /** * 头像 */ @ExcelProperty("头像") private String avatar; /** * 密码 */ @ExcelProperty("密码") private String password; /** * 加密盐 */ @ExcelProperty("盐") private String salt; /** * 邮箱 */ @ExcelProperty("邮箱") private String email; /** * 手机号 */ @ExcelProperty("手机号") private String mobile; /** * 状态 0：禁用 1：正常 */ @ExcelProperty("状态") private Byte status; /** * 机构ID */ @ExcelProperty("机构id") private Long deptId; /** * 创建人 */ @ExcelProperty("创建人") private String createBy; /** * 创建时间 */ @ExcelProperty("创建时间") private Date createTime; /** * 更新人 */ @ExcelProperty("更新人") private String lastUpdateBy; /** * 更新时间 */ @ExcelProperty("更新时间") private Date lastUpdateTime; /** * 是否删除 -1：已删除 0：正常 */ @ExcelIgnore private Byte delFlag; private static final long serialVersionUID = 1L; @Override public boolean equals(Object that) { if (this == that) { return true; } if (that == null) { return false; } if (getClass() != that.getClass()) { return false; } SysUser other = (SysUser) that; return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId())) && (this.getName() == null ? other.getName() == null : this.getName().equals(other.getName())) && (this.getNickName() == null ? other.getNickName() == null : this.getNickName().equals(other.getNickName())) && (this.getAvatar() == null ? other.getAvatar() == null : this.getAvatar().equals(other.getAvatar())) && (this.getPassword() == null ? other.getPassword() == null : this.getPassword().equals(other.getPassword())) && (this.getSalt() == null ? other.getSalt() == null : this.getSalt().equals(other.getSalt())) && (this.getEmail() == null ? other.getEmail() == null : this.getEmail().equals(other.getEmail())) && (this.getMobile() == null ? other.getMobile() == null : this.getMobile().equals(other.getMobile())) && (this.getStatus() == null ? other.getStatus() == null : this.getStatus().equals(other.getStatus())) && (this.getDeptId() == null ? other.getDeptId() == null : this.getDeptId().equals(other.getDeptId())) && (this.getCreateBy() == null ? other.getCreateBy() == null : this.getCreateBy().equals(other.getCreateBy())) && (this.getCreateTime() == null ? other.getCreateTime() == null : this.getCreateTime().equals(other.getCreateTime())) && (this.getLastUpdateBy() == null ? other.getLastUpdateBy() == null : this.getLastUpdateBy().equals(other.getLastUpdateBy())) && (this.getLastUpdateTime() == null ? other.getLastUpdateTime() == null : this.getLastUpdateTime().equals(other.getLastUpdateTime())) && (this.getDelFlag() == null ? other.getDelFlag() == null : this.getDelFlag().equals(other.getDelFlag())); } @Override public int hashCode() { final int prime = 31; int result = 1; result = prime * result + ((getId() == null) ? 0 : getId().hashCode()); result = prime * result + ((getName() == null) ? 0 : getName().hashCode()); result = prime * result + ((getNickName() == null) ? 0 : getNickName().hashCode()); result = prime * result + ((getAvatar() == null) ? 0 : getAvatar().hashCode()); result = prime * result + ((getPassword() == null) ? 0 : getPassword().hashCode()); result = prime * result + ((getSalt() == null) ? 0 : getSalt().hashCode()); result = prime * result + ((getEmail() == null) ? 0 : getEmail().hashCode()); result = prime * result + ((getMobile() == null) ? 0 : getMobile().hashCode()); result = prime * result + ((getStatus() == null) ? 0 : getStatus().hashCode()); result = prime * result + ((getDeptId() == null) ? 0 : getDeptId().hashCode()); result = prime * result + ((getCreateBy() == null) ? 0 : getCreateBy().hashCode()); result = prime * result + ((getCreateTime() == null) ? 0 : getCreateTime().hashCode()); result = prime * result + ((getLastUpdateBy() == null) ? 0 : getLastUpdateBy().hashCode()); result = prime * result + ((getLastUpdateTime() == null) ? 0 : getLastUpdateTime().hashCode()); result = prime * result + ((getDelFlag() == null) ? 0 : getDelFlag().hashCode()); return result; } @Override public String toString() { StringBuilder sb = new StringBuilder(); sb.append(getClass().getSimpleName()); sb.append(" ["); sb.append("Hash = ").append(hashCode()); sb.append(", id=").append(id); sb.append(", name=").append(name); sb.append(", nickName=").append(nickName); sb.append(", avatar=").append(avatar); sb.append(", password=").append(password); sb.append(", salt=").append(salt); sb.append(", email=").append(email); sb.append(", mobile=").append(mobile); sb.append(", status=").append(status); sb.append(", deptId=").append(deptId); sb.append(", createBy=").append(createBy); sb.append(", createTime=").append(createTime); sb.append(", lastUpdateBy=").append(lastUpdateBy); sb.append(", lastUpdateTime=").append(lastUpdateTime); sb.append(", delFlag=").append(delFlag); sb.append(", serialVersionUID=").append(serialVersionUID); sb.append("]"); return sb.toString(); } }