devbox
Cpp五条
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Excel工具类_@excelimport

作者：Cpp五条 | 2024-03-27 03:04:08

赞

踩

@excelimport

目录

1导入导出

2测试

2.1导入测试

2.1.1JSON导入

2.1.2对象导入

 2.2导出测试

2.2.1导出模版

2.2.2导出用户表

3依赖

4工具包

​​​​​​​

1导入导出

UserImport

  1. package com.excel.entity;
  2.  
  3. import com.excel.utils.ExcelImport;
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class UserImport {
  8. //    获取此行的错误提示
  9.     private String rowTips;
  10.  
  11. //    获取此时数据第几行
  12.     private int rowNum;
  13.  
  14. //    required非空    unique不能重复
  15.     @ExcelImport(value = "姓名",required = true,unique = true)
  16.     private String name;
  17.  
  18.     @ExcelImport("年龄")
  19.     private Integer age;
  20.  
  21.     @ExcelImport(value = "性别",kv="1-男;2-女")
  22.     private Integer sex;
  23.  
  24.     @ExcelImport(value = "电话",maxLength = 11)
  25.     private String tel;
  26.  
  27.     @ExcelImport("城市")
  28.     private String city;
  29.  
  30.     @ExcelImport("头像")
  31.     private String avatar;
  32.  
  33. }

UserExport

  1. package com.excel.entity;
  2.  
  3. import com.excel.utils.ExcelExport;
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class UserExport {
  8.  
  9. //    注释的是导出模版文件
  10.     @ExcelExport(value = "姓名",example = "张三")
  11.     private String name;
  12.  
  13.     @ExcelExport(value = "年龄",example = "81")
  14.     private Integer age;
  15.  
  16.     @ExcelExport(value="城市",example = "苏州")
  17.     private String city;
  18.     @ExcelExport(value = "头像",example = "http:dwawaa")
  19.     private  String avatar;
  20.  
  21.     @ExcelExport(value="电话",example = "1111123232")
  22.     private String tel;
  23.  
  24. //    导出用户表
  25. //    @ExcelExport(value = "姓名")
  26. //    private String name;
  27. //
  28. //    @ExcelExport(value = "年龄")
  29. //    private Integer age;
  30. //
  31. //    @ExcelExport(value="城市")
  32. //    private String city;
  33. //    @ExcelExport(value = "头像")
  34. //    private  String avatar;
  35. //
  36. //    @ExcelExport(value="电话")
  37. //    private String tel;
  38. }

excelController

  1. package com.excel.controller;
  2.  
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.excel.entity.UserImport;
  5. import com.excel.entity.UserExport;
  6. import com.excel.utils.ExcelUtil;
  7. import org.springframework.web.bind.annotation.*;
  8. import org.springframework.web.multipart.MultipartFile;
  9.  
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.util.ArrayList;
  12. import java.util.List;
  13.  
  14.  
  15. @RestController
  16. @RequestMapping("/user")
  17. public class ExcelController {
  18. //解析为JSON格式  导入
  19.     @PostMapping("/import1")
  20.     public JSONArray importJSON(@RequestPart("file") MultipartFile file) throws Exception {
  21.         JSONArray array = ExcelUtil.readMultipartFile(file);
  22.         System.out.println(array);
  23.         return array;
  24.     }
  25.  
  26.  
  27. //    解析为对象格式 导入
  28.     @PostMapping("/import2")
  29.     public void importUser(@RequestPart("file") MultipartFile file) throws Exception {
  30.         List<UserImport> userImports = ExcelUtil.readMultipartFile(file, UserImport.class);
  31.         for(UserImport u: userImports){
  32.             System.out.println(u);
  33.         }
  34.     }
  35.  
  36. //    导出模版
  37.     @GetMapping("/export1")
  38.     public void export1(HttpServletResponse httpServletResponse){
  39.         ExcelUtil.exportTemplate(httpServletResponse,"用户表", UserExport.class,true);
  40.     }
  41.  
  42.  
  43. //    导出
  44.  
  45.     @GetMapping("/export2")
  46.     public void export2(HttpServletResponse httpServletResponse){
  47.         ArrayList<UserExport> userList = new ArrayList<>();
  48.         UserExport user1 = new UserExport();
  49.  
  50.         user1.setName("hh");
  51.         user1.setAge(2);
  52.         user1.setAvatar("33");
  53.         user1.setCity("3");
  54.         user1.setTel("34");
  55.  
  56.         userList.add(user1);
  57.  
  58.         ExcelUtil.export(httpServletResponse,"用户表",userList,UserExport.class);
  59.     }
  60.  
  61. }
  62.

2测试

2.1导入测试

2.1.1JSON导入

PostMan测试 

2.1.2对象导入

 2.2导出测试

2.2.1导出模版

直接在浏览器上输入即可

2.2.2导出用户表

 

3依赖

  1. <!--        excel-->
  2.         <!-- 文件上传 -->
  3.         <dependency>
  4.             <groupId>org.apache.httpcomponents</groupId>
  5.             <artifactId>httpmime</artifactId>
  6.             <artifactId>4.5.7</artifactId>
  7.         </dependency>
  8.         <!-- JSON -->
  9.         <dependency>
  10.             <groupId>com.alibaba</groupId>
  11.             <artifactId>fastjson</artifactId>
  12.             <version>1.2.41</version>
  13.         </dependency>
  14.         <!-- POI -->
  15.         <dependency>
  16.             <groupId>org.apache.poi</groupId>
  17.             <artifactId>poi-ooxml</artifactId>
  18.             <version>3.16</version>
  19.         </dependency>
  20.  
  21. <!--        end-->

4工具包

ExcelClassField

  1. package com.excel.utils;
  2.  
  3. import java.util.LinkedHashMap;
  4.  
  5. public class ExcelClassField {
  6.  
  7.     /** 字段名称 */
  8.     private String fieldName;
  9.  
  10.     /** 表头名称 */
  11.     private String name;
  12.  
  13.     /** 映射关系 */
  14.     private LinkedHashMap<String, String> kvMap;
  15.  
  16.     /** 示例值 */
  17.     private Object example;
  18.  
  19.     /** 排序 */
  20.     private int sort;
  21.  
  22.     /** 是否为注解字段：0-否，1-是 */
  23.     private int hasAnnotation;
  24.  
  25.     public String getFieldName() {
  26.         return fieldName;
  27.     }
  28.  
  29.     public void setFieldName(String fieldName) {
  30.         this.fieldName = fieldName;
  31.     }
  32.  
  33.     public String getName() {
  34.         return name;
  35.     }
  36.  
  37.     public void setName(String name) {
  38.         this.name = name;
  39.     }
  40.  
  41.     public LinkedHashMap<String, String> getKvMap() {
  42.         return kvMap;
  43.     }
  44.  
  45.     public void setKvMap(LinkedHashMap<String, String> kvMap) {
  46.         this.kvMap = kvMap;
  47.     }
  48.  
  49.     public Object getExample() {
  50.         return example;
  51.     }
  52.  
  53.     public void setExample(Object example) {
  54.         this.example = example;
  55.     }
  56.  
  57.     public int getSort() {
  58.         return sort;
  59.     }
  60.  
  61.     public void setSort(int sort) {
  62.         this.sort = sort;
  63.     }
  64.  
  65.     public int getHasAnnotation() {
  66.         return hasAnnotation;
  67.     }
  68.  
  69.     public void setHasAnnotation(int hasAnnotation) {
  70.         this.hasAnnotation = hasAnnotation;
  71.     }
  72.  
  73. }

 ExcelExport

  1. package com.excel.utils;
  2.  
  3. import java.lang.annotation.ElementType;
  4. import java.lang.annotation.Retention;
  5. import java.lang.annotation.RetentionPolicy;
  6. import java.lang.annotation.Target;
  7.  
  8.  
  9. @Target(ElementType.FIELD)
  10. @Retention(RetentionPolicy.RUNTIME)
  11. public @interface ExcelExport {
  12.  
  13.     /** 字段名称 */
  14.     String value();
  15.  
  16.     /** 导出排序先后: 数字越小越靠前（默认按Java类字段顺序导出） */
  17.     int sort() default 0;
  18.  
  19.     /** 导出映射，格式如：0-未知;1-男;2-女 */
  20.     String kv() default "";
  21.  
  22.     /** 导出模板示例值（有值的话，直接取该值，不做映射） */
  23.     String example() default "";
  24.  
  25. }

ExcelImport

  1. package com.excel.utils;
  2.  
  3. import java.lang.annotation.ElementType;
  4. import java.lang.annotation.Retention;
  5. import java.lang.annotation.RetentionPolicy;
  6. import java.lang.annotation.Target;
  7.  
  8.  
  9. @Target(ElementType.FIELD)
  10. @Retention(RetentionPolicy.RUNTIME)
  11. public @interface ExcelImport {
  12.  
  13.     /** 字段名称 */
  14.     String value();
  15.  
  16.     /** 导出映射，格式如：0-未知;1-男;2-女 */
  17.     String kv() default "";
  18.  
  19.     /** 是否为必填字段（默认为非必填） */
  20.     boolean required() default false;
  21.  
  22.     /** 最大长度（默认255） */
  23.     int maxLength() default 255;
  24.  
  25.     /** 导入唯一性验证（多个字段则取联合验证） */
  26.     boolean unique() default false;
  27.  
  28. }

ExcelUtil

  1. package com.excel.utils;
  2.  
  3. import java.io.ByteArrayOutputStream;
  4. import java.io.File;
  5. import java.io.FileInputStream;
  6. import java.io.FileOutputStream;
  7. import java.io.IOException;
  8. import java.io.InputStream;
  9. import java.lang.reflect.Field;
  10. import java.math.BigDecimal;
  11. import java.math.RoundingMode;
  12. import java.net.URL;
  13. import java.text.NumberFormat;
  14. import java.text.SimpleDateFormat;
  15. import java.util.*;
  16. import java.util.Map.Entry;
  17.  
  18. import javax.servlet.ServletOutputStream;
  19. import javax.servlet.http.HttpServletResponse;
  20.  
  21. import org.apache.poi.hssf.usermodel.HSSFDataValidation;
  22. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  23. import org.apache.poi.poifs.filesystem.POIFSFileSystem;
  24. import org.apache.poi.ss.usermodel.Cell;
  25. import org.apache.poi.ss.usermodel.CellStyle;
  26. import org.apache.poi.ss.usermodel.CellType;
  27. import org.apache.poi.ss.usermodel.ClientAnchor.AnchorType;
  28. import org.apache.poi.ss.usermodel.DataValidation;
  29. import org.apache.poi.ss.usermodel.DataValidationConstraint;
  30. import org.apache.poi.ss.usermodel.DataValidationHelper;
  31. import org.apache.poi.ss.usermodel.Drawing;
  32. import org.apache.poi.ss.usermodel.FillPatternType;
  33. import org.apache.poi.ss.usermodel.HorizontalAlignment;
  34. import org.apache.poi.ss.usermodel.IndexedColors;
  35. import org.apache.poi.ss.usermodel.Row;
  36. import org.apache.poi.ss.usermodel.Sheet;
  37. import org.apache.poi.ss.usermodel.VerticalAlignment;
  38. import org.apache.poi.ss.usermodel.Workbook;
  39. import org.apache.poi.ss.util.CellRangeAddress;
  40. import org.apache.poi.ss.util.CellRangeAddressList;
  41. import org.apache.poi.xssf.streaming.SXSSFWorkbook;
  42. import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
  43. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  44. import org.springframework.web.multipart.MultipartFile;
  45.  
  46. import com.alibaba.fastjson.JSONArray;
  47. import com.alibaba.fastjson.JSONObject;
  48.  
  49.  
  50. public class ExcelUtil {
  51.  
  52.     private static final String XLSX = ".xlsx";
  53.     private static final String XLS = ".xls";
  54.     public static final String ROW_MERGE = "row_merge";
  55.     public static final String COLUMN_MERGE = "column_merge";
  56.     private static final String DATE_FORMAT = "yyyy-MM-dd HH:mm:ss";
  57.     private static final String ROW_NUM = "rowNum";
  58.     private static final String ROW_DATA = "rowData";
  59.     private static final String ROW_TIPS = "rowTips";
  60.     private static final int CELL_OTHER = 0;
  61.     private static final int CELL_ROW_MERGE = 1;
  62.     private static final int CELL_COLUMN_MERGE = 2;
  63.     private static final int IMG_HEIGHT = 30;
  64.     private static final int IMG_WIDTH = 30;
  65.     private static final char LEAN_LINE = '/';
  66.     private static final int BYTES_DEFAULT_LENGTH = 10240;
  67.     private static final NumberFormat NUMBER_FORMAT = NumberFormat.getNumberInstance();
  68.  
  69.  
  70.     public static <T> List<T> readFile(File file, Class<T> clazz) throws Exception {
  71.         JSONArray array = readFile(file);
  72.         return getBeanList(array, clazz);
  73.     }
  74. //Class<T> 反射
  75.     public static <T> List<T> readMultipartFile(MultipartFile mFile, Class<T> clazz) throws Exception {
  76.         JSONArray array = readMultipartFile(mFile);
  77.         return getBeanList(array, clazz);
  78.     }
  79.  
  80.     public static JSONArray readFile(File file) throws Exception {
  81.         return readExcel(null, file);
  82.     }
  83.  
  84.     public static JSONArray readMultipartFile(MultipartFile mFile) throws Exception {
  85.         return readExcel(mFile, null);
  86.     }
  87.  
  88.     private static <T> List<T> getBeanList(JSONArray array, Class<T> clazz) throws Exception {
  89.         List<T> list = new ArrayList<>();
  90.         Map<Integer, String> uniqueMap = new HashMap<>(16);
  91.         for (int i = 0; i < array.size(); i++) {
  92.             list.add(getBean(clazz, array.getJSONObject(i), uniqueMap));
  93.         }
  94.         return list;
  95.     }
  96.  
  97.     /**
  98.      * 获取每个对象的数据
  99.      */
  100.     private static <T> T getBean(Class<T> c, JSONObject obj, Map<Integer, String> uniqueMap) throws Exception {
  101.         T t = c.newInstance();
  102.         Field[] fields = c.getDeclaredFields();
  103.         List<String> errMsgList = new ArrayList<>();
  104.         boolean hasRowTipsField = false;
  105.         StringBuilder uniqueBuilder = new StringBuilder();
  106.         int rowNum = 0;
  107.         for (Field field : fields) {
  108.             // 行号
  109.             if (field.getName().equals(ROW_NUM)) {
  110.                 rowNum = obj.getInteger(ROW_NUM);
  111.                 field.setAccessible(true);
  112.                 field.set(t, rowNum);
  113.                 continue;
  114.             }
  115.             // 是否需要设置异常信息
  116.             if (field.getName().equals(ROW_TIPS)) {
  117.                 hasRowTipsField = true;
  118.                 continue;
  119.             }
  120.             // 原始数据
  121.             if (field.getName().equals(ROW_DATA)) {
  122.                 field.setAccessible(true);
  123.                 field.set(t, obj.toString());
  124.                 continue;
  125.             }
  126.             // 设置对应属性值
  127.             setFieldValue(t,field, obj, uniqueBuilder, errMsgList);
  128.         }
  129.         // 数据唯一性校验
  130.         if (uniqueBuilder.length() > 0) {
  131.             if (uniqueMap.containsValue(uniqueBuilder.toString())) {
  132.                 Set<Integer> rowNumKeys = uniqueMap.keySet();
  133.                 for (Integer num : rowNumKeys) {
  134.                     if (uniqueMap.get(num).equals(uniqueBuilder.toString())) {
  135.                         errMsgList.add(String.format("数据唯一性校验失败,(%s)与第%s行重复)", uniqueBuilder, num));
  136.                     }
  137.                 }
  138.             } else {
  139.                 uniqueMap.put(rowNum, uniqueBuilder.toString());
  140.             }
  141.         }
  142.         // 失败处理
  143.         if (errMsgList.isEmpty() && !hasRowTipsField) {
  144.             return t;
  145.         }
  146.         StringBuilder sb = new StringBuilder();
  147.         int size = errMsgList.size();
  148.         for (int i = 0; i < size; i++) {
  149.             if (i == size - 1) {
  150.                 sb.append(errMsgList.get(i));
  151.             } else {
  152.                 sb.append(errMsgList.get(i)).append(";");
  153.             }
  154.         }
  155.         // 设置错误信息
  156.         for (Field field : fields) {
  157.             if (field.getName().equals(ROW_TIPS)) {
  158.                 field.setAccessible(true);
  159.                 field.set(t, sb.toString());
  160.             }
  161.         }
  162.         return t;
  163.     }
  164.  
  165.     private static <T> void setFieldValue(T t, Field field, JSONObject obj, StringBuilder uniqueBuilder, List<String> errMsgList) {
  166.         // 获取 ExcelImport 注解属性
  167.         ExcelImport annotation = field.getAnnotation(ExcelImport.class);
  168.         if (annotation == null) {
  169.             return;
  170.         }
  171.         String cname = annotation.value();
  172.         if (cname.trim().length() == 0) {
  173.             return;
  174.         }
  175.         // 获取具体值
  176.         String val = null;
  177.         if (obj.containsKey(cname)) {
  178.             val = getString(obj.getString(cname));
  179.         }
  180.         if (val == null) {
  181.             return;
  182.         }
  183.         field.setAccessible(true);
  184.         // 判断是否必填
  185.         boolean require = annotation.required();
  186.         if (require && val.isEmpty()) {
  187.             errMsgList.add(String.format("[%s]不能为空", cname));
  188.             return;
  189.         }
  190.         // 数据唯一性获取
  191.         boolean unique = annotation.unique();
  192.         if (unique) {
  193.             if (uniqueBuilder.length() > 0) {
  194.                 uniqueBuilder.append("--").append(val);
  195.             } else {
  196.                 uniqueBuilder.append(val);
  197.             }
  198.         }
  199.         // 判断是否超过最大长度
  200.         int maxLength = annotation.maxLength();
  201.         if (maxLength > 0 && val.length() > maxLength) {
  202.             errMsgList.add(String.format("[%s]长度不能超过%s个字符(当前%s个字符)", cname, maxLength, val.length()));
  203.         }
  204.         // 判断当前属性是否有映射关系
  205.         LinkedHashMap<String, String> kvMap = getKvMap(annotation.kv());
  206.         if (!kvMap.isEmpty()) {
  207.             boolean isMatch = false;
  208.             for (String key : kvMap.keySet()) {
  209.                 if (kvMap.get(key).equals(val)) {
  210.                     val = key;
  211.                     isMatch = true;
  212.                     break;
  213.                 }
  214.             }
  215.             if (!isMatch) {
  216.                 errMsgList.add(String.format("[%s]的值不正确(当前值为%s)", cname, val));
  217.                 return;
  218.             }
  219.         }
  220.         // 其余情况根据类型赋值
  221.         String fieldClassName = field.getType().getSimpleName();
  222.         try {
  223.             if ("String".equalsIgnoreCase(fieldClassName)) {
  224.                 field.set(t, val);
  225.             } else if ("boolean".equalsIgnoreCase(fieldClassName)) {
  226.                 field.set(t, Boolean.valueOf(val));
  227.             } else if ("int".equalsIgnoreCase(fieldClassName) || "Integer".equals(fieldClassName)) {
  228.                 try {
  229.                     field.set(t, Integer.valueOf(val));
  230.                 } catch (NumberFormatException e) {
  231.                     errMsgList.add(String.format("[%s]的值格式不正确(当前值为%s)", cname, val));
  232.                 }
  233.             } else if ("double".equalsIgnoreCase(fieldClassName)) {
  234.                 field.set(t, Double.valueOf(val));
  235.             } else if ("long".equalsIgnoreCase(fieldClassName)) {
  236.                 field.set(t, Long.valueOf(val));
  237.             } else if ("BigDecimal".equalsIgnoreCase(fieldClassName)) {
  238.                 field.set(t, new BigDecimal(val));
  239.             }
  240.         } catch (Exception e) {
  241.             e.printStackTrace();
  242.         }
  243.     }
  244.  
  245.     private static JSONArray readExcel(MultipartFile mFile, File file) throws IOException {
  246.         boolean fileNotExist = (file == null || !file.exists());
  247.         if (mFile == null && fileNotExist) {
  248.             return new JSONArray();
  249.         }
  250.         // 解析表格数据
  251.         InputStream in;
  252.         String fileName;
  253.         if (mFile != null) {
  254.             // 上传文件解析
  255.             in = mFile.getInputStream();
  256.             fileName = getString(mFile.getOriginalFilename()).toLowerCase();
  257.         } else {
  258.             // 本地文件解析
  259.             in = new FileInputStream(file);
  260.             fileName = file.getName().toLowerCase();
  261.         }
  262.         Workbook book;
  263.         if (fileName.endsWith(XLSX)) {
  264.             book = new XSSFWorkbook(in);
  265.         } else if (fileName.endsWith(XLS)) {
  266.             POIFSFileSystem poifsFileSystem = new POIFSFileSystem(in);
  267.             book = new HSSFWorkbook(poifsFileSystem);
  268.         } else {
  269.             return new JSONArray();
  270.         }
  271.         JSONArray array = read(book);
  272.         book.close();
  273.         in.close();
  274.         return array;
  275.     }
  276.  
  277.     private static JSONArray read(Workbook book) {
  278.         // 获取 Excel 文件第一个 Sheet 页面
  279.         Sheet sheet = book.getSheetAt(0);
  280.         return readSheet(sheet);
  281.     }
  282.  
  283.     private static JSONArray readSheet(Sheet sheet) {
  284.         // 首行下标
  285.         int rowStart = sheet.getFirstRowNum();
  286.         // 尾行下标
  287.         int rowEnd = sheet.getLastRowNum();
  288.         // 获取表头行
  289.         Row headRow = sheet.getRow(rowStart);
  290.         if (headRow == null) {
  291.             return new JSONArray();
  292.         }
  293.         int cellStart = headRow.getFirstCellNum();
  294.         int cellEnd = headRow.getLastCellNum();
  295.         Map<Integer, String> keyMap = new HashMap<>();
  296.         for (int j = cellStart; j < cellEnd; j++) {
  297.             // 获取表头数据
  298.             String val = getCellValue(headRow.getCell(j));
  299.             if (val != null && val.trim().length() != 0) {
  300.                 keyMap.put(j, val);
  301.             }
  302.         }
  303.         // 如果表头没有数据则不进行解析
  304.         if (keyMap.isEmpty()) {
  305.             return (JSONArray) Collections.emptyList();
  306.         }
  307.         // 获取每行JSON对象的值
  308.         JSONArray array = new JSONArray();
  309.         // 如果首行与尾行相同，表明只有一行，返回表头数据
  310.         if (rowStart == rowEnd) {
  311.             JSONObject obj = new JSONObject();
  312.             // 添加行号
  313.             obj.put(ROW_NUM, 1);
  314.             for (int i : keyMap.keySet()) {
  315.                 obj.put(keyMap.get(i), "");
  316.             }
  317.             array.add(obj);
  318.             return array;
  319.         }
  320.         for (int i = rowStart + 1; i <= rowEnd; i++) {
  321.             Row eachRow = sheet.getRow(i);
  322.             JSONObject obj = new JSONObject();
  323.             // 添加行号
  324.             obj.put(ROW_NUM, i + 1);
  325.             StringBuilder sb = new StringBuilder();
  326.             for (int k = cellStart; k < cellEnd; k++) {
  327.                 if (eachRow != null) {
  328.                     String val = getCellValue(eachRow.getCell(k));
  329.                     // 所有数据添加到里面，用于判断该行是否为空
  330.                     sb.append(val);
  331.                     obj.put(keyMap.get(k), val);
  332.                 }
  333.             }
  334.             if (sb.length() > 0) {
  335.                 array.add(obj);
  336.             }
  337.         }
  338.         return array;
  339.     }
  340.  
  341.     private static String getCellValue(Cell cell) {
  342.         // 空白或空
  343.         if (cell == null || cell.getCellTypeEnum() == CellType.BLANK) {
  344.             return "";
  345.         }
  346.         // String类型
  347.         if (cell.getCellTypeEnum() == CellType.STRING) {
  348.             String val = cell.getStringCellValue();
  349.             if (val == null || val.trim().length() == 0) {
  350.                 return "";
  351.             }
  352.             return val.trim();
  353.         }
  354.         // 数字类型
  355.         if (cell.getCellTypeEnum() == CellType.NUMERIC) {
  356.             // 科学计数法类型
  357.             return NUMBER_FORMAT.format(cell.getNumericCellValue()) + "";
  358.         }
  359.         // 布尔值类型
  360.         if (cell.getCellTypeEnum() == CellType.BOOLEAN) {
  361.             return cell.getBooleanCellValue() + "";
  362.         }
  363.         // 错误类型
  364.         return cell.getCellFormula();
  365.     }
  366.  
  367.     public static <T> void exportTemplate(HttpServletResponse response, String fileName, Class<T> clazz) {
  368.         exportTemplate(response, fileName, fileName, clazz, false);
  369.     }
  370.  
  371.     public static <T> void exportTemplate(HttpServletResponse response, String fileName, String sheetName,
  372.                                           Class<T> clazz) {
  373.         exportTemplate(response, fileName, sheetName, clazz, false);
  374.     }
  375.  
  376.     public static <T> void exportTemplate(HttpServletResponse response, String fileName, Class<T> clazz,
  377.                                           boolean isContainExample) {
  378.         exportTemplate(response, fileName, fileName, clazz, isContainExample);
  379.     }
  380.  
  381.     public static <T> void exportTemplate(HttpServletResponse response, String fileName, String sheetName,
  382.                                           Class<T> clazz, boolean isContainExample) {
  383.         // 获取表头字段
  384.         List<ExcelClassField> headFieldList = getExcelClassFieldList(clazz);
  385.         // 获取表头数据和示例数据
  386.         List<List<Object>> sheetDataList = new ArrayList<>();
  387.         List<Object> headList = new ArrayList<>();
  388.         List<Object> exampleList = new ArrayList<>();
  389.         Map<Integer, List<String>> selectMap = new LinkedHashMap<>();
  390.         for (int i = 0; i < headFieldList.size(); i++) {
  391.             ExcelClassField each = headFieldList.get(i);
  392.             headList.add(each.getName());
  393.             exampleList.add(each.getExample());
  394.             LinkedHashMap<String, String> kvMap = each.getKvMap();
  395.             if (kvMap != null && kvMap.size() > 0) {
  396.                 selectMap.put(i, new ArrayList<>(kvMap.values()));
  397.             }
  398.         }
  399.         sheetDataList.add(headList);
  400.         if (isContainExample) {
  401.             sheetDataList.add(exampleList);
  402.         }
  403.         // 导出数据
  404.         export(response, fileName, sheetName, sheetDataList, selectMap);
  405.     }
  406.  
  407.     private static <T> List<ExcelClassField> getExcelClassFieldList(Class<T> clazz) {
  408.         // 解析所有字段
  409.         Field[] fields = clazz.getDeclaredFields();
  410.         boolean hasExportAnnotation = false;
  411.         Map<Integer, List<ExcelClassField>> map = new LinkedHashMap<>();
  412.         List<Integer> sortList = new ArrayList<>();
  413.         for (Field field : fields) {
  414.             ExcelClassField cf = getExcelClassField(field);
  415.             if (cf.getHasAnnotation() == 1) {
  416.                 hasExportAnnotation = true;
  417.             }
  418.             int sort = cf.getSort();
  419.             if (map.containsKey(sort)) {
  420.                 map.get(sort).add(cf);
  421.             } else {
  422.                 List<ExcelClassField> list = new ArrayList<>();
  423.                 list.add(cf);
  424.                 sortList.add(sort);
  425.                 map.put(sort, list);
  426.             }
  427.         }
  428.         Collections.sort(sortList);
  429.         // 获取表头
  430.         List<ExcelClassField> headFieldList = new ArrayList<>();
  431.         if (hasExportAnnotation) {
  432.             for (Integer sort : sortList) {
  433.                 for (ExcelClassField cf : map.get(sort)) {
  434.                     if (cf.getHasAnnotation() == 1) {
  435.                         headFieldList.add(cf);
  436.                     }
  437.                 }
  438.             }
  439.         } else {
  440.             headFieldList.addAll(map.get(0));
  441.         }
  442.         return headFieldList;
  443.     }
  444.  
  445.     private static ExcelClassField getExcelClassField(Field field) {
  446.         ExcelClassField cf = new ExcelClassField();
  447.         String fieldName = field.getName();
  448.         cf.setFieldName(fieldName);
  449.         ExcelExport annotation = field.getAnnotation(ExcelExport.class);
  450.         // 无 ExcelExport 注解情况
  451.         if (annotation == null) {
  452.             cf.setHasAnnotation(0);
  453.             cf.setName(fieldName);
  454.             cf.setSort(0);
  455.             return cf;
  456.         }
  457.         // 有 ExcelExport 注解情况
  458.         cf.setHasAnnotation(1);
  459.         cf.setName(annotation.value());
  460.         String example = getString(annotation.example());
  461.         if (!example.isEmpty()) {
  462.             if (isNumeric(example)) {
  463.                 cf.setExample(Double.valueOf(example));
  464.             } else {
  465.                 cf.setExample(example);
  466.             }
  467.         } else {
  468.             cf.setExample("");
  469.         }
  470.         cf.setSort(annotation.sort());
  471.         // 解析映射
  472.         String kv = getString(annotation.kv());
  473.         cf.setKvMap(getKvMap(kv));
  474.         return cf;
  475.     }
  476.  
  477.     private static LinkedHashMap<String, String> getKvMap(String kv) {
  478.         LinkedHashMap<String, String> kvMap = new LinkedHashMap<>();
  479.         if (kv.isEmpty()) {
  480.             return kvMap;
  481.         }
  482.         String[] kvs = kv.split(";");
  483.         if (kvs.length == 0) {
  484.             return kvMap;
  485.         }
  486.         for (String each : kvs) {
  487.             String[] eachKv = getString(each).split("-");
  488.             if (eachKv.length != 2) {
  489.                 continue;
  490.             }
  491.             String k = eachKv[0];
  492.             String v = eachKv[1];
  493.             if (k.isEmpty() || v.isEmpty()) {
  494.                 continue;
  495.             }
  496.             kvMap.put(k, v);
  497.         }
  498.         return kvMap;
  499.     }
  500.  
  501.     /**
  502.      * 导出表格到本地
  503.      *
  504.      * @param file      本地文件对象
  505.      * @param sheetData 导出数据
  506.      */
  507.     public static void exportFile(File file, List<List<Object>> sheetData) {
  508.         if (file == null) {
  509.             System.out.println("文件创建失败");
  510.             return;
  511.         }
  512.         if (sheetData == null) {
  513.             sheetData = new ArrayList<>();
  514.         }
  515.         export(null, file, file.getName(), file.getName(), sheetData, null);
  516.     }
  517.  
  518.     /**
  519.      * 导出表格到本地
  520.      *
  521.      * @param <T>      导出数据类似，和K类型保持一致
  522.      * @param filePath 文件父路径（如：D:/doc/excel/）
  523.      * @param fileName 文件名称（不带尾缀，如：学生表）
  524.      * @param list     导出数据
  525.      * @throws IOException IO异常
  526.      */
  527.     public static <T> File exportFile(String filePath, String fileName, List<T> list) throws IOException {
  528.         File file = getFile(filePath, fileName);
  529.         List<List<Object>> sheetData = getSheetData(list);
  530.         exportFile(file, sheetData);
  531.         return file;
  532.     }
  533.  
  534.     /**
  535.      * 获取文件
  536.      *
  537.      * @param filePath filePath 文件父路径（如：D:/doc/excel/）
  538.      * @param fileName 文件名称（不带尾缀，如：用户表）
  539.      * @return 本地File文件对象
  540.      */
  541.     private static File getFile(String filePath, String fileName) throws IOException {
  542.         String dirPath = getString(filePath);
  543.         String fileFullPath;
  544.         if (dirPath.isEmpty()) {
  545.             fileFullPath = fileName;
  546.         } else {
  547.             // 判定文件夹是否存在，如果不存在，则级联创建
  548.             File dirFile = new File(dirPath);
  549.             if (!dirFile.exists()) {
  550.                 dirFile.mkdirs();
  551.             }
  552.             // 获取文件夹全名
  553.             if (dirPath.endsWith(String.valueOf(LEAN_LINE))) {
  554.                 fileFullPath = dirPath + fileName + XLSX;
  555.             } else {
  556.                 fileFullPath = dirPath + LEAN_LINE + fileName + XLSX;
  557.             }
  558.         }
  559.         System.out.println(fileFullPath);
  560.         File file = new File(fileFullPath);
  561.         if (!file.exists()) {
  562.             file.createNewFile();
  563.         }
  564.         return file;
  565.     }
  566.  
  567.     private static <T> List<List<Object>> getSheetData(List<T> list) {
  568.         // 获取表头字段
  569.         List<ExcelClassField> excelClassFieldList = getExcelClassFieldList(list.get(0).getClass());
  570.         List<String> headFieldList = new ArrayList<>();
  571.         List<Object> headList = new ArrayList<>();
  572.         Map<String, ExcelClassField> headFieldMap = new HashMap<>();
  573.         for (ExcelClassField each : excelClassFieldList) {
  574.             String fieldName = each.getFieldName();
  575.             headFieldList.add(fieldName);
  576.             headFieldMap.put(fieldName, each);
  577.             headList.add(each.getName());
  578.         }
  579.         // 添加表头名称
  580.         List<List<Object>> sheetDataList = new ArrayList<>();
  581.         sheetDataList.add(headList);
  582.         // 获取表数据
  583.         for (T t : list) {
  584.             Map<String, Object> fieldDataMap = getFieldDataMap(t);
  585.             Set<String> fieldDataKeys = fieldDataMap.keySet();
  586.             List<Object> rowList = new ArrayList<>();
  587.             for (String headField : headFieldList) {
  588.                 if (!fieldDataKeys.contains(headField)) {
  589.                     continue;
  590.                 }
  591.                 Object data = fieldDataMap.get(headField);
  592.                 if (data == null) {
  593.                     rowList.add("");
  594.                     continue;
  595.                 }
  596.                 ExcelClassField cf = headFieldMap.get(headField);
  597.                 // 判断是否有映射关系
  598.                 LinkedHashMap<String, String> kvMap = cf.getKvMap();
  599.                 if (kvMap == null || kvMap.isEmpty()) {
  600.                     rowList.add(data);
  601.                     continue;
  602.                 }
  603.                 String val = kvMap.get(data.toString());
  604.                 if (isNumeric(val)) {
  605.                     rowList.add(Double.valueOf(val));
  606.                 } else {
  607.                     rowList.add(val);
  608.                 }
  609.             }
  610.             sheetDataList.add(rowList);
  611.         }
  612.         return sheetDataList;
  613.     }
  614.  
  615.     private static <T> Map<String, Object> getFieldDataMap(T t) {
  616.         Map<String, Object> map = new HashMap<>();
  617.         Field[] fields = t.getClass().getDeclaredFields();
  618.         try {
  619.             for (Field field : fields) {
  620.                 String fieldName = field.getName();
  621.                 field.setAccessible(true);
  622.                 Object object = field.get(t);
  623.                 map.put(fieldName, object);
  624.             }
  625.         } catch (IllegalArgumentException | IllegalAccessException e) {
  626.             e.printStackTrace();
  627.         }
  628.         return map;
  629.     }
  630.  
  631.     public static void exportEmpty(HttpServletResponse response, String fileName) {
  632.         List<List<Object>> sheetDataList = new ArrayList<>();
  633.         List<Object> headList = new ArrayList<>();
  634.         headList.add("导出无数据");
  635.         sheetDataList.add(headList);
  636.         export(response, fileName, sheetDataList);
  637.     }
  638.  
  639.     public static void export(HttpServletResponse response, String fileName, List<List<Object>> sheetDataList) {
  640.         export(response, fileName, fileName, sheetDataList, null);
  641.     }
  642.  
  643.     public static void export(HttpServletResponse response, String fileName, String sheetName,
  644.                               List<List<Object>> sheetDataList) {
  645.         export(response, fileName, sheetName, sheetDataList, null);
  646.     }
  647.  
  648.     public static void export(HttpServletResponse response, String fileName, String sheetName,
  649.                               List<List<Object>> sheetDataList, Map<Integer, List<String>> selectMap) {
  650.         export(response, null, fileName, sheetName, sheetDataList, selectMap);
  651.     }
  652.  
  653.     public static <T, K> void export(HttpServletResponse response, String fileName, List<T> list, Class<K> template) {
  654.         // list 是否为空
  655.         boolean lisIsEmpty = list == null || list.isEmpty();
  656.         // 如果模板数据为空，且导入的数据为空，则导出空文件
  657.         if (template == null && lisIsEmpty) {
  658.             exportEmpty(response, fileName);
  659.             return;
  660.         }
  661.         // 如果 list 数据，则导出模板数据
  662.         if (lisIsEmpty) {
  663.             exportTemplate(response, fileName, template);
  664.             return;
  665.         }
  666.         // 导出数据
  667.         List<List<Object>> sheetDataList = getSheetData(list);
  668.         export(response, fileName, sheetDataList);
  669.     }
  670.  
  671.     public static void export(HttpServletResponse response, String fileName, List<List<Object>> sheetDataList, Map<Integer, List<String>> selectMap) {
  672.         export(response, fileName, fileName, sheetDataList, selectMap);
  673.     }
  674.  
  675.     private static void export(HttpServletResponse response, File file, String fileName, String sheetName,
  676.                                List<List<Object>> sheetDataList, Map<Integer, List<String>> selectMap) {
  677.         // 整个 Excel 表格 book 对象
  678.         SXSSFWorkbook book = new SXSSFWorkbook();
  679.         // 每个 Sheet 页
  680.         Sheet sheet = book.createSheet(sheetName);
  681.         Drawing<?> patriarch = sheet.createDrawingPatriarch();
  682.         // 设置表头背景色（灰色）
  683.         CellStyle headStyle = book.createCellStyle();
  684.         headStyle.setFillForegroundColor(IndexedColors.GREY_80_PERCENT.index);
  685.         headStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
  686.         headStyle.setAlignment(HorizontalAlignment.CENTER);
  687.         headStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.index);
  688.         // 设置表身背景色（默认色）
  689.         CellStyle rowStyle = book.createCellStyle();
  690.         rowStyle.setAlignment(HorizontalAlignment.CENTER);
  691.         rowStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  692.         // 设置表格列宽度（默认为15个字节）
  693.         sheet.setDefaultColumnWidth(15);
  694.         // 创建合并算法数组
  695.         int rowLength = sheetDataList.size();
  696.         int columnLength = sheetDataList.get(0).size();
  697.         int[][] mergeArray = new int[rowLength][columnLength];
  698.         for (int i = 0; i < sheetDataList.size(); i++) {
  699.             // 每个 Sheet 页中的行数据
  700.             Row row = sheet.createRow(i);
  701.             List<Object> rowList = sheetDataList.get(i);
  702.             for (int j = 0; j < rowList.size(); j++) {
  703.                 // 每个行数据中的单元格数据
  704.                 Object o = rowList.get(j);
  705.                 int v = 0;
  706.                 if (o instanceof URL) {
  707.                     // 如果要导出图片的话, 链接需要传递 URL 对象
  708.                     setCellPicture(book, row, patriarch, i, j, (URL) o);
  709.                 } else {
  710.                     Cell cell = row.createCell(j);
  711.                     if (i == 0) {
  712.                         // 第一行为表头行，采用灰色底背景
  713.                         v = setCellValue(cell, o, headStyle);
  714.                     } else {
  715.                         // 其他行为数据行，默认白底色
  716.                         v = setCellValue(cell, o, rowStyle);
  717.                     }
  718.                 }
  719.                 mergeArray[i][j] = v;
  720.             }
  721.         }
  722.         // 合并单元格
  723.         mergeCells(sheet, mergeArray);
  724.         // 设置下拉列表
  725.         setSelect(sheet, selectMap);
  726.         // 写数据
  727.         if (response != null) {
  728.             // 前端导出
  729.             try {
  730.                 write(response, book, fileName);
  731.             } catch (IOException e) {
  732.                 e.printStackTrace();
  733.             }
  734.         } else {
  735.             // 本地导出
  736.             FileOutputStream fos;
  737.             try {
  738.                 fos = new FileOutputStream(file);
  739.                 ByteArrayOutputStream ops = new ByteArrayOutputStream();
  740.                 book.write(ops);
  741.                 fos.write(ops.toByteArray());
  742.                 fos.close();
  743.             } catch (Exception e) {
  744.                 e.printStackTrace();
  745.             }
  746.         }
  747.     }
  748.  
  749.     /**
  750.      * 合并当前Sheet页的单元格
  751.      *
  752.      * @param sheet      当前 sheet 页
  753.      * @param mergeArray 合并单元格算法
  754.      */
  755.     private static void mergeCells(Sheet sheet, int[][] mergeArray) {
  756.         // 横向合并
  757.         for (int x = 0; x < mergeArray.length; x++) {
  758.             int[] arr = mergeArray[x];
  759.             boolean merge = false;
  760.             int y1 = 0;
  761.             int y2 = 0;
  762.             for (int y = 0; y < arr.length; y++) {
  763.                 int value = arr[y];
  764.                 if (value == CELL_COLUMN_MERGE) {
  765.                     if (!merge) {
  766.                         y1 = y;
  767.                     }
  768.                     y2 = y;
  769.                     merge = true;
  770.                 } else {
  771.                     merge = false;
  772.                     if (y1 > 0) {
  773.                         sheet.addMergedRegion(new CellRangeAddress(x, x, (y1 - 1), y2));
  774.                     }
  775.                     y1 = 0;
  776.                     y2 = 0;
  777.                 }
  778.             }
  779.             if (y1 > 0) {
  780.                 sheet.addMergedRegion(new CellRangeAddress(x, x, (y1 - 1), y2));
  781.             }
  782.         }
  783.         // 纵向合并
  784.         int xLen = mergeArray.length;
  785.         int yLen = mergeArray[0].length;
  786.         for (int y = 0; y < yLen; y++) {
  787.             boolean merge = false;
  788.             int x1 = 0;
  789.             int x2 = 0;
  790.             for (int x = 0; x < xLen; x++) {
  791.                 int value = mergeArray[x][y];
  792.                 if (value == CELL_ROW_MERGE) {
  793.                     if (!merge) {
  794.                         x1 = x;
  795.                     }
  796.                     x2 = x;
  797.                     merge = true;
  798.                 } else {
  799.                     merge = false;
  800.                     if (x1 > 0) {
  801.                         sheet.addMergedRegion(new CellRangeAddress((x1 - 1), x2, y, y));
  802.                     }
  803.                     x1 = 0;
  804.                     x2 = 0;
  805.                 }
  806.             }
  807.             if (x1 > 0) {
  808.                 sheet.addMergedRegion(new CellRangeAddress((x1 - 1), x2, y, y));
  809.             }
  810.         }
  811.     }
  812.  
  813.     private static void write(HttpServletResponse response, SXSSFWorkbook book, String fileName) throws IOException {
  814.         response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
  815.         response.setCharacterEncoding("utf-8");
  816.         String name = new String(fileName.getBytes("GBK"), "ISO8859_1") + XLSX;
  817.         response.addHeader("Content-Disposition", "attachment;filename=" + name);
  818.         ServletOutputStream out = response.getOutputStream();
  819.         book.write(out);
  820.         out.flush();
  821.         out.close();
  822.     }
  823.  
  824.     private static int setCellValue(Cell cell, Object o, CellStyle style) {
  825.         // 设置样式
  826.         cell.setCellStyle(style);
  827.         // 数据为空时
  828.         if (o == null) {
  829.             cell.setCellType(CellType.STRING);
  830.             cell.setCellValue("");
  831.             return CELL_OTHER;
  832.         }
  833.         // 是否为字符串
  834.         if (o instanceof String) {
  835.             String s = o.toString();
  836.             if (isNumeric(s)) {
  837.                 cell.setCellType(CellType.NUMERIC);
  838.                 cell.setCellValue(Double.parseDouble(s));
  839.                 return CELL_OTHER;
  840.             } else {
  841.                 cell.setCellType(CellType.STRING);
  842.                 cell.setCellValue(s);
  843.             }
  844.             if (s.equals(ROW_MERGE)) {
  845.                 return CELL_ROW_MERGE;
  846.             } else if (s.equals(COLUMN_MERGE)) {
  847.                 return CELL_COLUMN_MERGE;
  848.             } else {
  849.                 return CELL_OTHER;
  850.             }
  851.         }
  852.         // 是否为字符串
  853.         if (o instanceof Integer || o instanceof Long || o instanceof Double || o instanceof Float) {
  854.             cell.setCellType(CellType.NUMERIC);
  855.             cell.setCellValue(Double.parseDouble(o.toString()));
  856.             return CELL_OTHER;
  857.         }
  858.         // 是否为Boolean
  859.         if (o instanceof Boolean) {
  860.             cell.setCellType(CellType.BOOLEAN);
  861.             cell.setCellValue((Boolean) o);
  862.             return CELL_OTHER;
  863.         }
  864.         // 如果是BigDecimal，则默认3位小数
  865.         if (o instanceof BigDecimal) {
  866.             cell.setCellType(CellType.NUMERIC);
  867.             cell.setCellValue(((BigDecimal) o).setScale(3, RoundingMode.HALF_UP).doubleValue());
  868.             return CELL_OTHER;
  869.         }
  870.         // 如果是Date数据，则显示格式化数据
  871.         if (o instanceof Date) {
  872.             cell.setCellType(CellType.STRING);
  873.             cell.setCellValue(formatDate((Date) o));
  874.             return CELL_OTHER;
  875.         }
  876.         // 如果是其他，则默认字符串类型
  877.         cell.setCellType(CellType.STRING);
  878.         cell.setCellValue(o.toString());
  879.         return CELL_OTHER;
  880.     }
  881.  
  882.     private static void setCellPicture(SXSSFWorkbook wb, Row sr, Drawing<?> patriarch, int x, int y, URL url) {
  883.         // 设置图片宽高
  884.         sr.setHeight((short) (IMG_WIDTH * IMG_HEIGHT));
  885.         // （jdk1.7版本try中定义流可自动关闭）
  886.         try (InputStream is = url.openStream(); ByteArrayOutputStream outputStream = new ByteArrayOutputStream()) {
  887.             byte[] buff = new byte[BYTES_DEFAULT_LENGTH];
  888.             int rc;
  889.             while ((rc = is.read(buff, 0, BYTES_DEFAULT_LENGTH)) > 0) {
  890.                 outputStream.write(buff, 0, rc);
  891.             }
  892.             // 设置图片位置
  893.             XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, y, x, y + 1, x + 1);
  894.             // 设置这个，图片会自动填满单元格的长宽
  895.             anchor.setAnchorType(AnchorType.MOVE_AND_RESIZE);
  896.             patriarch.createPicture(anchor, wb.addPicture(outputStream.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
  897.         } catch (Exception e) {
  898.             e.printStackTrace();
  899.         }
  900.     }
  901.  
  902.     private static String formatDate(Date date) {
  903.         if (date == null) {
  904.             return "";
  905.         }
  906.         SimpleDateFormat format = new SimpleDateFormat(DATE_FORMAT);
  907.         return format.format(date);
  908.     }
  909.  
  910.     private static void setSelect(Sheet sheet, Map<Integer, List<String>> selectMap) {
  911.         if (selectMap == null || selectMap.isEmpty()) {
  912.             return;
  913.         }
  914.         Set<Entry<Integer, List<String>>> entrySet = selectMap.entrySet();
  915.         for (Entry<Integer, List<String>> entry : entrySet) {
  916.             int y = entry.getKey();
  917.             List<String> list = entry.getValue();
  918.             if (list == null || list.isEmpty()) {
  919.                 continue;
  920.             }
  921.             String[] arr = new String[list.size()];
  922.             for (int i = 0; i < list.size(); i++) {
  923.                 arr[i] = list.get(i);
  924.             }
  925.             DataValidationHelper helper = sheet.getDataValidationHelper();
  926.             CellRangeAddressList addressList = new CellRangeAddressList(1, 65000, y, y);
  927.             DataValidationConstraint dvc = helper.createExplicitListConstraint(arr);
  928.             DataValidation dv = helper.createValidation(dvc, addressList);
  929.             if (dv instanceof HSSFDataValidation) {
  930.                 dv.setSuppressDropDownArrow(false);
  931.             } else {
  932.                 dv.setSuppressDropDownArrow(true);
  933.                 dv.setShowErrorBox(true);
  934.             }
  935.             sheet.addValidationData(dv);
  936.         }
  937.     }
  938.  
  939.     private static boolean isNumeric(String str) {
  940.         if ("0.0".equals(str)) {
  941.             return true;
  942.         }
  943.         for (int i = str.length(); --i >= 0; ) {
  944.             if (!Character.isDigit(str.charAt(i))) {
  945.                 return false;
  946.             }
  947.         }
  948.         return true;
  949.     }
  950.  
  951.     private static String getString(String s) {
  952.         if (s == null) {
  953.             return "";
  954.         }
  955.         if (s.isEmpty()) {
  956.             return s;
  957.         }
  958.         return s.trim();
  959.     }
  960.  
  961. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/321497
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号