반응형
# 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";
}
}
반응형
'인프런 강의 학습 > MVC 프레임워크_나프2탄' 카테고리의 다른 글
인프런 나프_2탄 22일차 : Spring WEB MVC_02버전_04 Spring WEB_MVC와 Ajax 통신(@ResponseBody) (0) | 2021.07.04 |
---|---|
인프런 나프_2탄 21일차 : Spring WEB MVC_02버전_03 Mapper 인터페이스와 @(어노테이션)이용한 CRUD (0) | 2021.07.04 |
인프런 나프_2탄 19일차 : Spring WEB MVC_01버전_06~08 MVC 동작원리, 회원관리 (0) | 2021.07.03 |
인프런 나프_2탄 18일차 : Spring WEB MVC_01버전_04~05 DataBase 연결 (0) | 2021.07.03 |
인프런 나프_2탄 17일차 : Spring WEB MVC_01버전_03 POJO 개수 줄이기 (0) | 2021.07.01 |