SpringBootコース

MyBatisを使ったデータベース有のSpringBootアプリケーション

SpringBoot + MyBatisでTODOリストアプリ作成 (2)（機能追加）

ここでは、このチュートリアルで作成した全てのソースコードを掲載しています。
```
src/
└── main/
    ├── java/
    │   └── com/
    │       └── example/
    │           └── todolist/
    │               ├── controller/
    │               │   └── TaskController.java (1)
    │               ├── mapper/
    │               │   └── TaskMapper.java (2)
    │               ├── model/
    │               │   └── Task.java (3)
    │               └── TodolistApplication.java
    └── resources/
        │    └── templates/
        │       └── tasks/
        │              └── form.html (4)
        │              └── list.html (5)
        ├── application.properties (6)
        └── schema.sql (7)
```
  

---

## 1. TaskController.java
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```java~TaskController
package com.example.todolist.controller;

import java.util.List;

import jakarta.validation.Valid;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import com.example.todolist.mapper.TaskMapper;
import com.example.todolist.model.Task;

@Controller
@RequestMapping("/tasks")
public class TaskController {
    @Autowired
    private TaskMapper taskMapper;

    @GetMapping
    public String listTasks(Model model) {
        List<Task> tasks = taskMapper.getAllTasks();
        model.addAttribute("tasks", tasks);
        return "tasks/list";
    }

    @GetMapping("/new")
    public String showCreateForm(Model model) {
        model.addAttribute("task", new Task());
        return "tasks/form";
    }

    @PostMapping
    public String createTask(@Valid @ModelAttribute Task task, BindingResult bindingResult, Model model) {
        if (bindingResult.hasErrors()) {
            return "tasks/form";
        }
    	taskMapper.insertTask(task);
        return "redirect:/tasks";
    }

    @GetMapping("/{id}/edit")
    public String showEditForm(@PathVariable Long id, Model model) {
        Task task = taskMapper.getTaskById(id);
        model.addAttribute("task", task);
        return "tasks/form";
    }

    @PostMapping("/{id}")
    public String updateTask(@PathVariable Long id, @ModelAttribute Task task) {
        task.setId(id);
        taskMapper.updateTask(task);
        return "redirect:/tasks";
    }

    @PostMapping("/{id}/delete")
    public String deleteTask(@PathVariable Long id) {
    	taskMapper.deleteTask(id);
        return "redirect:/tasks";
    }

    @PostMapping("/{id}/toggle")
    public String toggleCompletion(@PathVariable Long id) {
    	taskMapper.toggleTaskCompletion(id);
        return "redirect:/tasks";
    }
}

```
</details>

## 2. TaskMapper.java
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```java~TaskMapper
package com.example.todolist.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.example.todolist.model.Task;

@Mapper
public interface TaskMapper {

    @Select("SELECT * FROM tasks ORDER BY created_at ASC")
    @Results(id = "TaskResultMap", value = {
        @Result(property = "id", column = "id", id = true),
        @Result(property = "name", column = "name"),
        @Result(property = "completed", column = "completed"),
        @Result(property = "createdAt", column = "created_at"),
        @Result(property = "updatedAt", column = "updated_at")
    })
    List<Task> getAllTasks();

    @Select("SELECT * FROM tasks WHERE id = #{id}")
    @ResultMap("TaskResultMap")
    Task getTaskById(Long id);

    @Insert("INSERT INTO tasks (name) VALUES (#{name})")
    @Options(useGeneratedKeys = true, keyProperty = "id")
    void insertTask(Task task);

    @Update("UPDATE tasks SET name = #{name}, completed = #{completed}, updated_at = CURRENT_TIMESTAMP WHERE id = #{id}")
    void updateTask(Task task);

    @Update("UPDATE tasks SET completed = NOT completed, updated_at = CURRENT_TIMESTAMP WHERE id = #{id}")
    void toggleTaskCompletion(Long id);

    @Delete("DELETE FROM tasks WHERE id = #{id}")
    void deleteTask(Long id);
}

```
</details>

## 3. Task.java
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```java~Task
package com.example.todolist.model;

import java.time.LocalDateTime;

import jakarta.validation.constraints.NotBlank;
import jakarta.validation.constraints.Size;

import lombok.Data;

@Data
public class Task {
    private Long id;
    @NotBlank(message = "タスク名は必須です")
    @Size(max = 10, message = "タスク名は10文字以内で入力してください")
    private String name;
    private Boolean completed;
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
}

```
</details>

## 4. form.html
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```html~form
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title>Create/Edit Task</title>
</head>
<body>
    <h1 th:text="${task.id != null ? 'Edit Task' : 'Create Task'}"></h1>
    <form th:action="${task.id != null ? '/tasks/' + task.id : '/tasks'}" method="post" th:object="${task}">
        <label for="name">Task Name</label>
		<input type="text" id="name" name="name" th:field="*{name}" required />
		
        <p th:if="${#fields.hasErrors('name')}" th:errors="*{name}" style="color:red"></p>
        <button type="submit" th:text="${task.id != null ? 'Save' : 'Create'}"></button>
    </form>
</body>
</html>

```
</details>

## 5. list.html
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```html~list
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title>Task List</title>
</head>
<body>
    <h1>Task List</h1>
    <a href="/tasks/new">Create New Task</a>
    <ul>
        <li th:each="task : ${tasks}">
			<form th:action="'/tasks/' + ${task.id} + '/toggle'" method="post" style="display: inline;">
                <input type="checkbox" th:checked="${task.completed}" th:onchange="this.form.requestSubmit()" />
            </form>
            <span th:text="${task.name}"></span>
            <a th:href="'/tasks/' + ${task.id} + '/edit'">Edit</a>
            <form th:action="'/tasks/' + ${task.id} + '/delete'" method="post" style="display: inline;">
                <button type="submit">Delete</button>
            </form>
        </li>
    </ul>
</body>
</html>

```
</details>

## 6. application.properties
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```properties~application
# データベース設定
spring.sql.init.mode=always
spring.datasource.url=jdbc:postgresql://localhost:5432/todolist
spring.datasource.username=postgres
spring.datasource.password=password
spring.datasource.driver-class-name=org.postgresql.Driver

```
</details>

## 7. schema.sql
<details><summary>ソースコード<クリックで折りたたみ ON/OFF></summary>

```sql~schema
CREATE TABLE IF NOT EXISTS tasks (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  completed BOOLEAN DEFAULT FALSE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

```
</details>