Java实现批改插入、更新、删除数据

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);