java mybatisplus 批量新增和更新

荆轲刺秦王

1.批量新增

java mapper：
/** * 批量插入 */ void batchInsert(@Param("list") List<DeductionDetailEntity>
insertList);
xml:
<insert id="batchInsert"> insert into meter_contract_deduction_detail
(id,epid,dept_id,deduction_id,deduction_name,exchange_rate,
deduction_amount,deduction_remark,is_delete,create_by,
create_at,update_by,update_at) values <foreach collection="list" item="item"
index="index" separator=","> (#{item.id},#{item.epid},#{item.deptId},
#{item.deductionId},#{item.deductionName},#{item.exchangeRate},
#{item.deductionAmount},#{item.deductionRemark},#{item.isDelete},#{item.createBy},
#{item.createAt},#{item.updateBy},#{item.updateAt}) </foreach> </insert>

2.批量更新

2.1 批量更新一个字段 比如批量更新删除字段

java mapper :
/** * 批量删除 * * @param ids * @return */ int batchDelete(@Param("list")
List<String> ids);
xml : 
<update id="batchDelete"> update meter_contract_deduction_detail SET is_delete
= 1 where id in <foreach collection = 'list' item = 'item' index='index' open =
'(' separator= ',' close = ')' > #{item} </foreach> </update>

2.2 批量更新多个字段

java mapper : 
void batchUpdate(@Param("referenceIds") List<String> referenceIds,
@Param("approvalStatus") Integer approvalStatus, @Param("processId") String
processId);
xml : 
<!--批量更新--> <update id="batchUpdate"> UPDATE meter_contract_prod_value SET
approval_status = #{approvalStatus}, process_id = #{processId} WHERE id in
<foreach collection="referenceIds" item="item" index="index" open = '('
separator= ',' close = ')'> #{item} </foreach> </update>

• « 上一篇：Python实现批量修改文件名（万能模板）
• » 下一篇：2023美赛A题：收干旱影响的植物群落（MCM）思路&Python代码