QueryRunner 传入in参数
时间: 2024-02-04 22:02:48 浏览: 36
QueryRunner的query方法可以传入in参数。在query方法中,当params不为null时,会循环遍历传入的params,将params赋值到preparedStatement中,然后填充占位符进行sql查询。因此,如果需要传入in参数,可以将参数值作为数组传入params参数中。这样,在执行sql查询时,会将数组中的值依次赋值给preparedStatement的占位符,从而实现传入in参数的功能。\[1\]\[3\]
#### 引用[.reference_title]
- *1* *3* [QueryRunner类实战](https://blog.csdn.net/weixin_39564831/article/details/114550445)[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^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [QueryRunner使用动态sql时的参数传递](https://blog.csdn.net/sinat_41430316/article/details/118603230)[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^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]