LambdaQueryWrapper如何做sum操作
时间: 2024-01-08 13:21:32 浏览: 49
LambdaQueryWrapper可以通过使用select方法和lambda表达式来进行sum操作。下面是两个例子:
1. 使用LambdaQueryWrapper进行sum操作并获取结果:
```java
LambdaQueryWrapper<Order> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.select(Order::getAmountTotal.sum().as("sumAll"));
Order ord = orderService.getOne(queryWrapper);
// 取值
BigDecimal sumAll = ord.getSumAll();
```
2. 使用LambdaQueryWrapper进行sum操作并返回结果:
```java
LambdaQueryWrapper<SbhPlatOrder> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.select(SbhPlatOrder::getAmt.sum().as("total"));
queryWrapper.between(SbhPlatOrder::getOrderEndTime, 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());
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)