mybatis-plus分页查询_以及关于in的处理

个人学习笔记:

LambdaQueryWrapper<PaymentFlowListForPage> userLambdaQueryWrapper = Wrappers.lambdaQuery();
//page 页码 和 limit 页码数据长度(数量)  都是前端传递过来的
Page<PaymentFlowListForPage> userPage = new Page<>(paymentFlowList.getPage() , paymentFlowList.getLimit());
       String mrch_no = "1,2,3,4,5 ";
        List<String> resultList = new ArrayList<>();
        if(mrch_no.contains(",")){
            String[] split = mrch_no.split(",");
            resultList = new ArrayList<>(Arrays.asList(split));
        }else {
            resultList.add(mrch_no);
        }
    //如果前端传递参mrch_no 数为字符串类型 "1,2,3,4,5 " 会导致查询数据为空 如下注释部分代码   所以才有了上边的对于mrch_no的判断切割 转list
    // userLambdaQueryWrapper.in(PaymentFlowListForPage::getMrch_No, mrch_no);
    userLambdaQueryWrapper.in(PaymentFlowListForPage::getMrch_No, resultList);
    Page<PaymentFlowListForPage> paymentFlowListForPagePage = flowListForPageMapper.selectPage(userPage, userLambdaQueryWrapper);
        //页码
        long current = paymentFlowListForPagePage.getCurrent();
        //当前查询出数据数量 即limit
        long total = paymentFlowListForPagePage.getTotal();
        //查询出的数据  list
        List<PaymentFlowListForPage> records = paymentFlowListForPagePage.getRecords();