[2-1등록,수정,삭제,조회 기능의 구현]3.프로젝트 생성

필요한 것들

정리

1. pom.xml 1)java-version 2)spring version 3)spring compile - ${java-version}으로 셋팅

2. JDBC 1) 자바 JDBC 2) 스프링 JDBC

3. MyBatis

4. MyBatis - Spring

5. Spring-test

6. log4j2

1. pom.xml

1) java version

2) spring version

3) spring compile - ${java-version}

1,2) java version & spring version

3) spring compile - setting 자바버전으로 설정

2. JDBC

1) mySQL드라이버(자바 jdbc)

2) 스프링 jdbc

1) mySQL드라이버(자바 jdbc):mysql-connector-java

        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.41</version>
        </dependency>

2) 스프링 jdbc

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
 

version을 ${org.springframework-version}로 맞춰준다.

3.MyBatis 모듈

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>
 

4.MyBatis-Spring 모듈

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>

5. Spring-test모듈

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>

version을 ${org.springframework-version}로 맞춰준다.

6. log4j2 모듈 추가

        <!-- https://mvnrepository.com/artifact/org.bgee.log4jdbc-log4j2/log4jdbc-log4j2-jdbc4 -->
        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
            <version>1.16</version>
        </dependency>
 

# 테스트 진행을 위해 필요한 것

1) JUnit 버전 변경

2) Servlet 버전 변경

#설정 관련 파일 추가

1) mybatis-config.xml

src>main>resource>mybatis>mybatis-config.xml

2) log4j2.properties, logback.xml

src>main>resource

※ 본 자료는 구멍가게 코딩단- 코드로 배우는 스프링 웹 프로젝트를 기반으로 작성하였습니다.