16 - DB Spring 게시판 댓글

package com.db.model;

import java.sql.Timestamp;

import lombok.Data;

@Data
public class FBoardReplyVO {

	private int rno;
	private int num;
	private String writer;
	private String content;
	private Timestamp regDate;

}

package com.db.mapper;

import com.db.model.FBoardReplyVO;

public interface ReplyMapper {

	// 댓글 작성
	public void replyWriter(FBoardReplyVO vo)throws Exception;
}

package com.db.service;

import com.db.model.FBoardReplyVO;

public interface ReplyService {

	// 댓글 작성
	public void replyWriter(FBoardReplyVO vo) throws Exception;
}

package com.db.service;

import org.springframework.beans.factory.annotation.Autowired;

import com.db.mapper.ReplyMapper;
import com.db.model.FBoardReplyVO;

public class ReplyServiceImpl implements ReplyService{
	
	@Autowired
	private ReplyMapper mapper;
	
	@Override
	public void replyWriter(FBoardReplyVO vo) throws Exception {
		mapper.replyWriter(vo);
	}
}

package com.db.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import com.db.model.FBoardReplyVO;
import com.db.service.ReplyService;

@Controller
@RequestMapping("/reply/*")
public class ReplyController {
	@Autowired
	private ReplyService service;
	
	// 댓글 작성
	@PostMapping("/write")
	public String postWirte(FBoardReplyVO vo) throws Exception {

		service.replyWriter(vo);

		return "redirect:/board/get?num=" + vo.getNum();
	}


}

	// 댓글 조회
	public List<FBoardReplyVO> replyList(int num)throws Exception;

	// 댓글 조회
	public List<FBoardReplyVO> replyList(int num) throws Exception;

	@Override
	public List<FBoardReplyVO> replyList(int bno) throws Exception {
		return mapper.replyList(bno);
	}

	@Inject
	private ReplyService replyService; 

    // 게시판 조회
	@GetMapping("/get")
	public void boardGetPageGET(@RequestParam("num") int num, Model model, Criteria cri) throws Exception {
		bservice.updateReadCount(num); //조회수 업데이트
		log.info("게시글번호:" + num);
		model.addAttribute("pageInfo", bservice.getPage(num));
		model.addAttribute("cri", cri);

		// 댓글 조회
		List<FBoardReplyVO> reply = null;
		reply = replyService.replyList(num);
		model.addAttribute("reply", reply);

	}

	// 댓글 수
	public int getReplyCount(int num);

		//댓글 수 
		public int getReplyCount(int num);

	@Override
	public int getReplyCount(int num) {
		return mapper.getReplyCount(num);
	}

	@Override
	public List<BoardVO> getListPaging(Criteria cri) {
	    // 1. 게시물 목록을 가져옴
	    List<BoardVO> list = mapper.getListPaging(cri);

	    // 2. 각 게시물에 대해 댓글 개수를 가져와서 replyCount를 설정함
	    for (BoardVO boardVO : list) {
	        int replyCount = mapper.getReplyCount(boardVO.getNum()); // 댓글 개수를 가져오는 새로운 메소드 호출
	        boardVO.setReply_count(replyCount); 
	    }

	    return list;
	}

	// 게시판 조회
	@GetMapping("/get")
	public void boardGetPageGET(@RequestParam("num") int num, Model model, Criteria cri) throws Exception {
		bservice.updateReadCount(num); //조회수 업데이트
		log.info("게시글번호:" + num);
		model.addAttribute("pageInfo", bservice.getPage(num));
		model.addAttribute("cri", cri);
		model.addAttribute("reply_Count", bservice.getReplyCount(num));

		// 댓글 조회
		List<FBoardReplyVO> reply = null;
		reply = replyService.replyList(num);
		model.addAttribute("reply", reply);

	}

	// 단일 댓글 조회
	public FBoardReplyVO replySelect(FBoardReplyVO vo) throws Exception;
	
	// 댓글 수정
	public void replyModify(FBoardReplyVO vo)throws Exception;

	// 단일 댓글 조회
	public FBoardReplyVO replySelect(FBoardReplyVO vo) throws Exception;
	
	// 댓글 수정
	public void replyModify(FBoardReplyVO vo) throws Exception;

	@Override
	public FBoardReplyVO replySelect(FBoardReplyVO vo) throws Exception {
		
		return mapper.replySelect(vo);
	}
	
	@Override
	public void replyModify(FBoardReplyVO vo) throws Exception {
		mapper.replyModify(vo);
	}

	// 댓글 단일 조회(수정페이지)
	@GetMapping("/modify")
	public void getMofidy(@RequestParam("num") int num, @RequestParam("rno") int rno, Model model) throws Exception {

		FBoardReplyVO vo = new FBoardReplyVO();
		vo.setNum(num);
		vo.setRno(rno);

		FBoardReplyVO reply = service.replySelect(vo); //수정 버튼을 클릭한 댓글을 불러옴

		model.addAttribute("reply", reply);
	}

	// 댓글 수정
	@PostMapping("/modify")
	public String postModify(FBoardReplyVO vo) throws Exception {

		service.replyModify(vo);

		return "redirect:/board/get?num=" + vo.getNum();
	}

	// 댓글 삭제
	public void replyDelete(FBoardReplyVO vo)throws Exception;

	// 댓글 삭제
	public void replyDelete(FBoardReplyVO vo) throws Exception;

	@Override
	public void replyDelete(FBoardReplyVO vo) throws Exception {
		mapper.replyDelete(vo);
	}

	// 댓글 삭제
	@GetMapping("/delete")
	public String getDelete(FBoardReplyVO vo) throws Exception {

		service.replyDelete(vo);

		return "redirect:/board/get?num=" + vo.getNum();
	}