728x90
출처:
https://www.youtube.com/watch?v=ZzWXzj9vg44&list=PL93mKxaRDidECgjOBjPgI3Dyo8ka6Ilqm&index=70
이렇게 입력하면 자바스크립트 문자열 받아올수 있음
` <==1번 옆에 숫자
33행 type="button"을 입력 안해줫더니 자바스크립트가 submit으로 인지했는데 이상하게 작동함.
form태그 안에서는 submit으로 인지하나 봄
package com.cosblog.model;
import java.sql.Timestamp;
import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.OrderBy;
import org.hibernate.annotations.CreationTimestamp;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Entity
public class Board {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@Column(nullable = false, length = 100)
private String title;
@Lob //대용량 데이터
private String content; //섬머노트 라이브러리<html>태그가 섞여서 디자인 됨.
//@ColumnDefault("0") //조회수 강제로 넣어줄 것임.
private int count;
@ManyToOne(fetch = FetchType.EAGER) //Many = Board, User = One
@JoinColumn(name="userId")//DB테이블 필드값은 userId로 만들어지고 연관관계는 ManyToOne으로 만들어진다.
private User user;//DB는 오브젝트를 저장할 수 없다. FK, 자바는 오브젝트를 저장할 수 있다.
@OneToMany(mappedBy = "board", fetch = FetchType.EAGER) //Many = Board, User = One
@JsonIgnoreProperties({"board"})
@OrderBy("id desc")
private List<Reply> replys;//DB는 오브젝트를 저장할 수 없다. FK, 자바는 오브젝트를 저장할 수 있다.
@CreationTimestamp
private Timestamp createDate;
}
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file="../layout/header.jsp"%>
<div class="container">
<button class="btn btn-secondary" onclick="history.back()">돌아가기</button>
<c:if test="${board.user.id == principal.user.id }">
<a href="/board/${board.id}/updateForm" class="btn btn-warning">수정</a>
<button id="btn-delete" class="btn btn-danger">삭제</button>
</c:if>
<br> <br>
<div>
글 번호 : <span id="id"><i>${board.id} </i></span> 작성자 : <span><i>${board.user.username} </i></span>
</div>
<br>
<div>
<h3>${board.title}</h3>
</div>
<hr />
<div>
<div>${board.content}</div>
</div>
<hr />
<button id="btn-save" class="btn btn-primary">글 저장</button>
<div class="card">
<form>
<input type="hidden" id="boardId" value="${board.id}"/>
<div class="card-body">
<textarea id="reply-content" class="form-control" row="1"></textarea>
</div>
<div class="card-footer">
<button type="button" id="btn-reply-save" class="btn btn-primary">등록</button>
</div>
</div>
</form>
<br />
<div class="card">
<div class="card-header">댓글 리스트</div>
<ul id="reply-box" class="list-group">
<c:forEach var="reply" items="${board.replys}">
<li id="reply--1" class="list-group-item d-flex justify-content-between">
<div>${reply.content}</div>
<div class="d-flex">
<div class="font-italic">작성자 : ${reply.user.username} </div>
<button class="badge">삭제</button>
</div>
</li>
</c:forEach>
</ul>
</div>
</div>
<script src="/js/board.js"></script>
<%@ include file="../layout/footer.jsp"%>
let index = {
init: function () {
$("#btn-save").on("click", () => {
this.save();
});
$("#btn-delete").on("click", () => {
this.deleteById();
});
$("#btn-update").on("click", () => {
this.update();
});
$("#btn-reply-save").on("click", () => {
this.replySave();
});
},
save: function () {
let data = {
title: $("#title").val(),
content: $("#content").val(),
};
$.ajax({
type: "POST",
url: "/api/board",
data: JSON.stringify(data),
contentType: "application/json; charset=utf-8",
dataType: "json",
})
.done(function (resp) {
alert("글쓰기가 완료되었습니다.");
location.href = "/";
})
.fail(function (error) {
alert(JSON.stringify(error));
});
},
deleteById: function () {
let id = $("#id").text();
$.ajax({
type: "DELETE",
url: "/api/board/" + id,
dataType: "json",
})
.done(function (resp) {
alert("삭제가 완료되었습니다.");
location.href = "/";
})
.fail(function (error) {
alert(JSON.stringify(error));
});
},
update: function () {
let id = $("#id").val();
let data = {
title: $("#title").val(),
content: $("#content").val(),
};
$.ajax({
type: "PUT",
url: "/api/board/" + id,
data: JSON.stringify(data),
contentType: "application/json; charset=utf-8",
dataType: "json",
})
.done(function (resp) {
alert("글수정이 완료되었습니다.");
location.href = "/";
})
.fail(function (error) {
alert(JSON.stringify(error));
});
},
replySave: function () {
let data = {
content: $("#reply-content").val(),
};
let boardId = $("#boardId").val();
$.ajax({
type: "POST",
url: `/api/board/${boardId}/reply`,
data: JSON.stringify(data),
contentType: "application/json; charset=utf-8",
dataType: "json",
})
.done(function (resp) {
alert("댓글작성이 완료되었습니다.");
location.href = `/board/${boardId}`;
})
.fail(function (error) {
alert(JSON.stringify(error));
});
},
};
index.init();
package com.cosblog.controller.api;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.security.core.annotation.AuthenticationPrincipal;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import com.cosblog.config.auth.PrincipalDetail;
import com.cosblog.dto.ResponseDto;
import com.cosblog.model.Board;
import com.cosblog.model.Reply;
import com.cosblog.service.BoardService;
@RestController
public class BoardApiController {
@Autowired
private BoardService boardService;
@PostMapping("/api/board")
public ResponseDto<Integer> save(@RequestBody Board board,@AuthenticationPrincipal PrincipalDetail principal) {
boardService.글쓰기(board, principal.getUser());
return new ResponseDto<Integer>(HttpStatus.OK.value(), 1);
}
@DeleteMapping("/api/board/{id}")
public ResponseDto<Integer> deleteById(@PathVariable int id){
boardService.글삭제하기(id);
return new ResponseDto<Integer>(HttpStatus.OK.value(), 1);
}
@PutMapping("/api/board/{id}")
public ResponseDto<Integer> update(@PathVariable int id, @RequestBody Board board){
boardService.글수정하기(id, board);
return new ResponseDto<Integer>(HttpStatus.OK.value(),1);
}
@PostMapping("/api/board/{boardId}/reply")
public ResponseDto<Integer> replySave(@PathVariable int boardId, @RequestBody Reply reply,@AuthenticationPrincipal PrincipalDetail principal) {
boardService.댓글쓰기(principal.getUser(),boardId,reply);
return new ResponseDto<Integer>(HttpStatus.OK.value(), 1);
}
}
package com.cosblog.service;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.cosblog.model.Board;
import com.cosblog.model.Reply;
import com.cosblog.model.User;
import com.cosblog.repository.BoardRepository;
import com.cosblog.repository.ReplyRepository;
//스프링이 컴포넌트 스캔을 통해서 bean에 등록을 해줌
@Service
public class BoardService {
@Autowired
private BoardRepository boardRepository;
@Autowired
private ReplyRepository replyRepository;
@Transactional
public void 글쓰기(Board board, User user) {
board.setCount(0);
board.setUser(user);
boardRepository.save(board);
}
@Transactional(readOnly=true)
public Page<Board> 글목록(Pageable pageable) {
return boardRepository.findAll(pageable);
}
@Transactional(readOnly=true)
public Board 글상세보기(int id) {
return boardRepository.findById(id)
.orElseThrow(() -> {
return new IllegalArgumentException("글 상세보기 실패:아이디를 찾을 수 없습니다.");
});
}
@Transactional
public void 글삭제하기(int id) {
boardRepository.deleteById(id);
}
@Transactional
public void 글수정하기(int id, Board requestBoard) {
Board board = boardRepository.findById(id)
.orElseThrow(()->{
return new IllegalArgumentException("글 찾기 실패:아이디를 찾을 수 없습니다.");
});//영속화 완료
board.setTitle(requestBoard.getTitle());
board.setTitle(requestBoard.getContent());
//해당 함수로 종료시(Service가 종료될 때)트랜잭션이 종료됩니다. 이때 더티체킹 - 자동 업데이트가 됨.db flush
}
@Transactional
public void 댓글쓰기(User user, int boardId, Reply requestReply) {
Board board=boardRepository.findById(boardId).orElseThrow(()->{
return new IllegalArgumentException("댓글 쓰기 실패: 게시글 id를 찾을 수 없습니다.");
});
requestReply.setUser(user);
requestReply.setBoard(board);
replyRepository.save(requestReply);
}
}
/*
* 이 로그인도 사용 안 할거라 삭제
*
* @Transactional(readOnly = true)//Select할 때 트랜잭션 시작, 서비스 종료시에 트랜잭션 종료(정합성)
* public User 로그인(User user) { return
* userRepository.findByUsernameAndPassword(user.getUsername(),
* user.getPassword()); }
*/
728x90
'Spring > Spring boot' 카테고리의 다른 글
마이바티스 xml설정 살짝 정리 (0) | 2022.01.30 |
---|---|
스프링부트 강좌 69강(블로그 프로젝트 ) - 댓글 작성시 Dto 사용해보기 (0) | 2022.01.26 |
스프링부트 강좌 67강(블로그 프로젝트) - 댓글 목록 뿌리기 (0) | 2022.01.26 |
스프링부트 강좌 66강(블로그 프로젝트) - 댓글 디자인하기 (0) | 2022.01.26 |
스프링부트 강좌 65강(블로그 프로젝트) - 카카오 로그인 서비스 구현 완료 (0) | 2022.01.26 |
댓글