From 1afe70fac3969b6fec64c669ac7838e18e2f57f6 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期三, 24 十一月 2021 14:13:41 +0800
Subject: [PATCH] 引入excel依赖,编写接口导出操作事件记录
---
src/main/java/com/whyc/controller/UserLogController.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/controller/UserLogController.java b/src/main/java/com/whyc/controller/UserLogController.java
index b3c5284..e83b2da 100644
--- a/src/main/java/com/whyc/controller/UserLogController.java
+++ b/src/main/java/com/whyc/controller/UserLogController.java
@@ -4,10 +4,15 @@
import com.whyc.dto.Response;
import com.whyc.pojo.UserLog;
import com.whyc.service.UserLogService;
+import com.whyc.util.ExcelUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
/**
* 鐢ㄦ埛鎿嶄綔鏃ュ織
@@ -27,4 +32,17 @@
return new Response<PageInfo<UserLog>>().set(1,pageInfo);
}
+ @PostMapping("exportExcel")
+ @ApiOperation(value = "瀵煎嚭excel",produces = "application/octet-stream")
+ public void exportExcel(HttpServletResponse response,@RequestBody List<List<String>> valueList){
+
+ String[][] value = new String[valueList.size()][valueList.get(0).size()];
+ for (int i = 0; i < valueList.size(); i++) {
+ for (int j = 0; j < valueList.get(i).size(); j++) {
+ value[i][j]=valueList.get(i).get(j);
+ }
+ }
+ service.exportExcel(response,value);
+ }
+
}
--
Gitblit v1.9.1