hutool 导入excel到数据库
导入hutool依赖
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.5.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
实体类
package com.example.hutool_excel_in.entity;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
@Data
@TableName(value ="testexcel")
public class Person {
@TableId
private String enterpriseName;
private Integer code;
private String name;
private Integer idCode;
private String type;
}
Mapper层
package com.example.hutool_excel_in.mapper;
import com.baomidou.mybatisplus.core.mapper.