Spring - 개발 환경 3 (Mybatis & Oracle 연동)

상단에 Package Explorer로 안보이면

 

 

후에 open

 

 

 

<!-- 오라클 -->
<repositories>
<repository>
<id>oracle</id>
<url>http://maven.jahia.org/maven2</url>
</repository>
</repositories>

 

추가

 

 </dependencies> 위에다가 아래 추가

 

        <!-- spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>

 

        <!-- spring-test -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${org.springframework-version}</version>
            <scope>test</scope>
        </dependency>
     
        <!-- log4jdbc-log4j2-jdbc4 -->
        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
            <version>1.16</version>
        </dependency>
  
        <!-- org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>
      
        <!-- mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency> 

 

후에 ctrl + s 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

이름 : log4jdbc.log4j2.properties finish

 

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator 입력 후 저장

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

 

해당 경로에서 이름 : lib      finish

 

자신의 오라클 깔린 곳 경로 확인 후 jdbc lib 폴더 확인 하면

ojdbc6 파일 복사

 

추가한 ojdbc에서 오른쪽 마우스

 

 

Refreneced Libaries에서 추가 된 것을 확인 가능

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

 

<!-- 오라클 접속 -->
    <bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
        <property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"/>
        <property name="url" value="jdbc:log4jdbc:oracle:thin:@localhost:1521/orcl"/>
        <property name="username" value="자신오라클아이디"/>
        <property name="password" value="자신오라클비번"/>
    </bean>
   
    <!-- Mybatis 연동 -->
    <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"/>
    </bean>
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="clearCache">
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
    </bean>

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

만든 mappers에서 xml 파일 만들기

 

finish

 

 

<?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="boardMapper">
   
</mapper>

안에 내용 추가

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

 

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>
  
</configuration>

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------

JUnit 추가

 

 

 

 

 

 

name Test  후 finish

 

안에 내용 추가

 

package com.dandycompany.dandyapp;

import java.sql.Connection;

import javax.inject.Inject;
import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ={"file:src/main/webapp/WEB-INF/spring/**/root-context.xml"})
public class Test {

    @Inject
    private DataSource ds;
       
    @Inject
    private SqlSessionFactory sqlFactory;
 
    @org.junit.Test
    public void test() throws Exception{

        try(Connection conn = ds.getConnection()){
            System.out.println(conn);
        } catch(Exception e){
            e.printStackTrace();
        }
    }
   
  
    @org.junit.Test
    public void factoryTest() {
        System.out.println(sqlFactory);
      
    }
  
    @org.junit.Test
    public void sessionTest() throws Exception{
      
        try(SqlSession session = sqlFactory.openSession()) {
            System.out.println(session);
        }catch(Exception e) {
            e.printStackTrace();
        }
    }
}

 

 

후 

The import org.junit cannot be resolved

라는 에러 발생시에 

=> Description Resource Path Location Type org.junit cannot be resolved to a type Test.java /dandyStudy/src/test/java/com/dandycompany/dandyapp line 24 Java Problem

 

프로젝트 우클릭

 

JUnit -> pom.xml에 맞는 버전 선택

후에 apply close

 

두번째 에러

Description Resource Path Location Type
Class<SpringJUnit4ClassRunner> cannot be resolved to a type Test.java /dandyStudy/src/test/java/com/dandycompany/dandyapp line 14 Java Problem

 

 

pom.xml에서

scope 부분 지우기

해결됨.

 

 

 

 

 

초록색 일때 정상적으로 성공 했다는 것