package com.lf.server.config;
|
|
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;
|
import org.springframework.boot.ApplicationArguments;
|
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
|
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 {
|
// 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");
|
|
//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.getMessage(), ex);
|
}
|
}
|
|
private void testBatchUpdate() {
|
DlgagnpEntity d1 = new DlgagnpEntity();
|
d1.setGid(56L);
|
d1.setGb("10");
|
d1.setName("a01");
|
DlgagnpEntity d2 = new DlgagnpEntity();
|
d2.setGid(57L);
|
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"));
|
// 分页：Wrapper查询条件
|
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();
|
}
|
}
|
