iBatis iterate

26 Jul 2018 Tags:

Tags:

oracle, ibatis, iterate

SELECT WHERE 조건

<iterate prepend="PCKAGE_CODE IN" open="(" conjunction="," close=")" property="pckageCodeSearch">
    #pckageCodeSearch[]#
</iterate>

다중 INSERT (오라클)

<insert id="DAO.insert" parameterClass="VO">
    INSERT ALL
		<iterate property="membIdList">
			INTO 테이블명 (
        INSTT_ID
		  , MEMB_ID
			) VALUES (
				#insttId#
      , #membIdList[]#
			)
  	</iterate>
  	SELECT * FROM DUAL
</insert>