mybatis plus sum的一些操作

最新推荐文章于 2024-07-18 09:08:20 发布

abc81163788

最新推荐文章于 2024-07-18 09:08:20 发布

阅读量852

点赞数

分类专栏： java 数据库文章标签： mybatis java sql

本文链接：https://blog.csdn.net/abc81163788/article/details/128215822

版权

java 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

数据库

2 篇文章 0 订阅

订阅专栏

1、

    QueryWrapper<Order> queryWrapper = new QueryWrapper<Order>();
    queryWrapper.select("ifnull(sum(amount_total),0) as sumAll");     
    Order ord= orderService.getOne(queryWrapper);
    //取值
    ord.getSumAll()

2、

 	QueryWrapper<SbhPlatOrder> queryWrapper = new QueryWrapper<>();
    queryWrapper.select("sum(amt) as total ");
    queryWrapper.between("order_end_time", merPlatOrderRequest.getStartTime(),merPlatOrderRequest.getEndTime());
    Map<String, Object> count = sbhPlatOrderManager.getMap(queryWrapper);
    if (count==null){
        return Result.success(0L);
    }
    Double total = Double.valueOf(String.valueOf(count.get("total")));
    return Result.success(total.longValue());

3、

return this.getMap(new QueryWrapper<LevyPromoteDetail>()
        .select("service_id serviceId,separate_state separateState,count(1) countSum,sum(pay_success_amt) payAmount")
        .eq("settle_number", settleNumber)
        .eq("service_id", enterpriseProviderDTO.getProviderId())
        .groupBy("service_id, separate_state"));

4、***☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆

QueryWrapper<SbhPlatOrder> queryWrapper = Wrappers.query();
    queryWrapper.lambda()
            .ge(SbhPlatOrder::getCreateTime, new Date())
            .lt(SbhPlatOrder::getCreateTime, new Date())
            .groupBy(SbhPlatOrder::getProduct, SbhPlatOrder::getEnterpriseId, SbhPlatOrder::getLevyId);
    queryWrapper.lambda().select(SbhPlatOrder::getEnterpriseId, SbhPlatOrder::getProduct);
    String columns= queryWrapper.getSqlSelect()+",sum(IFNULL(suc_amt,0))";
    queryWrapper.select(columns);
    List<SbhPlatOrder> list = sbhPlatOrderManager.list(queryWrapper);