[싱글이의 영수증] 삭제하기

싱글이의 영수증 삭제하기

삭제하기 script

<script>
	$("#deleteBtn").on("click", function(){
		if(confirm("삭제 하시겠습니까?")){
			
			location.href = "${contextPath}/review/${review.boardNo}/delete";
		}
	});
</script>

Controller

@RequestMapping("{boardNo}/delete")
public String deleteReview(@PathVariable("boardNo") int boardNo, @ModelAttribute Review review, HttpServletRequest request, RedirectAttributes ra) {
    
    review.setBoardNo(boardNo);
    
    int result = service.deleteReview(review);
    
    String url = null;
    
    if(result>0) {
        swalIcon = "success";
        swalTitle ="삭제 성공";
        url = "redirect:../list";
    }else {
        swalIcon = "error";
        swalTitle = "삭제 실패";
        url = "redirect:" + request.getHeader("referer");
    }
    
    ra.addFlashAttribute("swalIcon",swalIcon);
    ra.addFlashAttribute("swalTitle", swalTitle);
    return url;
}

• 삭제하기

Service

int deleteReview(Review review);

ServiceImpl

@Transactional(rollbackFor = Exception.class)
@Override
public int deleteReview(Review review) {

    return dao.deleteReview(review);
}

DAO

public int insertBoard(Map<String, Object> map) {
    return sqlSession.insert("reviewMapper.insertBoard",map);
}

Mapper

<update id="deleteReview" parameterType="Review">
    UPDATE BOARD SET
    STATUS = 'Y'
    WHERE BOARD_NO = '${boardNo}'
</update>