From cccaf417bc5cb4a9c3fa925d491ca7c1e5621a0c Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期一, 11 十二月 2023 11:12:39 +0800 Subject: [PATCH] 还原测试类 --- consum-base/src/main/java/com/consum/base/BaseController.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/BaseController.java b/consum-base/src/main/java/com/consum/base/BaseController.java index b379508..f41965a 100644 --- a/consum-base/src/main/java/com/consum/base/BaseController.java +++ b/consum-base/src/main/java/com/consum/base/BaseController.java @@ -1,5 +1,14 @@ package com.consum.base; +import java.io.ByteArrayOutputStream; +import java.io.IOException; +import java.io.OutputStream; +import java.net.URLEncoder; + +import javax.servlet.http.HttpServletResponse; + +import org.apache.poi.ss.usermodel.Workbook; + import com.consum.model.po.FinSysTenantUser; import com.iplatform.base.PlatformAdapterController; import com.iplatform.base.util.UserUtils; @@ -38,4 +47,19 @@ // 浠庣紦瀛樹腑鍙栧嚭鐢ㄦ埛锛屽鏋滄病鏈夊垯鏂板 return this.getFinSysTenantUserCache().get(String.valueOf(userInfo.getId())); } + + protected void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) throws IOException { + OutputStream out = response.getOutputStream(); + response.setCharacterEncoding("UTF-8"); + response.setHeader("content-Type", "application/vnd.ms-excel"); + response.setHeader("Content-Disposition", + "attachment;filename=" + URLEncoder.encode(fileName + ".xls", "UTF-8")); + ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); + workbook.write(byteArrayOutputStream); + response.setHeader("Content-Length", String.valueOf(byteArrayOutputStream.size())); + out.write(byteArrayOutputStream.toByteArray()); + workbook.close(); + out.close(); + } + } -- Gitblit v1.9.1