OSDN Git Service

リストの取得を追加
authortkskjri05 <t.kujirai@nagatake.co.jp>
Mon, 3 May 2021 04:33:54 +0000 (13:33 +0900)
committertkskjri05 <t.kujirai@nagatake.co.jp>
Mon, 3 May 2021 04:33:54 +0000 (13:33 +0900)
src/main/java/com/example/logic/TodoLogic.java
src/main/java/com/example/mapper/TodoListMapper.java
src/main/java/com/example/rest/TodoRestController.java
src/main/java/com/example/service/TodoService.java

index 5ab0afd..43e10b5 100644 (file)
@@ -1,6 +1,7 @@
 package com.example.logic;\r
 \r
 import java.util.List;\r
+import java.util.Optional;\r
 import java.util.stream.Collectors;\r
 \r
 import org.springframework.beans.factory.annotation.Autowired;\r
@@ -56,4 +57,13 @@ public class TodoLogic {
                                .name(dto.getName())\r
                                .build();\r
        }\r
+       \r
+       public Integer getMaxId(String headerId) {\r
+               if(ObjectUtils.isEmpty(headerId)) {\r
+                       throw new RuntimeException("headerId is Empty!");\r
+               }\r
+               return Optional\r
+                               .ofNullable(todoListMapper.getMaxId(Integer.valueOf(headerId)))\r
+                               .orElse(0);\r
+       }\r
 }\r
index 7fee7f6..e35fec4 100644 (file)
@@ -27,5 +27,15 @@ public interface TodoListMapper {
                        "</script>" })
        List<TodoListDto> findTodoLists(@Param("headerId") Integer headerId);
        
+       @Select({ "<script>",
+               " select",
+               "     , max(id)",
+               " from",
+               "     todo_list ",
+               " where",
+               "     header_id = #{headerId}",
+               "</script>" })
+       Integer getMaxId(@Param("headerId") Integer headerId);
+       
        //TODO create delete update
 }
\ No newline at end of file
index ca09122..7c83e59 100644 (file)
@@ -39,4 +39,10 @@ public class TodoRestController {
        public List<TodoListInfo> getLists(@RequestParam(name = "headerId") String headerId) {\r
                return todoHeaderService.findTodoLists(headerId);\r
        }\r
+       \r
+       @RequestMapping(value = "/getMaxId", method = RequestMethod.GET)\r
+       @ResponseBody\r
+       public Integer getMaxId(@RequestParam(name = "headerId") String headerId) {\r
+               return todoHeaderService.getMaxId(headerId);\r
+       }\r
 }\r
index f658401..4916083 100644 (file)
@@ -21,4 +21,8 @@ public class TodoService {
        public List<TodoListInfo> findTodoLists(String headerId) {
                return todoHeaderLogic.findTodoLists(headerId);
        }
+       
+       public Integer getMaxId(String headerId) {
+               return todoHeaderLogic.getMaxId(headerId);
+       }
 }