<insert id="bindRight" parameterType="java.util.List">
INSERT INTO T_P_USER_MODUEL (USER_ID, MODUEL_ID)
<foreach collection="list" item="item" index="index" separator=" UNION ALL ">
SELECT #{item.userId}, #{item.moduelId} FROM DUAL
</foreach>
</insert>
转载于:https://my.oschina.net/u/1410278/blog/210185