java 定时任务每日晚上凌晨执行数据统计

最新推荐文章于 2025-07-22 14:16:34 发布

原创

最新推荐文章于 2025-07-22 14:16:34 发布 · 5.1k 阅读

1 ·

CC 4.0 BY-SA版权

例如：统计每日会员账户余额

Page page = new Page();
page.setPageSize(1000);
page.setPageNum(1);
do{
    //获取所有用户余额
    com.github.pagehelper.Page<AccountFinanceBillParam> pages = PageHelper.startPage(page.getPageNum(),page.getPageSize());
    List<MemberAccountBean> list = memberBalanceMapper.findMemberBalanceList();
    if(list != null && !list.isEmpty()){
        List<MemberBalance> balanceList = new ArrayList<MemberBalance>();
        for(MemberAccountBean account: list){
            MemberBalance entity = new MemberBalance();
            entity.setId(UF.getRandomUUID());
            entity.setDay(currentDate.toString());
            entity.setMemberId(account.getMemberId());
            entity.setAmount(account.getUsableAmount());
            balanceList.add(entity);
        }
        memberBalanceMapper.insert(balanceList);
    }else{
        logger.info("账户统计没有数据了");break;  //跳出循环
    }
    // 下