sql的for循环代码

// java 代码    把pids用“，”隔开的 转为集合
String[] linePid = dbcIU001.getLinePId().split(",");
ArrayList<String> linePIds = new ArrayList<String>();
Collections.addAll(linePIds, linePid);
dbcIU001.setLinePIds(linePIds);

sql:

<foreach item="item" index="index" collection="linePIds" open="(" separator="," close=")">
　　#{item}
</foreach>