devbox
小小林熬夜学编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

SpringBoot+Vue+OpenOffice实现文档管理(文档上传、下载、在线预览)_springboot+vue+onlyoffice开发在线编辑文档

作者：小小林熬夜学编程 | 2024-05-27 00:01:02

赞

踩

springboot+vue+onlyoffice开发在线编辑文档

场景

SpringBoot集成OpenOffice实现doc文档转html：

SpringBoot集成OpenOffice实现doc文档转html_BADAO_LIUMANG_QIZHI的博客-CSDN博客

在上面初步使用了OpenOffice之后，怎样实现文档管理，文档上传、下载、在线预览等。

首先OpenOffice的下载安装与启动服务参照上文，不再复述。

注：

博客：
BADAO_LIUMANG_QIZHI的博客_霸道流氓气质_CSDN博客
关注公众号
霸道的程序猿
获取编程相关电子书、教程推送与免费下载。

实现

1、搭建SpringBoot+Vue前后端分离项目

若依前后端分离版本地搭建开发环境并运行项目的教程：

若依前后端分离版手把手教你本地搭建环境并运行项目_BADAO_LIUMANG_QIZHI的博客-CSDN博客

2、设计表

数据库语句为

  1. DROP TABLE IF EXISTS `bus_file_preview`;
  2. CREATE TABLE `bus_file_preview`  (
  3.   `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  4.   `fileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原文件名（上传前文件名）',
  5.   `fileType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件后缀（.xls;.xlsx;.ppt;.doc;.docx;.pptx）',
  6.   `uploadPath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上传后文件路径',
  7.   `uploadFileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上传后文件名',
  8.   `pdfPath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转换pdf路径',
  9.   `pdfName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转换pdf文件名',
  10.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  11.   `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '创建人',
  12.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  13.   `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '更新人',
  14.   `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  15.   `preview_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预览URL',
  16.   PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件上传与预览' ROW_FORMAT = Dynamic;
  18.  
  19. SET FOREIGN_KEY_CHECKS = 1;

依照此表生成前后端代码，然后修改代码。

3、文件上传实现

前端按钮

  1.         <el-form-item label="附件" prop="photoPath">
  2.           <el-upload
  3.             :headers="headers"
  4.             :action="url"
  5.             :multiple="false"
  6.             :file-list="fileList"
  7.             :on-remove="fileRemove"
  8.             :on-success="uploadSuccess"
  9.             :on-error="uploadError"
  10.             :on-progress="uploadProgress"
  11.             :before-upload="beforeUpload"
  12.             :limit="1"
  13.             :on-exceed="beyond"
  14.             accept=".doc,.docx,.xls,.ppt,.xlsx,.pptx"
  15.           >
  16.             <el-button size="small">
  17.               上传
  18.               <i class="el-icon-upload el-icon--right"></i>
  19.             </el-button>
  20.             <div class="el-upload__tip" style="color: red" slot="tip">
  21.               提示：仅允许导入“.doc、.docx、.xls、.ppt、.xlsx、.pptx”格式文件！
  22.             </div>
  23.           </el-upload>
  24.         </el-form-item>

调用的各方法

  1.     // 文件上传失败
  2.     uploadError(err) {
  3.       this.btnLoding = false;
  4.       this.$message.error(res.msg);
  5.     },
  6.     // 上传中
  7.     uploadProgress(e) {
  8.       this.btnLoding = true;
  9.     },
  10.     // 文件上传之前
  11.     beforeUpload(file) {
  12.       console.log(file, "上传之前");
  13.       const fileName = file.name;
  14.       const fileType = fileName.substring(fileName.lastIndexOf("."));
  15.       if (
  16.         fileType === ".doc" ||
  17.         fileType === ".docx" ||
  18.         fileType === ".xls" ||
  19.         fileType === ".ppt" ||
  20.         fileType === ".pptx" ||
  21.         fileType === ".xlsx"
  22.       ) {
  23.         this.form.filename = file.name;
  24.         // 不处理
  25.       } else {
  26.         this.$message.error("请上传正确的文件类型,.doc,.docx,.xls,.ppt,.xlsx,.pptx,");
  27.         return false;
  28.       }
  29.     },
  30.     // 文件上传成功
  31.     uploadSuccess(res, file, fileList) {
  32.       this.form.uploadpath = res.uploadpath;
  33.       this.btnLoding = false;
  34.       this.fileList = fileList;
  35.       this.$message(res.msg);
  36.     },
  37.     beyond(file, fileList) {
  38.       this.$message({
  39.         message: "最多上传一个文件",
  40.         type: "warning",
  41.       });
  42.     },
  43.     // 移除选择的文件
  44.     fileRemove(file, fileList) {
  45.       this.btnLoding = false;
  46.       this.reset();
  47.       this.fileList = [];
  48.     },

对应后台SpingBoot通用上传接口

这里做了修改，使其能返回磁盘路径

  1.     /**
  2.      * 通用上传请求返回磁盘路径
  3.      */
  4.     @PostMapping("/common/uploadWithAbsolutePath")
  5.     public AjaxResult uploadFileWithAbsolutePath(MultipartFile file) throws Exception
  6.     {
  7.         try
  8.         {
  9.             // 上传文件路径
  10.             String filePath = RuoYiConfig.getUploadPath();
  11.             // 上传并返回新文件名称
  12.             String fileName = FileUploadUtils.uploadWithAbsolutePath(filePath, file);
  13.             AjaxResult ajax = AjaxResult.success();
  14.             ajax.put("uploadpath", filePath+ File.separator+fileName);
  15.             return ajax;
  16.         }
  17.         catch (Exception e)
  18.         {
  19.             return AjaxResult.error(e.getMessage());
  20.         }
  21.     }

调用的方法uploadWithAbsolutePath实现

  1.     public static final String uploadWithAbsolutePath(String baseDir, MultipartFile file) throws IOException
  2.     {
  3.         try
  4.         {
  5.             return uploadWithAbsolutePath(baseDir, file, MimeTypeUtils.DEFAULT_ALLOWED_EXTENSION);
  6.         }
  7.         catch (Exception e)
  8.         {
  9.             throw new IOException(e.getMessage(), e);
  10.         }
  11.     }

其中又调用的uploadWithAbsolutePath方法实现

  1.     public static final String uploadWithAbsolutePath(String baseDir, MultipartFile file, String[] allowedExtension)
  2.             throws FileSizeLimitExceededException, IOException, FileNameLengthLimitExceededException,
  3.             InvalidExtensionException
  4.     {
  5.         int fileNamelength = file.getOriginalFilename().length();
  6.         if (fileNamelength > FileUploadUtils.DEFAULT_FILE_NAME_LENGTH)
  7.         {
  8.             throw new FileNameLengthLimitExceededException(FileUploadUtils.DEFAULT_FILE_NAME_LENGTH);
  9.         }
  10.         assertAllowed(file, allowedExtension);
  11.         String fileName = extractFilename(file);
  12.         File desc = getAbsoluteFile(baseDir, fileName);
  13.         file.transferTo(desc);
  14.         return fileName;
  15.     }

其他的若依框架原来的方法。

上传效果

4、预览实现

上传之后的文件转换成pdf的实现，在提交按钮时调用后台就接口

  1.     /** 提交按钮 */
  2.     submitForm() {
  3.       this.$refs["form"].validate((valid) => {
  4.         if (valid) {
  5.           if (this.form.id != null) {
  6.             updatePreview(this.form).then((response) => {
  7.               this.msgSuccess("修改成功");
  8.               this.open = false;
  9.               this.fileList = [];
  10.               this.getList();
  11.             });
  12.           } else {
  13.             addPreview(this.form).then((response) => {
  14.               this.msgSuccess("新增成功");
  15.               this.open = false;
  16.               this.fileList = [];
  17.               this.getList();
  18.             });
  19.           }
  20.         }
  21.       });
  22.     },

首先是新增接口

  1.     /**
  2.      * 新增preview
  3.      */
  4.  
  5.     @Log(title = "preview", businessType = BusinessType.INSERT)
  6.     @PostMapping
  7.     public AjaxResult add(@RequestBody BusFilePreview busFilePreview) throws IOException{
  8.         if (StringUtils.isNull(busFilePreview.getFilename())) {
  9.             AjaxResult.error("缺少文件名称");
  10.         }
  11.         if (StringUtils.isNull(busFilePreview.getUploadpath())) {
  12.             AjaxResult.error("缺少上传文件路径");
  13.         }
  14.         String substringAfter = StringUtils.substringAfter(busFilePreview.getUploadpath(), ".");
  15.         String upName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  16.         busFilePreview.setUploadfilename(upName);
  17.         busFilePreview.setFiletype(substringAfter); //类型
  18.         if ("pdf".equals(substringAfter)){
  19.             FilePdfUtils.copyFile(busFilePreview.getUploadpath(), RuoYiConfig.getProfile());
  20.             String pdfName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  21.             busFilePreview.setPdfpath(RuoYiConfig.getProfile()+ "/" + pdfName);
  22.             busFilePreview.setPdfname(pdfName);
  23.             return  toAjax(busFilePreviewService.insertBusFilePreview(busFilePreview));
  24.         }
  25.  
  26.         File file = new File(busFilePreview.getUploadpath());
  27.         FileInputStream fileInputStream = new FileInputStream(file);
  28.         String htmFileName = FilePdfUtils.file2pdf(fileInputStream, substringAfter,RuoYiConfig.getProfile());
  29.         String pdfPath = RuoYiConfig.getProfile()+ "/" + htmFileName;
  30.         busFilePreview.setPdfpath(pdfPath);
  31.         String pdfName = StringUtils.substringAfterLast(pdfPath, "/");
  32.         busFilePreview.setPdfname(pdfName);
  33.         String previewUrl = serverConfig.getUrl()+ Constants.RESOURCE_PREFIX+File.separator+htmFileName;
  34.         busFilePreview.setPreviewUrl(previewUrl);
  35.         return toAjax(busFilePreviewService.insertBusFilePreview(busFilePreview));
  36.     }

这里调用了工具类中FilePdfUtils的file2pdf方法，并且将转换后的pdf的路径拼接成静态资源映射后的路径返回给前端。

关于静态资源映射可以参考如下

SpringBoot中通过重写WebMvcConfigurer的方法配置静态资源映射实现图片上传后返回网络Url：

SpringBoot中通过重写WebMvcConfigurer的方法配置静态资源映射实现图片上传后返回网络Url_BADAO_LIUMANG_QIZHI的博客-CSDN博客

5、FilePdfUtils工具类实现

  1. package com.ruoyi.common.utils.pdf;
  2.  
  3.  
  4. import com.artofsolving.jodconverter.DocumentConverter;
  5. import com.artofsolving.jodconverter.openoffice.connection.OpenOfficeConnection;
  6. import com.artofsolving.jodconverter.openoffice.connection.SocketOpenOfficeConnection;
  7. import com.artofsolving.jodconverter.openoffice.converter.StreamOpenOfficeDocumentConverter;
  8. import com.ruoyi.common.utils.StringUtils;
  9.  
  10. import java.io.*;
  11. import java.net.ConnectException;
  12. import java.text.SimpleDateFormat;
  13. import java.util.Date;
  14.  
  15. public class FilePdfUtils {
  16.  
  17.     /**
  18.      * 转换文件成pdf
  19.      *
  20.      * @param fromFileInputStream:
  21.      * @throws IOException
  22.      */
  23.     public static String file2pdf(InputStream fromFileInputStream, String type,String pdfPath) throws IOException {
  24.         Date date = new Date();
  25.         SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
  26.         String timesuffix = sdf.format(date);
  27.         String docFileName = null;
  28.         String htmFileName = null;
  29.         if("doc".equals(type)){
  30.             docFileName = "doc_" + timesuffix + ".doc";
  31.             htmFileName = "doc_" + timesuffix + ".pdf";
  32.         }else if("docx".equals(type)){
  33.             docFileName = "docx_" + timesuffix + ".docx";
  34.             htmFileName = "docx_" + timesuffix + ".pdf";
  35.         }else if("xls".equals(type)){
  36.             docFileName = "xls_" + timesuffix + ".xls";
  37.             htmFileName = "xls_" + timesuffix + ".pdf";
  38.         }else if("ppt".equals(type)){
  39.             docFileName = "ppt_" + timesuffix + ".ppt";
  40.             htmFileName = "ppt_" + timesuffix + ".pdf";
  41.         }else if("xlsx".equals(type)){
  42.             docFileName = "xlsx_" + timesuffix + ".xlsx";
  43.             htmFileName = "xlsx_" + timesuffix + ".pdf";
  44.         }else if("pptx".equals(type)){
  45.             docFileName = "pptx_" + timesuffix + ".pptx";
  46.             htmFileName = "pptx_" + timesuffix + ".pdf";
  47.         }else{
  48.             return null;
  49.         }
  50.  
  51.  
  52.         check_folder(pdfPath);
  53.  
  54.         File htmlOutputFile = new File(pdfPath + File.separatorChar + htmFileName);
  55.         File docInputFile = new File(pdfPath + File.separatorChar + docFileName);
  56.         if (htmlOutputFile.exists())
  57.             htmlOutputFile.delete();
  58.         htmlOutputFile.createNewFile();
  59.         if (docInputFile.exists())
  60.             docInputFile.delete();
  61.         docInputFile.createNewFile();
  62.         /**
  63.          * 由fromFileInputStream构建输入文件
  64.          */
  65.         try {
  66.             OutputStream os = new FileOutputStream(docInputFile);
  67.             int bytesRead = 0;
  68.             byte[] buffer = new byte[1024 * 8];
  69.             while ((bytesRead = fromFileInputStream.read(buffer)) != -1) {
  70.                 os.write(buffer, 0, bytesRead);
  71.             }
  72.  
  73.             os.close();
  74.             fromFileInputStream.close();
  75.         } catch (IOException e) {
  76.         }
  77.  
  78.         OpenOfficeConnection connection = new SocketOpenOfficeConnection(8100);
  79.         try {
  80.             connection.connect();
  81.         } catch (ConnectException e) {
  82.             System.err.println("文件转换出错，请检查OpenOffice服务是否启动。");
  83.         }
  84.  
  85.         DocumentConverter converter = new StreamOpenOfficeDocumentConverter(connection);
  86.         converter.convert(docInputFile, htmlOutputFile);
  87.         connection.disconnect();
  88.         // 转换完之后删除word文件
  89.         docInputFile.delete();
  90.         System.out.println(htmFileName);
  91.         return htmFileName;
  92.     }
  93.  
  94.     public static void check_folder(String path) {
  95.         File dir = new File(path);
  96.         // 判断文件夹是否存在
  97.         if (dir.isDirectory()) {
  98.         } else {
  99.             dir.mkdirs();
  100.         }
  101.     }
  102.  
  103.     public static void copyFile(String oldPath, String newPath) throws IOException {
  104.         File oldFile = new File(oldPath);//获取旧的文件File对象
  105.         File file = new File(newPath + oldFile.separator + StringUtils.substringAfterLast(oldPath, "/"));  //获取新的文件File对象并生成文件
  106.         FileInputStream in = new FileInputStream(oldFile);  //
  107.         FileOutputStream out = new FileOutputStream(file);
  108.  
  109.         byte[] buffer=new byte[2097152];
  110.         int readByte = 0;
  111.         //读取旧文件的流写入新文件里
  112.         while((readByte = in.read(buffer)) != -1){
  113.             out.write(buffer, 0, readByte);
  114.         }
  115.  
  116.         in.close();
  117.         out.close();
  118.     }
  119.  
  120. }

注意这里的连接openOffice的服务的端口要对应并且确保openOffice已经启动

 然后工具类FilePdfUtils是在common模块下，所以后台需要在此模块下pom文件中添加依赖

  1.         <dependency>
  2.             <groupId>com.artofsolving</groupId>
  3.             <artifactId>jodconverter</artifactId>
  4.             <version>2.2.1</version>
  5.         </dependency>

添加位置

注意这里的版本为2.2.1，Maven中央仓库中此为最高版本

这里在调用工具类转换文件时，如果文件类型为docx、pptx、xlsx时会报错提示

unknown document format for file ....docx

这是因为2.2.1的能转换doc ,但2.2.2才能转换docx,如果你用2.2.1的jar包,转换2.2.2的docx文档就会出错

除了不加载Maven中央仓库的2.1的依赖之外，还可以重写DocumentFormatRegistry接口的getFormatByFileExtension方法

注意包名一致

  1. package com.artofsolving.jodconverter;
  2.  
  3. import java.util.ArrayList;
  4. import java.util.Iterator;
  5. import java.util.List;
  6.  
  7. /**
  8.  * @ClassName: online
  9.  * @description: 重写 BasicDocumentFormatRegistry 文档格式
  10.  * @Author: yandongfa
  11.  * @Data: 2020-03-24 19:47
  12.  * @Version: 1.0
  13.  **/
  14. public class BasicDocumentFormatRegistry implements DocumentFormatRegistry {
  15.  
  16.     private List/* <DocumentFormat> */ documentFormats = new ArrayList();
  17.  
  18.     public void addDocumentFormat(DocumentFormat documentFormat) {
  19.         documentFormats.add(documentFormat);
  20.     }
  21.  
  22.     protected List/* <DocumentFormat> */ getDocumentFormats() {
  23.         return documentFormats;
  24.     }
  25.  
  26.     /**
  27.      * @param extension
  28.      *            the file extension
  29.      * @return the DocumentFormat for this extension, or null if the extension
  30.      *         is not mapped
  31.      */
  32.     public DocumentFormat getFormatByFileExtension(String extension) {
  33.         if (extension == null) {
  34.             return null;
  35.         }
  36.  
  37.         //new DefaultDocumentFormatRegistry();
  38.         //将文件名后缀统一转化
  39.         if (extension.indexOf("doc") >= 0) {
  40.             extension = "doc";
  41.         }
  42.         if (extension.indexOf("ppt") >= 0) {
  43.             extension = "ppt";
  44.         }
  45.         if (extension.indexOf("xls") >= 0) {
  46.             extension = "xls";
  47.         }
  48.         String lowerExtension = extension.toLowerCase();
  49.         for (Iterator it = documentFormats.iterator(); it.hasNext();) {
  50.             DocumentFormat format = (DocumentFormat) it.next();
  51.             if (format.getFileExtension().equals(lowerExtension)) {
  52.                 return format;
  53.             }
  54.         }
  55.         return null;
  56.     }
  57.  
  58.     public DocumentFormat getFormatByMimeType(String mimeType) {
  59.         for (Iterator it = documentFormats.iterator(); it.hasNext();) {
  60.             DocumentFormat format = (DocumentFormat) it.next();
  61.             if (format.getMimeType().equals(mimeType)) {
  62.                 return format;
  63.             }
  64.         }
  65.         return null;
  66.     }
  67. }

6、在线预览实现

  1.           <el-button
  2.             size="mini"
  3.             type="text"
  4.             icon="el-icon-edit"
  5.             @click="handlePreview(scope.row)"
  6.             >预览</el-button
  7.           >

调用js方法

  1.     // 预览
  2.     handlePreview(row) {
  3.       let url = row.previewUrl;
  4.       window.open(url);
  5.     },

这里直接打开url这个字段对应的地址即可，url是在进行文件转换成pdf时生成的映射的服务器上的url

String previewUrl = serverConfig.getUrl()+ Constants.RESOURCE_PREFIX+File.separator+htmFileName;

注意这里的预览地址如果有拦截，让在后台配置中放开白名单。

7、文件下载实现

  1.     // 下载
  2.     handleDownload(row) {
  3.       const baseURL = process.env.VUE_APP_BASE_API
  4.       window.location.href = baseURL + "/common/download/resourceeasy?resource=" + encodeURI(row.uploadpath);
  5.     },
  6.

这里直接修改后台的下载本地资源的通用下载方法

  1.     @GetMapping("/common/download/resourceeasy")
  2.     public void resourceDownloadEasy(String resource, HttpServletRequest request, HttpServletResponse response)
  3.             throws Exception
  4.     {
  5.         try
  6.         {
  7.             if (!FileUtils.checkAllowDownload(resource))
  8.             {
  9.                 throw new Exception(StringUtils.format("资源文件({})非法，不允许下载。 ", resource));
  10.             }
  11.             response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
  12.             FileUtils.setAttachmentResponseHeader(response, resource);
  13.             FileUtils.writeBytes(resource, response.getOutputStream());
  14.         }
  15.         catch (Exception e)
  16.         {
  17.             log.error("下载文件失败", e);
  18.         }
  19.     }

下载效果

8、各层完整代码

前端完整代码

  1. <template>
  2.   <div class="app-container">
  3.     <el-form
  4.       :model="queryParams"
  5.       ref="queryForm"
  6.       :inline="true"
  7.       v-show="showSearch"
  8.       label-width="68px"
  9.     >
  10.       <el-form-item label="原文件名" prop="filename">
  11.         <el-input
  12.           v-model="queryParams.filename"
  13.           placeholder="请输入原文件名"
  14.           clearable
  15.           size="small"
  16.           @keyup.enter.native="handleQuery"
  17.         />
  18.       </el-form-item>
  19.  
  20.       <el-form-item>
  21.         <el-button type="cyan" icon="el-icon-search" size="mini" @click="handleQuery"
  22.           >搜索</el-button
  23.         >
  24.         <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
  25.       </el-form-item>
  26.     </el-form>
  27.  
  28.     <el-row :gutter="10" class="mb8">
  29.       <el-col :span="1.5">
  30.         <el-button
  31.           type="primary"
  32.           icon="el-icon-plus"
  33.           size="mini"
  34.           @click="handleAdd"
  35.           v-hasPermi="['basicinfomanage:preview:add']"
  36.           >新增</el-button
  37.         >
  38.       </el-col>
  39.       <el-col :span="1.5">
  40.         <el-button
  41.           type="success"
  42.           icon="el-icon-edit"
  43.           size="mini"
  44.           :disabled="single"
  45.           @click="handleUpdate"
  46.           v-hasPermi="['basicinfomanage:preview:edit']"
  47.           >修改</el-button
  48.         >
  49.       </el-col>
  50.       <el-col :span="1.5">
  51.         <el-button
  52.           type="danger"
  53.           icon="el-icon-delete"
  54.           size="mini"
  55.           :disabled="multiple"
  56.           @click="handleDelete"
  57.           v-hasPermi="['basicinfomanage:preview:remove']"
  58.           >删除</el-button
  59.         >
  60.       </el-col>
  61.  
  62.       <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
  63.     </el-row>
  64.  
  65.     <el-table
  66.       v-loading="loading"
  67.       :data="previewList"
  68.       @selection-change="handleSelectionChange"
  69.     >
  70.       <el-table-column type="selection" width="55" align="center" />
  71.       <el-table-column
  72.         show-overflow-tooltip
  73.         label="文件名"
  74.         align="center"
  75.         prop="filename"
  76.       />
  77.       <el-table-column
  78.         show-overflow-tooltip
  79.         label="上传后文件路径"
  80.         align="center"
  81.         prop="uploadpath"
  82.       />
  83.       <el-table-column
  84.         show-overflow-tooltip
  85.         label="转换pdf路径"
  86.         align="center"
  87.         prop="pdfpath"
  88.         width="400"
  89.       />
  90.        <el-table-column
  91.         show-overflow-tooltip
  92.         label="预览地址"
  93.         align="center"
  94.         prop="previewUrl"
  95.         width="400"
  96.       />
  97.       <el-table-column show-overflow-tooltip label="备注" align="center" prop="remark" />
  98.       <el-table-column
  99.         label="操作"
  100.         align="center"
  101.         class-name="small-padding fixed-width"
  102.         width="200"
  103.       >
  104.         <template slot-scope="scope">
  105.           <el-button
  106.             size="mini"
  107.             type="text"
  108.             icon="el-icon-edit"
  109.             @click="handleUpdate(scope.row)"
  110.             v-hasPermi="['basicinfomanage:preview:edit']"
  111.             >修改</el-button
  112.           >
  113.           <el-button
  114.             size="mini"
  115.             type="text"
  116.             icon="el-icon-edit"
  117.             @click="handlePreview(scope.row)"
  118.             >预览</el-button
  119.           >
  120.           <el-button
  121.             size="mini"
  122.             type="text"
  123.             icon="el-icon-edit"
  124.             @click="handleDownload(scope.row)"
  125.             >下载</el-button
  126.           >
  127.           <el-button
  128.             size="mini"
  129.             type="text"
  130.             icon="el-icon-delete"
  131.             @click="handleDelete(scope.row)"
  132.             v-hasPermi="['basicinfomanage:preview:remove']"
  133.             >删除</el-button
  134.           >
  135.         </template>
  136.       </el-table-column>
  137.     </el-table>
  138.  
  139.     <pagination
  140.       v-show="total > 0"
  141.       :total="total"
  142.       :page.sync="queryParams.pageNum"
  143.       :limit.sync="queryParams.pageSize"
  144.       @pagination="getList"
  145.     />
  146.  
  147.     <!-- 添加或修改preview对话框 -->
  148.     <el-dialog :title="title" :visible.sync="open" width="35%" append-to-body>
  149.       <el-form ref="form" :model="form" :rules="rules" label-width="110px">
  150.         <el-form-item label="文件名" prop="filename">
  151.           <el-input v-model="form.filename" placeholder="请输入文件名" disabled />
  152.         </el-form-item>
  153.         <el-form-item label="上传后文件路径" prop="uploadpath">
  154.           <el-input v-model="form.uploadpath" placeholder="请输入上传后文件名" disabled />
  155.         </el-form-item>
  156.         <el-form-item label="备注" prop="remark">
  157.           <el-input v-model="form.remark" placeholder="请输入备注"  />
  158.         </el-form-item>
  159.         <el-form-item label="附件" prop="photoPath">
  160.           <el-upload
  161.             :headers="headers"
  162.             :action="url"
  163.             :multiple="false"
  164.             :file-list="fileList"
  165.             :on-remove="fileRemove"
  166.             :on-success="uploadSuccess"
  167.             :on-error="uploadError"
  168.             :on-progress="uploadProgress"
  169.             :before-upload="beforeUpload"
  170.             :limit="1"
  171.             :on-exceed="beyond"
  172.             accept=".doc,.docx,.xls,.ppt,.xlsx,.pptx"
  173.           >
  174.             <el-button size="small">
  175.               上传
  176.               <i class="el-icon-upload el-icon--right"></i>
  177.             </el-button>
  178.             <div class="el-upload__tip" style="color: red" slot="tip">
  179.               提示：仅允许导入“.doc、.docx、.xls、.ppt、.xlsx、.pptx”格式文件！
  180.             </div>
  181.           </el-upload>
  182.         </el-form-item>
  183.       </el-form>
  184.       <div slot="footer" class="dialog-footer">
  185.         <el-button type="primary" @click="submitForm">确 定</el-button>
  186.         <el-button @click="cancel">取 消</el-button>
  187.       </div>
  188.     </el-dialog>
  189.   </div>
  190. </template>
  191.  
  192. <script>
  193. import {
  194.   listPreview,
  195.   getPreview,
  196.   delPreview,
  197.   addPreview,
  198.   updatePreview,
  199. } from "@/api/system/preview";
  200. import { getToken } from "@/utils/auth";
  201.  
  202. export default {
  203.   name: "preview",
  204.   data() {
  205.     return {
  206.       // 遮罩层
  207.       loading: true,
  208.       // 选中数组
  209.       ids: [],
  210.       // 非单个禁用
  211.       single: true,
  212.       // 非多个禁用
  213.       multiple: true,
  214.       // 显示搜索条件
  215.       showSearch: true,
  216.       // 总条数
  217.       total: 0,
  218.       // preview表格数据
  219.       previewList: [],
  220.       // 弹出层标题
  221.       title: "",
  222.       // 是否显示弹出层
  223.       open: false,
  224.       // 查询参数
  225.       queryParams: {
  226.         pageNum: 1,
  227.         pageSize: 10,
  228.         filename: null,
  229.         filetype: null,
  230.         uploadpath: null,
  231.         pdfpath: null,
  232.         pdfname: null,
  233.       },
  234.       // 表单参数
  235.       form: {},
  236.       // 表单校验
  237.       rules: {
  238.         filename: [
  239.           {
  240.             required: true,
  241.             message: "文件名称不能为空",
  242.             trigger: "blur",
  243.           },
  244.         ],
  245.       },
  246.       // 上传按钮闸口
  247.       btnLoding: false,
  248.       //  请求头
  249.       headers: { Authorization: "Bearer" + " " + getToken() },
  250.       // 上传地址
  251.       url: process.env.VUE_APP_BASE_API + "/common/uploadWithAbsolutePath",
  252.       // 图片列表
  253.       fileList: [],
  254.     };
  255.   },
  256.   created() {
  257.     this.getList();
  258.   },
  259.   methods: {
  260.     /** 查询preview列表 */
  261.     getList() {
  262.       this.loading = true;
  263.       listPreview(this.queryParams).then((response) => {
  264.         this.previewList = response.rows;
  265.         this.total = response.total;
  266.         this.loading = false;
  267.       });
  268.     },
  269.     // 取消按钮
  270.     cancel() {
  271.       this.open = false;
  272.       this.reset();
  273.     },
  274.     // 表单重置
  275.     reset() {
  276.       this.form = {
  277.         id: null,
  278.         filename: null,
  279.         uploadpath: null,
  280.       };
  281.       this.resetForm("form");
  282.     },
  283.     /** 搜索按钮操作 */
  284.     handleQuery() {
  285.       this.queryParams.pageNum = 1;
  286.       this.getList();
  287.     },
  288.     /** 重置按钮操作 */
  289.     resetQuery() {
  290.       this.resetForm("queryForm");
  291.       this.handleQuery();
  292.     },
  293.     // 多选框选中数据
  294.     handleSelectionChange(selection) {
  295.       this.ids = selection.map((item) => item.id);
  296.       this.single = selection.length !== 1;
  297.       this.multiple = !selection.length;
  298.     },
  299.     /** 新增按钮操作 */
  300.     handleAdd() {
  301.       this.fileRemove();
  302.       this.open = true;
  303.       this.title = "添加文件";
  304.     },
  305.     /** 修改按钮操作 */
  306.     handleUpdate(row) {
  307.       this.reset();
  308.       const id = row.id || this.ids;
  309.       getPreview(id).then((response) => {
  310.         this.form = response.data;
  311.         this.open = true;
  312.         this.title = "修改文件";
  313.       });
  314.     },
  315.     // 预览
  316.     handlePreview(row) {
  317.       let url = row.previewUrl;
  318.       window.open(url);
  319.     },
  320.     // 下载
  321.     handleDownload(row) {
  322.       const baseURL = process.env.VUE_APP_BASE_API
  323.       window.location.href = baseURL + "/common/download/resourceeasy?resource=" + encodeURI(row.uploadpath);
  324.     },
  325.  
  326.     /** 提交按钮 */
  327.     submitForm() {
  328.       this.$refs["form"].validate((valid) => {
  329.         if (valid) {
  330.           if (this.form.id != null) {
  331.             updatePreview(this.form).then((response) => {
  332.               this.msgSuccess("修改成功");
  333.               this.open = false;
  334.               this.fileList = [];
  335.               this.getList();
  336.             });
  337.           } else {
  338.             addPreview(this.form).then((response) => {
  339.               this.msgSuccess("新增成功");
  340.               this.open = false;
  341.               this.fileList = [];
  342.               this.getList();
  343.             });
  344.           }
  345.         }
  346.       });
  347.     },
  348.     /** 删除按钮操作 */
  349.     handleDelete(row) {
  350.       const ids = row.id || this.ids;
  351.       this.$confirm('是否确认删除文件编号为"' + ids + '"的数据项?', "警告", {
  352.         confirmButtonText: "确定",
  353.         cancelButtonText: "取消",
  354.         type: "warning",
  355.       })
  356.         .then(function () {
  357.           return delPreview(ids);
  358.         })
  359.         .then(() => {
  360.           this.getList();
  361.           this.msgSuccess("删除成功");
  362.         });
  363.     },
  364.     // 文件上传失败
  365.     uploadError(err) {
  366.       this.btnLoding = false;
  367.       this.$message.error(res.msg);
  368.     },
  369.     // 上传中
  370.     uploadProgress(e) {
  371.       this.btnLoding = true;
  372.     },
  373.     // 文件上传之前
  374.     beforeUpload(file) {
  375.       console.log(file, "上传之前");
  376.       const fileName = file.name;
  377.       const fileType = fileName.substring(fileName.lastIndexOf("."));
  378.       if (
  379.         fileType === ".doc" ||
  380.         fileType === ".docx" ||
  381.         fileType === ".xls" ||
  382.         fileType === ".ppt" ||
  383.         fileType === ".pptx" ||
  384.         fileType === ".xlsx"
  385.       ) {
  386.         this.form.filename = file.name;
  387.         // 不处理
  388.       } else {
  389.         this.$message.error("请上传正确的文件类型,.doc,.docx,.xls,.ppt,.xlsx,.pptx,");
  390.         return false;
  391.       }
  392.     },
  393.     // 文件上传成功
  394.     uploadSuccess(res, file, fileList) {
  395.       this.form.uploadpath = res.uploadpath;
  396.       this.btnLoding = false;
  397.       this.fileList = fileList;
  398.       this.$message(res.msg);
  399.     },
  400.     beyond(file, fileList) {
  401.       this.$message({
  402.         message: "最多上传一个文件",
  403.         type: "warning",
  404.       });
  405.     },
  406.     // 移除选择的文件
  407.     fileRemove(file, fileList) {
  408.       this.btnLoding = false;
  409.       this.reset();
  410.       this.fileList = [];
  411.     },
  412.   },
  413. };
  414. </script>

前端js代码

  1. ​
  2. import request from '@/utils/request'
  3.  
  4.  
  5. // 查询preview列表
  6. export function listPreview(query) {
  7.   return request({
  8.     url: '/system/preview/list',
  9.     method: 'get',
  10.     params: query
  11.   })
  12. }
  13.  
  14. // 查询preview详细
  15. export function getPreview(id) {
  16.   return request({
  17.     url: '/system/preview/' + id,
  18.     method: 'get'
  19.   })
  20. }
  21.  
  22. // 新增preview
  23. export function addPreview(data) {
  24.   return request({
  25.     url: '/system/preview',
  26.     method: 'post',
  27.     data: data
  28.   })
  29. }
  30.  
  31. // 修改preview
  32. export function updatePreview(data) {
  33.   return request({
  34.     url: '/system/preview',
  35.     method: 'put',
  36.     data: data
  37.   })
  38. }
  39.  
  40. // 删除preview
  41. export function delPreview(id) {
  42.   return request({
  43.     url: '/system/preview/' + id,
  44.     method: 'delete'
  45.   })
  46. }
  47.  
  48. ​

后台实体类

  1. package com.ruoyi.system.domain;
  2.  
  3. import com.ruoyi.common.annotation.Excel;
  4. import com.ruoyi.common.core.domain.BaseEntity;
  5. import org.apache.commons.lang3.builder.ToStringBuilder;
  6. import org.apache.commons.lang3.builder.ToStringStyle;
  7.  
  8. public class BusFilePreview extends BaseEntity
  9. {
  10.     private static final long serialVersionUID = 1L;
  11.  
  12.     /** 主键 */
  13.     private Long id;
  14.  
  15.     /** 原文件名（上传前文件名） */
  16.     @Excel(name = "原文件名", readConverterExp = "上传前文件名")
  17.     private String filename;
  18.  
  19.     /** 文件后缀（.xls;.xlsx;.ppt;.doc;.docx;.pptx） */
  20.     @Excel(name = "文件后缀", readConverterExp = ".=xls;.xlsx;.ppt;.doc;.docx;.pptx")
  21.     private String filetype;
  22.  
  23.     /** 上传后文件路径 */
  24.     @Excel(name = "上传后文件路径")
  25.     private String uploadpath;
  26.  
  27.     /** 上传后文件名 */
  28.     @Excel(name = "上传后文件名")
  29.     private String uploadfilename;
  30.  
  31.     /** 转换pdf路径 */
  32.     @Excel(name = "转换pdf路径")
  33.     private String pdfpath;
  34.  
  35.     /** 转换pdf文件名 */
  36.     @Excel(name = "转换pdf文件名")
  37.     private String pdfname;
  38.  
  39.     /** 预览地址 */
  40.     @Excel(name = "预览地址")
  41.     private String previewUrl;
  42.  
  43.     public String getPreviewUrl() {
  44.         return previewUrl;
  45.     }
  46.  
  47.     public void setPreviewUrl(String previewUrl) {
  48.         this.previewUrl = previewUrl;
  49.     }
  50.  
  51.     public void setId(Long id)
  52.     {
  53.         this.id = id;
  54.     }
  55.  
  56.     public Long getId()
  57.     {
  58.         return id;
  59.     }
  60.     public void setFilename(String filename)
  61.     {
  62.         this.filename = filename;
  63.     }
  64.  
  65.     public String getFilename()
  66.     {
  67.         return filename;
  68.     }
  69.     public void setFiletype(String filetype)
  70.     {
  71.         this.filetype = filetype;
  72.     }
  73.  
  74.     public String getFiletype()
  75.     {
  76.         return filetype;
  77.     }
  78.     public void setUploadpath(String uploadpath)
  79.     {
  80.         this.uploadpath = uploadpath;
  81.     }
  82.  
  83.     public String getUploadpath()
  84.     {
  85.         return uploadpath;
  86.     }
  87.     public void setUploadfilename(String uploadfilename)
  88.     {
  89.         this.uploadfilename = uploadfilename;
  90.     }
  91.  
  92.     public String getUploadfilename()
  93.     {
  94.         return uploadfilename;
  95.     }
  96.     public void setPdfpath(String pdfpath)
  97.     {
  98.         this.pdfpath = pdfpath;
  99.     }
  100.  
  101.     public String getPdfpath()
  102.     {
  103.         return pdfpath;
  104.     }
  105.     public void setPdfname(String pdfname)
  106.     {
  107.         this.pdfname = pdfname;
  108.     }
  109.  
  110.     public String getPdfname()
  111.     {
  112.         return pdfname;
  113.     }
  114.  
  115.     @Override
  116.     public String toString() {
  117.         return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
  118.                 .append("id", getId())
  119.                 .append("filename", getFilename())
  120.                 .append("filetype", getFiletype())
  121.                 .append("uploadpath", getUploadpath())
  122.                 .append("uploadfilename", getUploadfilename())
  123.                 .append("pdfpath", getPdfpath())
  124.                 .append("pdfname", getPdfname())
  125.                 .append("createTime", getCreateTime())
  126.                 .append("createBy", getCreateBy())
  127.                 .append("updateTime", getUpdateTime())
  128.                 .append("updateBy", getUpdateBy())
  129.                 .append("remark", getRemark())
  130.                 .toString();
  131.     }
  132. }

后台mapper.xml

  1. ​
  2. <?xml version="1.0" encoding="UTF-8" ?>
  3. <!DOCTYPE mapper
  4. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  5. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  6. <mapper namespace="com.ruoyi.system.mapper.BusFilePreviewMapper">
  7.  
  8.     <resultMap type="BusFilePreview" id="BusFilePreviewResult">
  9.         <result property="id"    column="id"    />
  10.         <result property="filename"    column="fileName"    />
  11.         <result property="filetype"    column="fileType"    />
  12.         <result property="uploadpath"    column="uploadPath"    />
  13.         <result property="uploadfilename"    column="uploadFileName"    />
  14.         <result property="pdfpath"    column="pdfPath"    />
  15.         <result property="pdfname"    column="pdfName"    />
  16.         <result property="createTime"    column="create_time"    />
  17.         <result property="createBy"    column="create_by"    />
  18.         <result property="updateTime"    column="update_time"    />
  19.         <result property="updateBy"    column="update_by"    />
  20.         <result property="remark"    column="remark"    />
  21.         <result property="previewUrl"    column="preview_url"    />
  22.     </resultMap>
  23.  
  24.     <sql id="selectBusFilePreviewVo">
  25.         select id, fileName, fileType, uploadPath, uploadFileName, pdfPath, pdfName, create_time, create_by, update_time, update_by, remark ,preview_url from bus_file_preview
  26.     </sql>
  27.  
  28.     <select id="selectBusFilePreviewList" parameterType="BusFilePreview" resultMap="BusFilePreviewResult">
  29.         <include refid="selectBusFilePreviewVo"/>
  30.         <where>
  31.             <if test="filename != null  and filename != ''"> and fileName like concat('%', #{filename}, '%')</if>
  32.             <if test="filetype != null  and filetype != ''"> and fileType = #{filetype}</if>
  33.             <if test="uploadpath != null  and uploadpath != ''"> and uploadPath = #{uploadpath}</if>
  34.             <if test="uploadfilename != null  and uploadfilename != ''"> and uploadFileName like concat('%', #{uploadfilename}, '%')</if>
  35.             <if test="pdfpath != null  and pdfpath != ''"> and pdfPath = #{pdfpath}</if>
  36.             <if test="pdfname != null  and pdfname != ''"> and pdfName like concat('%', #{pdfname}, '%')</if>
  37.         </where>
  38.     </select>
  39.  
  40.     <select id="selectBusFilePreviewById" parameterType="Long" resultMap="BusFilePreviewResult">
  41.         <include refid="selectBusFilePreviewVo"/>
  42.         where id = #{id}
  43.     </select>
  44.  
  45.     <insert id="insertBusFilePreview" parameterType="BusFilePreview" useGeneratedKeys="true" keyProperty="id">
  46.         insert into bus_file_preview
  47.         <trim prefix="(" suffix=")" suffixOverrides=",">
  48.             <if test="filename != null">fileName,</if>
  49.             <if test="filetype != null">fileType,</if>
  50.             <if test="uploadpath != null">uploadPath,</if>
  51.             <if test="uploadfilename != null">uploadFileName,</if>
  52.             <if test="pdfpath != null">pdfPath,</if>
  53.             <if test="pdfname != null">pdfName,</if>
  54.             <if test="createTime != null">create_time,</if>
  55.             <if test="createBy != null">create_by,</if>
  56.             <if test="updateTime != null">update_time,</if>
  57.             <if test="updateBy != null">update_by,</if>
  58.             <if test="remark != null">remark,</if>
  59.             <if test="previewUrl != null">preview_url,</if>
  60.  
  61.          </trim>
  62.         <trim prefix="values (" suffix=")" suffixOverrides=",">
  63.             <if test="filename != null">#{filename},</if>
  64.             <if test="filetype != null">#{filetype},</if>
  65.             <if test="uploadpath != null">#{uploadpath},</if>
  66.             <if test="uploadfilename != null">#{uploadfilename},</if>
  67.             <if test="pdfpath != null">#{pdfpath},</if>
  68.             <if test="pdfname != null">#{pdfname},</if>
  69.             <if test="createTime != null">#{createTime},</if>
  70.             <if test="createBy != null">#{createBy},</if>
  71.             <if test="updateTime != null">#{updateTime},</if>
  72.             <if test="updateBy != null">#{updateBy},</if>
  73.             <if test="remark != null">#{remark},</if>
  74.             <if test="previewUrl != null">#{previewUrl},</if>
  75.          </trim>
  76.     </insert>
  77.  
  78.     <update id="updateBusFilePreview" parameterType="BusFilePreview">
  79.         update bus_file_preview
  80.         <trim prefix="SET" suffixOverrides=",">
  81.             <if test="filename != null">fileName = #{filename},</if>
  82.             <if test="filetype != null">fileType = #{filetype},</if>
  83.             <if test="uploadpath != null">uploadPath = #{uploadpath},</if>
  84.             <if test="uploadfilename != null">uploadFileName = #{uploadfilename},</if>
  85.             <if test="pdfpath != null">pdfPath = #{pdfpath},</if>
  86.             <if test="pdfname != null">pdfName = #{pdfname},</if>
  87.             <if test="createTime != null">create_time = #{createTime},</if>
  88.             <if test="createBy != null">create_by = #{createBy},</if>
  89.             <if test="updateTime != null">update_time = #{updateTime},</if>
  90.             <if test="updateBy != null">update_by = #{updateBy},</if>
  91.             <if test="remark != null">remark = #{remark},</if>
  92.             <if test="previewUrl != null">preview_url = #{previewUrl},</if>
  93.         </trim>
  94.         where id = #{id}
  95.     </update>
  96.  
  97.     <delete id="deleteBusFilePreviewById" parameterType="Long">
  98.         delete from bus_file_preview where id = #{id}
  99.     </delete>
  100.  
  101.     <delete id="deleteBusFilePreviewByIds" parameterType="String">
  102.         delete from bus_file_preview where id in
  103.         <foreach item="id" collection="array" open="(" separator="," close=")">
  104.             #{id}
  105.         </foreach>
  106.     </delete>
  107.  
  108. </mapper>
  109.  
  110. ​

后台mapper接口

  1. package com.ruoyi.system.mapper;
  2.  
  3.  
  4.  
  5. import com.ruoyi.system.domain.BusFilePreview;
  6.  
  7. import java.util.List;
  8.  
  9. /**
  10.  * previewMapper接口
  11.  *
  12.  * @author ruoyi
  13.  * @date 2021-10-29
  14.  */
  15. public interface BusFilePreviewMapper
  16. {
  17.     /**
  18.      * 查询preview
  19.      *
  20.      * @param id previewID
  21.      * @return preview
  22.      */
  23.     public BusFilePreview selectBusFilePreviewById(Long id);
  24.  
  25.     /**
  26.      * 查询preview列表
  27.      *
  28.      * @param busFilePreview preview
  29.      * @return preview集合
  30.      */
  31.     public List<BusFilePreview> selectBusFilePreviewList(BusFilePreview busFilePreview);
  32.  
  33.     /**
  34.      * 新增preview
  35.      *
  36.      * @param busFilePreview preview
  37.      * @return 结果
  38.      */
  39.     public int insertBusFilePreview(BusFilePreview busFilePreview);
  40.  
  41.     /**
  42.      * 修改preview
  43.      *
  44.      * @param busFilePreview preview
  45.      * @return 结果
  46.      */
  47.     public int updateBusFilePreview(BusFilePreview busFilePreview);
  48.  
  49.     /**
  50.      * 删除preview
  51.      *
  52.      * @param id previewID
  53.      * @return 结果
  54.      */
  55.     public int deleteBusFilePreviewById(Long id);
  56.  
  57.     /**
  58.      * 批量删除preview
  59.      *
  60.      * @param ids 需要删除的数据ID
  61.      * @return 结果
  62.      */
  63.     public int deleteBusFilePreviewByIds(Long[] ids);
  64. }

后台service接口

  1. package com.ruoyi.system.service;
  2.  
  3.  
  4. import com.ruoyi.system.domain.BusFilePreview;
  5.  
  6. import java.util.List;
  7.  
  8. /**
  9.  * previewService接口
  10.  *
  11.  * @author ruoyi
  12.  * @date 2021-10-29
  13.  */
  14. public interface IBusFilePreviewService
  15. {
  16.     /**
  17.      * 查询preview
  18.      *
  19.      * @param id previewID
  20.      * @return preview
  21.      */
  22.     public BusFilePreview selectBusFilePreviewById(Long id);
  23.  
  24.     /**
  25.      * 查询preview列表
  26.      *
  27.      * @param busFilePreview preview
  28.      * @return preview集合
  29.      */
  30.     public List<BusFilePreview> selectBusFilePreviewList(BusFilePreview busFilePreview);
  31.  
  32.     /**
  33.      * 新增preview
  34.      *
  35.      * @param busFilePreview preview
  36.      * @return 结果
  37.      */
  38.     public int insertBusFilePreview(BusFilePreview busFilePreview);
  39.  
  40.     /**
  41.      * 修改preview
  42.      *
  43.      * @param busFilePreview preview
  44.      * @return 结果
  45.      */
  46.     public int updateBusFilePreview(BusFilePreview busFilePreview);
  47.  
  48.     /**
  49.      * 批量删除preview
  50.      *
  51.      * @param ids 需要删除的previewID
  52.      * @return 结果
  53.      */
  54.     public int deleteBusFilePreviewByIds(Long[] ids);
  55.  
  56.     /**
  57.      * 删除preview信息
  58.      *
  59.      * @param id previewID
  60.      * @return 结果
  61.      */
  62.     public int deleteBusFilePreviewById(Long id);
  63. }

后台serviceImpl

  1. package com.ruoyi.system.service.impl;
  2.  
  3.  
  4. import com.ruoyi.common.utils.DateUtils;
  5. import com.ruoyi.common.utils.SecurityUtils;
  6. import com.ruoyi.system.domain.BusFilePreview;
  7. import com.ruoyi.system.mapper.BusFilePreviewMapper;
  8. import com.ruoyi.system.service.IBusFilePreviewService;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Service;
  11.  
  12. import java.util.List;
  13.  
  14. /**
  15.  * previewService业务层处理
  16.  *
  17.  * @author ruoyi
  18.  * @date 2021-10-29
  19.  */
  20. @Service
  21. public class BusFilePreviewServiceImpl implements IBusFilePreviewService
  22. {
  23.     @Autowired
  24.     private BusFilePreviewMapper busFilePreviewMapper;
  25.  
  26.     /**
  27.      * 查询preview
  28.      *
  29.      * @param id previewID
  30.      * @return preview
  31.      */
  32.     @Override
  33.     public BusFilePreview selectBusFilePreviewById(Long id)
  34.     {
  35.         return busFilePreviewMapper.selectBusFilePreviewById(id);
  36.     }
  37.  
  38.     /**
  39.      * 查询preview列表
  40.      *
  41.      * @param busFilePreview preview
  42.      * @return preview
  43.      */
  44.     @Override
  45.     public List<BusFilePreview> selectBusFilePreviewList(BusFilePreview busFilePreview)
  46.     {
  47.         return busFilePreviewMapper.selectBusFilePreviewList(busFilePreview);
  48.     }
  49.  
  50.     /**
  51.      * 新增preview
  52.      *
  53.      * @param busFilePreview preview
  54.      * @return 结果
  55.      */
  56.     @Override
  57.     public int insertBusFilePreview(BusFilePreview busFilePreview)
  58.     {
  59.         busFilePreview.setCreateTime(DateUtils.getNowDate());
  60.         busFilePreview.setCreateBy(String.valueOf(SecurityUtils.getUsername()));// 创建人
  61.         return busFilePreviewMapper.insertBusFilePreview(busFilePreview);
  62.     }
  63.  
  64.     /**
  65.      * 修改preview
  66.      *
  67.      * @param busFilePreview preview
  68.      * @return 结果
  69.      */
  70.     @Override
  71.     public int updateBusFilePreview(BusFilePreview busFilePreview)
  72.     {
  73.         busFilePreview.setUpdateTime(DateUtils.getNowDate());
  74.         busFilePreview.setUpdateBy(String.valueOf(SecurityUtils.getUsername()));// 创建人
  75.         return busFilePreviewMapper.updateBusFilePreview(busFilePreview);
  76.     }
  77.  
  78.     /**
  79.      * 批量删除preview
  80.      *
  81.      * @param ids 需要删除的previewID
  82.      * @return 结果
  83.      */
  84.     @Override
  85.     public int deleteBusFilePreviewByIds(Long[] ids)
  86.     {
  87.         return busFilePreviewMapper.deleteBusFilePreviewByIds(ids);
  88.     }
  89.  
  90.     /**
  91.      * 删除preview信息
  92.      *
  93.      * @param id previewID
  94.      * @return 结果
  95.      */
  96.     @Override
  97.     public int deleteBusFilePreviewById(Long id)
  98.     {
  99.         return busFilePreviewMapper.deleteBusFilePreviewById(id);
  100.     }
  101. }

后台Controller

  1. package com.ruoyi.web.controller.system;
  2.  
  3. import com.ruoyi.common.annotation.Log;
  4. import com.ruoyi.common.config.RuoYiConfig;
  5. import com.ruoyi.common.constant.Constants;
  6. import com.ruoyi.common.core.controller.BaseController;
  7. import com.ruoyi.common.core.domain.AjaxResult;
  8. import com.ruoyi.common.core.page.TableDataInfo;
  9. import com.ruoyi.common.enums.BusinessType;
  10. import com.ruoyi.common.utils.StringUtils;
  11. import com.ruoyi.common.utils.pdf.FilePdfUtils;
  12. import com.ruoyi.common.utils.poi.ExcelUtil;
  13. import com.ruoyi.framework.config.ServerConfig;
  14. import com.ruoyi.system.domain.BusFilePreview;
  15. import com.ruoyi.system.service.IBusFilePreviewService;
  16. import io.swagger.annotations.ApiOperation;
  17. import org.springframework.beans.factory.annotation.Autowired;
  18. import org.springframework.security.access.prepost.PreAuthorize;
  19. import org.springframework.web.bind.annotation.*;
  20.  
  21. import javax.servlet.http.HttpServletRequest;
  22. import javax.servlet.http.HttpServletResponse;
  23. import java.io.File;
  24. import java.io.FileInputStream;
  25. import java.io.IOException;
  26. import java.util.List;
  27.  
  28. /**
  29.  * previewController
  30.  *
  31.  * @author ruoyi
  32.  * @date 2021-10-29
  33.  */
  34. @RestController
  35. @RequestMapping("/system/preview")
  36. public class BusFilePreviewController extends BaseController
  37. {
  38.     @Autowired
  39.     private IBusFilePreviewService busFilePreviewService;
  40.  
  41.     @Autowired
  42.     private ServerConfig serverConfig;
  43.  
  44.     /**
  45.      * 查询preview列表
  46.      */
  47.     @GetMapping("/list")
  48.     public TableDataInfo list(BusFilePreview busFilePreview)
  49.     {
  50.         startPage();
  51.         List<BusFilePreview> list = busFilePreviewService.selectBusFilePreviewList(busFilePreview);
  52.         return getDataTable(list);
  53.     }
  54.  
  55.     /**
  56.      * 获取preview详细信息
  57.      */
  58.  
  59.     @GetMapping(value = "/{id}")
  60.     public AjaxResult getInfo(@PathVariable("id") Long id)
  61.     {
  62.         return AjaxResult.success(busFilePreviewService.selectBusFilePreviewById(id));
  63.     }
  64.  
  65.     /**
  66.      * 新增preview
  67.      */
  68.  
  69.     @Log(title = "preview", businessType = BusinessType.INSERT)
  70.     @PostMapping
  71.     public AjaxResult add(@RequestBody BusFilePreview busFilePreview) throws IOException{
  72.         if (StringUtils.isNull(busFilePreview.getFilename())) {
  73.             AjaxResult.error("缺少文件名称");
  74.         }
  75.         if (StringUtils.isNull(busFilePreview.getUploadpath())) {
  76.             AjaxResult.error("缺少上传文件路径");
  77.         }
  78.         String substringAfter = StringUtils.substringAfter(busFilePreview.getUploadpath(), ".");
  79.         String upName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  80.         busFilePreview.setUploadfilename(upName);
  81.         busFilePreview.setFiletype(substringAfter); //类型
  82.         if ("pdf".equals(substringAfter)){
  83.             FilePdfUtils.copyFile(busFilePreview.getUploadpath(), RuoYiConfig.getProfile());
  84.             String pdfName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  85.             busFilePreview.setPdfpath(RuoYiConfig.getProfile()+ "/" + pdfName);
  86.             busFilePreview.setPdfname(pdfName);
  87.             return  toAjax(busFilePreviewService.insertBusFilePreview(busFilePreview));
  88.         }
  89.  
  90.         File file = new File(busFilePreview.getUploadpath());
  91.         FileInputStream fileInputStream = new FileInputStream(file);
  92.         String htmFileName = FilePdfUtils.file2pdf(fileInputStream, substringAfter,RuoYiConfig.getProfile());
  93.         String pdfPath = RuoYiConfig.getProfile()+ "/" + htmFileName;
  94.         busFilePreview.setPdfpath(pdfPath);
  95.         String pdfName = StringUtils.substringAfterLast(pdfPath, "/");
  96.         busFilePreview.setPdfname(pdfName);
  97.         String previewUrl = serverConfig.getUrl()+ Constants.RESOURCE_PREFIX+File.separator+htmFileName;
  98.         busFilePreview.setPreviewUrl(previewUrl);
  99.         return toAjax(busFilePreviewService.insertBusFilePreview(busFilePreview));
  100.     }
  101.  
  102.     /**
  103.      * 修改preview
  104.      */
  105.     @Log(title = "preview", businessType = BusinessType.UPDATE)
  106.     @PutMapping
  107.     public AjaxResult edit(@RequestBody BusFilePreview busFilePreview) throws IOException {
  108.         if (StringUtils.isNull(busFilePreview.getFilename())) {
  109.             AjaxResult.error("缺少文件名称");
  110.         }
  111.         if (StringUtils.isNull(busFilePreview.getUploadpath())) {
  112.             AjaxResult.error("缺少上传文件路径");
  113.         }
  114.         String substringAfter = StringUtils.substringAfter(busFilePreview.getUploadpath(), ".");
  115.         String upName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  116.         busFilePreview.setUploadfilename(upName);
  117.         busFilePreview.setFiletype(substringAfter); //类型
  118.         if ("pdf".equals(substringAfter)){
  119.             FilePdfUtils.copyFile(busFilePreview.getUploadpath(), RuoYiConfig.getProfile());
  120.             String pdfName = StringUtils.substringAfterLast(busFilePreview.getUploadpath(), "/");
  121.             busFilePreview.setPdfpath(RuoYiConfig.getProfile()+ "/" + pdfName);
  122.             busFilePreview.setPdfname(pdfName);
  123.             return  toAjax(busFilePreviewService.insertBusFilePreview(busFilePreview));
  124.         }
  125.  
  126.         File file = new File(busFilePreview.getUploadpath());
  127.         FileInputStream fileInputStream = new FileInputStream(file);
  128.         String htmFileName = FilePdfUtils.file2pdf(fileInputStream, substringAfter,RuoYiConfig.getProfile());
  129.         String pdfPath = RuoYiConfig.getProfile()+ "/" + htmFileName;
  130.         busFilePreview.setPdfpath(pdfPath);
  131.         String pdfName = StringUtils.substringAfterLast(pdfPath, "/");
  132.         busFilePreview.setPdfname(pdfName);
  133.         String previewUrl = serverConfig.getUrl()+ Constants.RESOURCE_PREFIX+File.separator+htmFileName;
  134.         busFilePreview.setPreviewUrl(previewUrl);
  135.         return toAjax(busFilePreviewService.updateBusFilePreview(busFilePreview));
  136.     }
  137.  
  138.     /**
  139.      * 删除preview
  140.      */
  141.     @Log(title = "preview", businessType = BusinessType.DELETE)
  142.  @DeleteMapping("/{ids}")
  143.     public AjaxResult remove(@PathVariable Long[] ids)
  144.     {
  145.         return toAjax(busFilePreviewService.deleteBusFilePreviewByIds(ids));
  146.     }
  147.  
  148.     @GetMapping("/pdf")
  149.     @ApiOperation(value = "预览")
  150.     public void prePDF(Long id, HttpServletRequest request, HttpServletResponse response) throws IOException {
  151.         BusFilePreview busFilePreview = busFilePreviewService.selectBusFilePreviewById(id);
  152.         if (StringUtils.isNotNull(busFilePreview) && StringUtils.isNotNull(busFilePreview.getPdfpath())) {
  153.             File file = new File(busFilePreview.getPdfpath());
  154.             if (file.exists()) {
  155.                 byte[] data = null;
  156.                 try {
  157.                     FileInputStream input = new FileInputStream(file);
  158.                     data = new byte[input.available()];
  159.                     input.read(data);
  160.                     response.getOutputStream().write(data);
  161.                     input.close();
  162.                 } catch (Exception e) {
  163.                     e.printStackTrace();
  164.                 }
  165.             } else if (!file.exists()){
  166.                 BusFilePreview filePreview = new BusFilePreview();
  167.                 filePreview.setId(id);
  168.                 filePreview.setRemark("文件不存在");
  169.                 busFilePreviewService.updateBusFilePreview(filePreview);
  170.             }
  171.         }
  172.     }
  173. }

后台通用Controller

  1. package com.ruoyi.web.controller.common;
  2.  
  3. import javax.servlet.http.HttpServletRequest;
  4. import javax.servlet.http.HttpServletResponse;
  5. import org.slf4j.Logger;
  6. import org.slf4j.LoggerFactory;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.http.MediaType;
  9. import org.springframework.web.bind.annotation.GetMapping;
  10. import org.springframework.web.bind.annotation.PostMapping;
  11. import org.springframework.web.bind.annotation.RestController;
  12. import org.springframework.web.multipart.MultipartFile;
  13. import com.ruoyi.common.config.RuoYiConfig;
  14. import com.ruoyi.common.constant.Constants;
  15. import com.ruoyi.common.core.domain.AjaxResult;
  16. import com.ruoyi.common.utils.StringUtils;
  17. import com.ruoyi.common.utils.file.FileUploadUtils;
  18. import com.ruoyi.common.utils.file.FileUtils;
  19. import com.ruoyi.framework.config.ServerConfig;
  20.  
  21. import java.io.File;
  22.  
  23. /**
  24.  * 通用请求处理
  25.  *
  26.  * @author ruoyi
  27.  */
  28. @RestController
  29. public class CommonController
  30. {
  31.     private static final Logger log = LoggerFactory.getLogger(CommonController.class);
  32.  
  33.     @Autowired
  34.     private ServerConfig serverConfig;
  35.  
  36.     /**
  37.      * 通用下载请求
  38.      *
  39.      * @param fileName 文件名称
  40.      * @param delete 是否删除
  41.      */
  42.     @GetMapping("common/download")
  43.     public void fileDownload(String fileName, Boolean delete, HttpServletResponse response, HttpServletRequest request)
  44.     {
  45.         try
  46.         {
  47.             if (!FileUtils.checkAllowDownload(fileName))
  48.             {
  49.                 throw new Exception(StringUtils.format("文件名称({})非法，不允许下载。 ", fileName));
  50.             }
  51.             String realFileName = System.currentTimeMillis() + fileName.substring(fileName.indexOf("_") + 1);
  52.             String filePath = RuoYiConfig.getDownloadPath() + fileName;
  53.  
  54.             response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
  55.             FileUtils.setAttachmentResponseHeader(response, realFileName);
  56.             FileUtils.writeBytes(filePath, response.getOutputStream());
  57.             if (delete)
  58.             {
  59.                 FileUtils.deleteFile(filePath);
  60.             }
  61.         }
  62.         catch (Exception e)
  63.         {
  64.             log.error("下载文件失败", e);
  65.         }
  66.     }
  67.  
  68.     /**
  69.      * 通用上传请求
  70.      */
  71.     @PostMapping("/common/upload")
  72.     public AjaxResult uploadFile(MultipartFile file) throws Exception
  73.     {
  74.         try
  75.         {
  76.             // 上传文件路径
  77.             String filePath = RuoYiConfig.getUploadPath();
  78.             // 上传并返回新文件名称
  79.             String fileName = FileUploadUtils.upload(filePath, file);
  80.             String url = serverConfig.getUrl() + fileName;
  81.             AjaxResult ajax = AjaxResult.success();
  82.             ajax.put("fileName", fileName);
  83.             ajax.put("url", url);
  84.             return ajax;
  85.         }
  86.         catch (Exception e)
  87.         {
  88.             return AjaxResult.error(e.getMessage());
  89.         }
  90.     }
  91.  
  92.     /**
  93.      * 通用上传请求返回磁盘路径
  94.      */
  95.     @PostMapping("/common/uploadWithAbsolutePath")
  96.     public AjaxResult uploadFileWithAbsolutePath(MultipartFile file) throws Exception
  97.     {
  98.         try
  99.         {
  100.             // 上传文件路径
  101.             String filePath = RuoYiConfig.getUploadPath();
  102.             // 上传并返回新文件名称
  103.             String fileName = FileUploadUtils.uploadWithAbsolutePath(filePath, file);
  104.             AjaxResult ajax = AjaxResult.success();
  105.             ajax.put("uploadpath", filePath+ File.separator+fileName);
  106.             return ajax;
  107.         }
  108.         catch (Exception e)
  109.         {
  110.             return AjaxResult.error(e.getMessage());
  111.         }
  112.     }
  113.  
  114.     /**
  115.      * 本地资源通用下载
  116.      */
  117.     @GetMapping("/common/download/resource")
  118.     public void resourceDownload(String resource, HttpServletRequest request, HttpServletResponse response)
  119.             throws Exception
  120.     {
  121.         try
  122.         {
  123.             if (!FileUtils.checkAllowDownload(resource))
  124.             {
  125.                 throw new Exception(StringUtils.format("资源文件({})非法，不允许下载。 ", resource));
  126.             }
  127.             // 本地资源路径
  128.             String localPath = RuoYiConfig.getProfile();
  129.             // 数据库资源地址
  130.             String downloadPath = localPath + StringUtils.substringAfter(resource, Constants.RESOURCE_PREFIX);
  131.             // 下载名称
  132.             String downloadName = StringUtils.substringAfterLast(downloadPath, "/");
  133.             response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
  134.             FileUtils.setAttachmentResponseHeader(response, downloadName);
  135.             FileUtils.writeBytes(downloadPath, response.getOutputStream());
  136.         }
  137.         catch (Exception e)
  138.         {
  139.             log.error("下载文件失败", e);
  140.         }
  141.     }
  142.  
  143.     /**
  144.      * 本地资源通用下载
  145.      */
  146.     @GetMapping("/common/download/resourceeasy")
  147.     public void resourceDownloadEasy(String resource, HttpServletRequest request, HttpServletResponse response)
  148.             throws Exception
  149.     {
  150.         try
  151.         {
  152.             if (!FileUtils.checkAllowDownload(resource))
  153.             {
  154.                 throw new Exception(StringUtils.format("资源文件({})非法，不允许下载。 ", resource));
  155.             }
  156.             response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
  157.             FileUtils.setAttachmentResponseHeader(response, resource);
  158.             FileUtils.writeBytes(resource, response.getOutputStream());
  159.         }
  160.         catch (Exception e)
  161.         {
  162.             log.error("下载文件失败", e);
  163.         }
  164.     }
  165. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/628979
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号