From 1d53dd8f501a98ddcce8146443b51b357ef5f9b1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 十二月 2022 16:55:46 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/config/InitConfig.java | 208 ++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 203 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/lf/server/config/InitConfig.java b/src/main/java/com/lf/server/config/InitConfig.java
index 194d6f8..5041d70 100644
--- a/src/main/java/com/lf/server/config/InitConfig.java
+++ b/src/main/java/com/lf/server/config/InitConfig.java
@@ -1,6 +1,21 @@
package com.lf.server.config;
-import com.lf.server.helper.PathHelper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+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.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.md.*;
+import com.lf.server.helper.*;
+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.show.LocateService;
+import com.lf.server.service.sys.ArgsService;
+import com.lf.server.service.sys.BlacklistService;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
@@ -8,25 +23,208 @@
import org.springframework.boot.ApplicationRunner;
import org.springframework.stereotype.Component;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
/**
* 鍒濆鍖栧畬鎴愰厤缃被
* @author WWW
*/
@Component
+@SuppressWarnings("AlibabaRemoveCommentedCode")
public class InitConfig implements ApplicationRunner {
private final static Log log = LogFactory.getLog(InitConfig.class);
@Autowired
- private PathHelper pathHelper;
+ PathHelper pathHelper;
+
+ @Autowired
+ ArgsService argsService;
+
+ @Autowired
+ DlgagnpMapper dlgagnpMapper;
+
+ @Autowired
+ PermsService permsService;
+
+ @Autowired
+ BlacklistService blacklistService;
+
+ @Autowired
+ BaseQueryService baseQueryService;
+
+ @Autowired
+ LocateService locateService;
@Override
public void run(ApplicationArguments args) {
+ // noinspection AlibabaRemoveCommentedCode
try {
- pathHelper.init();
+ // GDAL娴嬭瘯锛�"E:\\data\\7.Insar\\insartest.tif","E:\\data\\6.楂樺厜璋盶\GF5_Cut_1.img","E:\\data\\22.tif\\110.747 sq km.tif","E:\\Test\\Test.gdb"
+ //GdalHelper.readTif("E:\\data\\7.Insar\\insartest.tif")
+ //GdalHelper.readShp("E:\\data\\13.cppe\\shps\\addr.shp");
+ //GdalHelper.readGdb("E:\\Test\\addr.gdb");
+ //ShpRecord sr = GdalHelper.readShpFirstRecord("D:\\LF\\data\\shp\\extent.shp");
- log.info("*****************绯荤粺鍚姩瀹屾瘯*****************");
+ //com.lf.server.helper.RsaHelper.generate();
+ //testMybatisPlus();
+ //testAes();
+ //testPerms();
+ //testBlacklist();
+ //FloatServerController.test();
+ //testReadExcel();
+ //testBatchUpdate();
+ //testAccess();
+
+ //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");
+ //boolean f3 = Zip4jHelper.zip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\resources", "12345");
+ //boolean f4 = Zip4jHelper.unzip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\res", "12345");
+
+ // 鍒濆鍖�
+ GdalHelper.init();
+ pathHelper.init();
+ argsService.initSettingData();
+
+ log.info("***************** 绯荤粺鍚姩瀹屾瘯 *****************" + "\n");
} catch (Exception ex) {
- log.error(ex.getStackTrace());
+ log.error(ex.getMessage(), ex);
}
}
+
+ 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", "%鍘�%");
+
+ 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);
+
+ QueryWrapper<DlgagnpEntity> w1 = new QueryWrapper<>();
+ w1.eq("name", "娌诲鍘�");
+ List<DlgagnpEntity> list2 = dlgagnpMapper.selectList(w1);
+
+ UpdateWrapper<DlgagnpEntity> w2 = new UpdateWrapper<DlgagnpEntity>();
+ // 璁剧疆鏇存柊鍐呭
+ w2.set("name", "newName").set("gb", "10013")
+ // 璁剧疆鏇存柊鏉′欢
+ .eq("gid", 0);
+ // 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.updateById(dlg)
+ // List<DlgAgnp> all = dlgagnpMapper.selectList(null)
+
+ // 椤垫暟 / 姣忛〉璁板綍鏁�
+ Page<DlgagnpEntity> page = new Page<>(1, 10);
+ // 鍗囧簭鎺掑簭
+ page.addOrder(OrderItem.asc("gid"));
+ // 鍒嗛〉锛歐rapper鏌ヨ鏉′欢
+ Page<DlgagnpEntity> userPage = dlgagnpMapper.selectPage(page, null);
+ // 鎬婚〉鏁� / 鎬昏褰曟暟锛�325 / 3247
+ String str = userPage.getPages() + " / " + userPage.getTotal();
+ List<DlgagnpEntity> list4 = userPage.getRecords();
+
+ QueryWrapper<DlgagnpEntity> w3 = new QueryWrapper<>();
+ w3.like("name", "澶�").ge("gid", 100);
+ List<DlgagnpEntity> list5 = dlgagnpMapper.selectList(w3);
+ }
+
+ private void testAes() {
+ try {
+ String content = "POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))";
+ System.out.println("鍔犲瘑鍓嶏細" + content);
+ String encrypt = AesHelper.encrypt(content);
+
+ System.out.println("鍔犲瘑鍚庯細" + encrypt);
+ String decrypt = AesHelper.decrypt(encrypt);
+
+ System.out.println("瑙ｅ瘑鍚庯細" + decrypt);
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+ }
+
+ private void testPerms() {
+ List<ResAuthEntity> raeList = permsService.selectRes("admin");
+ List<ResAuthEntity> raeList2 = permsService.selectRes("admin");
+
+ List<MenusAuthEntity> maeList = permsService.selectMenus("admin");
+ List<MenusAuthEntity> maeList2 = permsService.selectMenus("admin");
+
+ List<String> pList = permsService.selectPerms("admin");
+ List<String> pList2 = permsService.selectPerms("admin");
+
+ List<PermsAuthEntity> pauList = permsService.selectPermsEntity("admin");
+ List<PermsAuthEntity> pauList2 = permsService.selectPermsEntity("admin");
+
+ permsService.clearResCache();
+ permsService.clearPermsCache();
+
+ raeList = permsService.selectRes("admin");
+ maeList = permsService.selectMenus("admin");
+ pList = permsService.selectPerms("admin");
+ pauList = permsService.selectPermsEntity("admin");
+ permsService.clearAllCache();
+ }
+
+ private void testBlacklist() {
+ List<String> list1 = blacklistService.selectIpList(1);
+ List<String> list2 = blacklistService.selectIpList(1);
+ List<String> list3 = blacklistService.selectIpList(2);
+ List<String> list4 = blacklistService.selectIpList(2);
+ blacklistService.clearCache();
+ List<String> list5 = blacklistService.selectIpList(1);
+ }
+
+ private void testReadExcel() {
+ List<MdZxcgEntity> listMdZxcg = ExcelHelper.readExcel(MdZxcgEntity.class, "D:\\LF\\data\\xls\\娴嬬粯\\1-椤圭洰鎴愭灉-瑗夸笁涓璡\1-1涓嚎鎴愭灉琛╘\娴峰師鍘夸腑绾挎垚鏋滆〃.xlsx");
+ int r1 = listMdZxcg.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();
+ }
}
--
Gitblit v1.9.3