Mybatis注解批量更新之多参数多条件

    /**
     * 批量修改状态
     *
     * UPDATE user_order SET status = 
	 * CASE WHEN order_no = ? AND user_id = ? THEN ? WHEN order_no = ? AND user_id = ? THEN ? END 
	 * WHERE ( order_no = ? AND user_id = ?) or (order_no = ? AND user_id = ? )
     * @param list
     */
    @Update({"<script>" +
            "UPDATE user_order"+
            " SET status ="+
            "<foreach collection=\"list\" item=\"item\" open=\"CASE\" close=\"END\">"+
            "WHEN order_no = #{item.orderNo} AND user_id = #{item.userId} THEN #{item.status}" +
            "</foreach>"+
            "<where>"+
            "<foreach collection=\"list\" item=\"item\" open=\"( \" separator=\") or (\" close=\" )\">"+
            "order_no = #{item.orderNo} AND user_id = #{item.userId}" +
            "</foreach>"+
            "</where>"+
            "</script>"})

    void batchUpdateStatus(@Param("list") List<UserOrder> list);