在java中将列表转换为字符串for Oracle SQL in子句

import java.util.List;
import java.util.StringJoiner;

public class ListToStringExample {
    public static void main(String[] args) {
        List<String> list = List.of("apple", "banana", "orange");

        // 使用StringBuilder和循环拼接字符串
        StringBuilder stringBuilder = new StringBuilder();
        for (String item : list) {
            stringBuilder.append(item);
            stringBuilder.append(", ");
        }
        stringBuilder.setLength(stringBuilder.length() - 2); // 移除最后的逗号和空格
        String result = stringBuilder.toString();
        System.out.println(result);

        // 使用StringJoiner类拼接字符串
        StringJoiner stringJoiner = new StringJoiner(", ");
        for (String item : list) {
            stringJoiner.add(item);
        }
        result = stringJoiner.toString();
        System.out.println(result);
    }
}

List<String> employeeNames = List.of("John", "Jane", "Alice");

// 使用StringJoiner类拼接字符串
StringJoiner stringJoiner = new StringJoiner(", ");
for (String name : employeeNames) {
    stringJoiner.add("'" + name + "'");
}
String inClause = stringJoiner.toString();

String sql = "SELECT * FROM employees WHERE name IN (" + inClause + ")";
System.out.println(sql);

SELECT * FROM employees WHERE name IN ('John', 'Jane', 'Alice')