以更新多个ID的状态为为例子
Mapper接口定义类
public int updateStatus(@Param("ids") String[] ids,@Param("status") Integer status);
需将参数声明
Mapper.xml实现
<update id="updateStatus">
update sys_consensus_dingding set status= #{status} where id in
<foreach item="id" collection="ids" open="(" separator="," close=")">
#{id}
</foreach>
</update>
调用
public int updateStatus(String ids,Integer status){
String[] arr=ids.split(",");
return consensusDingdingMapper.updateStatus(arr,status);
}
需将字符串数组化