如何用Java实现在线笔记本项目

-- 用户表
CREATE TABLE users (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) UNIQUE NOT NULL,
  password VARCHAR(100) NOT NULL
);
<p>-- 笔记表
CREATE TABLE notes (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(100),
content TEXT,
created_time DATETIME DEFAULT CURRENT_TIMESTAMP,
user_id BIGINT,
FOREIGN KEY (user_id) REFERENCES users(id)
);</p>

@Entity
public class Note {
    @Id @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String title;
    private String content;
    private LocalDateTime createdTime;
<pre class='brush:java;toolbar:false;'>@ManyToOne
@JoinColumn(name = "user_id")
private User user;
// getter 和 setter

@Controller
public class NoteController {
<pre class='brush:java;toolbar:false;'>@Autowired private NoteService noteService;

@GetMapping("/notes")
public String listNotes(Model model, HttpSession session) {
    User user = (User) session.getAttribute("user");
    model.addAttribute("notes", noteService.findByUser(user));
    return "note-list";
}

@PostMapping("/notes/save")
@ResponseBody
public Map<String, Object> saveNote(@RequestBody Note note, HttpSession session) {
    User user = (User) session.getAttribute("user");
    note.setUser(user);
    note.setCreatedTime(LocalDateTime.now());
    noteService.save(note);
    Map<String, Object> result = new HashMap<>();
    result.put("success", true);
    result.put("id", note.getId());
    return result;
}

<div th:each="note : ${notes}">
  <h3 th:text="${note.title}"></h3>
  <p th:text="${#strings.abbreviate(note.content, 100)}"></p>
  <a th:href="'/edit?id=' + ${note.id}">编辑</a>
</div>

mvn package
java -jar online-notebook.jar