스프링 pom.xml, dbcp 설정 정리

클래스 명명규칙

1. 프리젠테이션: XxxController

2. 비즈니스: XxxService 인터페이스, XxxService 인터페이스를 구현한 XxxServiceImpl 클래스

3. 퍼시스턴스: MapperXxx 인터페이스, MapperXxx XML

4. 데이터: XxxVO, XxxDTO

 

패키지명명규칙

1. 컨트롤러: xxx.xxx.controller

2. 비즈니스: xxx.xxx.service

3. 퍼시스턴스: xxx.xxx.persistence

4. 데이터: xxx.xxx.domain

 

pom.xml 버전설정, 추가di

 

<properties>

<java-version>1.8</java-version>   <  ↓  버전 수정

<org.springframework-version>5.0.7.RELEASE</org.springframework-version>

<org.aspectj-version>1.6.10</org.aspectj-version>

<org.slf4j-version>1.6.6</org.slf4j-version>

</properties>

 

61행 log4j <version>1.2.17</version>, exclusions~scope까지 주석처리

junit 버전 4.12

 

<!-- Servlet -->  버전수정, artifactId에 javax추가

<dependency>

  <groupId>javax.servlet</groupId>

  <artifactId>javax.servlet-api</artifactId>

<version>3.1.0</version>  

      <!-- spring-test -->

      <dependency>

         <groupId>org.springframework</groupId>

         <artifactId>spring-test</artifactId>

         <version>${org.springframework-version}</version>

      </dependency>

      

      <!-- Lombok -->

      <dependency>

         <groupId>org.projectlombok</groupId>

         <artifactId>lombok</artifactId>

         <version>1.18.22</version>

         <scope>provided</scope>

      </dependency>

      

      

      <dependency>

           <groupId>com.zaxxer</groupId>

           <artifactId>HikariCP</artifactId>

           <version>3.4.1</version>

      </dependency>

      

      

      <dependency>

         <groupId>org.mybatis</groupId>

         <artifactId>mybatis</artifactId>

         <version>3.4.6</version>

      </dependency>      

      

      <dependency>

         <groupId>org.mybatis</groupId>

         <artifactId>mybatis-spring</artifactId>

         <version>1.3.2</version>

      </dependency>      

      <dependency>

         <groupId>org.springframework</groupId>

         <artifactId>spring-jdbc</artifactId>

         <version>${org.springframework-version}</version>

      </dependency>

      <dependency>

         <groupId>org.springframework</groupId>

         <artifactId>spring-tx</artifactId>

         <version>${org.springframework-version}</version>

      </dependency>

      

       <!-- Test -->

      <dependency>

         <groupId>org.bgee.log4jdbc-log4j2</groupId>

         <artifactId>log4jdbc-log4j2-jdbc4</artifactId>

         <version>1.16</version>

      </dependency>

 

<groupId>org.apache.maven.plugins</groupId>

source, target 1.8로 수정

 

설정 후 프로젝트 우클릭 - maven - update project

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

oracle jdbc8 추가(DBCP구현을위해) oracle 설치

프로젝트 우클릭

1. properties에서 java buildpath, add External jars에서 ojdbc8추가(sqldeveloper\jdbc\lib)

2. properties에서 Deployment Assembly에 add - java build path entries - ojdbc8선택

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

root-context에 히카리config와 mybatis 핵심객체 등록

 

<!-- 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:ORCL"></property>

      -->      

      <property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>

      <property name="jdbcUrl"    value="jdbc:log4jdbc:oracle:thin:@localhost:1521:ORCL"></property>

      

      <property name="username" value="book_ex"></property>

      <property name="password" value="book_ex"></property>

   </bean>

   

   <!-- HikariCP configuration -->

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

 

   <mybatis-spring:scan base-package="org.zerock.persistence"></mybatis-spring:scan>

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

src/main/java

 

1. 컨트롤러: xxx.xxx.controller

2. 비즈니스: xxx.xxx.service

3. 퍼시스턴스: xxx.xxx.persistence

4. 데이터: xxx.xxx.domain

 

src/main/resources

 

org.zerock.persistence 패키지 생성 후 BoardMapper.xml파일생성

log4jdbc.log4j2.properties 파일 추가!!!

 

<!DOCTYPE mapper

  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

  

<mapper namespace="org.zerock.persistence.BoardMapper">

  <select id="getList" resultType="org.zerock.domain.BoardVO">

    <![CDATA[ select * from tbl_board where bno > 0 ]]>    <!-- 비교연산자 > < 를 쓰려면 CDATA를 사용한다 -->

  </select>

</mapper>

 

—-------------------------------------------------------------------------------------------

 

에러나면 확인할거.

junit버전바꾸기, root-context에 mybatis bean객체있나 확인, log4jdbc 외부주입확인, log4j 1.2.17버전…