수정 : com_comment.js에서 받아온 com_com_num, com_com_content이 담긴 ccvo 이용 (com_com_num은 ccvo에 담긴 것과 넘겨 받은 것 둘 다 사용 가능 = 동일한 값!)
삭제: com_comment.js에서 받아온 com_com_num이용
//댓글 수정
@PutMapping(value="/{com_com_num}", consumes="application/json", produces = {MediaType.TEXT_PLAIN_VALUE})
private ResponseEntity<String> modify(@PathVariable("com_com_num") int com_com_num, @RequestBody Com_CommentVO ccvo){
log.info(">>> modify com_com_num : "+ com_com_num);
log.info(">>> modify ccvo : "+ ccvo);
int isOk = ccsv.modifyCom_Comment(ccvo);
return isOk > 0? new ResponseEntity<String>("1",HttpStatus.OK)
: new ResponseEntity<String>("0",HttpStatus.INTERNAL_SERVER_ERROR);
}
//댓글 삭제
@DeleteMapping(value="/{com_com_num}", consumes="application/json", produces = {MediaType.TEXT_PLAIN_VALUE})
private ResponseEntity<String> delete(@PathVariable("com_com_num")int com_com_num){
log.info(">>> delete com_com_num : "+ com_com_num);
int isOk = ccsv.deleteCom_Comment(com_com_num);
return isOk > 0? new ResponseEntity<String>("1",HttpStatus.OK)
: new ResponseEntity<String>("0",HttpStatus.INTERNAL_SERVER_ERROR);
}
3. Com_CommentService 작성
package com.bewithme.www.service;
import java.util.List;
import com.bewithme.www.domain.Com_CommentVO;
public interface Com_CommentService {
int modifyCom_Comment(Com_CommentVO ccvo);
int deleteCom_Comment(int com_com_num);
}
4. Com_CommentServiceImpl 작성
@Override
public int modifyCom_Comment(Com_CommentVO ccvo) {
//댓글 수정
log.info("com_comment ServiceImpl modify in!");
return ccdao.update(ccvo);
}
@Override
public int deleteCom_Comment(int com_com_num) {
//댓글 삭제
log.info("com_comment ServiceImpl delete in!");
return ccdao.delete(com_com_num);
}
5. Com_CommentDAO작성
package com.bewithme.www.repository;
import java.util.List;
import com.bewithme.www.domain.Com_CommentVO;
public interface Com_CommentDAO {
int update(Com_CommentVO ccvo);
int delete(int com_com_num);
}
6. Com_CommentMapper 작성
<update id="update">
update com_comment set com_com_content=#{com_com_content}, com_com_mod_date=now(), com_com_isMod='Y'
where com_com_num=#{com_com_num}
</update>
<delete id="delete">
delete from com_comment where com_com_num=#{com_com_num}
</delete>