5. [Delete] Java-Spring

NoticeVO.java

package hello.itemservice.domain.item;

import lombok.Data;
import lombok.Getter;
import lombok.Setter;

// @Data
// Data는 위험하다. getter, setter 정도만 쓰는게 좋음, DTO용으로 쓸땐 괜찮음
@Getter
@Setter
public class NoticeVO {

    private String subject;
    private String contents;
    private String regDt;
    private String updDt;
    private String regUser;
    private String updUser;
   }

---

noticeMapper.java

 

package data.mapper;
import org.apache.ibatis.annotations.Mapper;
import data.dto.noticeVO;

@Mapper
public interface NoticeMapper { 
	 public void deleteNotice (NoticeVO NoticeVO);
}

---

mapper-commonNotice.xml

(실무 TIP : 진짜 삭제가 아닌 del_yn 컬럼의 값을 Y로 바꿔서 select문에서 del_yn이 N인 값만 출력되도록 조건을 주는식)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTDMapper3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="data.mapper.NoticeMapper">  
 	
 <update id="deleteNotice" parameterType="NoticeVO">
    UPDATE
        TBM_TOP_ANN
    SET
        DEL_YN = 'Y'	
    WHERE
        PKM_TOP_ANN = #{PKM_TOP_ANN}
 </update>
  	
</mapper>

 

---

noticeService.java

public interface noticeService {
    public void deleteNotice (NoticeVO NoticeVO);
}

 

---

noticeServiceImpl.java

@Service
public class noticeServiceImpl implements noticeService{
	
	@Autowired
	noticeMapperInter noticeMapperInter;
	
    @Override
    public void deleteNotice (NoticeVO NoticeVO){
    	MitipNoticeMapper.deleteNotice(NoticeVO)
    }
}

---

 

noticeController.java

@RestController
@RequestMapping('api/common/')
public class noticeController {

	@Autowired
	noticeService noticeService;
 
    @postMapping(“/deleteNotice”)
    public ResponseEntity<?> insertNotice(@RequestBody NoticeVO NoticeVO) throws IOException {
     	MitopNoticeService.insertNotice(NoticeVO);
	   return null;
    }

}