有个坑,就是批量添加时,不能动态sql
参数必须固定
批量添加
// 批量增加房源图片(效率高,但是参数不灵活)
int batchInsertSelective(List<HousePic> list);
<insert id="batchInsertSelective" parameterType="java.util.List">
INSERT INTO house_pic
(house_id, house_type, image_url, add_time)
VALUES
<foreach collection="list" item="item" separator=",">
(
#{item.houseId,jdbcType=INTEGER},
#{item.houseType,jdbcType=INTEGER},
#{item.imageUrl,jdbcType=VARCHAR},
#{item.addTime,jdbcType=TIMESTAMP}
)
</foreach>
</insert>