Settings

1.  Project  선택 
    (1) project facets -> 1.8 변경

2 . pom.xml  수정
    (1) version  수정 
<properties>
<java-version>1.8</java-version>
<!--<org.springframework-version>3.1.1.RELEASE</org.springframework-version>-->
<org.springframework-version>4.1.7.RELEASE</org.springframework-version>
<org.aspectj-version>1.6.10</org.aspectj-version>
<org.slf4j-version>1.6.6</org.slf4j-version>
</properties>

(2) junit 변경 
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<!--<version>4.7</version>-->
<version>4.1.2</version>
<scope>test</scope>
</dependency> 

    (3) MyBatis 
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.8</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${org.springframework-version}</version>
</dependency>

      (4) JSON 
<!-- JSON -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.5.4</version>
</dependency>

      (5) servlet
<!-- Servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>

      (6) build 태그 내 java version 수정
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <!--<version>2.5.1</version>-->
<version>3.5.1</version>
                <configuration>
                    <!--<source>1.6</source>-->
                    <!--<target>1.6</target>-->
                    <source>1.8</source>
                    <target>1.8</target>
                    <compilerArgument>-Xlint:all</compilerArgument>
                    <showWarnings>true</showWarnings>
                    <showDeprecation>true</showDeprecation>
                </configuration>
            </plugin>

  (7) Project 선택 후 우클릭 -> Maven -> Update Project

3 . Oracle 설정 
    (1) ojdbc8.jar 추가 
    ① project를 선택한 후 Build Path를 이용
② Libraries (Add External JARs) 
③ Deployment Assembly -> Add -> Archives from File System

4. root-context.xml 
    (1) Namespace추가
    ① aop / beans / context / jdbc / mybatis-spring
    (2) DataSource 설정
 <!-- oracle.jdbc.driver.OracleDriver
    jdbc:oracle:thin:@127.0.0.1:1521/pdborcl
-->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521/pdborcl"></property>
<property name="username" value="dev"></property>
<property name="password" value="tester"></property>
</bean>

<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:/mybatis-config.xml"></property>
<property name="mapperLocations" value="classpath:mappers/**/*Mapper.xml"></property>
</bean>

<bean id="sqlSession"
class="org.mybatis.spring.SqlSessionTemplate"
destroy-method="clearCache">
<constructor-arg name="sqlSessionFactory"
ref="sqlSessionFactory"></constructor-arg>
</bean>

5. mybatis-config.xml 
    (1) src/main/resources 내에 mybatis-config.xml 생성
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">

6. 예제 memberMapper.xml 설정 
    (1) src/main/resources/mappers 내에 memberMapper.xml 생성
<?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">
<mapper namespace="com.nbisys.mapper.MemberMapper">
   <select id="getTime" resultType="String">
       select sysdate from dual
   </select>
</mapper>

7. log4 jdbc
    (1) src/main/resources 내에 log4jdbc.log4j2.properties 생성
    ① log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
    (2) pom.xml 추가
<!-- log4jdbc -->
<dependency>
<groupId>org.bgee.log4jdbc-log4j2</groupId>
<artifactId>log4jdbc-log4j2-jdbc4</artifactId>
<version>1.16</version>
</dependency>
    (3) root-context.xml 수정
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<!--<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"></property>
 <property name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521/pdborcl"></property>-->
        <property name="driverClassName"
value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>
<property name="url"
value="jdbc:log4jdbc:oracle:thin:@127.0.0.1:1521/pdborcl"></property>
<property name="username" value="dev"></property>
<property name="password" value="tester"></property>
</bean>

8 . web.xml 한글 문제해결 filter추가
<filter>
<filter-name>encoding</filter-name>
<filter-class>org.springframwork.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
9. 프로젝트 우클릭
   properties -> Web Project Settings -> Context root 변경