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.helper.AesHelper;
|
import com.lf.server.helper.FileHelper;
|
import com.lf.server.helper.GdalHelper;
|
import com.lf.server.helper.PathHelper;
|
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
|
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();
|
|
//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 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);
|
}
|
}
|