好好编程-物流项目20【客户管理-删除客户】

SELECT customer_id,count(1) num
FROM t_order 
GROUP BY customer_id 

SELECT t1.customer_id
      ,t1.customer_name
      ,t1.address
      ,t1.c_sex
      ,t1.email
      ,t1.base_id
      ,t1.id_card
      ,t1.mobile_phone
      ,t1.order_id
      ,t1.remark
      ,t1.user_id
      ,t2.user_name
      ,t2.real_name
      ,t3.base_name
      ,ifnull(t4.num,0) num
from t_customer t1
  left join t_user t2
     on t1.user_id = t2.user_id 
  left join t_basicdata t3
      on t1.base_id = t3.base_id 
  left join v_customer_order_num t4
      on t1.customer_id = t4.customer_id 

<shiro:hasAnyRoles name="业务员,操作员">
  <c:if test="${dto.orderNum eq 0 }">
    <a href="javascript:void(0)" onclick="deleteUser(${dto.customer.customerId})" 
    class="tablelink"> 删除</a></td>
  </c:if>
</shiro:hasAnyRoles>
// .......
function deleteUser(userId){
  if(window.confirm("确定要删除该用户吗?")){
    location.href="/customer/delete?id="+userId;
  }
}

@RequestMapping("/delete")
public String delete(Integer id) throws IOException{
  customerService.deleteCustomer(id);
  return "customer/query";
}

public void deleteCustomer(Integer id);

@Override
public void deleteCustomer(Integer id) {
  // TODO Auto-generated method stub
  customerMapper.deleteByPrimaryKey(id);
}