───────┬──────────────────────────────────────────────────────────────────────── │ File: src/main//java/jp/ac/kobe_u/cs/itspecialist/todoapp/repository/ToDoRepository.java ───────┼──────────────────────────────────────────────────────────────────────── 1 │ package jp.ac.kobe_u.cs.itspecialist.todoapp.repository; 2 │ 3 │ import java.util.List; 4 │ 5 │ import org.springframework.data.domain.Page; 6 │ import org.springframework.data.domain.Pageable; 7 │ import org.springframework.data.repository.CrudRepository; 8 │ import org.springframework.stereotype.Repository; 9 │ 10 │ import jp.ac.kobe_u.cs.itspecialist.todoapp.entity.ToDo; 11 │ 12 │ @Repository 13 │ public interface ToDoRepository extends CrudRepository<ToDo, Long> { 14 │ Page<ToDo> findAll(Pageable pageable); 15 │ Page<ToDo> findByDone(boolean done, Pageable pageable); 16 │ Page<ToDo> findByMid(String mid, Pageable pageable); 17 │ Page<ToDo> findByMidAndDone(String mid, boolean done, Pageable pageable); 18 │ 19 │ // ソート機能を追加する. 20 │ Page<ToDo> findByDoneOrderBySeqAsc(boolean done, Pageable pageable); 21 │ Page<ToDo> findByDoneOrderBySeqDesc(boolean done, Pageable pageable); 22 │ Page<ToDo> findByDoneOrderByTitleAsc(boolean done, Pageable pageable); 23 │ Page<ToDo> findByDoneOrderByTitleDesc(boolean done, Pageable pageable); 24 │ Page<ToDo> findByDoneOrderByMidAsc(boolean done, Pageable pageable); 25 │ Page<ToDo> findByDoneOrderByMidDesc(boolean done, Pageable pageable); 26 │ Page<ToDo> findByDoneOrderByCreatedAtAsc(boolean done, Pageable pageable); 27 │ Page<ToDo> findByDoneOrderByCreatedAtDesc(boolean done, Pageable pageable); 28 │ Page<ToDo> findByDoneOrderByDoneAtAsc(boolean done, Pageable pageable); 29 │ Page<ToDo> findByDoneOrderByDoneAtDesc(boolean done, Pageable pageable); 30 │ Page<ToDo> findByDoneOrderByDueAtAsc(boolean done, Pageable pageable); 31 │ Page<ToDo> findByDoneOrderByDueAtDesc(boolean done, Pageable pageable); 32 │ 33 │ Page<ToDo> findByMidAndDoneOrderBySeqAsc(String mid, boolean done, Pageable pageable); 34 │ Page<ToDo> findByMidAndDoneOrderBySeqDesc(String mid, boolean done, Pageable pageable); 35 │ Page<ToDo> findByMidAndDoneOrderByTitleAsc(String mid, boolean done, Pageable pageable); 36 │ Page<ToDo> findByMidAndDoneOrderByTitleDesc(String mid, boolean done, Pageable pageable); 37 │ Page<ToDo> findByMidAndDoneOrderByCreatedAtAsc(String mid, boolean done, Pageable pageable); 38 │ Page<ToDo> findByMidAndDoneOrderByCreatedAtDesc(String mid, boolean done, Pageable pageable); 39 │ Page<ToDo> findByMidAndDoneOrderByDoneAtAsc(String mid, boolean done, Pageable pageable); 40 │ Page<ToDo> findByMidAndDoneOrderByDoneAtDesc(String mid, boolean done, Pageable pageable); 41 │ Page<ToDo> findByMidAndDoneOrderByDueAtAsc(String mid, boolean done, Pageable pageable); 42 │ Page<ToDo> findByMidAndDoneOrderByDueAtDesc(String mid, boolean done, Pageable pageable); 43 │ } ───────┴────────────────────────────────────────────────────────────────────────