12

13693261870

2022-11-21 07a68b8d93aa059968a9709f2c81e6625338032c

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

@@ -4,13 +4,11 @@
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.md.*;
import com.lf.server.helper.*;
import com.lf.server.mapper.bd.DlgAgnpMapper;
import com.lf.server.service.all.BaseQueryService;
@@ -35,6 +33,7 @@
 * @author WWW
 */
@Component
@SuppressWarnings("AlibabaRemoveCommentedCode")
public class InitConfig implements ApplicationRunner {
    private final static Log log = LogFactory.getLog(InitConfig.class);

@@ -96,7 +95,7 @@
    private void testMybatisPlus() {
        String s1 = locateService.selectWktById(1);

        String tabName = baseQueryService.getTabName(dlgAgnpMapper);
        String tabName = BaseQueryService.getTabName(dlgAgnpMapper);
        List<String> list0 = dlgAgnpMapper.selectFieldFuzzy(tabName, "name", "%县%");

        DlgAgnpEntity dlg = dlgAgnpMapper.selectById(1);
@@ -189,10 +188,19 @@
    }

    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();
    }
}