From 65a9573f62b495272daeb39a94ddd4ab5e838d44 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 18 十一月 2022 11:31:19 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/service/data/UploaderService.java | 57 +++++++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 45 insertions(+), 12 deletions(-) diff --git a/src/main/java/com/lf/server/service/data/UploaderService.java b/src/main/java/com/lf/server/service/data/UploaderService.java index 0489870..965974c 100644 --- a/src/main/java/com/lf/server/service/data/UploaderService.java +++ b/src/main/java/com/lf/server/service/data/UploaderService.java @@ -1,5 +1,6 @@ package com.lf.server.service.data; +import com.lf.server.entity.ctrl.KeyValueEntity; import com.lf.server.entity.data.MetaFileEntity; import com.lf.server.helper.FileHelper; import com.lf.server.helper.PathHelper; @@ -40,15 +41,13 @@ if (t != null) { setEntity(t, request); } - List<MetaFileEntity> list = getFiles(path,request); + List<MetaFileEntity> list = getFiles(path, request); return list; } /** * 璁剧疆瀹炰綋绫� - * class<T> clazz - * T t = clazz.newInstance(); */ private <T> void setEntity(T t, StandardMultipartHttpServletRequest req) { Enumeration<String> enumeration = req.getParameterNames(); @@ -87,7 +86,7 @@ /** * 鑾峰彇鏂囦欢 */ - private List<MetaFileEntity> getFiles(String subPath,StandardMultipartHttpServletRequest req) throws Exception { + private List<MetaFileEntity> getFiles(String subPath, StandardMultipartHttpServletRequest req) throws Exception { List<MetaFileEntity> list = new ArrayList<MetaFileEntity>(); String path = pathHelper.getTempPath(subPath); @@ -124,19 +123,17 @@ /** * 鍒犻櫎鏂囦欢 - * @param list 瀹炰綋闆嗗悎 - * @return */ - public Integer deleteFiles(List<MetaFileEntity> list){ - String root=pathHelper.getConfig().getTempPath(); + public Integer deleteFiles(List<MetaFileEntity> list) { + String root = pathHelper.getConfig().getTempPath(); int count = 0; for (MetaFileEntity entity : list) { - if (!StringHelper.isEmpty(entity.getPath())){ - String file=root+File.separator+entity.getPath(); + if (!StringHelper.isEmpty(entity.getPath())) { + String file = root + File.separator + entity.getPath(); - File f=new File(file); - if (f.exists()){ + File f = new File(file); + if (f.exists()) { f.delete(); count++; } @@ -147,6 +144,42 @@ } /** + * 鎻掑叆鍏冩暟鎹� + */ + public List<KeyValueEntity> insertMetas(List<KeyValueEntity> kvs) { + String root = pathHelper.getConfig().getTempPath(); + List<KeyValueEntity> rs = new ArrayList<KeyValueEntity>(); + + for (KeyValueEntity kv : kvs) { + if (kv.getKey().toLowerCase().contains(".xls")) { + KeyValueEntity entity = readExcel(root + File.separator + kv.getKey(), kv.getValue()); + if (null != entity) { + rs.add(entity); + } + continue; + } + } + + return rs; + } + + /** + * 璇诲彇Excel + */ + private KeyValueEntity readExcel(String fileName, String entity) { + File f = new File(fileName); + if (!f.exists() || f.isDirectory()) { + return null; + } + + KeyValueEntity kv = new KeyValueEntity(); + kv.setKey(FileHelper.getFileName(fileName)); + + + return kv; + } + + /** * 鑾峰彇鍙傛暟 * Enumeration<String> headers = req.getHeaderNames(); * Enumeration<String> attributes = req.getAttributeNames(); -- Gitblit v1.9.3