Java 中写in 包含的sql语句

1.接收参数

String ids[] = request.getParameterValues("phoneInfoID");

2.数组转换为List

List<String> list = Arrays.asList(ids);

3.循环并拼接到SQL中

StringBuffer sbuffer= new StringBuffer();
for(int i=0;i<list .size();i++){
sbuffer.append("\'");
sbuffer.append(list .get(i));
sbuffer.append("\',");
}
String sql = "delete from 表名 where phone_id in(" + sbuffer.substring(0, sbuffer.length()-1) + ")";