LambdaQueryWrapper limit1
时间: 2023-08-17 17:12:22 浏览: 79
LambdaQueryWrapper可以通过使用last方法来添加limit限制,例如:
```
LambdaQueryWrapper<Crm> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(Crm::getShopId, cdtShopId)
.orderByDesc(Crm::getId)
.last("limit 1");
return baseMapper.selectOne(queryWrapper);
```
这段代码使用LambdaQueryWrapper来构建查询条件,通过eq方法指定了shopId的条件,通过orderByDesc方法指定了按照Id降序排序。最后使用last方法添加了limit 1的限制,表示只返回一条结果。这样就可以通过baseMapper的selectOne方法来执行查询并返回结果。\[1\]
#### 引用[.reference_title]
- *1* *2* [mybatis-plus中使用QueryWrapper和LambdaQueryWrapper的limit出现的问题](https://blog.csdn.net/Tony_zt/article/details/125225091)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [MyBatis中的LambdaQueryWrapper构造器](https://blog.csdn.net/java123456111/article/details/125906104)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]