foreach

여러 건의 데이터를 INSERT 또는 SELECT 해야할 때 FOREACH문을 활용하면 된다.

SELECT
	*
FROM
	TB_MEMBER
WHERE
	<foreach collection="member" item="no" open "MEMBER_NO IN(" seperator="," close=")">
    	#{no}
    </foreach>
;

INSERT INTO MEMBER (
	ID, 
    NAME, 
    AGE
) VALUES (
	<foreach collection="memberList" item="member" seperator=",">
        #{member.id},
        #{member.name},
        #{member.age}
	</foreach>
);