mybatis foreach

---

    /* 배열에 값을 담았다가, ','로 join하여 param으로 서버에 넘김 */
    var arrItcn = [];

    for (var idx=0; idx<this.vo_resultData.getRowCount(); idx++)
    {
        if (this.vo_resultData.getColumn(idx, "chk") != "1")
            continue;

        arrItcn.push(this.vo_resultData.getColumn(idx, "itcnSqno"));
    }

    var itcnSqno = arrItcn.join(',');

    this.vo_inputData.setColumn("itcnSqno", itcnSqno);

---

    /* 서버에서 ','로 join된 String을 배열로 변환 */
        ArrayList<String> itcnSqnoArr = new ArrayList<String>();
        String[] items = param.getString("itcnSqno").split(",");
        for(String item : items)
        {
            String sItem = item.trim();

            if ("".equals(sItem))
                continue;

            itcnSqnoArr.add(sItem);
        }

        param.set("itcnSqnoArr", itcnSqnoArr);

---

    /* xml mybatis에서 foreach item으로 적용 */
    <if test='@kr.meps.framework.util.StringHelper@isNotEmpty(itcnSqnoArr)'> 
       AND RSLIP.ITCN_SQNO IN (<foreach collection="itcnSqnoArr" item="item" separator=",">#{item}</foreach>) 
    </if>

---

/* 결과 */
WHERE  RSLIP.ITCN_SQNO IN ('H06WEF005S0000000001','H06WEF005S0000000002','H06WEF005S0000000003','H06WEF005S0000000004')