Thymeleaf database update

Question

Is there a way to update value of the String "status" to "1" on button onClick. If there is no way to change it button onClick is there another way to do it?

I want to find row by Id and update the value of the "status".

This is Html File with Thymeleaf

    <form action="#"  method="put" th:action="@{/order}">
    <table>
        <tr th:each="p : ${GetOrder}">
            <td th:text="${p.getName()}"> <button> </button></td>
            <td th:text="${p.getSecondName()}"></td>
            <td th:text="${p.getAddress()}"></td>
            <td th:text="${p.getApartment()}"></td>
            <td th:text="${p.getPhoneNumber()}"></td>
            <td th:text="${p.getOrderPrice()}"></td>
            <td th:text="${p.getCity()}"></td>
            <td>
                <span style="color: green" th:if="${p.getStatus() == '1'}">Delivered</span>
                <span style="color: red" th:if="${p.getStatus() == '0'}">Not Delivered</span>

            </td>
            <td>
                <input type="submit" value="✓"/>
            </td>

        </tr>
    </table>
    </form>

This is my Controller Class

@Controller
@RequestMapping("/managment")
public class Managment {

    @Autowired
    private PurchaseDataService purchaseDataService;

    @Autowired
    private OrderInterface orderInterface;


    @GetMapping("/order")
    public String goToOrderList(Model model){


        List<Purchases> allStats = purchaseDataService.getAllStats();


        int status = 0;
        model.addAttribute("GetOrder", allStats);
        model.addAttribute("notDelivered", status);



        return "OrderManagment";
    }

    @PutMapping("/order/{id}")
    public String updateInfo(@PathVariable(value = "id") Integer orderId, Model model){


        return "OrderManagment";
    }




}

You cannot set method put in Form submit, you can set put method on AJAX though. — Popeye, Dec 07 '21 at 08:33

Wim Deblauwe · Answer 1 · 2021-12-08T07:49:12.513

2

Instead of 1 form for everything, you can use a form per item:

    <table>
        <tr th:each="p : ${GetOrder}">
            <td th:text="${p.getName()}"> <button> </button></td>
            <td th:text="${p.getSecondName()}"></td>
            <td th:text="${p.getAddress()}"></td>
            <td th:text="${p.getApartment()}"></td>
            <td th:text="${p.getPhoneNumber()}"></td>
            <td th:text="${p.getOrderPrice()}"></td>
            <td th:text="${p.getCity()}"></td>
            <td>
                <span style="color: green" th:if="${p.getStatus() == '1'}">Delivered</span>
                <span style="color: red" th:if="${p.getStatus() == '0'}">Not Delivered</span>

            </td>
            <td>
              <form action="#"  th:method="put" th:action="@{/order/{id}(id=${p.id})}">
                <input type="submit" value="✓"/>
              </form>
            </td>

        </tr>
    </table>

For clarity: if you use @PutMapping with Thymeleaf, be sure to have spring.mvc.hiddenmethod.filter.enabled=trueand use th:method in the template. See Delete or put methods in thymeleaf for more details.

edited Dec 08 '21 at 07:49

answered Dec 07 '21 at 08:13

Wim Deblauwe

25,113
20
133
211

method = put will not work – Popeye Dec 07 '21 at 08:34
It is perfectly possible to use PUT with Thymeleaf if you enable this filter: `spring.mvc.hiddenmethod.filter.enabled=true` – Wim Deblauwe Dec 07 '21 at 11:01
How is thymeleaf related to how a browser behave? I am seriously asking – Popeye Dec 08 '21 at 07:01
1

When you enable that property and use `th:method="put"`, then Thymeleaf will use a POST with a hidden input to simulate the PUT. – Wim Deblauwe Dec 08 '21 at 07:38
Which means browser still process a Post method and spring-boot receive a post method. Will you please explain in your answer how would that work? For me and other who would read your answer in future. – Popeye Dec 08 '21 at 07:45
Updated my answer. – Wim Deblauwe Dec 08 '21 at 07:49

score 0 · Answer 2 · answered Dec 07 '21 at 18:46

I achieved my goal, in a different way, but still. Here is the answer:

Controller Class



    @GetMapping(path = "/order/{getOrderId}")
    public String updateStudent(@PathVariable("getOrderId") Integer getOrderId, Model model){

        Purchases purchases =
                orderInterface.findByOrderId(getOrderId);



        model.addAttribute("Delivered", purchases);
        System.out.println(purchases);
        purchases.setStatus("1");

        orderInterface.save(purchases);

        return "redirect:/managment/order";
    }

Here is my Html file

    <table>

        <tr>
            <th>Id</th>
            <th>Imie</th>
            <th>Nazwsiko</th>
            <th>Adres</th>
            <th>Mieszkanie</th>
            <th>Numer telefonu</th>
            <th>Cena</th>
            <th>Miasto</th>
            <th>Delivered</th>
            <th>Finish</th>

        </tr>



            <tr th:each="p : ${GetOrder}">
                <td th:text="${p.getOrderId()}"></td>
                <td th:text="${p.getName()}"></td>
                <td th:text="${p.getSecondName()}"></td>
                <td th:text="${p.getAddress()}"></td>
                <td th:text="${p.getApartment()}"></td>
                <td th:text="${p.getPhoneNumber()}"></td>
                <td th:text="${p.getOrderPrice()}"></td>
                <td th:text="${p.getCity()}"></td>

                <td>
                    <span style="color: green" th:if="${p.getStatus() == '1'}">Delivered</span>

                    <span style="color: red"  th:if="${p.getStatus() == '0'}">NotDelivered </span>

                </td>
                <td>

                    <a th:href="@{/managment/order/{getOrderId}(getOrderId = ${p.getOrderId()})}">Click!</a>

                </td>


            </tr>
        </table>

It is a bad practise to change things in a GET request. GET requests should only retrieve information, not change anything. — Wim Deblauwe, Dec 08 '21 at 07:50
I know it's bad, but i will use it for now, until i repair it. — Peetkovski, Dec 08 '21 at 12:23

Thymeleaf database update

2 Answers2