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/service/UserLogService.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/UserLogService.java b/src/main/java/com/whyc/service/UserLogService.java
index ab16f3c..3cd5a8e 100644
--- a/src/main/java/com/whyc/service/UserLogService.java
+++ b/src/main/java/com/whyc/service/UserLogService.java
@@ -7,9 +7,16 @@
import com.whyc.constant.UserOperation;
import com.whyc.mapper.UserLogMapper;
import com.whyc.pojo.UserLog;
+import com.whyc.util.DateUtil;
+import com.whyc.util.ExcelUtil;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.List;
@Service
@@ -44,4 +51,11 @@
return pageInfo;
}
+
+ public void exportExcel(HttpServletResponse response, String[][] value) {
+
+ String[] columnTitleArr = new String[]{"鎿嶄綔浜哄鍚�","鎿嶄綔绫诲瀷","鎿嶄綔鏃堕棿","缁堢IP","鎿嶄綔浜嬩欢","鍏蜂綋鍙傛暟"};
+ String now = DateUtil.YYYY_MM_DD_HH_MM_SS_UNION.format(new Date());
+ ExcelUtil.exportExcel("UserLog-"+now,"娴嬭瘯sheet1",columnTitleArr,value,new HSSFWorkbook(),response);
+ }
}
--
Gitblit v1.9.1