主页 / 问题 / 1535089
Accepted
Дмитрий
Asked:2023-08-10 00:17:46 +0000 UTC2023-08-10 00:17:46 +0000 UTC

Spring Boot + Thymeleaf + PostgreSQL 不通过选择选项将记录添加到数据库

  • 772

我正在使用 PostgreSQL 和 Thymeleaf 制作 Spring Boot 应用程序。在视图中，我制作了一个用于向数据库添加条目的表单，其中几个输入字段用于普通文本输入，另外两个输入字段带有下拉列表select option。因此，当向数据库添加记录时，会添加具有常规文本输入的字段，但不会添加下拉列表，只有一个空格。在数据库中，这两个组合框 ( ) 之一的gender类型为Enum，另一个 ( breed) 的类型为varchar(30)（并且两者均未添加）。没有错误输出。可能不太清楚，但也没有其他办法了。

该表本身具有以下结构：

create type gender as enum ('MALE', 'FEMALE');
create table dogs (id int not null generated by default as identity primary key, nickname varchar(20) not null, name varchar(40), breed varchar(30), date_of_birth timestamp without time zone, puppies_count int, gender gender);

安慰：

2023-08-09T18:45:53.968+03:00 DEBUG 17908 --- [nio-8080-exec-6] org.hibernate.SQL                        : insert into dogs (breed,date_of_birth,gender,name,nickname,puppies_count) values (?,?,?,?,?,?)
Hibernate: insert into dogs (breed,date_of_birth,gender,name,nickname,puppies_count) values (?,?,?,?,?,?)

表现：

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="https://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Собаки</title>
 <style>
   table { 
    width: 100%; 
    border: 4px double black; 
    border-collapse: collapse; 
   }
   th { 
    text-align: left; 
    background: #ccc; 
    padding: 5px; 
    border: 1px solid black; 
   }
   td { 
    padding: 5px; 
    border: 1px solid black; 
   }
  </style>
</head>
<body>
<div th:if="${isUserAuth}">Выйти</div>
<div th:unless="${isUserAuth}">Войти</div>
<div sec:authorize="isAuthenticated()">
    <p>user@ukr.net</p> <a href="/logout">Logout</a>  
</div>

<div sec:authorize="!isAuthenticated()">
    <p>Hello, guest! Please <a href="/login">Login</a> or <a href="/signup">SignUp</a></p> 
</div>
<table border="1" color="black" border-collapse="collapse">
    <tr>
        <td><b>ID</b></td>
        <td><b>Кличка</b></td>
        <td><b>Имя</b></td>
        <td><b>Пол</b></td>
        <td><b>Порода</b></td>
        <td><b>Дата рождения</b></td>
        <td><b>Щенки</b></td>
        </tr>
        <tr>
            <form modelAttribute="dog" th:method="POST" th:object:"${dog}" th:action="@{/}" action="#">
            <td><input type="submit" value="Добавить"/></td>
            <td><input type="text" th:field="*{dog.nickname}" id="dog.nickname"/></td>
            <td><input type="text" th:field="*{dog.name}" id="dog.name"/></td>
            <td><select th.field="*{dog.gender}" id="dog.gender">
                    <option th:each="genderSex : ${T(com.example.demo6.entities.Dog.Gender).values()}" 
                        th:value="${genderSex.sex}" th:text="${genderSex.sex}"></option>
                </select></td>
            <td><select  th.field="*{dog.breed}" id="dog.breed">
                    <option th:each="breed : ${T(com.example.demo6.entities.Dog.Breed).values()}" 
                        th:value="${breed.type}" th:text="${breed.type}"></option>
                </select>
            </td>
            <td><input type="text" th:field="*{dog.dateOfBirth}" id="dog.dateOfBirth"/></td>
            <td><input type="text" th:field="*{dog.puppies}" id="dog.puppies"/></td>
            </form>
            </tr>
<tr  th:each="dog : ${dogs}">
       <td th:text="${dog.id}">1</td>
       <td th:text="${dog.nickname}"></td>
       <td th:text="${dog.name}"></td>
       <td th:text="${dog.gender}"></td>
       <td th:text="${dog.breed}"></td>
       <td th:text="${dog.dateOfBirth}"></td>
       <td th:text="${dog.puppies}"></td>
        <br>
 </tr>
 </table>
 
</body>
</html>

本质：

package com.example.demo6.entities;

import java.time.LocalDateTime;


import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.EnumType;
import jakarta.persistence.Enumerated;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.Table;
import jakarta.validation.constraints.NotBlank;
import jakarta.validation.constraints.NotNull;
import jakarta.validation.constraints.Size;


@Entity
@Table(name = "dogs")
public class Dog {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    @NotBlank(message = "Nickname should not be empty")
    @Size(min = 3, max = 30, message = "Nickname should be between 3 and 30 characters long")
    private String nickname;
    //@Size(min = 3, max = 30, message = "Name should be between 3 and 30 characters long")
    private String name;
    @Column(columnDefinition = "Gender")
    @Enumerated(EnumType.STRING)
    
    private Gender gender;
    //@Column(columnDefinition = "Breed")
    @Enumerated(EnumType.STRING)
    private Breed breed;
    @Column(name = "date_of_birth")
    private LocalDateTime dateOfBirth;
    @Column(name = "puppies_count")
    private int puppies;
    
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getNickname() {
        return nickname;
    }

    public void setNickname(String nickname) {
        this.nickname = nickname;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Gender getGender() {
        return gender;
    }

    public void setGender(Gender gender) {
        this.gender = gender;
    }

    public Breed getBreed() {
        return breed;
    }

    public void setBreed(Breed breed) {
        this.breed = breed;
    }

    public LocalDateTime getDateOfBirth() {
        return dateOfBirth;
    }

    public void setDateOfBirth(LocalDateTime dateOfBirth) {
        this.dateOfBirth = dateOfBirth;
    }

    public int getPuppies() {
        return puppies;
    }

    public void setPuppies(int puppies) {
        this.puppies = puppies;
    }

    public Dog() {}
    
    public enum Breed {
        WHWT("Вест Хайленд Вайт Терьер"), 
        SCOTTISH_T("Скотч Терьер"), 
        SEALYHAM_T("Силихем Терьер"), 
        JRT("Джек Рассел Терьер"), 
        AUSTRALIAN_S("Австралийская овчарка"), 
        METIS("Метис/Дворняга"),
        OTHER("Другая");
        
        String type;
        Breed(String type){this.type = type;}
        public String getType(){return type;}
    }
    
    public enum Gender {
        MALE("Мальчик"), 
        FEMALE("Девочка"); 
    
        String sex;
        Gender(String sex){this.sex = sex;}
        public String getSex(){return sex;}
    }
}
postgresql

1 个回答

  1. Best Answer

    首先，你有一个 Thymeleaf 语法​​错误。排队

    <td><select th.field="*{dog.gender}" id="dog.gender">

    和

    <td><select  th.field="*{dog.breed}" id="dog.breed">

    点而不是冒号。

    此外，如果您填写的字段是 Thymeleaf 表单中的枚举 () ，则无需将枚举成员的自定义别名编写enum为字段。th:value

    因为 Spring 自动通过 -a 成员的字符串表示形式enum将其转换为对象本身。而将“杰克罗素梗犬”变成“JRT”对他来说将是有问题的。

    因此，例如th:value，可以简单地传递通过枚举迭代的对象，因为例如在这种情况下

    th:each="each : ${enum}"

    foreach将被调用toString()，对于枚举返回name。然后 Spring 很容易将其转换为enum隐含的成员 -a 。

    • 0

相关问题