当前位置：网站首页>MySQL passes in list ＜ string ＞ to query

MySQL passes in list ＜ string ＞ to query

2022-07-18 04:01:00 【*๛ก(ｰ ̀ω ｰ ́ ก) 】

If you want to mysql Pass in List<String> As query criteria 

List<String> list = ["1","2","3"];
String ids = "\"" + String.join("\",\"",list) + +"\"";
// After splicing, it is ""1","2","3""

select * from student where id in (${
    ids})
//
select * from student where id in ("1","2","3")

Use it carefully $ Splicer , instead of # Place holder

原网站

版权声明
本文为[*๛ก(ｰ ̀ω ｰ ́ ก) ]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/199/202207151258313369.html

边栏推荐

猜你喜欢

随机推荐