[SpringBoot] REST API 활용하여 CUD 처리 [INSERT, UPDATE, DELETE]

---

[SpringBoot] GetMapping, PostMapping [예외처리로 에러 방지하기]

---

- REST API 활용하여 CUD 처리

1. INSERT : cityAdd

@PostMapping(value="cityAdd")
public ResponseEntity<City> cityAdd(@RequestBody City city) {
    try {
        log.info("city = {}", city.toString());
        return new ResponseEntity<>(infoService.insert(city), HttpStatus.OK);
    } catch (Exception e) {
        return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
    }
}

POST로 cityAdd 전송

새로운 도시 데이터 추가 완료

---

2. UPDATE : cityEdit

@PostMapping(value="cityEdit")
public ResponseEntity<String> cityEdit(@RequestBody City city) {
    try {
        log.info("city = {}", city.toString());
        Integer updatedCnt = infoService.updateById(city);
        return new ResponseEntity<>(String.format("%d updated", updatedCnt), HttpStatus.OK);
    }catch (Exception e) {
        log.error(e.toString());
        return new ResponseEntity<>(e.getMessage(), HttpStatus.INTERNAL_SERVER_ERROR);
    }
}

POST로 cityEdit 전송

도시 데이터 업데이트 완료

NewYork에서 LA로 변경되었다.

---

3. DELETE : cityDelete

@PostMapping(value="cityDelete")
public ResponseEntity<String> cityDelete(@RequestBody City city) {
    try {
        log.info("city id = {}", city.getId());
        Integer deletedCnt = infoService.deleteById(city.getId());
        return new ResponseEntity<>(String.format("%d deleted", deletedCnt), HttpStatus.OK);
    }catch (Exception e) {
        log.error(e.toString());
        return new ResponseEntity<>(e.getMessage(), HttpStatus.INTERNAL_SERVER_ERROR);
    }
}

POST로 cityDelete 전송

LA 데이터 삭제 완료

---

- 참고자료

[SpringBoot] RestApi 만들기 (5.5) jdbcTemplate - Insert, Update, Delete

---