mybatics一次插入多行

作者:zeke | 时间:Dec 11, 2024 3:33:57 PM | 访问量:3

<p>&lt;insert id="insertList" parameterType="java.util.List" useGeneratedKeys="false"&gt;</p><p>&nbsp;&nbsp;insert into TABLENAME(ID, MAIN_ID)</p><p>&nbsp;&nbsp;&nbsp;values</p><p>&nbsp;&nbsp;&lt;foreach collection="list" item="item" index="index" separator=","&gt;</p><p>&nbsp;&nbsp;(#{item.id,jdbcType=VARCHAR}, #{item.mainId,jdbcType=VARCHAR})</p><p>&lt;/foreach&gt;</p><p>&lt;/insert&gt;</p><p><br></p>