2021-10-01 (Springboot - board 테이블 read)

1. (Mission 수행)Board 테이블에 데이터를 read 해보자

BoardController.java

/* mission */
    // 글 읽기
    // 요청URL은 GET http://localhost:8080/board/{id}
    @GetMapping(value = "/{id}")
    public ApiResponse<BoardDTO> getBoardById(@PathVariable int id) throws Exception {
        return boardService.getBoardById(id);
    }

BoardDAO.java

BoardDTO getBoardById(int id);

BoardService.java

public ApiResponse<BoardDTO> getBoardById(int id) {
        BoardDTO data = boardDAO.getBoardById(id);
        return new ApiResponse(true, data);
    }

BoardMapper.xml

<select id="getBoardById" parameterType="int" resultType="kr.ac.daegu.springbootapi.board.model.BoardDTO">
        SELECT * from Board
        WHERE id = #{id}
    </select>