학원 수업 55일차 221108

• 9-10

(/springWebRdsJpa02/src/main/resources/templates/board/detail.html)
수정 기능 만들기

https://www.w3schools.com/jquery/jquery_get_started.asp
Google CDN:
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

 

 

• 10-11

mybatis 수정 기능 구현

xml을 이용한 방법 시작
(/springWebRdsJpa02/src/main/resources/mapper/myboard-mapper.xml)
https://mybatis.org/mybatis-3/getting-started.html#exploring-mapped-sql-statements

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.mybatis.example.BlogMapper">

</mapper>

복붙

 

 

• 11-12

mybatis -> xml을 이용한 게시판 구현

댓글 기능 추가
(/springWebRdsJpa02/src/main/resources/templates/board/detail.html)

HeidiSQL에서 댓글 테이블 my_reply 생성

CREATE TABLE `my_reply` (
    `rno` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `created_date` TIMESTAMP NULL DEFAULT current_timestamp(),
    `text` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `updated_date` TIMESTAMP NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `writer` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `bno` BIGINT(20) NULL DEFAULT NULL,
    PRIMARY KEY (`rno`) USING BTREE,
    INDEX `FK_my_reply_my_board` (`bno`) USING BTREE,
    CONSTRAINT `FK_my_reply_my_board` FOREIGN KEY (`bno`) REFERENCES `my_board` (`bno`) ON UPDATE NO ACTION ON DELETE NO ACTION
);

테이블 인덱스 중 데이터 타입이 BIGINT이면
java에선 long으로 받아야함(int면 오류)

my_reply의 bno를 my_board의 bno(pk)의 fk로 설정

 

 

• 12-1

(com.green.nowon.domain.dao.MyReplyMapper)

댓글작성
댓글조회

 

 

• 2-3

댓글 삭제 기능 구현
input type="hidden" 얘는 무슨 역할..?
@PathVariable?

 

 

• 3-4

댓글 수정 기능 구현

 

 

• 4-5

ajax로 바꿔보자https://azderica.github.io/00-javascript-ajax/

(/springWebRdsJpa02/src/main/resources/templates/board/detail.html)
/*[[${}]]*/값이 null이면 ?? 뒤의 값이 반환됨
var bno=/*[[${detail.bno}]]*/null??0;
주석 딱 붙여 띄어쓰기 없이

var bno=/*[[${detail.bno}]]*/null;
값이 있으면
var bno=/*[[${detail.bno}]]*/
이렇게만 해도 됨

타임리프 주석 https://ksabs.tistory.com/193
<!--/* 한줄짜리 */-->
여러줄 주석 : <!--/*--> <--*/-->

ajax쓸거야 (/springWebRdsJpa02/src/main/java/com/green/nowon/controller/MyReplyController.java)
https://www.w3schools.com/jquery/jquery_ref_ajax.asp
https://www.w3schools.com/jquery/ajax_ajax.asp

Syntax : $.ajax({name:value, name:value, ... })

(/springWebRdsJpa02/src/main/resources/templates/board/detail.html)

function getReplies(){
    $.ajax({
    url:"",
    name:value
    });
}

 

jQuery get() Method
https://www.w3schools.com/jquery/ajax_get.asp

Syntax : $.get(URL,data,function(data,status,xhr),dataType)

 

[[${ }]] 표현식 뭐냐고

parseInt() ?

ModelAndView?

dispatcherservlet.forward ?

responsebody?

viewresolver?

JSON형식?

 

 

• 5-6

ajax로 댓글등록