1、实体类代码如下
import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.handler.inter.IExcelDataModel;
import cn.afterturn.easypoi.handler.inter.IExcelModel;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import lombok.Builder;
import lombok.Data;
import java.io.Serializable;
@Data
@Builder
public class DownloadEntity implements Serializable, IExcelModel, IExcelDataModel {
@Excel(name = "项目名称", orderNum = "0", width = 30, isImportField = "false")
private String projectName;
@Excel(name = "科室编码", orderNum = "2", width = 30, isImportField = "false")
private String deptCode;
@Excel(name = "科室名称", orderNum = "3", width = 30, isImportField = "false")
private String deptName;
@Excel(name = "金额", orderNum = "4", width = 30, isImportField = "false")
private double money;
private String errorMsg;
@Override
public int getRowNum() {
return 0;
}
@Override
public void setRowNum(int rowNum) {
}
@Override
public String getErrorMsg() {
return this.errorMsg;
}
@Override
public void setErrorMsg(String errorMsg) {
this.errorMsg = errorMsg;
}
}
2、获取实体类对象和注解内容的方法:
入参1: Object instance 对应类对象例如:DownloadEntity entity = new DownloadEntity ();
入参2: Map<String, String> fieldMap 对应需要过滤掉哪些不需要的属性。
注意事项:
clazz.getDeclaredFields()方法获取实体类的所有属性值。
Excel.class 对应的注解类。
/**
* 获取累中的所有属性名称及注解内容
* @param instance
* @param fieldMap
* @return
*/
public static Map<String, String> getDeclaredFieldsInfo2(Object instance, Map<String, String> fieldMap) throws NoSuchFieldException {
Map<String, String> map = new HashMap();
Class<?> clazz = instance.getClass();
Field[] fields = clazz.getDeclaredFields();
boolean b = false;
for (int i = 0; i < fields.length; i++) {
// 除过fieldMap中的属性,其他属性都获取
if (!fieldMap.containsValue(fields[i].getName())) {
// Field field=clazz.getDeclaredField(fields[i].getName());
boolean annotationPresent = fields[i].isAnnotationPresent(Excel.class);
if (annotationPresent) {
// 获取注解值
String name = fields[i].getAnnotation(Excel.class).name();
map.put(name, fields[i].getName());
}
}
}
return map;
}