From d91c78e445e49cda5430bd33ef281f60f56a0a2d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 05 二月 2023 20:09:10 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/config/InitConfig.java | 125 ++++++++++++++++++++++++++++++++---------
1 files changed, 96 insertions(+), 29 deletions(-)
diff --git a/src/main/java/com/lf/server/config/InitConfig.java b/src/main/java/com/lf/server/config/InitConfig.java
index e3680a4..a7b8c77 100644
--- a/src/main/java/com/lf/server/config/InitConfig.java
+++ b/src/main/java/com/lf/server/config/InitConfig.java
@@ -4,17 +4,16 @@
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.OrderItem;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.lf.server.controller.other.FloatServerController;
import com.lf.server.entity.all.MenusAuthEntity;
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.entity.bd.DlgagnpEntity;
+import com.lf.server.entity.md.*;
import com.lf.server.helper.*;
-import com.lf.server.mapper.bd.DlgAgnpMapper;
+import com.lf.server.mapper.bd.DlgagnpMapper;
import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.all.PermsService;
+import com.lf.server.service.all.UploadAttachService;
import com.lf.server.service.show.LocateService;
import com.lf.server.service.sys.ArgsService;
import com.lf.server.service.sys.BlacklistService;
@@ -23,6 +22,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
+import org.springframework.core.env.Environment;
import org.springframework.stereotype.Component;
import java.util.ArrayList;
@@ -35,6 +35,7 @@
* @author WWW
*/
@Component
+@SuppressWarnings("AlibabaRemoveCommentedCode")
public class InitConfig implements ApplicationRunner {
private final static Log log = LogFactory.getLog(InitConfig.class);
@@ -45,7 +46,7 @@
ArgsService argsService;
@Autowired
- DlgAgnpMapper dlgAgnpMapper;
+ DlgagnpMapper dlgagnpMapper;
@Autowired
PermsService permsService;
@@ -58,6 +59,9 @@
@Autowired
LocateService locateService;
+
+ @Autowired
+ Environment env;
@Override
public void run(ApplicationArguments args) {
@@ -76,6 +80,9 @@
//testBlacklist();
//FloatServerController.test();
//testReadExcel();
+ //testBatchUpdate();
+ //testAccess();
+ //testMd5();
//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");
@@ -83,7 +90,8 @@
//boolean f4 = Zip4jHelper.unzip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\res", "12345");
// 鍒濆鍖�
- GdalHelper.init();
+ GdalHelper.init(env.getProperty("sys.gdal_path"));
+ UploadAttachService.init(env.getProperty("sys.attachTabs"));
pathHelper.init();
argsService.initSettingData();
@@ -93,52 +101,69 @@
}
}
+ private void testBatchUpdate() {
+ DlgagnpEntity d1 = new DlgagnpEntity();
+ d1.setGid(56);
+ d1.setGb("10");
+ d1.setName("a01");
+ DlgagnpEntity d2 = new DlgagnpEntity();
+ d2.setGid(57);
+ d2.setGb("20");
+ d2.setName("a02");
+
+ List<DlgagnpEntity> list = new ArrayList<>();
+ list.add(d1);
+ list.add(d2);
+
+ int rows = dlgagnpMapper.updateBatch(list);
+ }
+
private void testMybatisPlus() {
String s1 = locateService.selectWktById(1);
- String tabName = baseQueryService.getTabName(dlgAgnpMapper);
- List<String> list0 = dlgAgnpMapper.selectFieldFuzzy(tabName, "name", "%鍘�%");
+ String tabName = BaseQueryService.getTabName(dlgagnpMapper);
+ List<String> list0 = dlgagnpMapper.selectFieldFuzzy(tabName, "name", "%鍘�%");
- DlgAgnpEntity dlg = dlgAgnpMapper.selectById(1);
- String wkt = dlgAgnpMapper.selectWktById(tabName, 2);
+ DlgagnpEntity dlg = dlgagnpMapper.selectById(1);
+ String wkt = dlgagnpMapper.selectWktById(tabName, 2);
Map<String, Object> map = new HashMap<String, Object>(3);
map.put("gid", 2);
- List<DlgAgnpEntity> list1 = dlgAgnpMapper.selectByMap(map);
+ List<DlgagnpEntity> list1 = dlgagnpMapper.selectByMap(map);
- QueryWrapper<DlgAgnpEntity> w1 = new QueryWrapper<>();
+ QueryWrapper<DlgagnpEntity> w1 = new QueryWrapper<>();
w1.eq("name", "娌诲鍘�");
- List<DlgAgnpEntity> list2 = dlgAgnpMapper.selectList(w1);
+ List<DlgagnpEntity> list2 = dlgagnpMapper.selectList(w1);
- UpdateWrapper<DlgAgnpEntity> w2 = new UpdateWrapper<DlgAgnpEntity>();
+ UpdateWrapper<DlgagnpEntity> w2 = new UpdateWrapper<DlgagnpEntity>();
// 璁剧疆鏇存柊鍐呭
w2.set("name", "newName").set("gb", "10013")
// 璁剧疆鏇存柊鏉′欢
.eq("gid", 0);
- // dlgAgnpMapper.update(null, w2)
+ // dlgagnpMapper.update(null, w2)
List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(2);
- // dlgAgnpMapper.deleteBatchIds(ids)
- List<DlgAgnpEntity> list3 = dlgAgnpMapper.selectBatchIds(ids);
+ // dlgagnpMapper.deleteBatchIds(ids)
+ List<DlgagnpEntity> list3 = dlgagnpMapper.selectBatchIds(ids);
- // dlgAgnpMapper.updateById(dlg)
- // List<DlgAgnp> all = dlgAgnpMapper.selectList(null)
+ // dlgagnpMapper.updateById(dlg)
+ // List<DlgAgnp> all = dlgagnpMapper.selectList(null)
// 椤垫暟 / 姣忛〉璁板綍鏁�
- Page<DlgAgnpEntity> page = new Page<>(1, 10);
+ Page<DlgagnpEntity> page = new Page<>(1, 10);
// 鍗囧簭鎺掑簭
page.addOrder(OrderItem.asc("gid"));
// 鍒嗛〉锛歐rapper鏌ヨ鏉′欢
- Page<DlgAgnpEntity> userPage = dlgAgnpMapper.selectPage(page, null);
+ Page<DlgagnpEntity> userPage = dlgagnpMapper.selectPage(page, null);
// 鎬婚〉鏁� / 鎬昏褰曟暟锛�325 / 3247
String str = userPage.getPages() + " / " + userPage.getTotal();
- List<DlgAgnpEntity> list4 = userPage.getRecords();
+ List<DlgagnpEntity> list4 = userPage.getRecords();
- QueryWrapper<DlgAgnpEntity> w3 = new QueryWrapper<>();
+ QueryWrapper<DlgagnpEntity> w3 = new QueryWrapper<>();
w3.like("name", "澶�").ge("gid", 100);
- List<DlgAgnpEntity> list5 = dlgAgnpMapper.selectList(w3);
+ List<DlgagnpEntity> list5 = dlgagnpMapper.selectList(w3);
}
private void testAes() {
@@ -189,10 +214,52 @@
}
private void testReadExcel() {
- List<Zxcg> listZxcg = ExcelHelper.readExcel(Zxcg.class, "D:\\LF\\data\\xls\\娴嬬粯\\1-椤圭洰鎴愭灉-瑗夸笁涓璡\1-1涓嚎鎴愭灉琛╘\娴峰師鍘夸腑绾挎垚鏋滆〃.xlsx");
- int r1 = listZxcg.size();
+ List<MdZxcgEntity> listMdZxcg = ExcelHelper.readExcel(MdZxcgEntity.class, "D:\\LF\\data\\xls\\娴嬬粯\\1-椤圭洰鎴愭灉-瑗夸笁涓璡\1-1涓嚎鎴愭灉琛╘\娴峰師鍘夸腑绾挎垚鏋滆〃.xlsx");
+ int r1 = listMdZxcg.size();
- List<Gxcg> listGxcg = ExcelHelper.readExcel(Gxcg.class, "D:\\LF\\data\\xls\\娴嬬粯\\2-鍦颁笅绠＄嚎鎺㈡祴鎴愭灉\\2-2 绠＄嚎鎴愭灉琛�.xlsx");
- int r2 = listGxcg.size();
+ //List<MdGdcgEntity> listGdcg = ExcelHelper.readExcel(MdGdcgEntity.class, "D:\\LF\\data\\xls\\娴嬬粯\\2-鍦颁笅绠＄嚎鎺㈡祴鎴愭灉\\2-2 绠＄嚎鎴愭灉琛�.xlsx");
+ //int r2 = listGdcg.size();
+
+ String entityName = "Gxcg";
+ String xls = "D:\\LF\\data\\xls\\娴嬬粯\\2-鍦颁笅绠＄嚎鎺㈡祴鎴愭灉\\2-2 绠＄嚎鎴愭灉琛�.xlsx";
+
+ String className = "com.lf.server.entity.bs." + entityName;
+ Object obj = ClassHelper.createInstance(className);
+
+ List<?> list = ExcelHelper.readExcel(obj.getClass(), xls);
+ int r3 = list.size();
+ }
+
+ private void testAccess() {
+ List<Map<String, Object>> list = AccessHelper.readMdb("D:\\LF\\data\\test.mdb", "", "");
+ int count = null == list || list.isEmpty() ? 0 : list.size();
+ }
+
+ private void testMd5() {
+ try {
+ String file = "E:\\data\\mpt\\A4mpt20131125.mpt";
+
+ long stime = System.currentTimeMillis();
+ // 2a0befb05146cd30213ee4b95038aca0
+ String md51 = FileHelper.getFileMd5(file);
+ long etime = System.currentTimeMillis();
+ String s1 = String.format("鎵ц鏃堕暱锛�%d 姣.", (etime - stime));
+
+ stime = System.currentTimeMillis();
+ // 2a0befb05146cd30213ee4b95038aca0
+ String md52 = FileHelper.getMd5ByJdk(file);
+ etime = System.currentTimeMillis();
+ String s2 = String.format("鎵ц鏃堕暱锛�%d 姣.", (etime - stime));
+
+ stime = System.currentTimeMillis();
+ // 9f1b7f050f41598710ffc08252484397
+ String md53 = FileHelper.getFastMd5(file);
+ etime = System.currentTimeMillis();
+ String s3 = String.format("鎵ц鏃堕暱锛�%d 姣.", (etime - stime));
+
+ etime = System.currentTimeMillis();
+ } catch (Exception ex) {
+ //
+ }
}
}
--
Gitblit v1.9.3