如何在Spring与Thymeleaf中实现一对多关联并绑定标签集合？

Hey there! Let's work through your two problems step by step—first resolving the "Tag table doesn't exist" error, then handling that space-separated tag string input.

1. Fixing the "Tag table doesn't exist" Error #

This usually happens because Hibernate isn't automatically creating the Tag table, or there's an issue with your entity configuration. Here's what to check:

a. Verify Hibernate DDL Auto Configuration #

Make sure your Spring Boot application config (either application.properties or application.yml) has the correct setting to auto-generate/update database tables:

# application.properties
spring.jpa.hibernate.ddl-auto=update

• update will create tables if they don't exist, and update their structure if your entities change. Use create or create-drop for development only (they'll recreate tables on app startup). Avoid these in production.

b. Fix Tag Entity Constructors #

JPA requires entities to have a no-argument constructor, and your test code uses a constructor that takes a tagname—so you need to add both to your Tag class:

@Entity
public class Tag {
    @Id
    private String tagname;
    @ManyToOne(fetch = FetchType.LAZY, optional = false)
    @JoinColumn(name = "barcode", nullable = false)
    private Product product;

    // Required no-arg constructor for JPA
    public Tag() {}

    // Constructor for easy tag creation
    public Tag(String tagname) {
        this.tagname = tagname;
    }

    // ... Getters & Setters
}

c. Don't Forget to Link Tags to Product #

Your test code creates Tag objects but doesn't set their product reference—since @ManyToOne(optional = false) requires this, it'll throw an error even if the table exists. Update your test code to:

Collection<Tag> col = new ArrayList<>();
Tag tag1 = new Tag("test");
tag1.setProduct(product); // Link tag to the product
col.add(tag1);
Tag tag2 = new Tag("test2");
tag2.setProduct(product);
col.add(tag2);
product.setTags(col);
productRepository.save(product);

2. Converting Space-Separated Tag String to Collection<Tag> #

You can't directly bind a string input to a Collection<Tag> in your Product entity—instead, use a form DTO to receive the input, then convert it to tags. Here's how:

a. Create a ProductForm DTO #

This class will handle the raw input, including the space-separated tag string:

public class ProductForm {
    private int barcode;
    private String name;
    private String tagString; // Holds input like "tag1 tag2 tag3"

    // ... Getters & Setters
}

b. Update Your Controller to Use the Form #

Modify your add method to accept ProductForm, convert the tag string to Tag objects, and link them to the Product:

@PostMapping("/add")
public String add(@Valid ProductForm productForm, BindingResult result, Model model) {
    model.addAttribute("responseMessage", result);
    if(!result.hasErrors()) {
        Product product = new Product();
        product.setBarcode(productForm.getBarcode());
        product.setName(productForm.getName());

        // Convert tag string to Tag collection
        Collection<Tag> tags = new ArrayList<>();
        if (productForm.getTagString() != null && !productForm.getTagString().trim().isEmpty()) {
            // Split on any whitespace (handles multiple spaces/tabs)
            String[] tagNames = productForm.getTagString().split("\\s+");
            for (String tagName : tagNames) {
                Tag tag = new Tag(tagName.trim());
                tag.setProduct(product); // Link each tag to the product
                tags.add(tag);
            }
        }
        product.setTags(tags);
        productRepository.save(product);
    }
    model.addAttribute("products", productRepository.findAll());
    return "products-add";
}

c. Update Your HTML Form #

Make sure your form uses the tagString field from the ProductForm:

<form th:action="@{/add}" th:object="${productForm}" method="post">
    <!-- Other fields for barcode, name -->
    <div>
        <label>Tags (space-separated):</label>
        <input type="text" th:field="*{tagString}" />
    </div>
    <button type="submit">Add Product</button>
</form>

That should cover both issues—your Tag table will be created correctly, and you'll be able to convert user input tags into the collection needed for your Product entity.

内容的提问来源于stack exchange，提问作者Mago99