管道基础大数据平台系统开发-【后端】-Server
1
13693261870
2022-11-18 3bd470aabe93e6922dd0c66bfacf48bea8cae8fc
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();
@@ -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();