리스트정보를 읽어와서 insert

1. 리스트정보를 읽어와서 insertList 를 사용하여 사용
List<DataItem> smtCntList = mainDao.selectList("smt.intrnordmgnt.intrnordmgnt.selectSmtCntrList", dma_ordBasic);

mainDao.insertList("xxx.insertBkngCntr", smtCntList);

INSERT INTO TB_BK_CN (
 BK_NO
VALUES
<!-- <foreach item="item" index="index" collection="smtCntList" separator=","> -->
 (
 #{bkngNo}
 )
<!-- </foreach> -->


2. 리스트정보를 읽어와서 맵과 함께 사용
List<DataItem> list = mainDao.selectList("xxx.selectForBkng", dma_ordBasic);

dma_ordBasic.put("list",list);
dma_ordBasic.put("session", SessionThreadLocal.get());


mainDao.insert("xxx.insertBkng", dma_ordBasic);

            INSERT INTO TB_BK_EXPND (
                   BK_NO
                 , BK_STAT_CD
                 , SHPP_CD
 )
            VALUES
<foreach item="item" index="index" collection="list" separator=",">
                 (
 #{bkngNo}
                 , '20'
                 , #{item.shppCd}
     )
            </foreach>

 

 

-- 또 다른 예시

<insert id="insertCfSettleHistory">

    INSERT INTO CF_SETTLEHISTORY

    (FEEMON, FICODE, BILL_ITM_GROUP, SUBMIT_CD, SUBMIT_SNO

    , ROWCODE, ROWNAME, COLCODE, COLNAME, BFDATA

    , AFDATA, MEMO, USERID, UPDATED, UPDATESTAMP)

    <foreach collection="param.historyList" item="item" index="index" separator="UNION ALL">

    SELECT

        #{param.feemon}, #{param.ficode}, null, #{item.pageID}, #{index}

        , #{item.row}, #{item.rowName}, #{item.col}, #{item.colName}, #{item.orgValue}

        , #{item.chgValue}, #{item.memo}, #{param.session.userid}, SYSDATE, SYSTIMESTAMP

    FROM DUAL

    </foreach>

</insert>