在Java中将String []转换为逗号分隔的字符串

Question

我有一个 String[]

String[] name = {"amit", "rahul", "surya"};

我想在IN子句中的sql查询中发送名称作为参数，所以我如何转换为格式

'amit','rahul','surya'

Answer 1

if (name.length > 0) {
    StringBuilder nameBuilder = new StringBuilder();

    for (String n : name) {
        nameBuilder.append("'").append(n.replace("'", "\\'")).append("',");
        // can also do the following
        // nameBuilder.append("'").append(n.replace("'", "''")).append("',");
    }

    nameBuilder.deleteCharAt(nameBuilder.length() - 1);

    return nameBuilder.toString();
} else {
    return "";
}