src/main/java/com/example/mapper/TodoListMapper.java

   1 package com.example.mapper;
   2
   3 import java.util.List;
   4
   5 import org.apache.ibatis.annotations.Mapper;
   6 import org.apache.ibatis.annotations.Param;
   7 import org.apache.ibatis.annotations.Select;
   8
   9 import com.example.dto.TodoListDto;
  10
  11 @Mapper
  12 public interface TodoListMapper {
  13         @Select({ "<script>",
  14                         " select",
  15                         "     header_id",
  16                         "     , id",
  17                         "     , name",
  18                         "     , done",
  19                         "     , created",
  20                         "     , updated",
  21                         " from",
  22                         "     todo_list ",
  23                         " where",
  24                         "     header_id = #{headerId}",
  25                         " order by ",
  26                         "     id",
  27                         "</script>" })
  28         List<TodoListDto> findTodoLists(@Param("headerId") Integer headerId);
  29
  30         //TODO create delete update
  31 }