Method excelCheckObj

src/main/java/util/ExcelUtils.java:73–123

excel 对象数据校验 @param excelList @param clazz @return

(List<?> excelList, Class<?> clazz)

     * @return
     */
    public static List<String> excelCheckObj(List<?> excelList, Class<?> clazz) {
        List<String> errList = new ArrayList<>();
        Map<String, ExcelCheck> excelCheckMap = new HashMap<String, ExcelCheck>();
        Map<String, ExcelProperty> excelPropertyMap = new HashMap<String, ExcelProperty>();
        for (Field field : TableInfoHelper.getAllFields(clazz)) {
            ExcelCheck excelCheck = field.getAnnotation(ExcelCheck.class);
            ExcelProperty excelProperty = field.getAnnotation(ExcelProperty.class);
            if (excelCheck != null) {
                excelCheckMap.put(field.getName(), excelCheck);
                excelPropertyMap.put(field.getName(), excelProperty);
            }
        }
        for (int i = 0; i < excelList.size(); i++) {
            Object obj = excelList.get(i);
            PropertyDescriptor origDescriptors[] = PropertyUtils.getPropertyDescriptors(obj);
            for (int j = 0; j < origDescriptors.length; j++) {
                String k = origDescriptors[j].getName();
                Object v = null;
                try {
                    v = PropertyUtils.getSimpleProperty(obj, k);
                } catch (Exception e) {
                    log.error(e.getMessage(), e);
                }
                ExcelCheck excelCheck = excelCheckMap.get(k);
                ExcelProperty excelProperty = excelPropertyMap.get(k);
                if (ObjectUtil.isNotEmpty(excelCheck) && ObjectUtil.isNotEmpty(excelProperty)) {
                    String fieldName = Arrays.toString(excelProperty.value());
                    fieldName = fieldName.substring(1, fieldName.length() - 1);

                    //不能为空
                    isNotNull(v, excelCheck, i, fieldName, errList);

                    //整数长度
                    integer(v, excelCheck, i, fieldName, errList);

                    //小数长度
                    decimal(v, excelCheck, i, fieldName, errList);

                    //时间格式
                    dateFormat(v, excelCheck, i, fieldName, errList);

                    //正则校验
                    matches(v, excelCheck, i, fieldName, errList);

                    //最大长度校验
                    maxLength(v, excelCheck, i, fieldName, errList);
                }
            }
        }
        return errList;
    }


    /**