[Spring] 스프링과 oracle Database연동

-오라클 설치  11g버전 (버전은 중요하지않음)

-sql Developer 설치(Sql plus보다 편한 gui방식 툴)

-계정생성 / 8080포트 변경(tomcat의 기본포트가 8080이기때문)

-프로젝트 jdbc 연결 (오라클은 pom.xml에 등록해도 저작권?문제때문에 자동으로 다운이 안되기때문에

 lib 폴더를 만들고 ojdbc8.jar를 넣어서 java balid path로 등록해주기!

 

- JDBC 테스트코드

package org.zeorck.persistence;
 
import static org.junit.Assert.fail;
 
import java.sql.Connection;
import java.sql.DriverManager;
 
import org.junit.Test;
 
import lombok.extern.log4j.Log4j;
 
@Log4j
public class JDBCTests {
static {
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
    }catch (Exception e) {
        e.printStackTrace();
        }
    }
 
@Test
public void testConnection() {
    try(Connection con = DriverManager.getConnection(
            "jdbc:oracle:thin:@localhost:1521:XE",
            "web02", 
            "1234")){
        log.info(con);
    }catch(Exception e) {
        fail(e.getMessage());
        }
    }
}
 

<!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
<dependency>
    <groupId>com.zaxxer</groupId>
    <artifactId>HikariCP</artifactId>
    <version>2.7.4</version>
</dependency>
 

root-context.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"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="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">
    
    <!-- Root Context: defines shared resources visible to all other web components -->
        
        
        <bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
        <property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:xe"></property>
        <property name="username" value="web02"></property>
        <property name="password" value="1234"></property>
        </bean>
        
        <!--HikariCP Configration-->
        <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
        <constructor-arg ref="hikariConfig"/>
        </bean>
        
    <context:component-scan base-package="org.zeorck.sample"></context:component-scan>
        
</beans>
 

DataSourceTests 테스트

package org.zeorck.persistence;
 
import static org.junit.Assert.fail;
 
import java.sql.Connection;
 
import javax.sql.DataSource;
 
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.Setter;
import lombok.extern.log4j.Log4j;
 
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
@RunWith(SpringJUnit4ClassRunner.class)
@Log4j
public class DataSourceTests {
 
 
    @Setter(onMethod_ = {@Autowired})
    private DataSource dataSource;
    
    @Test
    public void testConnection() {
        try(Connection con = dataSource.getConnection()){
            log.info(con);
        }catch (Exception e) {
            fail(e.getMessage());
        }
    }
}