거니의 velog

package kr.or.ddit.controller.board; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.InputStream; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.inject.Inject; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.commons.io.IOUtils; import org.apache.commons.lang3.StringUti..

${board.boTitle } ${board.boDate } / ${board.boHit } ${board.boWriter } 내용 ${board.boContent } ${boardFile.fileName } (${boardFile.fileFancysize }) download 삭제 수정 목록 package kr.or.ddit.controller.board; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.InputStream; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.inject.Inject..

and (bo_title like '%' || #{searchWord} || '%') and (bo_writer like '%' || #{searchWord} || '%') and (bo_title like '%' || #{searchWord} || '%') and (bo_writer like '%' || #{searchWord} || '%') select count(bo_no) from board where 1=1 select b.* from ( select a.*, row_number() over (order by a.bo_no desc) rnum from ( select bo_no, bo_title, bo_content, bo_writer, bo_date, bo_hit from board where..

파일명을 입력하세요! delete 등록 취소 목록 package kr.or.ddit.controller.board; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.inject.Inject; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.spring..

package kr.or.ddit.controller.board; import java.util.List; import javax.inject.Inject; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.Reques..

package kr.or.ddit.controller.board; import java.util.List; import javax.inject.Inject; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.Reques..

로그인 ${errors.memId } ${errors.memPw } 로그인 아직 회원이 아닌가요? 회원가입 package kr.or.ddit.controller.conn; import java.util.HashMap; import java.util.Map; import javax.inject.Inject; import javax.servlet.http.HttpSession; import org.apache.commons.lang3.StringUtils; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; ..

회원가입 회원등록 후, 저희 서비스와 함께해요! 개인정보 동의 가입하기 우리 서비스 회원이세요? 로그인 package kr.or.ddit.controller.conn; import java.util.Map; import javax.inject.Inject; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.Reque..

---------------------------------------------------- -- 2023.12.16(토) 보강 -- 회원 및 게시판, 파일 테이블 DROP TABLE member; DROP TABLE board; DROP TABLE boardfile; DROP SEQUENCE seq_member; DROP SEQUENCE seq_board; DROP SEQUENCE seq_boardfile; -- 회원 테이블 작성 쿼리 create table member( mem_no number(8) not null, mem_id varchar2(150) not null, mem_pw varchar2(150) not null, mem_name varchar2(150) not null, mem_nic..

package kr.or.ddit.security; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.security.core.Authentication; import org.springframework.security.core.userdetails.Use..