java - 如何将字符串数组转换为 MySQL IN 子句

Question

String[] name = request.getParameterValues("name");

 name stored as ['anil,raju,anitha']

如何将其转换为

            'anil','raju','anitha'

这是我的代码

        List<String> wordList = Arrays.asList(name);  

  for (String e : wordList)  
  {  
     System.out.println(e);  
  }  

请帮助我获得预期的输出

Answer 1

这已经是很久以前的事了，所以这里有一些更新的示例:

import java.util.stream.Collectors;
import java.util.stream.Stream;

public class JoiningTest {

    public static void main(String[] args) {
        String[] test = { "word1", "word2", "word3"};

        String join = String.join(",", test);
        System.out.println(join);

        String collect = Stream.of(test).collect(Collectors.joining(","));
        System.out.println(collect);
    }

}

将打印:

word1,word2,word3
word1,word2,word3

使用 apache commons lang:

public static void main(String[] args) {
        String[] test = {"1", "2", "3", "4"};
        String inClause = StringUtils.join(test, ",");
        System.out.println(inClause);
}

打印:

1,2,3,4

或者新的 StringJoiner (用于您的前缀/后缀):

StringJoiner joiner = new StringJoiner("','","'", "'");
        for(String s: test)
            joiner.add(s);

        System.out.println(joiner.toString());

打印:

'1','2','3','4'