利用 tk.mybatis 分批查询数据

 

 public int execSmsQuestionnaireDetail(Date date) {
        int successCnt = 0;
        Example pushPlanExample = new Example(QuestionnaireDetail.class);
        Example.Criteria criteria = pushPlanExample.createCriteria();
        criteria.andIn("pushWay", Lists.newArrayList(1,4));
        criteria.andGreaterThanOrEqualTo("created", date);

        int count = questionnaireDetailMapper.selectCountByExample(pushPlanExample);
        log.info("短信发送计划，本次任务待发送{}条", count);
        while (count > 0) {
            count -= 200;
            if (count < 0) {
                    count = 0;
             }
            //一次处理200条
            RowBounds rowBonds = new RowBounds(count, 200);
            List<QuestionnaireDetail> questionnaireDetails = questionnaireDetailMapper.selectByExampleAndRowBounds(pushPlanExample, rowBonds);
            log.info("短信发送计划，有{}条计划待发送", questionnaireDetails.size());
            // 随机线性访问这样的遍历效率最高
            if (questionnaireDetails instanceof RandomAccess) {
                log.info("RandomAccess logs");
                for (int i = 0; i < questionnaireDetails.size(); i++) {
                    QuestionnaireDetail bean = questionnaireDetails.get(i);
                    if (StringUtils.isNotBlank(bean.getSmsContent()) && StringUtils.isNotBlank(bean.getCustomerTel())) {
                        smsSendService.sendSMS(questionnaireDetails.get(i));
                        log.info("短信发送计划smsSendService.sendSMS，发送成功");
                        successCnt++;
                    }

                }
            }
        }
        return successCnt;
    }