0509spring 게시물 댓글(3) 댓글 수정 및 삭제

*댓글수정*

 

-ReplyController

//댓글 수정
	/*url : contextPath + "/reply/update",
    data : {"replyNo" : replyNo,
            "replyContent" : replyContent},
    type : "POST"
	 */
	@PostMapping("/update")
	public int replyUpdate(@ModelAttribute Reply reply ) {
		//				 -> vo객체를 가져올때는 @ModelAttribute 

		reply.getReplyNo();
		reply.getReplyContent();

		int result = replyservice.replyUpdate(reply);
		return result;
	}

 

-ReplyService

/**댓글수정
	 * @param
	 * @param replyNo
	 * @return
	 */
	int replyUpdate(Reply reply);

 

-ReplyServiceImpl

//댓글수정
	@Override
	public int replyUpdate(Reply reply) {
		return dao.replyUpdate(reply);
	}

 

-ReplyDAO

/**댓글수정
	 * @param replyNo
	 * @return
	 */
	public int replyUpdate(Reply reply) {
		return sqlSession.update("replyMapper.replyUpdate", reply);
	}

 

-reply-mapper.xml

<!-- 댓글수정 -->
	<update id="replyUpdate">
		UPDATE REPLY_S SET REPLY_CONTENT = #{replyContent}
		WHERE REPLY_NO = ${replyNo}
	</update>

 

*댓글삭제*

 

-ReplyController

//댓글 삭제
	/* url : contextPath + "/reply/delete",
    data : {"replyNo" : replyNo},
    type : "GET"
	*/
	@GetMapping("/delete")
	public int replyDelete(int replyNo) {
	
	int result = replyservice.replyDelete(replyNo);
	return result;
	
	}

 

-ReplyService

/**댓글삭제
	 * @param replyNo
	 * @return
	 */
	int replyDelete(int replyNo);

 

-ReplyServiceImpl

//댓글삭제
	@Override
	public int replyDelete(int replyNo) {
		return dao.replyDelete(replyNo);
	}

 

-ReplyDAO

/**댓글삭제
	 * @param replyNo
	 * @return
	 */
	public int replyDelete(int replyNo) {
		return sqlSession.update("replyMapper.replyDelete", replyNo);
	}

 

-reply-mapper.xml

<!-- 댓글삭제 -->
	<update id="replyDelete">
		UPDATE REPLY_S SET REPLY_ST = 'Y'
		WHERE REPLY_NO = #{replyNo}
	</update>