I am a beginner in Java and I'm trying to display the total number of clients on my html file. I tried setting it as a variable directly from my app controller but it returns a blank display. Any help on how I could display the total number of client/users is greatly appreciated.
Here's what I did
MY CONTROLLER
@RequestMapping("/backoffice-admin/admins/editar-admin/{id}")
public String dash6a(@PathVariable("id") int id, Model model) {
model.addAttribute("num", clientRepository.countById(id));
return "/backoffice-admin/admins/editar-admin";
}
REPOSITORY
package com.cometa.app.repository;
import javax.validation.Valid;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.transaction.annotation.Transactional;
import com.cometa.app.model.Client;
public interface ClientRepository extends CrudRepository<Client, Integer> {
@Query(value = "SELECT COUNT(id) FROM client;", nativeQuery = true)
int countById(int id);
}
HTML file
<div class="stats-holder-2-2-2" th:each="client, custStat: ${num}">
<a href="/backoffice-admin/clientes/todos-clientes" class="wrapper_stats-2 w-inline-block">
<div class="div-block-99">
<div class="div-block-137 azul">
<div class="text-block-113">1</div>
</div>
<div class="div-block-101" >
<div class="text-block-114 _303" th:text="${custStat.count}">[[${num}]]</div>
<div class="text-block-115">Clientes</div>
</div>