service层
@Override
public int operateOrder(Long ids[], Integer operation) {
Map<String, Object> map=new HashMap<>();
map.put("ids",ids);
map.put("operation",operation);
return shoppingOrderMapper.allSubmitOrder(map);
}
map层
public int allSubmitOrder(Map<String,Object> map);
xml
<update id="allSubmitOrder" parameterType="map">
update t_shopping_order set status = #{operation}, audit_time = NOW()
where id in
<foreach collection="ids" open="(" separator="," close=")" item="id">
#{id}
</foreach>
</update>