菜鸟的博客

1、批量新增 <!-- 批量新增--> <insert id="batchSave" parameterType="java.util.List"> insert into table_a (id, number) values <foreach collection="list" item="item" index="index" separator=","> ( #{item.id},

&lt;insert id="save" parameterType="pd" useGeneratedKeys="true" keyProperty="news_id"&gt;parameterType:参数类型keyProperty:主键名

第一种 :以数组形式传入参数&lt;!-- 批量删除 --&gt; &lt;delete id="deleteAll" parameterType="String"&gt; delete from &lt;include refid="tableName"&gt;&lt;/include&gt; where  条件字段 in &lt;foreach item=&qu