CODEWITHSUNDEEP
spring-bootjpa-2.0crud-repository
Aswathy
Aswathy

Reputation: 1

findAll() in spring boot

When I try to select all details of my database, I don't get data s into a table structure in my jsp page. The array is printed in my jsp but don't know how to make it single objects.

Here is my mapping

    @RequestMapping("/viewall")
    public ModelAndView findAll(ModelAndView mav){
            
       List<aswathyDTO>li= dao.findAll();
       for (aswathyDTO aswathyDTO : li) {
          System.out.println(li);
       }
       mav.addObject("li",li);
       mav.setViewName("li");
    
       return new ModelAndView("displayall.jsp","li",li);
    }

and here is my jsp page

<body>
${li }

<table>
  <tr>
    <th>id</th>
    <th>name</th>
    <th>age</th>
    <c:forEach items="${li}" var="li">
      <tr>
        <td>${li.id}</td>
        <td>${li.name}</td>
        <td>${li.age}</td>
      </tr>
   </c:forEach>
</table>

</body>

Upvotes: 0

Views: 524

Answers (1)

Simon Martinelli
Simon Martinelli

Reputation: 36143

Your JSP should look like this:

<body>
<table>
<tr>
<th>id</th>
<th>name</th>
<th>age</th>
  <c:forEach items="${li}" var="element">
    <tr>
        <td>${element.id}</td>
        <td>${element.name}</td>
        <td>${element.age}</td>
    </tr>
  </c:forEach>
</table>

</body>

Also make sure that you import the standard library:

<%@ taglib prefix = "c" uri = "http://java.sun.com/jsp/jstl/core" %>

Upvotes: 1

Related Questions