6. [Select] 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 { 
	List<NoticeVO> getNoticeList (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">  
 	
 <select id="insertNotice" parameterType="noticeVO">
  SELECT
 </select>
  	
</mapper>

 

---

noticeService.java

public interface noticeService {
	List<NoticeVO> getNoticeList (NoticeVO NoticeVO);
}

 

---

noticeServiceImpl.java

@Service
public class noticeServiceImpl implements noticeService{
	
	@Autowired
	noticeMapperInter noticeMapperInter;
	
    @Override
    public List<NoticeVO> getNoticeList (NoticeVO NoticeVO){
  	  return MitipNoticeMapper.getNoticeList(NoticeVO)
    }

}

---

 

noticeController.java

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

	@Autowired
	noticeService noticeService;
	
   
    @GetMapping(“/getNoticeList”)
    public ResponseEntity<?> getNoticeList(
		    @ApiParam(value = “searchCondition”, required = true) NoticeVO NoticeVO) throws IOExceptiob {
    	return ResponseEntity.ok(MitopNoticeService.getNoticeList(NoticeVO));
    }


}