Java & Spring/iBatis & myBatis
[myBatis] 오라클 다건 list insert
데르벨준
2015. 12. 24. 17:34
반응형
<update id="insertMeal" parameterType="hashmap" >
INSERT ALL
<foreach collection="foodList" item="item" separator=" ">
INTO DV_MEAL_LST_TB
VALUES
(
GET_UUID() /* MEAL_LST_ID */
,SYSDATE /* CRT_DT */
,SYSDATE /* UPD_DT */
,'' /* CRT_BY */
,'' /* UPD_BY */
,#{item.meal_type} /* MEAL_LST_TYPE */
,#{item.food_id} /* FOOD_ID */
)
</foreach>
SELECT * FROM DUAL
</update>
반응형