Spring不希望将记录保存在数据库中

Question

日志：

2021-05-09 14:04:19.356错误22211---[nio-8080-exec-2]O.A.C.C.C.[.[.[/].[dispatcherServlet]:servlet.Service（）对于路径[]上下文中的servlet[dispatcherServlet]抛出异常[请求处理失败；嵌套异常为java.lang.NullPointerException：无法调用“com.dzeru.springLoginformandoAuth2tutorial.repos.postrepo.save（Object）”，原因是“this.postrepo”为null]

package com.dzeru.springloginformandoauth2tutorial.controllers;

import com.dzeru.springloginformandoauth2tutorial.entities.Post;
import com.dzeru.springloginformandoauth2tutorial.repos.PostRepo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PostMapping;

import java.security.Principal;
import java.util.ArrayList;
import java.util.List;

@Controller
public class PostMakerController {
    @Autowired
    private PostRepo postRepo;

    public static List<Post> posts = new ArrayList<>();

    @PostMapping("/prj")
    public String makePost(String title, String content,
                           Principal principal, Model model) {

        int wordsLength = content.split(" ").length;

        if (title.length() > 30) {
            model.addAttribute("text", "Title size > 30");
        } else if (wordsLength < 30) {
            model.addAttribute("text", "Your content < 30 words");
        } else if (wordsLength > 100) {
            model.addAttribute("text", "Your content > 100 words");
        } else {
            Post post = new Post();
            post.setContent(content);
            post.setAuthor(principal.getName());
            post.setParagraph(title);

            postRepo.save(post);
            posts = postRepo.findAll();

            model.addAttribute("posts", posts);

            return "prj";
        }

        return "prj";
    }
}

package com.dzeru.springloginformandoauth2tutorial.repos;

import com.dzeru.springloginformandoauth2tutorial.entities.Post;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import org.springframework.stereotype.Service;

@Service
@Repository
public interface PostRepo extends JpaRepository<Post, Integer> {
}

<form action="/prj" method="post" class="auto_form">
    <div class="container">
        <label>
            <input type="text" placeholder="Enter title" name="title" required>
        </label>
        <label>
            <textarea id="text" cols="100%" rows="20%" placeholder="Enter content" name="content" required></textarea>
        </label>
        <b th:text="${text}"></b>
        <button type="submit" class="button_login">Submit</button>
    </div>
</form>

package com.dzeru.springloginformandoauth2tutorial.entities;

import javax.persistence.*;
import javax.validation.constraints.NotNull;
import java.util.Objects;

@Entity
@Table(name = "post")
public class Post {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @NotNull
    private String author;
    @NotNull
    private String paragraph;
    @NotNull
    private String content;

    public Post() {
        this("EMPTY", "EMPTY", "EMPTY");
    }

    public Post(@NotNull String author, @NotNull String paragraph, @NotNull String content) {
        this.author = author;
        this.paragraph = paragraph;
        this.content = content;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        Post post = (Post) o;
        return Objects.equals(id, post.id) && Objects.equals(author, post.author) && Objects.equals(paragraph, post.paragraph) && Objects.equals(content, post.content);
    }

    @Override
    public int hashCode() {
        return Objects.hash(id, author, paragraph, content);
    }

    @Override
    public String toString() {
        return "Post{" +
                "id=" + id +
                ", author='" + author + '\'' +
                ", paragraph='" + paragraph + '\'' +
                ", content='" + content + '\'' +
                '}';
    }

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

    public Long getId() {
        return id;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getParagraph() {
        return paragraph;
    }

    public void setParagraph(String paragraph) {
        this.paragraph = paragraph;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }
}

谢谢你的帮助！

Answer 1

我修好了。问题在于：数据截断：数据对于列'column_name'太长。我只是在我的应用程序中创建:jdbcCompliantTruncation=false.properties