【无标题】

一个逗号引起的错误（可恶啊）

controller

 @RequestMapping("toOrderDetailPage")
    public String toOrderDetailPage(Integer orderId, HttpServletRequest request){
        Map<String, Object> map = customerOrderService.queryOrderById(orderId);
        request.setAttribute("order",map);
        return "customer/customer_order_detail";
    }

service

 public HashMap<String, Object> queryOrderById(Integer orderId) {
         return customerOrderMapper.queryOrderById(orderId);
    }

dao

    HashMap<String, Object> queryOrderById(Integer orderId);

mapper.xml

<select id="queryOrderById" resultType="java.util.HashMap">
      select o.id,
             o.order_no,
             o.address
             case
                 when o.state = 1 then '已支付'
                 when o.state = 0 then '未支付'
                 end     status,
             sum(od.sum) total
      from t_customer_order o
               left join t_order_details od
                         on o.id = od.order_id
      where
        o.is_valid = 1
        and o.id =  #{orderId}
        and od.is_valid = 1
  </select>

结果

原因

修改后

语法正确后访问页面成功