From 26906f9b876b28be864a6dd16b1bd1ebab176a0f Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 18 十一月 2022 20:55:31 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/service/data/UploaderService.java |  101 +++++++++++++++++++++++++++++++++-----------------
 1 files changed, 67 insertions(+), 34 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 a6d7196..55cce11 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;
@@ -19,7 +20,7 @@
 import java.util.*;
 
 /**
- * 鏁版嵁涓婁紶鏈嶅姟绫�
+ * 涓婁紶鏈嶅姟绫�
  * @author WWW
  */
 @Service
@@ -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();
@@ -57,28 +56,26 @@
 
             try {
                 Field field = t.getClass().getDeclaredField(key);
-                if (field != null) {
-                    field.setAccessible(true);
-                    String value = req.getParameter(key);
+                field.setAccessible(true);
+                String value = req.getParameter(key);
 
-                    switch (field.getType().toString()) {
-                        case "double":
-                            field.set(t, Double.valueOf(value));
-                            break;
-                        case "long":
-                            field.set(t, Long.valueOf(value));
-                            break;
-                        case "int":
-                            field.set(t, Integer.valueOf(value));
-                            break;
-                        case "class java.sql.Timestamp":
-                            field.set(t, Timestamp.valueOf(value));
-                            break;
-                        //case "class java.lang.String":
-                        default:
-                            field.set(t, value);
-                            break;
-                    }
+                switch (field.getType().toString()) {
+                    case "double":
+                        field.set(t, Double.valueOf(value));
+                        break;
+                    case "long":
+                        field.set(t, Long.valueOf(value));
+                        break;
+                    case "int":
+                        field.set(t, Integer.valueOf(value));
+                        break;
+                    case "class java.sql.Timestamp":
+                        field.set(t, Timestamp.valueOf(value));
+                        break;
+                    //case "class java.lang.String":
+                    default:
+                        field.set(t, value);
+                        break;
                 }
             } catch (Exception ex) {
                 log.error(ex.getMessage(), ex);
@@ -89,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);
@@ -126,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++;
                 }
@@ -149,6 +144,44 @@
     }
 
     /**
+     * 鎻掑叆鍏冩暟鎹�
+     */
+    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 entityName) {
+        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