MemberController.java package com.basicWeb.www.controller; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import com.basicWeb.www.service.MemberService; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; @Slf4j @Controller @RequiredArgsConstructor @Re..

sql CREATE TABLE member ( email VARCHAR(100) NOT NULL, pwd VARCHAR(1000) NOT NULL, nick_name VARCHAR(100) NOT NULL, reg_at DATETIME DEFAULT now(), last_login DATETIME DEFAULT NULL, PRIMARY KEY(email) ); CREATE TABLE auth_member( email VARCHAR(100) NOT NULL, auth VARCHAR(50) NOT NULL ); ALTER TABLE auth_member ADD CONSTRAINT fk_auth FOREIGN KEY (email) REFERENCES member(email); pom.xml org.spring..

detail.jsp // ... (기존 코드) ${fvo.fileName} ${fvo.fileSize }Byte 수정 삭제 목록 // ... (기존 코드) modify.jsp // ... (기존 코드) ${fvo.fileName} ${fvo.fileSize }Byte X 파일 업로드 수정 삭제 목록 boardFile.js // ... (기존 코드) document.addEventListener('click', (e)=>{ if(e.target.classList.contains('file-x')) { let uuid = e.target.dataset.uuid; removeFileToServer(uuid).then(result =>{ if(result == '1') { console.log("파일 삭제 성공..

register.jsp 글쓰기 // ... (기존 코드) 파일 업로드 등록 취소 boardFile.js document.getElementById('trigger').addEventListener('click', ()=>{ document.getElementById('files').click(); }); const regExp = new RegExp("\.(.exe|sh|bat|dll|jar|msi)$"); const maxSize = 1024 * 1024 * 20; function fileValidation(fileName, fileSize) { if(regExp.test(fileName)) { return 0; } else if (fileSize > maxSize) { return 0; } else ..

sql -- 2024-01-19 CREATE TABLE file( uuid VARCHAR(256) NOT NULL, save_dir VARCHAR(256) NOT NULL, file_name VARCHAR(256) NOT NULL, file_type TINYINT(1) DEFAULT 0, bno BIGINT, file_size BIGINT, reg_at DATETIME DEFAULT now(), PRIMARY KEY(uuid) ); FileVO.java package com.basicWeb.www.domain; import lombok.AllArgsConstructor; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter..