[Spring] Spring 기본세팅 & Setting Test

1. Spring Framework version 변경 -> 5.1.7

 

 

2. JDK version 변경 -> 1.8

 

 

3. Spring webmvc dependency 두개 복사 후 spring-test, spring-jdbc로 변경

 

 

4. JUnit version 변경 -> 4.12

 

 

5. lombok 라이브러리 추가(lombok maven)

 

 

6. Log4J Exclusion,Scope삭제, version 변경->1.2.17 & Maven UPDATE 

 

 

 

 

7. Loading Test 

package org.sora.loading;
 
import static org.junit.Assert.assertNotNull;
 
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
 
import lombok.extern.log4j.Log4j;
 
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
@Log4j
public class LoadingTest {
    
    @Autowired
    private ApplicationContext ctx;    
    @Test
    public void testCtx() {
    log.info(ctx);
    assertNotNull(ctx);
    }    
}
 

 

 

8. root-context.xml 수정 및 DB connection pool & myBatis Test 

(pom.xml에 mysql connector, mybatis, mybatis-spring, hikari cp dependency 추가) 

<?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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
    xmlns:context="http://www.springframework.org/schema/context"
    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 http://www.springframework.org/schema/context/spring-context-4.3.xsd">

    <bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
        <property name="driverClassName"
            value="com.mysql.cj.jdbc.Driver"></property>
        <property name="jdbcUrl"
            value="jdbc:mysql://localhost:3306/bitdb?serverTimezone=Asia/Seoul&amp;useSSL=false"></property>
        <property name="username" value="bit04"></property>
        <property name="password" value="1234"></property>
    </bean>
 
 
    <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource"
        destroy-method="close">
        <constructor-arg ref="hikariConfig" />
    </bean>
 
 
    <bean id="sqlSessionFactory"
        class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

package org.sora.loading;
 
import java.sql.Connection;
import java.sql.DriverManager;
 
import org.junit.Test;
 
import lombok.extern.log4j.Log4j;
 
@Log4j
public class MySQLConnectTests {
 
    @Test
    public void testConnect() throws Exception {
        // Class.forName의 return type은 class
        // 어떤 class인줄 모르니 <?>
        // Class<?> clz = Class.forName("com.mysql.jdbc.Driver");
        // com.mysql.jdbc.Driver <= Old version.(deprecated임) 아래가 new type
        Class<?> clz = Class.forName("com.mysql.cj.jdbc.Driver");
        log.info(clz);
 
        // 위까지 오류없이 완료됐으면 JDBC Driver연결 테스트
        // 아래 코드는 에러 남.(구버전)
        // Connection con =
        // DriverManager.getConnection("jdbc:mysql://localhost:3306/bitdb","bit04","1234");
        Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/bitdb?serverTimezone=Asia/Seoul&useSSL=false", "bit04", "1234");
        log.info(con);
        con.close();
 
    }    
}
 

 

mybatis Test - Time Test (어노테이션 테스트, xml 테스트)

: root-context에 mapper bean 생성을 위한 코드 작성 

    <mybatis-spring:scan
        base-package="org.sora.mapper" />

 

src/main/resources에 org package 생성 및 하위 폴더 생성(sora>mapper) 후

TimeMapper.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="org.sora.mapper.TimeMapper">
 
<select id="getTime2" resultType="String">
select now()
</select>
</mapper>
 

 

TimeMapper interface 

package org.sora.mapper;
 
import org.apache.ibatis.annotations.Select;
 
public interface TimeMapper {    
    // 1. for 어노테이션 테스트
    @Select("select now()")
    public String getTime();    
    
    // 2. for xml 테스트 
    public String getTime2();    
}
 

 

Test Code 

package org.sora.mapper;
 
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
 
import lombok.extern.log4j.Log4j;
 
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
@Log4j
public class TimeMapperTests {
    
    @Autowired
    private TimeMapper mapper;
    
    @Test
    public void testTime() {        
        log.info(mapper.getTime());
        log.info(mapper.getTime2());        
    }    
 
}

 

끄적_spring_setting.txt

0.00MB

intelliJ_Spring_setting.txt

0.00MB

 

프로젝트1107.txt

0.00MB