(22.12.23)Spring 프레임워크: Mybatis로 Spring과 Oracle 연동하여 게시판, 첨부파일 올리기

 

BoardVO.java

import java.util.ArrayList;
import java.util.List;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import lombok.ToString;
 
@Data
@ToString
@EqualsAndHashCode(exclude= {"title","author","regDate","contents","hit","attList"})
@AllArgsConstructor
@NoArgsConstructor
public class BoardVO {
    private int boardid;
    private String title;
    private String author;
    private java.sql.Date regDate;
    private String contents;
    private int hit;
    private List<AttachVO> attList = new ArrayList<>();
}

 

 

AttachVO.java

import java.util.ArrayList;
import java.util.List;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import lombok.ToString;
 
@Data
@ToString
@EqualsAndHashCode(exclude= {"title","author","regDate","contents","hit","attList"})
@AllArgsConstructor
@NoArgsConstructor
public class BoardVO {
    private int boardid;
    private String title;
    private String author;
    private java.sql.Date regDate;
    private String contents;
    private int hit;
    private List<AttachVO> attList = new ArrayList<>();
}

 

 

BoardMapper.java

import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Mapper;
import com.ezen.spring.web.vo.AttachVO;
import com.ezen.spring.web.vo.BoardVO;
 
@Mapper
public interface BoardMapper {
    void saveAttach(List<AttachVO> list);
    void saveBoard(BoardVO board);
    List<BoardVO> getList();
}

 

 

 

BoardMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ezen.spring.web.mapper.BoardMapper">
 
    <insert id="saveBoard"
       parameterType="com.ezen.spring.web.vo.BoardVO">
      <selectKey keyProperty="num" resultType="integer" order="BEFORE">
          SELECT BOARD_SEQ.NEXTVAL FROM DUAL
      </selectKey>
       -->
      INSERT INTO board(boardid, title, contents, author)
      VALUES(BOARD_SEQ.NEXTVAL, #{title,jdbcType=VARCHAR}, #{contents,jdbcType=VARCHAR}, #{author,jdbcType=VARCHAR})
 
    </insert>
    
     <update id="saveAttach" parameterType="list">
       INSERT INTO attach (attachid,boardid , fname, fsize)
       SELECT ATTACH_SEQ.NEXTVAL AS attachid, t.* FROM
       (
           <foreach collection="list" item="item" index="index" separator="union all">
                SELECT (SELECT MAX(boardid) FROM board) AS boardid, #{item.fname}, #{item.fsize} FROM DUAL
           </foreach>
       ) t
   </update>
   <select id="getList" 
       resultType="com.ezen.spring.web.vo.BoardVO">
        SELECT * FROM board
    </select>
</mapper>

 

 

 

BoardController.java

import java.io.File;
import java.util.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.io.ResourceLoader;
import org.springframework.stereotype.Controller;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import com.ezen.spring.web.mapper.BoardMapper;
import com.ezen.spring.web.vo.AttachVO;
import com.ezen.spring.web.vo.BoardVO;
import jakarta.servlet.ServletContext;
import jakarta.servlet.http.HttpServletRequest;
 
@Controller
@RequestMapping("/board")
public class BoardController {
    @Autowired
    ResourceLoader resourceLoader;
        
    @Autowired
    private BoardMapper dao;
        
 
    @GetMapping("/add")
    public String getForm() 
    {
        return "board/boardAdd";
    }
       
    @PostMapping("/add")
    @ResponseBody
    @Transactional
    public String upload(@RequestParam("files")MultipartFile[] mfiles,
                         HttpServletRequest request,
                         BoardVO board) 
    {
          ServletContext context = request.getServletContext();
          String savePath = context.getRealPath("/WEB-INF/files");
 
          List<AttachVO> list = new ArrayList<AttachVO>();
              try {
                 for(int i=0;i<mfiles.length;i++) {
                    mfiles[i].transferTo(
                      new File(savePath+"/"+mfiles[i].getOriginalFilename()));
                    long fSize = mfiles[i].getSize();
                    String fName = mfiles[i].getOriginalFilename();
                   
                    AttachVO att = new AttachVO();
                     att.setFname(fName);
                     att.setFsize(fSize);
                     list.add(att);
                 }
                 String msg = String.format("파일(%d)개 저장성공(작성자:%s)", mfiles.length,board.getAuthor().toString());
                 dao.saveBoard(board);
                 dao.saveAttach(list);
                 return msg;
              } catch (Exception e) {
                 e.printStackTrace();
                 return "파일 저장 실패:";
              }
    }
    @GetMapping("/list")
    public String getList(Model m) 
    {
        m.addAttribute("list", dao.getList());
        return "board/boardList";
    }
}

 

 

 

boardAdd.jsp

<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>게시글 추가</title>
<style type="text/css">
    @import url(//fonts.googleapis.com/earlyaccess/jejumyeongjo.css);
    
    .jm-font{
        font-family: 'Jeju Myeongjo', cursive;
        color: orange;
        font-size:1.5em;
    }
    .main-font{
        font-family: 'Jeju Myeongjo', serif;
        color: black;
        font-size:1.5em;
    }
    .wrapper {
    display: flex;
    justify-content: center;
    align-items: center;
    }
    main { width: fit-conent; margin:1em auto;}
    main h1 { text-align: center; }
    label { display:inline-block; margin-right:1em; width:3em; 
        background-color:rgb(248,242,24); text-align:center; padding:0.5em;
    }
    div { margin-top:0.5em; }
</style>
</head>
<body style="background-color: rgb(254,223,255);">
<span class="wrapper">
<main class="main-font">
<h1 class="jm-font">게시글 입력</h1>
    <form action="/board/add" method="post" enctype="multipart/form-data">
    <div>
        <label for="title">제목</label> 
        <input id="title" type="text" name="title" value="">
    </div>
    <div>
        <label for="author">작성자</label> 
        <input id="author" type="text" name="author" value="">
    </div>
    <div>
        <label for="contents">내용</label>
        <textarea id="contents" name="contents" rows="5" cols="50"></textarea>
    </div>
    <div>
    첨부파일 <input type="file" name="files" multiple="multiple"><br>
   </div>
    <div class="btn">
        <button type="reset">취소</button>
        <button type="submit">저장</button>
    </div>
</form>
</main>
</span>
</body>
</html>

 

 

 

boardList.jsp

<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>게시글 목록</title>
</head>
<body>
<c:forEach var="board" items="${list}">
   ${board.boardid}&emsp;
   <a href="/board/detailBoard/${board.boardid}">${board.title}</a>&emsp;
   ${board.author}&emsp;
  <br>
</c:forEach>
</body>
</html>

 

 

실행 결과 :