CRUD 연습

 

 

 

 

 

 

oracle에 문제로 포맷후 다시실행하고 고난과 역경의 순간들이었습니다..

오라클 21c 설치후 sqldeveloper 설치 localhost를 IP 주소로 바꿔서 해줘야 성공이뜹니다..

 

쿼리문을 돌린후 위에 나와있는 제시사항 코드로 짜보기

 

 

 

① 우선 첫번째로 위에 켜자마자 주소가 list.do로 나오게 하기 위해서 redirect로 return 해주었습니다.

MvcController

 

 
@Controller
public class MvcController {
 
  @GetMapping(value="/")
  public String list() {
    return "redirect:/board/list.do";
  }
  
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
 
<mapper namespace="com.gdu.exam.dao.BoardMapper">
 
 
  <select id="getBoard" parameterType="int" resultType="BoardDto">
    SELECT BOARD_NO, AUTHOR, TITLE, CONTENT, HIT, IP, POSTDATE
      FROM MVC_BOARD_T
     WHERE BOARD_NO = #{boardNo}
  </select>
 
  <insert id="addBoard" parameterType="BoardDto">
    INSERT INTO MVC_BOARD_T (
        BOARD_NO
      , AUTHOR
      , TITLE
      , CONTENT
    ) VALUES (
        MVC_BOARD_SEQ.NEXTVAL
      , #{author}
      , #{title}
      , #{content}
    )
  </insert>
 
  <select id="getBoardList" resultType="BoardDto">
    SELECT BOARD_NO, AUTHOR, TITLE, HIT, POSTDATE
      FROM MVC_BOARD_T
     ORDER BY BOARD_NO DESC
  </select>
  
   <delete id="delete" parameterType="int">
       DELETE FROM MVC_BOARD_T WHERE BOARD_NO = #{boardNo}
   </delete>
</mapper>
 

 

 

 

③ interface BoardMapper

 각각 데이터베이스에서 수행할 작업을 정의합니다. 연결한 데이터베이스를 실행해주기위한 코드입니다.

 

package com.gdu.exam.dao;
 
import java.util.List;
 
import org.apache.ibatis.annotations.Mapper;
 
import com.gdu.exam.dto.BoardDto;
 
@Mapper
public interface BoardMapper {
    public BoardDto getBoard(int boardNo);
    public int addBoard(BoardDto boardDto);
    public List<BoardDto> getBoardList();
    public int delete(int boardNo);
 
}

package com.gdu.exam.service;
 
import java.util.List;
 
 
 
import com.gdu.exam.dto.BoardDto;
 
public interface BoardService {
    public BoardDto getBoard(int boardNo);
    public int addBoard(BoardDto boardDto);
    public List<BoardDto> getBoardList();
    public int delete(int boardNo);
}

 

⑤ 서비스 구현

addBoard(BoardDto boardDto) -> BoardDto 객체를 이용하여 데이터베이스에 새로운 게시글을 추가합니다.

getBoardList() -> 목록조회 List로 받습니다.

getBoard(int boardNo)-> 게시글 번호를 이용하여 해당 게시글의 정보를 조회하여 반환합니다.

delete(int boardNo) -> 게시글 번호로 삭제요청

 

@RequiredArgsConstructor 
@Service
public class BoardServiceImpl implements BoardService {
    
    private final BoardMapper boardMapper;
    
    @Override
    public int addBoard(BoardDto boardDto) {
        return boardMapper.addBoard(boardDto);
    }
 
    @Override
    public List<BoardDto> getBoardList() {
        return boardMapper.getBoardList();
    }
 
    @Override
    public BoardDto getBoard(int boardNo) {
        return boardMapper.getBoard(boardNo);
    }
 
    @Override
    public int delete(int boardNo) {
        return boardMapper.delete(boardNo);
    }
 
    
}

@RequiredArgsConstructor
@Controller
public class BoardController {
    
   
   private final BoardService boardService;
    
   @GetMapping(value="/board/list.do")
   public String list(Model model) {
     List<BoardDto> boardList = boardService.getBoardList();
     model.addAttribute("boardList", boardList);
     return "board/list";
   }
   
   @GetMapping(value="/board/write.do")
   public String write() {
       return "board/write";
   }
   @PostMapping(value="/board/insert.do")
   public String add(BoardDto boardDto
                    , RedirectAttributes redirectAttributes) {
     int addResult = boardService.addBoard(boardDto);
     redirectAttributes.addFlashAttribute("addResult", addResult);
     return "redirect:/board/list.do";
   }
   @GetMapping(value="/board/detail.do")
   public String detail(@RequestParam int boardNo, Model model) {
     BoardDto boardDto = boardService.getBoard(boardNo);
     model.addAttribute("board", boardDto);
     return "board/detail";  
   }
   @GetMapping("/board/delete.do")
   public String delete(@RequestParam int boardNo, RedirectAttributes redirectAttributes) {
       int deleteResult = boardService.delete(boardNo);
       redirectAttributes.addFlashAttribute("deleteResult", deleteResult);
       return "redirect:/board/list.do";
   }
 
}