From 5c0ac6be32ba82f6934ee85a1d0c46b8cec90f0b Mon Sep 17 00:00:00 2001
From: tkskjri05 <t.kujirai@nagatake.co.jp>
Date: Sat, 1 May 2021 22:57:54 +0900
Subject: [PATCH] =?utf8?q?DB=E6=8E=A5=E7=B6=9A=E3=81=A7=E3=81=8D=E3=81=9F?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 build.gradle                                        |  1 +
 src/main/java/com/example/data/TodoHeaderInfo.java  | 19 +++++++++++++++++++
 .../java/com/example/mapper/TodoHeaderMapper.java   | 21 +++++++++++++++++++++
 .../java/com/example/rest/SampleRestController.java | 14 +++++++++++++-
 .../java/com/example/service/TodoHeaderService.java | 19 +++++++++++++++++++
 src/main/resources/application.properties           |  5 +++++
 6 files changed, 78 insertions(+), 1 deletion(-)
 create mode 100644 src/main/java/com/example/data/TodoHeaderInfo.java
 create mode 100644 src/main/java/com/example/mapper/TodoHeaderMapper.java
 create mode 100644 src/main/java/com/example/service/TodoHeaderService.java

diff --git a/build.gradle b/build.gradle
index 99487b4..1a18832 100644
--- 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
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
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
--- 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;
 
 import java.util.List;
 
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.ResponseBody;
 import org.springframework.web.bind.annotation.RestController;
 
+import com.example.data.TodoHeaderInfo;
+import com.example.service.TodoHeaderService;
 import com.google.common.collect.Lists;
 
 
 @RestController
 public class SampleRestController {
-
+	
+	@Autowired
+	TodoHeaderService todoHeaderService;
+	
 	@RequestMapping(value = "/test")
 	@ResponseBody
 	public List<String> test() {
@@ -20,4 +26,10 @@ public class SampleRestController {
 		list.add("array2");
 		return list;
 	}
+	
+	@RequestMapping(value = "/dbTest")
+	@ResponseBody
+	public List<TodoHeaderInfo> dbTest() {
+		return todoHeaderService.findTodoHeaders();
+	}
 }
diff --git a/src/main/java/com/example/service/TodoHeaderService.java b/src/main/java/com/example/service/TodoHeaderService.java
new file mode 100644
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
--- 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
-- 
2.11.0