在String中将String []转换为逗号分隔的字符串 [英] Convert String[] to comma separated string in java

问题描述

我有一个 String []

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

我想在IN子句
里面的sql查询中发送名字作为参数所以我怎么做转换为格式

i want to send name as parameter in sql query inside IN clause so how do i convert into a format

'amit','rahul','surya'

推荐答案

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 "";
}

这篇关于在String中将String []转换为逗号分隔的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！