时间戳

首页 > 解决方案 > 如何显示为特定产品下订单的客户数量？

java - 如何显示为特定产品下订单的客户数量？

问题描述

我是 java 的初学者，我想显示在我的 MVC WebApp 上为特定产品下订单的客户数量。我想出了一个合乎逻辑的方法，但我偶然发现了一个死胡同。

这是我试图做的。任何帮助将不胜感激。

我的控制器

 @GetMapping("/produtos-crud/produtos-da-categoria-admin/{id}")
 public String Home15(Model model,  @PathVariable("id") int id, HttpServletRequest request, @Valid User user) {
            
    HttpSession session = request.getSession(false);
    if (session != null) {
        for(User user_: userRepository.verify(session.getAttribute("email"), session.getAttribute("password"))) {
                
         model.addAttribute("num_clients", orderRepository.countClientById(?)); //'?' <- All I need is this value
    





                //These codes are not relevant. Please ignore.
                //For originality purpose
                model.addAttribute("num", productRepository.countProductById(id) + " Produtos");
                model.addAttribute("users_cat", categoryRepository.findById(id));
                model.addAttribute("name", user_.getName());
                model.addAttribute("users", productRepository.findProductByCategoryId(id));
                
                }
            }
            else {       
                
                return "redirect:/index";
                
            }
            
            
            return "/produtos-crud/produtos-da-categoria-admin";

我的仓库

public interface OrderRepository extends CrudRepository<Pedido, Integer> {

@Query(value = "SELECT COUNT(client) FROM order WHERE product = ?;", nativeQuery = true)
    int countClientById(int ?); //Feel free to set a variable

}

我的 HTML 文件

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Category Items</title>
<meta content="Dashboard" property="og:title">
<meta content="Dashboard" property="twitter:title">
<meta content="width=device-width, initial-scale=1" name="viewport">
<meta content="Webflow" name="generator">
<link href="css/normalize.css" rel="stylesheet" type="text/css">
<link href="css/webflow.css" rel="stylesheet" type="text/css">
<link href="css/ui-login-teste.webflow.css" rel="stylesheet" type="text/css">
</head>

<body>

   <!-- Irrelevant codes have been removed for to shorten code--> 

  <div class="valida-table-field estatuto">
     <div th:text="${num_clients}">14</div> <!-- Main focus -->
  </div>

</body>
</html>

项目视图的屏幕截图 在此处输入图像描述

标签： javahtmlsql

解决方案

推荐阅读