in方式的参数传递

发现问题

对于预编译的SQL语句，in(?)该如何传参呢,?中是一个列表，如'1','2','3'.直接替换后应该是 in ('1','2','3'),但是把'1','2','3'传进却不能正确的执行取得结果，跟踪发现参数转义了，变成in (''1','2','3'') ,导致结果不对。

正确参考思路1:

PreparedStatement statement = connection.prepareStatement("Select * from test where field in (?)");
Array array = statement.getConnection().createArrayOf("VARCHAR", new Object[]{"A1", "B2","C3"});
statement.setArray(1, array);
ResultSet rs = statement.executeQuery();

正确参考思路2：

String[] values = value.split(",");
sql = String.format(sql.replace("?", "%s"),getStringFromArray(values);

public static String getStringFromArray(Object ... objects ) {
	StringBuilder sb = new StringBuilder();
	for (int i = 0; i < objects.length; i++) {
		if(i == objects.length - 1) {
			sb.append(objects[i]);
		}else {
			sb.append(objects[i]).append(",");
		}
	}
	return sb.toString().trim();
}