스프링 초기 설정

1. Project JRE 버전 변경

• Project - Properties - ProjectFacet
  자바 버전 1.8로 변경

2. pom.xml

• Overall Version

<properties>
    <java-version>1.8</java-version>
    <org.springframework-version>4.3.17.RELEASE</org.springframework-version>
    <org.aspectj-version>1.9.1</org.aspectj-version>
    <org.slf4j-version>1.7.25</org.slf4j-version>
</properties>

• MyBatis v.3.4.1

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

• MyBatis-Spring v.1.3.2

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

• Spring-JDBC v.spring

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

• Jackson-Databind (Ajax) v.2.9.6

<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.9.6</version>
</dependency>

3. OJDBC 설정

• src/main/webapp/WEB-INF에 lib폴더 생성
• ojdbc.jar파일 넣기

4. web.xml 한글 설정

• src/main/webapp/WEB-INF/web.xml
• 한글설정

<filter>
    <filter-name>encodingFilter</filter-name>
    <filter-class>org.springframework.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>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

5. Root Context (복붙 후 확인)

• src/main/webapp/WEB-INF/spring/web.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!-- db.properties -->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location">
            <value>classpath:db.properties</value>
        </property>
    </bean>

    <!-- db.properties 설정값을 읽어서 setting -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
    </bean>

    <!-- 트랜잭션 관리를 위한 설정 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" >
        <property name="dataSource" ref="dataSource" />
    </bean>

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

    <!-- SqlSession -->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean>
</beans>

6. 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">
<configuration>
    <typeAliases>
        <!-- <typeAlias type="com.package.name.vo.VO_Obj"	alias="VO_Obj" /> -->
    </typeAliases>

    <mappers>
        <!-- <mapper resource="mappers/Mapper.xml" /> -->
    </mappers>
</configuration>

• db.properties

driver = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@host:port:xe
username = id
password = password

• mappers/Mapper.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.package.name.dao.MapperInterface">
    <!-- 
    <insert id="insertMethod" parameterType="VO_Obj">
        INSERT INTO test (name)
        VALUES (#{name})		
    </insert>
    -->
</mapper>

7. HomeController

• HomeContorller.java

package com.package.name;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

@Controller
public class HomeController {
    @RequestMapping(value = "/", method = RequestMethod.GET)
    public String home(Locale locale, Model model) {
        return "index";
    }
}

8. JQuery 설치

• main/webapp/resources에 jquery-3.3.1.min.js 복사