1

13693261870

2022-10-11 03abc40237d5facd7a24628ed6afe0a014b49e1b

1

 data/db.sql

@@ -42,6 +42,7 @@
--update lf.sys_menu set bak=null,create_time=now() where 1=1;
delete from lf.sys_menu where id=40;
update lf.sys_menu set cn_name='黑/白名单',en_name='Black/White List' where id=41;
update lf.sys_menu set url='http://192.168.20.39:12316/sign/toDruid?token=',bak='databaseMonitoring' where id=42;

select * from lf.sys_menu order by id;
----------------------------------------------------------------------------------------------------- 2.单位表

 data/menu-Ö´ÐÐ.xls

Binary files differ

 src/main/java/com/lf/server/controller/data/StyleController.java

@@ -17,6 +17,7 @@
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
@@ -245,4 +246,14 @@

        return fileService.upload(ue, TAB_NAME, file, this);
    }

    @SysLog()
    @ApiOperation(value = "下载文件")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "guid", value = "附件Guid", dataType = "String", paramType = "body")
    })
    @GetMapping(value = "/download")
    public void download(String guid, HttpServletRequest req, HttpServletResponse res) {
        fileService.download(guid, req, res, this);
    }
}

 src/main/java/com/lf/server/controller/sys/ResController.java

@@ -17,6 +17,7 @@
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
@@ -240,4 +241,14 @@

        return fileService.upload(ue, TAB_NAME, file, this);
    }

    @SysLog()
    @ApiOperation(value = "下载文件")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "guid", value = "附件Guid", dataType = "String", paramType = "body")
    })
    @GetMapping(value = "/download")
    public void download(String guid, HttpServletRequest req, HttpServletResponse res) {
        fileService.download(guid, req, res, this);
    }
}

 src/main/java/com/lf/server/helper/FileHelper.java

@@ -11,9 +11,6 @@

    /**
     * èŽ·å–文件扩展名
     *
     * @param file æ–‡ä»¶
     * @return
     */
    public static String getExtension(File file) {
        if (file == null) {
@@ -30,6 +27,21 @@
        return fileName.substring(idx);
    }

    /**
     * èŽ·å–文件扩展名
     */
    public static String getExtension(String fileName) {
        if (StringHelper.isEmpty(fileName)) {
            return "";
        }

        int idx = fileName.lastIndexOf(POINT);
        if (idx == -1) {
            return "";
        }

        return fileName.substring(idx).toLowerCase();
    }

    /**
     * èŽ·å–多用途互联网邮件扩展类型

 src/main/java/com/lf/server/interceptor/AuthInterceptor.java

@@ -31,7 +31,6 @@

    private static final String NO_LOGIN = JSON.toJSONString(new ResponseMsg<String>(HttpStatus.NO_LOGIN_ERROR, "用户未登录"));


    public AuthInterceptor(TokenService tokenService) {
        this.tokenService = tokenService;
    }

 src/main/java/com/lf/server/service/all/FileService.java

@@ -1,12 +1,16 @@
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.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 com.sun.xml.internal.fastinfoset.tools.XML_SAX_StAX_FI;
import org.apache.commons.codec.digest.DigestUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
@@ -19,11 +23,13 @@
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.ServletContext;
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.net.URLEncoder;
import java.util.List;
import java.util.UUID;

@@ -43,6 +49,11 @@

    private final static Log log = LogFactory.getLog(FileService.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()) {
@@ -66,11 +77,10 @@
                return ctrl.success("文件已存在", md5);
            }

            String uploadPath = pathHelper.getUploadFullPath();
            String targetPath = uploadPath + File.separator + md5;
            AttachEntity ae = getAttachEntity(ue, tab, oldName, md5);
            String targetPath = pathHelper.getConfig().getUploadPath() + File.separator + ae.getPath();
            newFile.renameTo(new File(targetPath));

            AttachEntity ae = getAttachEntity(ue, tab, oldName, md5);
            int rows = attachService.insert(ae);

            return rows > 0 ? ctrl.success(md5) : ctrl.fail("保存文件失败", null);
@@ -102,6 +112,66 @@
    }

    /**
     * ä¸‹è½½æ–‡ä»¶
     */
    public void download(String guid, HttpServletRequest req, HttpServletResponse res, BaseController ctrl) {
        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.getMessage() + e.getStackTrace() + "\n");
            }
            log.error(ex.getMessage() + ex.getStackTrace() + "\n");
        }
    }

    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);
    }

    /**
     * ä¸Šä¼ æ–‡ä»¶
     *
     * @param req