DB接続できた

diff --git a/build.gradle b/build.gradle
index 99487b4..1a18832 100644 (file)
--- a/build.gradle
+++ b/build.gradle
@@ -20,6 +20,7 @@ dependencies {
        implementation group: 'org.mybatis.spring.boot', name: 'mybatis-spring-boot-starter', version: '2.1.4'
        implementation group: 'org.springframework.boot', name: 'spring-boot-starter-web', version: '2.4.5'
        implementation group: 'com.google.guava', name: 'guava', version: '30.1.1-jre'
+       compileOnly 'org.projectlombok:lombok:1.18.20'
 }
 
 test {

diff --git a/src/main/java/com/example/data/TodoHeaderInfo.java b/src/main/java/com/example/data/TodoHeaderInfo.java
new file mode 100644 (file)
index 0000000..e0b1bbb
--- /dev/null
+++ b/src/main/java/com/example/data/TodoHeaderInfo.java
@@ -0,0 +1,19 @@
+package com.example.data;
+
+import lombok.AllArgsConstructor;
+import lombok.Builder;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+
+@NoArgsConstructor
+@Builder
+@AllArgsConstructor
+public class TodoHeaderInfo {
+       @Getter
+       @Setter
+       private Integer id;
+       @Getter
+       @Setter
+       private String name;
+}

diff --git a/src/main/java/com/example/mapper/TodoHeaderMapper.java b/src/main/java/com/example/mapper/TodoHeaderMapper.java
new file mode 100644 (file)
index 0000000..afee1de
--- /dev/null
+++ b/src/main/java/com/example/mapper/TodoHeaderMapper.java
@@ -0,0 +1,21 @@
+package com.example.mapper;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
+
+import com.example.data.TodoHeaderInfo;
+
+@Mapper
+public interface TodoHeaderMapper {
+
+       @Select({ "<script>",
+                       " select",
+                       "  id",
+                       "  , name",
+                       " from",
+                       "  todo_header ",
+                       "</script>" })
+       List<TodoHeaderInfo> findTodoHeaders();
+}

diff --git a/src/main/java/com/example/rest/SampleRestController.java b/src/main/java/com/example/rest/SampleRestController.java
index 5b52204..617abc3 100644 (file)
--- a/src/main/java/com/example/rest/SampleRestController.java
+++ b/src/main/java/com/example/rest/SampleRestController.java
@@ -2,16 +2,22 @@ package com.example.rest;
 \r
 import java.util.List;\r
 \r
+import org.springframework.beans.factory.annotation.Autowired;\r
 import org.springframework.web.bind.annotation.RequestMapping;\r
 import org.springframework.web.bind.annotation.ResponseBody;\r
 import org.springframework.web.bind.annotation.RestController;\r
 \r
+import com.example.data.TodoHeaderInfo;\r
+import com.example.service.TodoHeaderService;\r
 import com.google.common.collect.Lists;\r
 \r
 \r
 @RestController\r
 public class SampleRestController {\r
-\r
+       \r
+       @Autowired\r
+       TodoHeaderService todoHeaderService;\r
+       \r
        @RequestMapping(value = "/test")\r
        @ResponseBody\r
        public List<String> test() {\r
@@ -20,4 +26,10 @@ public class SampleRestController {
                list.add("array2");\r
                return list;\r
        }\r
+       \r
+       @RequestMapping(value = "/dbTest")\r
+       @ResponseBody\r
+       public List<TodoHeaderInfo> dbTest() {\r
+               return todoHeaderService.findTodoHeaders();\r
+       }\r
 }\r

diff --git a/src/main/java/com/example/service/TodoHeaderService.java b/src/main/java/com/example/service/TodoHeaderService.java
new file mode 100644 (file)
index 0000000..e845a52
--- /dev/null
+++ b/src/main/java/com/example/service/TodoHeaderService.java
@@ -0,0 +1,19 @@
+package com.example.service;
+
+import java.util.List;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import com.example.data.TodoHeaderInfo;
+import com.example.mapper.TodoHeaderMapper;
+
+@Service
+public class TodoHeaderService {
+       @Autowired
+       private TodoHeaderMapper todoHeaderMapper;
+
+       public List<TodoHeaderInfo> findTodoHeaders() {
+               return todoHeaderMapper.findTodoHeaders();
+       }
+}

diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
index 67d593c..e3b2988 100644 (file)
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -1,2 +1,7 @@
 server.port=19080
 server.servlet.context-path=/todo
+
+spring.datasource.driverClassName=org.postgresql.Driver
+spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
+spring.datasource.username=postgres
+spring.datasource.password=postgres