java mapper 批量处理

做个专注的工程师

已于 2023-10-25 11:27:54 修改

阅读量244

点赞数

文章标签： python java 前端

于 2023-10-25 11:08:18 首次发布

本文链接：https://blog.csdn.net/CUITAO2305532402/article/details/134030207

版权

1.批量删除

String imagePropertyIdListStr = "(" + Joiner.on(",").join(imagePropertyIdList) + ")";

int deleteByRecordIdAndPropertyIds(@Param("recordId") Long recordId ,
                                   @Param("imagePropertyIdListStr") String imagePropertyIdListStr);

<delete id="deleteByRecordIdAndPropertyIds" parameterType="java.util.Map">
    delete
    from patient_record_files
    where record_id = #{recordId}
      and property_id in ${imagePropertyIdListStr}

</delete>