QueryWrapper关联
时间: 2023-08-17 20:13:47 浏览: 58
QueryWrapper关联是指在使用MyBatis Plus框架进行数据库查询时,通过QueryWrapper对象来构建查询条件,实现多表关联查询。在Mapper中,可以自定义表关联的SQL,并将QueryWrapper对象传入,MyBatis Plus会自动将SQL和查询条件组装在一起。同时,在Service层的代码中,需要至少有一个条件,如"1 = 1",来保证Wrapper不为空。在Controller中,可以通过调用Service的接口方法来获取关联查询的结果。\[1\]\[2\]\[3\]
#### 引用[.reference_title]
- *1* *3* [mybitsPlus QueryWrapper表关联分页查询](https://blog.csdn.net/eternal_tc/article/details/125299165)[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^koosearch_v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [基于QueryWrapper,实现MybatisPlus多表关联查询](https://blog.csdn.net/mr_foxsand/article/details/121356965)[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^koosearch_v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]