Java Configuration 을 이용한 프로젝트 뼈대 설정

pom.xml 수정
데이터베이스 설정
스프링 MVC 처리

1. pom.xml 설정

1. java 버전, 스프링 버전 변경

    <properties>
        <java-version>1.8</java-version>
        <org.springframework-version>5.2.12.RELEASE</org.springframework-version>
        <org.aspectj-version>1.6.10</org.aspectj-version>
        <org.slf4j-version>1.6.6</org.slf4j-version>
    </properties>
    <!-- 생략 -->
     <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>2.5.1</version>
        <configuration>
            <source>1.8</source>
            <target>1.8</target>
            <compilerArgument>-Xlint:all</compilerArgument>
            <showWarnings>true</showWarnings>
            <showDeprecation>true</showDeprecation>
        </configuration>
    </plugin>
   

2. 스프링 관련 추가 라이브러리
   • spring-tx, spring-jdbc, spring-test

    <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${org.springframework-version}</version>
    </dependency>   
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${org.springframework-version}</version>
    </dependency>
    <!-- spring-test -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${org.springframework-version}</version>
        <scope>provided</scope>
    </dependency>
   

3. DB 연결 관련 라이브러리 추가
   • HikariCP, MyBatis, mysql-connector-java, mybatis-spring, Log4jdbc

    <!--DB 관련 추가 라이브러 -->
    <!-- MySQL -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.22</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
    <dependency>
        <groupId>com.zaxxer</groupId>
        <artifactId>HikariCP</artifactId>
        <version>3.4.5</version>
    </dependency>
    <!-- MyBatis 3.4.1 -->
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.4</version>
    </dependency>
    <!-- MyBatis-Spring -->
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>2.0.3</version>
    </dependency>
        <!-- https://mvnrepository.com/artifact/org.bgee.log4jdbc-log4j2/log4jdbc-log4j2-jdbc4.1 -->
    <dependency>
        <groupId>org.bgee.log4jdbc-log4j2</groupId>
        <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
        <version>1.16</version>
    </dependency> 
   

4. Lombox 추가

    <!-- lombok -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.0</version>
        <scope>provided</scope>
    </dependency> 
   

5. jUnit 버전 변경
   • 4.7 -> 4.12

    <!-- Test -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency> 
   

6. Servlet 버전 변경
   • 2.5 -> 3.0 이상

    <!-- Servlet -->
    <!-- <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
    </dependency> -->
    <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
    <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>javax.servlet-api</artifactId>
        <version>3.1.0</version>
        <scope>provided</scope>
    </dependency>
   

7. Controller 객체를 json으로 변환하는 라이브러리 추가
   • jackson-binder

    <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.11.3</version>
    </dependency>				
   

8. Maven Project Update
   • 프로젝트 우클릭 > Maven > Update Project…

2. 테이블 생성과 더미 데이터 생성

• mysqlWorkbench로 ‘book_ex'/'book_ex'로 접속한다. (기본 DB는 testdb로 정하였었다.)

• 아래의 스키마를 실행하여 테이블을 생성한다.

    CREATE TABLE `testdb`.`tbl_board` (
    `bno` INT NOT NULL AUTO_INCREMENT,
    `title` NVARCHAR(200) NOT NULL,
    `content` NVARCHAR(2000) NOT NULL,
    `writer` NVARCHAR(50) NOT NULL,
    `regdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updatedate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`bno`));
  

• 더미 데이터를 5건 정도 입력한다.

    insert into tbl_board ( title, content, writer)
    values ('테스트제목','테스트내용','user00');
  

3. 데이터베이스 설정

1. DataSource, sqlSession, log4jdbc, MyBatis 설정

   • RootConfig.java

    @Configuration
    @MapperScan(basePackages = {"org.example.mapper"})
    public class RootConfig {
        @Bean
        public DataSource dataSource() {
            HikariConfig config = new HikariConfig();
            config.setDriverClassName("net.sf.log4jdbc.sql.jdbcapi.DriverSpy");
            //config.setDriverClassName("com.mysql.cj.jdbc.Driver");
            config.setJdbcUrl("jdbc:log4jdbc:mysql://localhost:3306/testDb");
            //config.setJdbcUrl("jdbc:mysql://localhost:3306/testDb");
            config.setUsername("book_ex");
            config.setPassword("book_ex");
            config.addDataSourceProperty("serverTimezone", "UTC");
            config.addDataSourceProperty("cachePrepStmts", "true");
            config.addDataSourceProperty("prepStmtCacheSize", "250");
            config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
   
            HikariDataSource dataSource = new HikariDataSource(config);
            return dataSource;
        }
           
        @Bean
        public SqlSessionFactory sqlSessionFactory() throws Exception {
            SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
            sqlSessionFactory.setDataSource(dataSource());
            return (SqlSessionFactory) sqlSessionFactory.getObject();
        }
   

2. log4jdbc.log4j2.properties 파일 추가

   • src/main/resource 폴더하위

    log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
    #log4jdbc.auto.load.popular.drivers = false
   

4. JDBC TEST

• src/test/java 폴더 하위 org.example.persistance 패키지 생성
• JDBCTest.java 생성 후 테스트코드 작성

@Log4j
public class JDBCTest {

	static {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	@Test
	public void testConnection() {
		Connection conn = null;
		try{
			conn = 
				DriverManager.getConnection("jdbc:mysql://localhost/testDb?characterEncoding=UTF-8&serverTimezone=UTC",
						"book_ex",
						"book_ex");
			log.info(conn);
			conn.close();
		} catch (SQLException e) {
			
			fail(e.getMessage());
		} 
	}
}

• run as > JUnit Test 실행 후, conn 객체가 로그에 찍히는지 확인.

5. DataSource & ConnectionPool TEST

• src/test/java 폴더 하위 org.example.persistance 패키지
• DataSourceTest.java 생성 후 테스트코드 작성

  @RunWith(SpringJUnit4ClassRunner.class)
  @ContextConfiguration(classes= {RootConfig.class})
  @Log4j
  public class DataSourceTest {
  
    @Setter(onMethod = @__({@Autowired}))
    private DataSource ds; 
  	
    @Test
    public void testConnection() {
        Connection conn = null;
        try{
            conn = ds.getConnection();
            log.info(conn);
        } catch (Exception e) {
            fail(e.getMessage());
        }
    }
  }
  

• run as > JUnit Test 실행 후, conn 객체가 로그에 찍히는지 확인.

6. JavaConfiguration 임을 pom.xml 에 설정

• pom.xml

<!-- xml config 사용안함  -->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.0</version>
<configuration>
    <failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>

7. RootConfig.java

• org.example.config 패키지 하위
• MapperScan 설정
• 데이터베이스 설정

@Configuration
@MapperScan(basePackages = {"org.example.mapper"})
public class RootConfig {
	@Bean
	public DataSource dataSource() {
		HikariConfig config = new HikariConfig();
		config.setDriverClassName("net.sf.log4jdbc.sql.jdbcapi.DriverSpy");
		//config.setDriverClassName("com.mysql.cj.jdbc.Driver");
		config.setJdbcUrl("jdbc:log4jdbc:mysql://localhost:3306/testDb");
		//config.setJdbcUrl("jdbc:mysql://localhost:3306/testDb");
		config.setUsername("book_ex");
		config.setPassword("book_ex");
		config.addDataSourceProperty("serverTimezone", "UTC");
		config.addDataSourceProperty("cachePrepStmts", "true");
		config.addDataSourceProperty("prepStmtCacheSize", "250");
		config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

		HikariDataSource dataSource = new HikariDataSource(config);
		return dataSource;
	}
	
	@Bean
	public SqlSessionFactory sqlSessionFactory() throws Exception {
		SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
		sqlSessionFactory.setDataSource(dataSource());
		return (SqlSessionFactory) sqlSessionFactory.getObject();
	}
}

8. ServletConfig.java

• org.example.config 패키지 하위
• MVC 설정임을 지정
• ComponentScan 설정
• ViewResolver 설정
• ResourceHandler 설정

@EnableWebMvc
@ComponentScan(basePackages = {"org.example.controller"})
public class ServletConfig implements WebMvcConfigurer {

	@Override
	public void configureViewResolvers(ViewResolverRegistry registry) {
		// TODO Auto-generated method stub
		InternalResourceViewResolver bean = new InternalResourceViewResolver();
		bean.setViewClass(JstlView.class);
		bean.setPrefix("/WEB-INF/views/");
		bean.setSuffix(".jsp");
		registry.viewResolver(bean);
	}
	
	
	@Override
	public void addResourceHandlers(ResourceHandlerRegistry registry) {
		// TODO Auto-generated method stub
		registry.addResourceHandler("/resources/**").addResourceLocations("/resources/");
	}
}

9. WebConfig.java

• org.example.config 패키지 하위
• Was 기동시, RootConfig.class, ServletConfig.class 로드되도록 설정
• Context root 지정

public class WebConfig extends
AbstractAnnotationConfigDispatcherServletInitializer {

	@Override
	protected Class<?>[] getRootConfigClasses() {
		// TODO Auto-generated method stub
		return new Class[] {RootConfig.class};
	}

	@Override
	protected Class<?>[] getServletConfigClasses() {
		// TODO Auto-generated method stub
		return new Class[] {ServletConfig.class};
	}

	@Override
	protected String[] getServletMappings() {
		// TODO Auto-generated method stub
		return new String[] {"/"};
	}

	@Override
	protected void customizeRegistration(Dynamic registration) {
		// TODO Auto-generated method stub
		registration.setInitParameter("throwExceptionIfNoHandlerFound", "true");
	}
}