3. [Insert] 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 insertNotice(noticeVO noticeVO);
}

---

mapper-commonNotice.xml

<?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">  
 	
 <insert id="insertNotice" parameterType="noticeVO">
  INSERT INTO TBM_TOP_ANN (subject, contents, reg_dt, upd_dt, reg_user, upd_user)
  	VALUES (#{subject}, #{contents}, TO_CHAR(NOW(),'YYYYMMDDHH24MISS'), TO_CHAR(NOW(),'YYYYMMDDHH24MISS'), #{reg_user}, #{upd_user})        
 </insert>
  	
</mapper>

 

---

noticeService.java

public interface noticeService {
    public void insertNotice(noticeVO noticeVO);   
}

 

---

noticeServiceImpl.java

@Service
public class noticeServiceImpl implements noticeService{
	
	@Autowired
	noticeMapperInter noticeMapperInter;
	
       @Override
	public void insertNotice(noticeVO noticeVO) {
		noticeMapperInter.insertNotice(noticeVO);
	}
}

---

 

noticeController.java

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

	@Autowired
	noticeService noticeService;

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

}