From ffa5afb4e38d577c85813f48e41696f0c569c7a7 Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期二, 01 七月 2025 18:09:57 +0800 Subject: [PATCH] 质量-检验工具,检验项目 --- src/main/java/org/jeecg/modules/base/controller/SupplierController.java | 32 ++++++++++++++++++++++++++++++++ 1 files changed, 32 insertions(+), 0 deletions(-) diff --git a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java index 4e4a9ac..c46995b 100644 --- a/src/main/java/org/jeecg/modules/base/controller/SupplierController.java +++ b/src/main/java/org/jeecg/modules/base/controller/SupplierController.java @@ -1,5 +1,7 @@ package org.jeecg.modules.base.controller; +import java.io.File; +import java.net.URLEncoder; import java.util.Arrays; import java.util.List; import java.util.Map; @@ -9,6 +11,9 @@ import java.net.URLDecoder; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; + +import org.apache.poi.ss.usermodel.Workbook; +import org.apache.poi.ss.usermodel.WorkbookFactory; import org.jeecg.common.api.vo.Result; import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.system.query.QueryGenerator; @@ -191,4 +196,31 @@ return Result.ok("鎿嶄綔鎴愬姛锛�"); } + /** + * 瀵煎叆妯℃澘涓嬭浇 + * + */ + @RequestMapping(value = "/loadTemplate") + public void loadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException { + + Map<String,String[]> req = request.getParameterMap(); + Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\渚涘簲鍟嗕俊鎭鍏ユā鏉�.xlsx")); + //瀵煎嚭Workbook + //璁剧疆鍝嶅簲澶� + String fileName = "渚涘簲鍟嗕俊鎭鍏ユā鏉�.xlsx"; + // 瀵规枃浠跺悕杩涜URL缂栫爜锛岄槻姝腑鏂囦贡鐮� + String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20"); + response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); + response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName); + // 灏哤orkbook鍐欏叆鍝嶅簲杈撳嚭娴� + try { // try-with-resources鑷姩鍏抽棴璧勬簮 + workbook.write(response.getOutputStream()); + response.flushBuffer(); + } catch (IOException e) { + // 寮傚父澶勭悊锛堝璁板綍鏃ュ織锛� + throw new IOException("涓嬭浇妯℃澘澶辫触", e); + } + + } + } -- Gitblit v1.9.3