파일내용을 게시판에 Write

 

BoardController.java

@RequestMapping("/board/massiveWrite")
    public ModelAndView writeMassiveArticle(MultipartHttpServletRequest request){
        
        MultipartFile excelFile = request.getFile("excelFile");
        if(excelFile==null || excelFile.isEmpty()){
            throw new RuntimeException("엑셀파일을 선택해 주세요");
        }
 
        File destFile = new File("D:\\"+excelFile.getOriginalFilename());
        try {
            excelFile.transferTo(destFile);
        } catch (IllegalStateException | IOException e) {
            throw new RuntimeException(e.getMessage(),e);
 
        }
        
        boardService.insertMassiveArticleInBoard(destFile);
        
        FileUtils.deleteFile(destFile.getAbsolutePath());
        
        ModelAndView view = new ModelAndView();
        view.setViewName("redirect:/board/list");
        return view;
    }

 

BoardService.java

 public void insertMassiveArticleInBoard(File destFile);
 
 
 

BoardServiceImpl.java

@Override
 public void insertMassiveArticleInBoard(File destFile) {
 
  ReadOption readOption = new ReadOption();
  readOption.setFilePath(destFile.getAbsolutePath());
  readOption.setOutputColumns("A","B","C","D");
  readOption.setStartRow(2);
  
  List<Map<String, String>> excelContent = ExcelRead.read(readOption);
  
  BoardVO boardVO = null;
  for(Map<String, String> article : excelContent){
   
   boardVO = new BoardVO();
   boardVO.setSubject(article.get("A"));
   boardVO.setContent(article.get("B"));
   boardVO.setUserId(article.get("C"));
   boardVO.setFileName(article.get("D"));
 
   this.insertArticleInBoard(boardVO);
  }
 }