[TIL] 22.03.10

Today I Learned

FileUpload

- 회원가입시 첨부한 이미지파일은 Mypage에서 출력됨

- MemberDAO

public int addFile(MemberFileDTO memberFileDTO) throws Exception {
		return sqlSession.insert(NAMESPACE + "addFile", memberFileDTO);
}

- MemberFileDTO

package com.spring.s1.member;

public class MemberFileDTO {
	
	private Long fileNum;
	private String id;
	private String fileName;
	private String oriName;
	
	public Long getFileNum() {
		return fileNum;
	}
	public void setFileNum(Long fileNum) {
		this.fileNum = fileNum;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getFileName() {
		return fileName;
	}
	public void setFileName(String fileName) {
		this.fileName = fileName;
	}
	public String getOriName() {
		return oriName;
	}
	public void setOriName(String oriName) {
		this.oriName = oriName;
	}
	
	
}

- memberMapper

<resultMap type="MemberDTO" id="mypageResult">
		<id column="id" property="id"/>		<!-- PK -->
		<result column="name" property="name"/>		<!-- PK를 제외한 나머지 -->
		<result column="email" property="email"/>
		<result column="phone" property="phone"/>
		<association property="memberFileDTO" javaType="com.spring.s1.member.MemberFileDTO">
			<id column="fileNum" property="fileNum"/>
			<result column="fileName" property="fileName"/>
			<result column="oriName" property="oriName"/>
		</association> <!-- 1:1 관계 -->
</resultMap>

- FileManager

package com.spring.s1.util;

import java.io.File;
import java.util.Calendar;
import java.util.UUID;

import javax.servlet.ServletContext;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.util.FileCopyUtils;
import org.springframework.web.multipart.MultipartFile;

@Component
public class FileManager {
	@Autowired
	private ServletContext servletContext;
	
	public String save(MultipartFile multipartFile, String path) throws Exception {
		//파일 저장은 tomcat이 아니라 OS에서 저장
		//path=/resources/upload/member
		String realPath = servletContext.getRealPath(path);
		System.out.println(realPath);
		
		File file = new File(realPath);
		//System.out.println(file2.exists());
		//System.out.println(file2.isDirectory());
			
		if(!file.exists()) {
			//file2.mkdir(); //중간 폴더가 없으면 에러
			file.mkdirs(); //중간 폴더가 없으면 중간 폴더도 생성
		}
		
		//1. 시간 
		Calendar ca = Calendar.getInstance();
		long l = ca.getTimeInMillis(); //현재 시간을 밀리세컨즈로 변환
		System.out.println("time : " + l);
		String oriName = multipartFile.getOriginalFilename();
		
		String fileName = l + "_" + oriName;
		System.out.println("fileName : " + fileName);
		
		//2. UUID
		fileName = UUID.randomUUID().toString();
		fileName = fileName + "_" + oriName;
		System.out.println("UUID: " + fileName);
		
		//file HDD에 저장
		//1. MultipartFile 클래스의 transferTo 메서드 사용
		//file = new File(realPath, fileName);
		//file = new File(file, fileName);
		//multipartFile.transferTo(file);
		
		//2. FileCopyUtils
		file = new File(file, fileName);
		FileCopyUtils.copy(multipartFile.getBytes(), file);
		
		return fileName;
	}
}

- MemberService

public int join(MemberDTO memberDTO, MultipartFile photo) throws Exception {
		int result = memberDAO.join(memberDTO);

		//1. 파일을 HDD에 저장
		String fileName = fileManager.save(photo, "resources/upload/member/");
		
		//2. 정보를 DB에 저장
		MemberFileDTO memberFileDTO = new MemberFileDTO();
		memberFileDTO.setId(memberDTO.getId());
		memberFileDTO.setFileName(fileName);
		memberFileDTO.setOriName(photo.getOriginalFilename());
		result = memberDAO.addFile(memberFileDTO);
		
		return result; 
}