1、批量插入
@Insert("<script>" +
"INSERT INTO tb_prod_rel_edr_screen(c_pk_id, c_screen_no, c_prod_no, c_screen_cname, c_screen_ename, n_show_order, d_crtr_time, d_uptr_time, c_crtr_code, c_uptr_code, c_scrn_json, c_chnl_code, c_version, c_prod_id, c_edr_rsn_no, c_dept_code)VALUES" +
"<foreach collection='list' item='e' separator=','> " +
"(#{e.c_pk_id},#{e.c_screen_no},#{e.c_prod_no},#{e.c_screen_cname},#{e.c_screen_ename},#{e.n_show_order},#{e.d_crtr_time},#{e.d_uptr_time},#{e.c_crtr_code},#{e.c_uptr_code},#{e.c_scrn_json},#{e.c_chnl_code},#{e.c_version},#{e.c_prod_id},#{e.c_edr_rsn_no},#{e.c_dept_code})" +
"</foreach> " +
"</script>")
int batchInsert(@Param("list")List<ProdRelEdrScreen> list);
2、批改更新
@Update("<script>" +
"update tb_prod_risk_assess set c_new_flag= '0' where c_pk_id in" +
"<foreach collection='list' index='index' item='item' open='(' separator=',' close=')'>" +
"#{item}" +
"</foreach> " +
"</script>")
int batchUpdate(@Param("list")List<String> list);
3、批改删除可以使用mybatisplus自带的
List<String> deleteIds = destEdrScreens.stream().map(ProdRelEdrScreen::getC_pk_id).collect(Collectors.toList());
int i = prodRelEdrScreenNamedSqlMapper.deleteBatchIds(deleteIds);