管道基础大数据平台系统开发-【后端】-Server
1
13693261870
2022-10-21 c0a828cca9ee3480c8797891732789e574ba2200
1
已添加1个文件
已修改6个文件
427 ■■■■ 文件已修改
data/menu-执行.xls 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/controller/data/StyleController.java 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/controller/data/UploaderController.java 10 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/controller/sys/ResController.java 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/helper/FileHelper.java 15 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/service/all/UploadService.java 163 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/service/data/UploaderService.java 223 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
data/menu-Ö´ÐÐ.xls
Binary files differ
src/main/java/com/lf/server/controller/data/StyleController.java
@@ -5,7 +5,7 @@
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.data.StyleEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.service.data.UploaderService;
import com.lf.server.service.all.UploadService;
import com.lf.server.service.data.StyleService;
import com.lf.server.service.sys.TokenService;
import io.swagger.annotations.Api;
@@ -36,7 +36,7 @@
    TokenService tokenService;
    @Autowired
    UploaderService uploaderService;
    UploadService uploadService;
    private final static String TAB_NAME = "sys_style";
@@ -244,7 +244,7 @@
    public ResponseMsg<String> upload(@RequestParam("file") MultipartFile file, HttpServletRequest req) {
        UserEntity ue = tokenService.getCurrentUser(req);
        return uploaderService.upload(ue, TAB_NAME, file, this);
        return uploadService.upload(ue, TAB_NAME, file, this);
    }
    @SysLog()
@@ -254,6 +254,6 @@
    })
    @GetMapping(value = "/download")
    public void download(String guid, HttpServletResponse res) {
        uploaderService.download(guid, res);
        uploadService.download(guid, res);
    }
}
src/main/java/com/lf/server/controller/data/UploaderController.java
@@ -4,6 +4,7 @@
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.service.data.UploaderService;
import com.lf.server.service.sys.TokenService;
@@ -14,6 +15,7 @@
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;
/**
 * æ•°æ®ä¸Šä¼ 
@@ -41,9 +43,13 @@
                return fail("用户未登录", null);
            }
            Object obj = uploaderService.uploadData(ue, req, res);
            MetaEntity me = new MetaEntity();
            List<MetaFileEntity> list = uploaderService.uploadData(me, ue, req, res);
            if (list.size() == 0 || me.getDirid() == 0) {
                return fail("没有找到上传数据", null);
            }
            return success(obj);
            return success(list.size());
        } catch (Exception ex) {
            return fail(ex.getMessage(), null);
        }
src/main/java/com/lf/server/controller/sys/ResController.java
@@ -5,7 +5,7 @@
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.sys.ResEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.service.data.UploaderService;
import com.lf.server.service.all.UploadService;
import com.lf.server.service.sys.ResService;
import com.lf.server.service.sys.TokenService;
import io.swagger.annotations.Api;
@@ -36,7 +36,7 @@
    TokenService tokenService;
    @Autowired
    UploaderService uploaderService;
    UploadService uploadService;
    private final static String TAB_NAME = "sys_res";
@@ -266,7 +266,7 @@
    public ResponseMsg<String> upload(@RequestParam("file") MultipartFile file, HttpServletRequest req) {
        UserEntity ue = tokenService.getCurrentUser(req);
        return uploaderService.upload(ue, TAB_NAME, file, this);
        return uploadService.upload(ue, TAB_NAME, file, this);
    }
    @SysLog()
@@ -276,6 +276,6 @@
    })
    @GetMapping(value = "/download")
    public void download(String guid, HttpServletResponse res) {
        uploaderService.download(guid, res);
        uploadService.download(guid, res);
    }
}
src/main/java/com/lf/server/helper/FileHelper.java
@@ -1,6 +1,10 @@
package com.lf.server.helper;
import org.apache.commons.codec.digest.DigestUtils;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.DecimalFormat;
/**
@@ -171,4 +175,15 @@
        return Double.parseDouble(str);
    }
    /**
     * èŽ·å–æ–‡ä»¶ MD5 ç 
     */
    public static String getFileMd5(String filePath) throws IOException {
        FileInputStream fileStream = new FileInputStream(filePath);
        String md5 = DigestUtils.md5Hex(fileStream);
        fileStream.close();
        return md5;
    }
}
src/main/java/com/lf/server/service/all/UploadService.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,163 @@
package com.lf.server.service.all;
import com.alibaba.fastjson.JSON;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.HttpStatus;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.all.SettingData;
import com.lf.server.entity.sys.AttachEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.FileHelper;
import com.lf.server.helper.PathHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.helper.WebHelper;
import com.lf.server.service.sys.AttachService;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.net.URLEncoder;
/**
 * ä¸Šä¼ æœåŠ¡ç±»
 * @author WWW
 */
@Service
public class UploadService {
    @Autowired
    PathHelper pathHelper;
    @Autowired
    AttachService attachService;
    private final static Log log = LogFactory.getLog(UploadService.class);
    private static final String NO_FILE = JSON.toJSONString(new ResponseMsg<String>(HttpStatus.NOT_FOUND, "文件找不到"));
    /**
     * ä¸Šä¼ æ–‡ä»¶
     */
    public ResponseMsg<String> upload(UserEntity ue, String tab, MultipartFile file, BaseController ctrl) {
        try {
            if (file == null && file.isEmpty()) {
                return ctrl.fail("文件上传为空", null);
            }
            if (file.getSize() > SettingData.MAX_FILE_SIZE) {
                return ctrl.fail(String.format("文件大于 %d MB", SettingData.MAX_FILE_SIZE / 1024 / 1024), null);
            }
            // ä¼ è¾“文件
            String oldName = file.getOriginalFilename();
            String filePath = pathHelper.getTempPath() + File.separator + oldName;
            File newFile = new File(filePath);
            file.transferTo(newFile);
            double sizes = FileHelper.sizeToMb(file.getSize());
            // èŽ·å–MD5
            String md5 = FileHelper.getFileMd5(filePath);
            AttachEntity entity = attachService.selectByGuid(md5);
            if (entity != null) {
                newFile.delete();
                return ctrl.success("文件已存在", md5);
            }
            AttachEntity ae = getAttachEntity(ue, tab, oldName, md5, sizes);
            String targetPath = pathHelper.getConfig().getUploadPath() + File.separator + ae.getPath();
            newFile.renameTo(new File(targetPath));
            int rows = attachService.insert(ae);
            return rows > 0 ? ctrl.success(md5) : ctrl.fail("保存文件失败", null);
        } catch (Exception ex) {
            return ctrl.fail(ex.getMessage(), null);
        }
    }
    /**
     * èŽ·å–é™„ä»¶å®žä½“ç±»
     */
    protected AttachEntity getAttachEntity(UserEntity ue, String tab, String oldName, String md5, double sizes) {
        AttachEntity entity = new AttachEntity();
        entity.setName(oldName);
        entity.setTab(tab);
        entity.setGuid(md5);
        String subPath = PathHelper.getUploadPath() + File.separator + md5;
        entity.setPath(subPath);
        entity.setSizes(sizes);
        if (ue != null) {
            entity.setCreateUser(ue.getId());
        }
        return entity;
    }
    /**
     * ä¸‹è½½æ–‡ä»¶
     */
    public void download(String guid, HttpServletResponse res) {
        try {
            if (StringHelper.isEmpty(guid)) {
                WebHelper.write2Page(res, NO_FILE);
                return;
            }
            AttachEntity entity = attachService.selectByGuid(guid);
            if (entity == null) {
                WebHelper.write2Page(res, NO_FILE);
                return;
            }
            setDownloadResponse(entity, res);
            String filePath = pathHelper.getConfig().getUploadPath() + File.separator + entity.getPath();
            // é€šè¿‡response对象,获取到输出流
            ServletOutputStream outputStream = res.getOutputStream();
            // å®šä¹‰è¾“入流,通过输入流读取文件内容
            FileInputStream fileInputStream = new FileInputStream(filePath);
            int len = 0;
            byte[] bytes = new byte[1024];
            while ((len = fileInputStream.read(bytes)) != -1) {
                // é€šè¿‡è¾“入流读取文件数据,然后通过上述的输出流写回浏览器
                outputStream.write(bytes, 0, len);
                outputStream.flush();
            }
            // å…³é—­èµ„源
            outputStream.close();
            fileInputStream.close();
        } catch (Exception ex) {
            try {
                String msg = JSON.toJSONString(new ResponseMsg<String>(HttpStatus.ERROR, "文件下载出错"));
                WebHelper.write2Page(res, msg);
            } catch (Exception e) {
                log.error(e.getStackTrace());
            }
            log.error(ex.getStackTrace());
        }
    }
    /**
     * è®¾ç½®ä¸‹è½½å“åº”信息
     */
    private void setDownloadResponse(AttachEntity entity, HttpServletResponse res) throws IOException {
        String fileName = URLEncoder.encode(entity.getName(), "UTF-8");
        // è®¾ç½®å“åº”头中文件的下载方式为附件方式,以及设置文件名
        res.setHeader("Content-Disposition", "attachment; filename=" + fileName);
        // è®¾ç½®å“åº”头的编码格式为UTF-8
        res.setCharacterEncoding("UTF-8");
        // é€šè¿‡response对象设置响应数据格式(如:"text/plain; charset=utf-8")
        String ext = FileHelper.getExtension(entity.getName());
        String mime = FileHelper.getMime(ext);
        res.setContentType(mime);
    }
}
src/main/java/com/lf/server/service/data/UploaderService.java
@@ -1,21 +1,11 @@
package com.lf.server.service.data;
import com.alibaba.fastjson.JSON;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.HttpStatus;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.all.SettingData;
import com.lf.server.entity.ctrl.FileInfo;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.sys.AttachEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.FileHelper;
import com.lf.server.helper.PathHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.helper.WebHelper;
import com.lf.server.service.sys.AttachService;
import org.apache.commons.codec.digest.DigestUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.tomcat.util.http.fileupload.FileItem;
@@ -27,14 +17,10 @@
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.support.StandardMultipartHttpServletRequest;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.lang.reflect.Field;
import java.net.URLEncoder;
import java.sql.Timestamp;
import java.util.*;
@@ -47,213 +33,58 @@
    @Autowired
    PathHelper pathHelper;
    @Autowired
    AttachService attachService;
    private final static Log log = LogFactory.getLog(UploaderService.class);
    private static final String NO_FILE = JSON.toJSONString(new ResponseMsg<String>(HttpStatus.NOT_FOUND, "文件找不到"));
    /**
     * ä¸Šä¼ æ–‡ä»¶
     */
    public ResponseMsg<String> upload(UserEntity ue, String tab, MultipartFile file, BaseController ctrl) {
        try {
            if (file == null && file.isEmpty()) {
                return ctrl.fail("文件上传为空", null);
            }
            if (file.getSize() > SettingData.MAX_FILE_SIZE) {
                return ctrl.fail(String.format("文件大于 %d MB", SettingData.MAX_FILE_SIZE / 1024 / 1024), null);
            }
            // ä¼ è¾“文件
            String oldName = file.getOriginalFilename();
            String filePath = pathHelper.getTempPath() + File.separator + oldName;
            File newFile = new File(filePath);
            file.transferTo(newFile);
            double sizes = FileHelper.sizeToMb(file.getSize());
            // èŽ·å–MD5
            String md5 = getFileMd5(filePath);
            AttachEntity entity = attachService.selectByGuid(md5);
            if (entity != null) {
                newFile.delete();
                return ctrl.success("文件已存在", md5);
            }
            AttachEntity ae = getAttachEntity(ue, tab, oldName, md5, sizes);
            String targetPath = pathHelper.getConfig().getUploadPath() + File.separator + ae.getPath();
            newFile.renameTo(new File(targetPath));
            int rows = attachService.insert(ae);
            return rows > 0 ? ctrl.success(md5) : ctrl.fail("保存文件失败", null);
        } catch (Exception ex) {
            return ctrl.fail(ex.getMessage(), null);
        }
    }
    /**
     * èŽ·å–æ–‡ä»¶ MD5 ç 
     */
    private String getFileMd5(String filePath) throws IOException {
        FileInputStream fileStream = new FileInputStream(filePath);
        String md5 = DigestUtils.md5Hex(fileStream);
        fileStream.close();
        return md5;
    }
    /**
     * èŽ·å–é™„ä»¶å®žä½“ç±»
     */
    protected AttachEntity getAttachEntity(UserEntity ue, String tab, String oldName, String md5, double sizes) {
        AttachEntity entity = new AttachEntity();
        entity.setName(oldName);
        entity.setTab(tab);
        entity.setGuid(md5);
        String subPath = PathHelper.getUploadPath() + File.separator + md5;
        entity.setPath(subPath);
        entity.setSizes(sizes);
        if (ue != null) {
            entity.setCreateUser(ue.getId());
        }
        return entity;
    }
    /**
     * ä¸‹è½½æ–‡ä»¶
     */
    public void download(String guid, HttpServletResponse res) {
        try {
            if (StringHelper.isEmpty(guid)) {
                WebHelper.write2Page(res, NO_FILE);
                return;
            }
            AttachEntity entity = attachService.selectByGuid(guid);
            if (entity == null) {
                WebHelper.write2Page(res, NO_FILE);
                return;
            }
            setDownloadResponse(entity, res);
            String filePath = pathHelper.getConfig().getUploadPath() + File.separator + entity.getPath();
            // é€šè¿‡response对象,获取到输出流
            ServletOutputStream outputStream = res.getOutputStream();
            // å®šä¹‰è¾“入流,通过输入流读取文件内容
            FileInputStream fileInputStream = new FileInputStream(filePath);
            int len = 0;
            byte[] bytes = new byte[1024];
            while ((len = fileInputStream.read(bytes)) != -1) {
                // é€šè¿‡è¾“入流读取文件数据,然后通过上述的输出流写回浏览器
                outputStream.write(bytes, 0, len);
                outputStream.flush();
            }
            // å…³é—­èµ„源
            outputStream.close();
            fileInputStream.close();
        } catch (Exception ex) {
            try {
                String msg = JSON.toJSONString(new ResponseMsg<String>(HttpStatus.ERROR, "文件下载出错"));
                WebHelper.write2Page(res, msg);
            } catch (Exception e) {
                log.error(e.getStackTrace());
            }
            log.error(ex.getStackTrace());
        }
    }
    /**
     * è®¾ç½®ä¸‹è½½å“åº”信息
     */
    private void setDownloadResponse(AttachEntity entity, HttpServletResponse res) throws IOException {
        String fileName = URLEncoder.encode(entity.getName(), "UTF-8");
        // è®¾ç½®å“åº”头中文件的下载方式为附件方式,以及设置文件名
        res.setHeader("Content-Disposition", "attachment; filename=" + fileName);
        // è®¾ç½®å“åº”头的编码格式为UTF-8
        res.setCharacterEncoding("UTF-8");
        // é€šè¿‡response对象设置响应数据格式(如:"text/plain; charset=utf-8")
        String ext = FileHelper.getExtension(entity.getName());
        String mime = FileHelper.getMime(ext);
        res.setContentType(mime);
    }
    /**
     * ä¸Šä¼ æ–‡ä»¶
     */
    public Object uploadData(UserEntity ue, HttpServletRequest request, HttpServletResponse res) throws Exception {
    public <T> List<MetaFileEntity> uploadData(T t, UserEntity ue, HttpServletRequest request, HttpServletResponse res) throws Exception {
        StandardMultipartHttpServletRequest req = (StandardMultipartHttpServletRequest) request;
        req.setCharacterEncoding("utf-8");
        res.setContentType("application/json;charset=utf-8");
        MetaEntity me = getMetaEntity(req);
        setEntity(t, req);
        List<MetaFileEntity> list = getFiles(req);
        //
        return list.size();
        return list;
    }
    private MetaEntity getMetaEntity(StandardMultipartHttpServletRequest req) {
        MetaEntity me = new MetaEntity();
    /**
     * è®¾ç½®å®žä½“ç±»
     * class<T> clazz
     * T t = clazz.newInstance();
     */
    private <T> void setEntity(T t, StandardMultipartHttpServletRequest req) {
        Enumeration<String> enumeration = req.getParameterNames();
        while (enumeration.hasMoreElements()) {
            String key = enumeration.nextElement();
            try {
                Field field = me.getClass().getDeclaredField(key);
                Field field = t.getClass().getDeclaredField(key);
                if (field != null) {
                    field.setAccessible(true);
                    String value = req.getParameter(key);
                    switch (field.getType().toString()) {
                        case "class java.lang.String":
                            field.set(me, value);
                            break;
                        case "long":
                            field.set(me, Long.valueOf(value));
                            field.set(t, Long.valueOf(value));
                            break;
                        case "int":
                            field.set(me, Integer.valueOf(value));
                            field.set(t, Integer.valueOf(value));
                            break;
                        case "class java.sql.Timestamp":
                            field.set(me, Timestamp.valueOf(value));
                            field.set(t, Timestamp.valueOf(value));
                            break;
                        //case "class java.lang.String":
                        default:
                            field.set(me, value);
                            field.set(t, value);
                            break;
                    }
                }
            } catch (Exception ex) {
                //
                log.error(ex.getStackTrace());
            }
        }
        return me;
    }
    /**
     * èŽ·å–å‚æ•°
     * Enumeration<String> headers = req.getHeaderNames();
     * Enumeration<String> attributes = req.getAttributeNames();
     */
    private Map<String, String> getParams(StandardMultipartHttpServletRequest req) {
        Map<String, String> map = new HashMap<String, String>(3);
        Enumeration<String> enumeration = req.getParameterNames();
        while (enumeration.hasMoreElements()) {
            String key = enumeration.nextElement();
            String value = req.getParameter(key);
            map.put(key, value);
        }
        return map;
    }
    /**
@@ -277,7 +108,7 @@
            mf.setPath(path + File.separator + mf.getName());
            file.transferTo(new File(mf.getPath()));
            mf.setGuid(getFileMd5(mf.getPath()));
            mf.setGuid(FileHelper.getFileMd5(mf.getPath()));
            list.add(mf);
        }
@@ -366,4 +197,22 @@
            return null;
        }
    }
    /**
     * èŽ·å–å‚æ•°
     * Enumeration<String> headers = req.getHeaderNames();
     * Enumeration<String> attributes = req.getAttributeNames();
     */
    private Map<String, String> getParams(StandardMultipartHttpServletRequest req) {
        Map<String, String> map = new HashMap<String, String>(3);
        Enumeration<String> enumeration = req.getParameterNames();
        while (enumeration.hasMoreElements()) {
            String key = enumeration.nextElement();
            String value = req.getParameter(key);
            map.put(key, value);
        }
        return map;
    }
}