Dev

INSERT

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.ma..

SQL select name, count(name) As cnt, gaipday from member where gaipday BETWEEN DATE_ADD(NOW(),INTERVAL -60 DAY) AND NOW() group by name; DTO package data.dto; import java.sql.Timestamp; import org.apache.ibatis.type.Alias; import org.springframework.format.annotation.DateTimeFormat; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import lombok.Getter; import lombok.Setter..