반응형

# Spring WEB MVC_02버전_05 다중 파일 업로드 구현_UI 구현

## pom.mxl

## servlet-context.xml

  • 다중 업로드 하기위한 API beans 설정
<!-- 다중 업로드 API -->
<beans:bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
  <beans:property name="maxUploadSize" value="52428800"/>	// 업로드 가능한 최대 파일 크기
  <beans:property name="maxInMemorySize" value="100000"/>	// 업로드 전 메모리에 보관할 수 있는 최대 byte 크기
  <beans:property name="defaultEncoding" value="utf-8"/>	// 인코딩
</beans:bean>

## uploadForm 생성

<%@ page language="java" 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>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
<script>
	var cnt = 1;
	
	function file_add() {
		$("#d_file").append("<br>" + "<input type='file' name='file" + cnt + "'/>");
		cnt++;
	}
</script>
</head>
<body>
<div class="container">
	<h2>다중파일 업로드</h2>
	<div class="panel panel-default">
	<div class="panel-heading">스프링을 이용한 다중 파일 업로드 구현</div>
	<div class="panel-body">
		<form class="form-horizontal" action="<c:url value='/upload.do'/>" enctype="multipart/form-data" method="post">
			<div class="form-group">
				<label class="control-label col-sm-2" for="id">아이디:</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" id="id" placeholder="Enter id" style="width: 30%;">
				</div>
			</div>
			<div class="form-group">
				<label class="control-label col-sm-2" for="name">이름:</label>
				<div class="col-sm-10">
					<input type="text" class="form-control" id="name" placeholder="Enter name" style="width: 30%;">
				</div>
			</div>
			<div class="form-group">
				<label class="control-label col-sm-2" for="">파일추가:</label>
				<div class="col-sm-10">
					<input type="button" value="파일추가" onClick="file_add()"/><br>
					<div id="d_file"></div>
				</div>
			</div>
			<div class="form-group">
				<div class="col-sm-offset-2 col-sm-10">
					<button type="submit" class="btn btn-default">업로드</button>
				</div>
			</div>
		</form>
	</div>
	<div class="panel-footer">다중파일 업로드JSP</div>
	</div>
</div>
</body>
</html>

## MemberController

@RequestMapping("/form.do")
public String form() {

	return "uploadForm";
}

 

# Spring WEB MVC_02버전_06~07 다중 파일 업로드 구현_서버쪽 구현

## FileController 생성

  • 파일 업로드, 다운로드 할 수 있는 컨트롤러
  • 프로젝트 > Java Resources > src/main/java > kr.narp.myapp1 우 클릭 > New > Class > FileController 이름으로 생성
  • Enumberation<String> : 나열, 열거형. 데이터가 있으면 가져오고 없으면 반복문을 멈춘다. (데이터의 유무 판단해서 가져옴)
  • getParameterNames : id, name 등만 읽어 들임. 
  • getFileNames : 파일 이름이 아닌, 파라미터 이름을 읽어 들임.(file1, file2 ..)
  • Iterator : 나열, 열거형, Enumberation과 비슷하나 속도 측면에서 조금 더 빠름.
  • MultipartFile : 스프링에서 제공해주는 첨부파일을 담을 수 있는 클래스, 하나의 파일을 받을 때 사용(파일의 크기, 파일의 이름, 파일의 타입 등..)
  • getOriginalFilename : 실제 업로드 된 파일의 이름을 담고 있다.
  • 파일 업로드 경로 : C:\eGovFrame-3.9.0\workspace.edu\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\SpringMVC02
package kr.narp.myapp1;

import java.io.File;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;

@Controller
public class FileController {
	
	@RequestMapping("/upload.do")
	public String upload(MultipartHttpServletRequest multipartRequest, 
			HttpServletRequest request, Model model) throws Exception {
		
		String UPLOAD_DIR = "repo";	
		
		// UPLOAD_DIR의 실제 경로 가져오는 것.
		String uploadPath = request.getServletContext().getRealPath("") + File.separator + UPLOAD_DIR;
		
		// 1. id, name 파라미터 읽어오기
		Map map = new HashMap();	// (KEY, Value)
		// String id = multipartRequest.getParameter("id");
		// String name = multipartRequest.getParameter("name");
		Enumeration<String> e = multipartRequest.getParameterNames();
		
		while (e.hasMoreElements()) {
			String name = e.nextElement();	// id
			String value = multipartRequest.getParameter(name);
			
			map.put(name, value);
		}
		
		// 2. 파일 담고있는 파라미터 읽어오기
		Iterator<String> it = multipartRequest.getFileNames();
		List<String> fileList = new ArrayList<String>();
		
		while (it.hasNext()) {
			String paramfName = it.next();
			MultipartFile mFile = multipartRequest.getFile(paramfName);
			String oName = mFile.getOriginalFilename();	// 실제 업로드된 파일 이름
			fileList.add(oName);
			
			// 파일 업로드할 경로 확인
			File file = new File(uploadPath + "\\" + paramfName);
			
			if (mFile.getSize() != 0) {
				if (!file.exists()) {
					if (file.getParentFile().mkdirs()) {
						file.createNewFile(); 	// 임시로 파일을 생성한다.
					}
				}
				mFile.transferTo(new File(uploadPath + "\\" + oName));	// 파일 업로드
			}
		}
		
		map.put("fileList", fileList);
		model.addAttribute("map", map);
		
		return "result";
	}
}

## pom.xml

  • Servlet 버전 변경
<!-- Servlet -->
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>javax.servlet-api</artifactId>
  <version>3.1.0</version>
  <scope>provided</scope>
</dependency>

## result.jsp 생성

<%@ page language="java" 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>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
</head>
<body>
	<div class="container">
	<h2>업로드가 완료 되었습니다.</h2>
	<div class="panel panel-default">
		<div class="panel-heading">스프링을 이용한 다중 파일 업로드 구현</div>
		<div class="panel-body">
			<table class="table table-bordered table-hover">
				<tr>
					<td>아이디</td>
					<td>${map.id}</td>
				</tr>
				<tr>
					<td>이름</td>
					<td>${map.name}</td>
				</tr>
				<c:forEach var="fName" items="${map.fileList}">
					<tr>
						<td>${fName}</td>
						<td>다운로드</td>
					</tr>
				</c:forEach>
			</table>
		</div>
		<div class="panel-footer">파일 업로드 결과 JSP</div>
	</div>
</div>
</body>
</html>

 

# Spring WEB MVC_02버전_08 다중 파일 다운로드 구현

## result.jsp

  • 다운로드 이미지 클릭 시 해당 파일 다운로드 가능하도록 작업
<%@ page language="java" 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>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
<script>
	function getfile(filename) {
		location.href="<c:url value='/download.do'/>?filename=" + filename;
	}
</script>
</head>
<body>
	<div class="container">
	<h2>업로드가 완료 되었습니다.</h2>
	<div class="panel panel-default">
		<div class="panel-heading">스프링을 이용한 다중 파일 업로드 구현</div>
		<div class="panel-body">
			<table class="table table-bordered table-hover">
				<tr>
					<td>아이디</td>
					<td>${map.id}</td>
				</tr>
				<tr>
					<td>이름</td>
					<td>${map.name}</td>
				</tr>
				<c:forEach var="fName" items="${map.fileList}">
					<tr>
						<td>${fName}</td>
						<td><a href="javascript:getfile('${fName}')"><span class="glyphicon glyphicon-file"></span></a></td>
					</tr>
				</c:forEach>
			</table>
		</div>
		<div class="panel-footer">파일 업로드 결과 JSP</div>
	</div>
</div>
</body>
</html>

## FileController

  • 다운로드 관련 메서드 추가.
package kr.narp.myapp1;

import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;

@Controller
public class FileController {
	
	@RequestMapping("/upload.do")
	public String upload(MultipartHttpServletRequest multipartRequest, 
			HttpServletRequest request, Model model) throws Exception {
		
		String UPLOAD_DIR = "repo";	
		
		// UPLOAD_DIR의 실제 경로 가져오는 것.
		String uploadPath = request.getServletContext().getRealPath("") + File.separator + UPLOAD_DIR;
		
		// 1. id, name 파라미터 읽어오기
		Map map = new HashMap();	// (KEY, Value)
		// String id = multipartRequest.getParameter("id");
		// String name = multipartRequest.getParameter("name");
		Enumeration<String> e = multipartRequest.getParameterNames();
		
		while (e.hasMoreElements()) {
			String name = e.nextElement();	// id
			String value = multipartRequest.getParameter(name);
			
			map.put(name, value);
		}
		
		// 2. 파일 담고있는 파라미터 읽어오기
		Iterator<String> it = multipartRequest.getFileNames();
		List<String> fileList = new ArrayList<String>();
		
		while (it.hasNext()) {
			String paramfName = it.next();
			MultipartFile mFile = multipartRequest.getFile(paramfName);
			String oName = mFile.getOriginalFilename();	// 실제 업로드된 파일 이름
			fileList.add(oName);
			
			// 파일 업로드할 경로 확인
			File file = new File(uploadPath + "\\" + paramfName);
			
			if (mFile.getSize() != 0) {
				if (!file.exists()) {
					if (file.getParentFile().mkdirs()) {
						file.createNewFile(); 	// 임시로 파일을 생성한다.
					}
				}
				mFile.transferTo(new File(uploadPath + "\\" + oName));	// 파일 업로드
			}
		}
		
		map.put("fileList", fileList);
		model.addAttribute("map", map);
		
		return "result";
	}
	
	@RequestMapping("/download.do")
	public void download(@RequestParam("filename") String filename, 
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		
		String UPLOAD_DIR = "repo";
		String uploadPath = request.getServletContext().getRealPath("") + File.separator + UPLOAD_DIR;
		
		File file = new File(uploadPath + "\\" + filename);
		
		// 클라이언트로부터 넘어오는 파일 이름에 한글 있는 경우 깨짐 방지.
		filename = URLEncoder.encode(filename, "UTF-8");
		filename = filename.replace("+", " ");
		// 다운로드 준비 (서버에서 클라이언트에게 다운로드 준비 시키는 부분_다운로드 창 띄움)
		response.setContentLength((int)file.length());
		response.setContentType("application/x-msdownload;charset=utf-8");
		response.setHeader("Content-Disposition", "attachment;filename=" + filename + ";");
		response.setHeader("Content-Transfer-Encoding", "binary");
		response.setHeader("Pragma", "no-cache");
		response.setHeader("Expires", "0");
		
		// 	실제 다운로드를 하는 부분
		FileInputStream in = new FileInputStream(file);	// 파일 읽기 준비
		OutputStream out = response.getOutputStream();
		byte[] buffer = new byte[104];
		
		while ( true ) {
			int count = in.read(buffer);
			
			if ( count == -1 ) {
				break;
			}
			out.write(buffer, 0, count); // 다운로드 (0% ..... 100%)
		}
		
		in.close();
		out.close();
	}
}

## 작동 확인

  • 업로드, 다운로드 정상작동 확인

 

반응형
반응형

# Spring WEB MVC_02버전_04 Spring WEB_MVC와 Ajax 통신(@ResponseBody)

## memberList.jsp

  • Ajax로 회원리스트보기 버튼 추가.
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>    
<%@ page import="java.util.*" %>
<%
     // ArrayList<MemberVO> list=(ArrayList<MemberVO>)request.getAttribute("list");
%>    
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>  
<c:set var="ctx" value="${pageContext.request.contextPath}"/>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
<script type="text/javascript">
  function deleteFn(num){
	  location.href="${ctx}/memberDelete.do?num="+num; // ?num=12
  }
  
  function btnClick() {
	  $.ajax({
		  url : "<c:url value='/memberAjaxList.do'/>",
		  type : "get",
		  dataType : "json",
		  success : resultHtml,
		  error : function() {
			  alert("error")
		  }
	  });
  }
  
  function resultHtml(data) {
	var html = "<table class='table table-bordered'>";
	html += "<tr>";
	html += "<td>번호</td>";
	html += "<td>아이디</td>";
	html += "<td>비밀번호</td>";
	html += "<td>이름</td>";
	html += "<td>나이</td>";
	html += "<td>이메일</td>";
	html += "<td>전화번호</td>";
	html += "</tr>";
	
	$.each(data, function(index, obj) {
		html += "<tr>";
		html += "<td>" + obj.num + "</td>";
		html += "<td>" + obj.id + "</td>";
		html += "<td>" + obj.pass + "</td>";
		html += "<td>" + obj.name + "</td>";
		html += "<td>" + obj.age + "</td>";
		html += "<td>" + obj.email + "</td>";
		html += "<td>" + obj.phone + "</td>";
		html += "</tr>";
	});

	html += "</table>";
	
	$("#list").html(html);
  }
</script>
</head>
<body>
[Spring WEB MVC 02버전]
<table class="table table-bordered">
  <tr>
    <td>번호</td>
    <td>아이디</td>
    <td>비밀번호</td>
    <td>이름</td>
    <td>나이</td>
    <td>이메일</td>
    <td>전화번호</td>
    <td>삭제</td>
  </tr>
  <c:forEach var="vo" items="${list}">
    	  <tr>
    	    <td>${vo.num}</td>
    	    <td><a href="${ctx}/memberContent.do?num=${vo.num}">${vo.id}</a></td>
    	    <td>${vo.pass}</td>
    	    <td>${vo.name}</td>
    	    <td>${vo.age}</td>
    	    <td>${vo.email}</td>
    	    <td>${vo.phone}</td>
    	    <td><input type="button" value="삭제" class="btn btn-warning" onclick="deleteFn(${vo.num})"></td>
    	  </tr>    	 
  </c:forEach>
  <tr>
  <td colspan="8" align="right"><input type="button" value="회원가입" class="btn btn-primary" onclick="location.href='${ctx}/memberRegister.do'"/></td>
  </tr>
  <tr>
  	<td colspan="8">
  		<input type="button" value="Ajax로 회원리스트보기" onclick="btnClick()"/>
  	</td>
  </tr>
</table>
<div id="list">여기에 회원리스트가 출력</div>
</body>
</html>

## @ResponseBody

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>kr.narp</groupId>
	<artifactId>myapp</artifactId>
	<name>SpringMVC02</name>
	<packaging>war</packaging>
	<version>1.0.0-BUILD-SNAPSHOT</version>
	<properties>
		<java-version>1.6</java-version>
		<org.springframework-version>3.1.1.RELEASE</org.springframework-version>
		<org.aspectj-version>1.6.10</org.aspectj-version>
		<org.slf4j-version>1.6.6</org.slf4j-version>
	</properties>
	<dependencies>
		<!-- Spring -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${org.springframework-version}</version>
			<exclusions>
				<!-- Exclude Commons Logging in favor of SLF4j -->
				<exclusion>
					<groupId>commons-logging</groupId>
					<artifactId>commons-logging</artifactId>
				 </exclusion>
			</exclusions>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				
		<!-- AspectJ -->
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>${org.aspectj-version}</version>
		</dependency>	
		
		<!-- Logging -->
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${org.slf4j-version}</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>jcl-over-slf4j</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.15</version>
			<exclusions>
				<exclusion>
					<groupId>javax.mail</groupId>
					<artifactId>mail</artifactId>
				</exclusion>
				<exclusion>
					<groupId>javax.jms</groupId>
					<artifactId>jms</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jdmk</groupId>
					<artifactId>jmxtools</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jmx</groupId>
					<artifactId>jmxri</artifactId>
				</exclusion>
			</exclusions>
			<scope>runtime</scope>
		</dependency>

		<!-- @Inject -->
		<dependency>
			<groupId>javax.inject</groupId>
			<artifactId>javax.inject</artifactId>
			<version>1</version>
		</dependency>
				
		<!-- Servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.1</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
	
		<!-- Test -->
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.7</version>
			<scope>test</scope>
		</dependency>
		<!-- Spring DB API -->
		<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>5.1.31</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis</artifactId>
		    <version>3.4.5</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis-spring</artifactId>
		    <version>1.3.0</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
		    <groupId>org.springframework</groupId>
		    <artifactId>spring-jdbc</artifactId>
		    <version>3.1.1.RELEASE</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
		<dependency>
		    <groupId>com.fasterxml.jackson.core</groupId>
		    <artifactId>jackson-databind</artifactId>
		    <version>2.6.3</version>
		</dependency>	
		<!-- https://mvnrepository.com/artifact/org.codehaus.jackson/jackson-mapper-asl -->
		<dependency>
		    <groupId>org.codehaus.jackson</groupId>
		    <artifactId>jackson-mapper-asl</artifactId>
		    <version>1.9.13</version>
		</dependency>			        
	</dependencies>
    <build>
        <plugins>
            <plugin>
                <artifactId>maven-eclipse-plugin</artifactId>
                <version>2.9</version>
                <configuration>
                    <additionalProjectnatures>
                        <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
                    </additionalProjectnatures>
                    <additionalBuildcommands>
                        <buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
                    </additionalBuildcommands>
                    <downloadSources>true</downloadSources>
                    <downloadJavadocs>true</downloadJavadocs>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.5.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <compilerArgument>-Xlint:all</compilerArgument>
                    <showWarnings>true</showWarnings>
                    <showDeprecation>true</showDeprecation>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>exec-maven-plugin</artifactId>
                <version>1.2.1</version>
                <configuration>
                    <mainClass>org.test.int1.Main</mainClass>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

## MemberController

@RequestMapping("/memberAjaxList.do")
public @ResponseBody List<MemberVO> memberAjaxList(Model model) {
  List<MemberVO> list = memberMapper.memberList();

  // $.ajax() -> callback 함수로 응답 (json)

  return list;	// Object -> JSON : @ResponseBody -> API (jackson-databind)
}
반응형
반응형

# Spring WEB MVC_02버전_03 Mapper 인터페이스와 @(어노테이션)이용한 CRUD

## Mapper 인터페이스와 어노테이션을 이용한 CRUD

  • 기존 MemberMapper.xml 제거.
  • 어노테이션에 SQL 문을 작성하여 작업.
package kr.bit.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import kr.bit.model.MemberVO;

public interface MemberMapper {
	@Select("SELECT * FROM member")
	public List<MemberVO> memberList();			// SQL id="memeberList"
	
    @Insert("INSERT INTO member(id, pass, name, age, email, phone) \r\n" + 
			"        values(#{id}, #{pass}, #{name}, #{age}, #{email}, #{phone})")
	public int memberInsert(MemberVO vo);		// SQL id="memberInsert"
	
    @Delete("DELETE FROM member WHERE num = #{num}")
	public int memberDelete(int num);			// SQL id="memberDelete"
	
    @Select("SELECT * FROM member WHERE num = #{num}")
	public MemberVO memberContent(int num);		// SQL id="memberContent"
	
    @Update("UPDATE member \r\n" + 
			"        SET age = #{age}, email = #{email}, phone = #{phone} where num = #{num}")
	public int memberUpdate(MemberVO vo);		// SQL id="memberUpdate"
}
반응형
반응형

# Spring WEB MVC_02버전_01 Spring WEB MVC 프로젝트 버전02 생성

## 기존 프로젝트(SpringMVC01) Export

  • 기존 프로젝트 우 클릭 > Export > Export... > General > File System 클릭하여 Export 진행.

## SpringMVC02 생성

  • 기존 SpringMVC01 바탕으로 02버전 생성.
  • File > New > Spring Legacy Project 클릭 후 아래와 같이 입력 및 선택 후 Next > 패키지 이름(kr.narp.myapp1) 등록 후 Finish.
Project name : SpringMVC02
Templates : Spring MVC Project

## 톰캣 서버 등록

  • Servers > 톰캣 우 클릭 > Add and Remove에서 Available에 있는 신규로 생성한 프로젝트(SpringMVC02) 클릭 후 Add 클릭해서 Configured로 이동 후 Finish.

## 기존 프로젝트 덮어쓰기

생성된 프로젝트(SpringMVC02) 우 클릭 > Import > Import... > General > File System 클릭 후 기존에 Export했던 SpringMVC01 찾아서 선택 > Select All 눌러서 모두 체크해주고 Finish > 덮어쓰기 할거냐는 문구에서 모두 덮어쓰기 클릭 후 완료.

## pom.xml 수정

  • 기존 프로젝트를 Import해서 pom.xml에 기존 프로젝트명으로 되어있는 부분 수정 필요.
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>kr.narp</groupId>
	<artifactId>myapp</artifactId>
	<name>SpringMVC02</name>
	<packaging>war</packaging>
	<version>1.0.0-BUILD-SNAPSHOT</version>
	<properties>
		<java-version>1.6</java-version>
		<org.springframework-version>3.1.1.RELEASE</org.springframework-version>
		<org.aspectj-version>1.6.10</org.aspectj-version>
		<org.slf4j-version>1.6.6</org.slf4j-version>
	</properties>
	<dependencies>
		<!-- Spring -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${org.springframework-version}</version>
			<exclusions>
				<!-- Exclude Commons Logging in favor of SLF4j -->
				<exclusion>
					<groupId>commons-logging</groupId>
					<artifactId>commons-logging</artifactId>
				 </exclusion>
			</exclusions>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
				
		<!-- AspectJ -->
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>${org.aspectj-version}</version>
		</dependency>	
		
		<!-- Logging -->
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${org.slf4j-version}</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>jcl-over-slf4j</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.15</version>
			<exclusions>
				<exclusion>
					<groupId>javax.mail</groupId>
					<artifactId>mail</artifactId>
				</exclusion>
				<exclusion>
					<groupId>javax.jms</groupId>
					<artifactId>jms</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jdmk</groupId>
					<artifactId>jmxtools</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jmx</groupId>
					<artifactId>jmxri</artifactId>
				</exclusion>
			</exclusions>
			<scope>runtime</scope>
		</dependency>

		<!-- @Inject -->
		<dependency>
			<groupId>javax.inject</groupId>
			<artifactId>javax.inject</artifactId>
			<version>1</version>
		</dependency>
				
		<!-- Servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.1</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
	
		<!-- Test -->
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.7</version>
			<scope>test</scope>
		</dependency>
		<!-- Spring DB API -->
		<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>5.1.31</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis</artifactId>
		    <version>3.4.5</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
		    <groupId>org.mybatis</groupId>
		    <artifactId>mybatis-spring</artifactId>
		    <version>1.3.0</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
		    <groupId>org.springframework</groupId>
		    <artifactId>spring-jdbc</artifactId>
		    <version>3.1.1.RELEASE</version>
		</dependency>	        
	</dependencies>
    <build>
        <plugins>
            <plugin>
                <artifactId>maven-eclipse-plugin</artifactId>
                <version>2.9</version>
                <configuration>
                    <additionalProjectnatures>
                        <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
                    </additionalProjectnatures>
                    <additionalBuildcommands>
                        <buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
                    </additionalBuildcommands>
                    <downloadSources>true</downloadSources>
                    <downloadJavadocs>true</downloadJavadocs>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.5.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <compilerArgument>-Xlint:all</compilerArgument>
                    <showWarnings>true</showWarnings>
                    <showDeprecation>true</showDeprecation>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>exec-maven-plugin</artifactId>
                <version>1.2.1</version>
                <configuration>
                    <mainClass>org.test.int1.Main</mainClass>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

## servlet-context.xml 수정

  • component-scan 에 기존 패키지 명 kr.narp.myapp 을 kr.narp.myapp1 으로 변경.
<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

	<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
	
	<!-- Enables the Spring MVC @Controller programming model -->
	<annotation-driven />

	<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
	<resources mapping="/resources/**" location="/resources/" />

	<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
	<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<beans:property name="prefix" value="/WEB-INF/views/" />
		<beans:property name="suffix" value=".jsp" />
	</beans:bean>
	
	<context:component-scan base-package="kr.narp.myapp1" />
	
	
	
</beans:beans>

## MemberController 이동

  • 프로젝트를 새로 만들어서 kr.narp.myapp1에 HomeController 존재. 해당 컨트롤러 제거, kr.narp.myapp에 존재하는 MemberController 이동하고 기존 kr.narp.myapp 패키지 제거.

## 작동 확인

  • 서버 실행 후 http://localhost:8081/myapp1/memberList.do 접속하여 회원 리스트, 회원 상세보기, 회원 삭제, 회원 등록 등의 기능 정상작동 여부 확인.

## Import 후 에러 난 경우

1. Maven 강제 업데이트

  • SpringMVC02 우 클릭 > Maven > Update Project... > SpringMVC03 체크된 상태에서 아래 Force Update of Snapshots/Releases 체크 후 OK

2. Project Clean

  • 상단 Project > Clean... 클릭하여 SpringMVC02 Clean 진행.

 

# Spring WEB MVC_02버전_02 Mapper 인터페이스와 XML mapper 이용한 CRUD

## mapper 패키지 생성

  • 프로젝트 > Java Resources > src/main/java 우 클릭 > New > Package > kr.bit.mapper 이름의 패키지 생성

## 인터페이스 생성

  • kr.bit.mapper 패키지 우 클릭 > New > InterFace 클릭 후 아래와 같이 입력 후 Finish.
Name : MemberMapper

## MemberMapper 인터페이스

  • MemberDAO가 가진 기능 정의.
  • @Mapper를 넣으면 MyBatis(SqlSessionFactory + SqlSession)를 불러오게 된다. (SQL Mapper XML 파일의 mapper nameSpace가 정상적으로 등록되어있다면 MemberMapper 인터페이스에서 @Mapper를 생략해도 문제 없다.)
  • 인터페이스에 존재하는 메서드의 이름과 SQL의 id가 동일하게 설계되어있기 때문에, DAO가 없어도 Spring 프레임워크 내부에서 인터페이스만 가지고도 SQL을 실행할 수 있게 해주는 방법이 존재. 
package kr.bit.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import kr.bit.model.MemberVO;

@Mapper	// @Mapper를 넣으면 MyBatis(SqlSessionFactory + SqlSession)를 불러오게 된다.
public interface MemberMapper {
	public List<MemberVO> memberList();			// SQL id="memeberList"
	public int memberInsert(MemberVO vo);		// SQL id="memberInsert"
	public int memberDelete(int num);			// SQL id="memberDelete"
	public MemberVO memberContent(int num);		// SQL id="memberContent"
	public int memberUpdate(MemberVO vo);		// SQL id="memberUpdate"
}

## MemberMapper Interface 와 SQL Mapper XML 파일

  • 인터페이스와 XML 파일 연결을 위해 MemberMapper Interface의 이름과 MemberMapper.xml의 namerspace가 같아야 한다.
  • 그리고 MemberMapper Interface의 메서드 들의 이름과 SQL Mapper XML 파일의 id 이름과 같아야 한다.
  • 일반적으로 해당 파일들은 동일한 경로에 위치하게 해주는게 좋다.

## root-context

  • mybatis-spring:scan 태그 추가.
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
	http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
	
	<!-- Root Context: defines shared resources visible to all other web components -->
	
	<!-- MyBatis SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	    <property name="dataSource"  ref="dataSource"/>
	    <property name="configLocation" value="/WEB-INF/mybatis/config.xml"/>
	</bean>
	<!-- JDBC 연결(DataSource) -->
	<bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
		<property name="driverClass" value="${driver}"/>
		<property name="url" value="${url}"/>
		<property name="username" value="${username}"/>
		<property name="password" value="${password}"/>
	</bean>
	<!-- db.properties 파일 연결 -->
	<bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
	    <property name="locations" value="/WEB-INF/mybatis/db.properties"/>
	</bean>
	
	<context:component-scan base-package="kr.bit.model" />	
	<mybatis-spring:scan base-package="kr.bit.mapper" />
</beans>

## MemberMapper.xml 이동

  • kr.bit.mapper로 이동

## MemberMapper.xml 수정

  • 파일이동에 따른 nameSpace 경로 수정
<?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">
<!-- namerspace는 이름. -->
<mapper namespace="kr.bit.mapper.MemberMapper">
  
    <!-- 회원 리스트(전체) -->
    <select id="memberList" resultType="memberVO">
	    SELECT *
    	FROM member
    </select>
    
    <!-- 회원 가입 -->
    <insert id="memberInsert" parameterType="memberVO">
        INSERT INTO member(id, pass, name, age, email, phone) 
        values(#{id}, #{pass}, #{name}, #{age}, #{email}, #{phone})
    </insert>
    
    <!-- 회원 삭제 -->
    <delete id="memberDelete" parameterType="Integer">
        DELETE 
        FROM member
        WHERE num = #{num}
    </delete>
    
    <!-- 회원 상세보기 -->
    <select id="memberContent" parameterType="Integer" resultType="memberVO">
        SELECT *
        FROM member
        WHERE num = #{num}
    </select>
    
    <!-- 회원 정보 수정 -->
    <update id="memberUpdate" parameterType="memberVO">
        UPDATE member 
        SET age = #{age}, email = #{email}, phone = #{phone} where num = #{num}
    </update>
    
</mapper>

## MemberController 수정

  • 기존 private MemberDAO dao; 사용했던 부분 변경
package kr.narp.myapp1;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import kr.bit.mapper.MemberMapper;
import kr.bit.model.MemberVO;

@Controller
public class MemberController {
	
	@Autowired
	//private MemberDAO dao;
	private MemberMapper memberMapper;
	
	@RequestMapping("/memberList.do")
	public String memberList(Model model) {
		//List<MemberVO> list = dao.memberList();
		List<MemberVO> list = memberMapper.memberList();
		// 객체 바인딩.
		model.addAttribute("list", list);	
		return "memberList";
	}
	
	@RequestMapping("/memberInsert.do")
	public String memberInsert(MemberVO vo) {
		//int cnt = dao.memberInsert(vo);
		int cnt = memberMapper.memberInsert(vo);
		
		return "redirect:/memberList.do";
	}
	
	@RequestMapping("/memberRegister.do")
	public String memberRegister() {
				
		return "memberRegister";
	}
	
	@RequestMapping("/memberDelete.do")
	public String memberDelete(int num) {	// 넘어오는 변수를 다른이름으로 받으려면 @RequestParam("num") int su 사용
		//int cnt = dao.memberDelete(num);
		int cnt = memberMapper.memberDelete(num);	
		
		return "redirect:/memberList.do";
	}
	
	@RequestMapping("/memberContent.do")
	public String memberContent(int num, Model model) {
		//MemberVO vo = dao.memberContent(num);
		MemberVO vo = memberMapper.memberContent(num);
		
		// 객체 바인딩
		model.addAttribute("vo", vo);
		
		return "memberContent";
	}
	
	@RequestMapping("/memberUpdate.do")
	public String memberUpdate(MemberVO vo) {
		//int cnt = dao.memberUpdate(vo);
		int cnt = memberMapper.memberUpdate(vo);
		
		return "redirect:/memberList.do";
	}
}
반응형

+ Recent posts