oracle数据库处理数据IN条件超1000处理方式,XML处理方式
import java.util.Iterator;
import java.util.List;
import org.apache.commons.collections4.CollectionUtils;
一、工具类处理方式实例
public class ListToStrUtil {
public ListToStrUtil() {
}
public static <T> String listToStrIn(int index, List<T> list) {
if (CollectionUtils.isEmpty(list)) {
return "";
} else {
StringBuilder builder = new StringBuilder();
Iterator var3 = list.iterator();
while(var3.hasNext()) {
T li = var3.next();
Class<?> aClass = li.getClass();
String simpleName = aClass.getSimpleName();
if ("String".equals(simpleName)) {
builder.append(",").append("(").append(index).append(",'").append(li).append("')");
} else {
builder.append(",").append("(").append(index).append(",").append(li).append(")");
}
}
builder.delete(0, 1);
return builder.toString();
}
}
}
二、*.xml处理方式实例
(1,ID) IN
<foreach collection="param" item="id" open="(" separator="," close=")">
(1,#{id})
</foreach>