1. 문제 사용자의 포인트 정보를 만들고 게시글을 작성할 경우, 포인트를 누적하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_incr..

1. 문제 내가 작성한 게시글의 코멘트 목록을 리턴하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary k..

1. 문제 내가 작성한 게시글 목록을 리턴하는 API 2. 풀이 - BizException.java package com.example.jpa.sample.common.exception; public class BizException extends RuntimeException { public BizException(String message) { super(message); } } - BoardService.java package com.example.jpa.sample.board.service; import com.example.jpa.sample.board.entity.Board; import com.example.jpa.sample.board.entity.BoardBadReport; import ..

1. 문제 관심사용자에서 관심사용자를 삭제하는 API 2. 풀이 - UserService.java package com.example.jpa.sample.user.service; import com.example.jpa.sample.board.model.ServiceResult; import com.example.jpa.sample.user.entity.User; import com.example.jpa.sample.user.model.UserLogCount; import com.example.jpa.sample.user.model.UserNoticeCount; import com.example.jpa.sample.user.model.UserSummary; import java.util.List; pub..

1. 문제 관심사용자에 등록하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary key, TITLE VAR..

1. 문제 게시글의 북마크를 추가/삭제하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary key, TIT..