To Do List 프로젝트 (Back)

CREATE TABLE `todo` ( `no` int NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `status` int DEFAULT '0', `reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `upd_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`no`) ) COMMENT='할일';

plugins { id 'java' id 'war' id 'org.springframework.boot' version '3.1.6' id 'io.spring.dependency-management' version '1.1.4' } group = 'com.joeun' version = '0.0.1-SNAPSHOT' java { sourceCompatibility = '17' } configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() } dependencies { implementation 'org.springframework.boot:spring-boot-starter-web' implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:3.0.3' compileOnly 'org.projectlombok:lombok' developmentOnly 'org.springframework.boot:spring-boot-devtools' runtimeOnly 'com.mysql:mysql-connector-j' annotationProcessor 'org.projectlombok:lombok' providedRuntime 'org.springframework.boot:spring-boot-starter-tomcat' testImplementation 'org.springframework.boot:spring-boot-starter-test' testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:3.0.3' } tasks.named('bootBuildImage') { builder = 'paketobuildpacks/builder-jammy-base:latest' } tasks.named('test') { useJUnitPlatform() }

# 데이터 소스 - MySQL spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/joeun?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true spring.datasource.username=joeun spring.datasource.password=123456 # Mybatis 설정 # Mybatis 설정 경로 : ~/resources/mybatis-config.xml mybatis.config-location=classpath:mybatis-config.xml # Mybatis 매퍼 파일 경로 : ~/메인패키지/mapper/**Mapper.xml mybatis.mapper-locations=classpath:mybatis/mapper/**/**.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "https://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <!-- 설정 --> <settings> <!-- 언더스코어 케이스인 컬럼을 카멜 케이스로 변환하는 설정 --> <!-- board_no - boardNo --> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings> <!-- 타입 별칭 설정 --> <typeAliases> <!-- 테이블과 매핑할 DTO가 있는 패키지 경로 지정 --> <package name="com.joeun.todo.dto"/> </typeAliases> </configuration>

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- namespace="매퍼 인터페이스 경로" --> <mapper namespace="com.joeun.todo.mapper.TodoMapper"> <!-- 할일 목록 --> <select id="list" resultType="Todo"> SELECT * FROM todo ORDER BY status ASC, no DESC </select> <!-- 할일 조회 --> <select id="select" resultType="Todo"> SELECT * FROM todo WHERE no = #{no} </select> <!-- 할일 등록 --> <insert id="insert"> INSERT INTO todo( name ) VALUES ( #{name} ) </insert> <!-- 할일 수정 --> <update id="update"> UPDATE todo SET name = #{name} ,status = #{status} ,upd_date = now() WHERE no = #{no} </update> <!-- 할일 삭제 --> <delete id="delete"> DELETE FROM todo WHERE no = #{no} </delete> <!-- last id --> <select id="lastId" resultType="int"> select last_insert_id() id </select> <!-- 전체 할일 완료 --> <update id="completeAll"> UPDATE todo SET status = 1 ,upd_date = now() </update> <!-- 전체 할일 삭제 --> <delete id="deleteAll"> DELETE FROM todo </delete> </mapper>

package com.joeun.todo.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import com.joeun.todo.dto.Todo; @Mapper public interface TodoMapper { public List<Todo> list() throws Exception; public Todo select(int no) throws Exception; public int insert(Todo todo) throws Exception; public int update(Todo todo) throws Exception; public int delete(int no) throws Exception; public int lastId() throws Exception; public int completeAll() throws Exception; public int deleteAll() throws Exception; }

package com.joeun.todo.service; import java.util.List; import com.joeun.todo.dto.Todo; public interface TodoService { public List<Todo> list() throws Exception; public Todo select(int no) throws Exception; public int insert(Todo todo) throws Exception; public int update(Todo todo) throws Exception; public int delete(int no) throws Exception; public int lastId() throws Exception; public int completeAll() throws Exception; public int deleteAll() throws Exception; }

package com.joeun.todo.service; import java.util.List; import com.joeun.todo.dto.Todo; public interface TodoService { public List<Todo> list() throws Exception; public Todo select(int no) throws Exception; public int insert(Todo todo) throws Exception; public int update(Todo todo) throws Exception; public int delete(int no) throws Exception; public int lastId() throws Exception; public int completeAll() throws Exception; public int deleteAll() throws Exception; }

package com.joeun.todo.service; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.joeun.todo.dto.Todo; import com.joeun.todo.mapper.TodoMapper; @Service public class TodoServiceImpl implements TodoService { @Autowired private TodoMapper todoMapper; @Override public List<Todo> list() throws Exception { return todoMapper.list(); } @Override public Todo select(int no) throws Exception { return todoMapper.select(no); } @Override public int insert(Todo todo) throws Exception { int result = todoMapper.insert(todo); if( result > 0 ) result = todoMapper.lastId(); return result; } @Override public int update(Todo todo) throws Exception { return todoMapper.update(todo); } @Override public int delete(int no) throws Exception { return todoMapper.delete(no); } @Override public int lastId() throws Exception { return todoMapper.lastId(); } @Override public int completeAll() throws Exception { return todoMapper.completeAll(); } @Override public int deleteAll() throws Exception { return todoMapper.deleteAll(); } }

package com.joeun.todo.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEntity; import org.springframework.web.bind.annotation.CrossOrigin; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.joeun.todo.dto.Todo; import com.joeun.todo.service.TodoService; import lombok.extern.slf4j.Slf4j; @Slf4j @RestController @CrossOrigin(origins = "*") // cors 허용 @RequestMapping("/todos") public class TodoController { @Autowired private TodoService todoService; @GetMapping() public ResponseEntity<?> getAll() { log.info("list..."); try { List<Todo> todoList = todoService.list(); log.info("할 일 개수 : " + todoList.size()); return new ResponseEntity<>(todoList, HttpStatus.OK); } catch (Exception e) { return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR); } } @GetMapping("/{id}") public ResponseEntity<?> getOne(@PathVariable Integer id) { log.info("select..."); log.info("id : " + id); try { Todo todo = todoService.select(id); log.info("todo : " + todo); return new ResponseEntity<>(todo, HttpStatus.OK); } catch (Exception e) { return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR); } } @PostMapping() public ResponseEntity<?> create(@RequestBody Todo todo) { log.info("insert..."); try { int result = todoService.insert(todo); // 새로 생성된 no 를 응답 todo.setNo(result); log.info("result : " + result); if( result > 0 ) return new ResponseEntity<>(todo, HttpStatus.CREATED); else return new ResponseEntity<>(todo, HttpStatus.OK); } catch (Exception e) { return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR); } } @PutMapping() public ResponseEntity<?> update(@RequestBody Todo todo) { log.info("update..."); log.info(todo.toString()); try { int result = 0; // 전체 완료 if( todo.getNo() == -1 ) { result = todoService.completeAll(); } else { result = todoService.update(todo); } if( result > 0 ) return new ResponseEntity<>("Update Result", HttpStatus.OK); else return new ResponseEntity<>("No Result", HttpStatus.OK); } catch (Exception e) { return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR); } } @DeleteMapping("/{id}") public ResponseEntity<?> destroy(@PathVariable Integer id) { log.info("delete..."); log.info("id : " + id); try { int result = 0; // 전체 삭제 if( id == -1 ) { result = todoService.deleteAll(); } else { result = todoService.delete(id); } if( result > 0 ) return new ResponseEntity<>("Destroy Result", HttpStatus.OK); else return new ResponseEntity<>("No Result", HttpStatus.OK); } catch (Exception e) { return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR); } } }

http://localhost:8080/boards

http://localhost:8080/boards/1

http://localhost:8080/boards

http://localhost:8080/boards

http://localhost:8080/boards/1