易用宝项目记录day8-Excel的导入导出_workbook failworkbook = result.getfailworkbook(); -CSDN博客

本文链接：https://blog.csdn.net/qq_41917101/article/details/95964404

本文档记录了易用宝项目中如何集成EasyPOI与SpringMVC进行Excel的导入导出操作。首先介绍了EasyPOI的文档链接和导入所需库，接着讲解了在MVC中配置视图解析器、处理前端查询数据和后台导出功能。在导入功能部分，详细阐述了访问页面、导入实现以及导入验证的步骤，包括使用JSR 303规范进行数据验证。

摘要由CSDN通过智能技术生成

易用宝项目记录day8-Excel的导入导出

1.EasyPOI集成SpringMVC完成导入导出

文档:http://easypoi.mydoc.io/

导包

注意:今天使用EasyPOI需要把之前的poi导包去掉

<!-- easypoi的支持 -->
<dependency>
  <groupId>cn.afterturn</groupId>
  <artifactId>easypoi-base</artifactId>
  <version>3.2.0</version>
</dependency>
<dependency>
  <groupId>cn.afterturn</groupId>
  <artifactId>easypoi-web</artifactId>
  <version>3.2.0</version>
</dependency>
<dependency>
  <groupId>cn.afterturn</groupId>
  <artifactId>easypoi-annotation</artifactId>
  <version>3.2.0</version>
</dependency>

修改domian

employee

@Entity//表示一个由jpa管理的持久对象,对应数据库的一个表
@Table(name = "employee")//table数据库的表名
public class Employee extends BaseDomain {
     
    @Excel(name = "用户名")
    @NotNull(message = "用户名不能为空!")
    private String username;

    private String password;

    @Excel(name = "邮箱", width = 25)
    private String email;

    @Excel(name = "头像", type = 2, width = 10, height = 20)
    private String headImage;

    @Excel(name = "年龄")
    @Max(value = 100, message = "年龄不能超过100岁!")
    @Min(value = 0, message = "年龄不能小于0岁!")
    @Column(length = 11)
    private Integer age;
    @Column(length = 1)
    private Integer isdelete;

    @ManyToMany
    @JoinTable(
            name = "employee_role",
            joinColumns = @JoinColumn(name = "employee_id"),
            inverseJoinColumns = @JoinColumn(name = "role_id")
    )
    private List<Role> roles = new ArrayList<>();

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "department_id")
    private Department department;

department

@Entity//表示一个由jpa管理的持久对象,对应数据库的一个表
@Table(name = "department")/