<pre name="code" class="html"> <!--批量插入 发送信息保存 -->
<insert id="saveMessage" parameterType="List">
insert into msg(org_id,msg_type_id,user_id,content,reviewed,created)
<foreach collection="list" item="item" index="index" separator="union all">
select #{item.org_id},
#{item.msg_type_id},
#{item.user_id},
#{item.content},
#{item.reviewed},
#{item.created}
from dual
</foreach>
</insert>
<!--批量插入 发送信息保存 -->
<insert id="saveMessage" parameterType="list">
insert into msg(org_id,msg_type_id,user_id,content,reviewed,created) values
<foreach collection="list" item="item" index="index" separator="," open="(" close=")">
#{item.org_id},#{item.msg_type_id}, #{item.user_id},#{item.content}, #{item.reviewed}, #{item.created}
</foreach>
</insert>
mybatis批量保存
最新推荐文章于 2024-04-30 17:53:24 发布