1

13693261870

2022-11-16 944091a18721ccd38a7c583acf2a6c68fa457990

 src/main/java/com/lf/server/config/InitConfig.java

@@ -1,15 +1,21 @@
package com.lf.server.config;

import cn.hutool.crypto.symmetric.AES;
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.PathHelper;
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;
@@ -27,6 +33,7 @@
 * @author WWW
 */
@Component
@SuppressWarnings("AlibabaRemoveCommentedCode")
public class InitConfig implements ApplicationRunner {
    private final static Log log = LogFactory.getLog(InitConfig.class);

@@ -38,6 +45,18 @@

    @Autowired
    DlgAgnpMapper dlgAgnpMapper;

    @Autowired
    PermsService permsService;

    @Autowired
    BlacklistService blacklistService;

    @Autowired
    BaseQueryService baseQueryService;

    @Autowired
    LocateService locateService;

    @Override
    public void run(ApplicationArguments args) {
@@ -52,6 +71,10 @@
            //com.lf.server.helper.RsaHelper.generate();
            //testMybatisPlus();
            //testAes();
            //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");
@@ -59,21 +82,24 @@
            //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);
        }
    }

    /**
     * 测试 Mybatis-Plus
     */
    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(2);
        String wkt = dlgAgnpMapper.selectWktById(tabName, 2);

        Map<String, Object> map = new HashMap<String, Object>(3);
        map.put("gid", 2);
@@ -125,7 +151,56 @@

            System.out.println("解密后：" + decrypt);
        } catch (Exception ex) {
            log.error(ex.getStackTrace());
            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();
    }
}