From cc01f01a9ff12f4167d7d5d40bc3cff2ffb366c6 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 15 十一月 2022 15:51:20 +0800
Subject: [PATCH] Excel数据操作
---
src/main/java/com/lf/server/config/InitConfig.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/config/InitConfig.java b/src/main/java/com/lf/server/config/InitConfig.java
index ae4237c..e3680a4 100644
--- a/src/main/java/com/lf/server/config/InitConfig.java
+++ b/src/main/java/com/lf/server/config/InitConfig.java
@@ -9,6 +9,8 @@
import com.lf.server.entity.all.PermsAuthEntity;
import com.lf.server.entity.all.ResAuthEntity;
import com.lf.server.entity.bd.DlgAgnpEntity;
+import com.lf.server.entity.bs.Gxcg;
+import com.lf.server.entity.bs.Zxcg;
import com.lf.server.helper.*;
import com.lf.server.mapper.bd.DlgAgnpMapper;
import com.lf.server.service.all.BaseQueryService;
@@ -73,6 +75,7 @@
//testPerms();
//testBlacklist();
//FloatServerController.test();
+ //testReadExcel();
//boolean f1 = ZipHelper.unzip("D:\\LF\\data\\resources.zip", "D:\\LF\\data\\unzip");
//boolean f2 = ZipHelper.zip("D:\\LF\\data\\res.zip", "D:\\LF\\data\\unzip\\resources");
@@ -184,4 +187,12 @@
blacklistService.clearCache();
List<String> list5 = blacklistService.selectIpList(1);
}
+
+ private void testReadExcel() {
+ List<Zxcg> listZxcg = ExcelHelper.readExcel(Zxcg.class, "D:\\LF\\data\\xls\\娴嬬粯\\1-椤圭洰鎴愭灉-瑗夸笁涓璡\1-1涓嚎鎴愭灉琛╘\娴峰師鍘夸腑绾挎垚鏋滆〃.xlsx");
+ int r1 = listZxcg.size();
+
+ List<Gxcg> listGxcg = ExcelHelper.readExcel(Gxcg.class, "D:\\LF\\data\\xls\\娴嬬粯\\2-鍦颁笅绠＄嚎鎺㈡祴鎴愭灉\\2-2 绠＄嚎鎴愭灉琛�.xlsx");
+ int r2 = listGxcg.size();
+ }
}
--
Gitblit v1.9.3