java拼接sql语句的in条件

1、问题

java拼接sql语句的in条件，需要将列表或数组转换为(" “,” ")的格式

2、代码

StringBuffer sbuffer= new StringBuffer();for(String s: list) {sbuffer.append("\'" +s + "\',");}String sql = "select * from table where is_delete = 0 and id in (" + sbuffer.substring(0, sbuffer.length() - 1) + ");";