[Spring Boot] Maven 환경 Oracle 연동하기

📌 Setting

- java : 11 

- oracle : 11c

- framework : spring Boot / maven 

 

💻 application.yml

  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: 
    username: 
    password:

- url 

1) Oracle9 버전인 경우 "jdbc:oracle:thin:@localhost:1521:XE"
2) Oracle11 버전인 경우 "jdbc:oracle:thin:@localhost:1521:orcl" 

 

- username 

oracle 유저 명 

 

- password 

oracle 유저의 패스워드 

 

💻 DBConfig.java

@Configuration
public class DBConfig {

    @Value("${spring.datasource.driver-class-name}")
    private String driverClassName;

    @Value("${spring.datasource.url}")
    private String url;

    @Value("${spring.datasource.username}")
    private String username;

    @Value("${spring.datasource.password}")
    private String password;

    @Autowired
    ApplicationContext applicationContext;

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(driverClassName);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);

        return dataSource;
    }

    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) throws IOException {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();

        factoryBean.setDataSource(dataSource);
        factoryBean.setConfigLocation(applicationContext.getResource("classpath:/mybatis/mybatis-config.xml"));
        factoryBean.setMapperLocations(applicationContext.getResources("classpath:/mapper/*Mapper.xml"));
        return factoryBean;
    }

    @Bean
    public SqlSessionTemplate sqlSession(SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

 

💻 pom.xml

<!-- spring jdbc -->
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>2.1.4</version>
    </dependency>
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8</artifactId>
      <version>12.2.0.1</version>
    </dependency>
<!-- spring jdbc -->

maven 업데이트 후 C:\Users\.m2\repository\com\oracle\database\jdbc\ojdbc8\12.2.0.1 내에 jar 파일이 생성되지 않는다면 maven 홈페이지에서 직접 jar 파일을 받아줍니다. 

 

- 다운로드 링크

https://mvnrepository.com/artifact/com.oracle.jdbc/ojdbc8/12.2.0.1

---

📌 TEST

💻 testDto

@Data
public class TestDto {
    private int id;
    private String name;
    private String memo;
}

💻 testDao

@Repository
public class TestDao {

    @Autowired
    private SqlSessionTemplate sqlSessionTemplate;

    public TestDto getTestInfo(int id) {
        return sqlSessionTemplate.selectOne("testMapper.getTestInfo", id);
    }
}

💻 testService

@Service
public class TestService {
    @Autowired
    private TestDao testDao;

    public TestDto getTestInfo(int id) {
        return testDao.getTestInfo(id);
    }

}

💻 testController

@Controller
public class TestController {
    @Autowired
    private TestService testService;

    @GetMapping("/test")
    @ResponseBody
    public void test() {
        TestDto obj = testService.getTestInfo(1);
        System.out.println("성공 : " + obj.getId() + " / " + obj.getName() );

    }
}

💻 testMapper

<?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="testMapper">
    <select id="getTestInfo" parameterType="Int" resultType="domain.test.dto.TestDto">
        SELECT * FROM test WHERE id = #{id}
    </select>

</mapper>

💻 Query

create table test (id int, name varchar(50), memo varchar(50));
INSERT INTO test VALUES(1,'최테스트','테스트 데이터');
INSERT INTO test VALUES(2,'이테스트','테스트 데이터');
INSERT INTO test VALUES(3,'김테스트','테스트 데이터');

💻 결과