把数组放到map 根据条件批量查询

最新推荐文章于 2022-07-13 19:53:10 发布

guochanof

最新推荐文章于 2022-07-13 19:53:10 发布

阅读量1.2k

点赞数 1

分类专栏： JAVA 文章标签：把数组放进map 根据条件批量删除

本文链接：https://blog.csdn.net/guochanof/article/details/98180010

版权

JAVA 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

controller:

public R mylistBatchRemoveCustomer(@RequestParam("ids[]") Long[] customerIds,Long mylistId{
	Map<String, Object> map = new HashMap<String, Object>();
	//把数组放入Map集合,后台的数据仍是数组
	List<Long> customerId = Arrays.asList(customerIds);
				
	map.put("customerId", customerId);
	map.put("mylistId", mylistId);
	mylistService.mylistBatchRemoveCustomer(map);
	return R.ok();
}

Mapper:

<delete id="mylistBatchRemoveCustomer"  parameterType="map">
	delete from wdkh_mylist_relation where mylist_id = #{mylistId} and customer_id in 
	<foreach item="item" collection="customerId" open="(" separator="," close=")">
		#{item}
	</foreach>
</delete>