为了提高代码的执行效率,我们有时需要采用批量插入的添加方法。
mybatis配置如下:
<insert id="insertModelConditionDetailList" parameterType="java.util.List">
insert into `ldp_analy_model_condition_detail` (<include refid="detailSql"></include>)
values
<foreach collection="list" item="item" separator=",">
(#{item.id},#{item.cId},#{item.andOr},#{item.selectName},#{item.operation},
#{item.referenceValue},#{item.conditionSql},#{item.createBy},#{item.createTime})
</foreach>
</insert>
mapper配置如下:
public int insertModelConditionDetailList(@Param("list")List<Map<String,Object>> detailList);