22-08-22 JavaSpring DB연결 라이브러리 설정(최종), 게시물 작성

1 라이브러리 설정

1. MySql Connector/J 8.0.29 : jdbc를 사용할 때, db와 연결시켜줄 Driver
2. Spring JDBC 4.2.14 RELEASE(해당 Spring 버전과 맞춰야함)
3. MyBatis 3.5.9
4. Mybatis Spring 2.0.7 : mybatis 강화
5. HikariCP 4.0.3 : DBCP(DataBase Connection Pool) 관리 라이브러리

→ <pom.xml>

  <?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.smhrd</groupId>
    <artifactId>web</artifactId>
    <name>SpringMVC01</name>
    <packaging>war</packaging>
    <version>1.0.0-BUILD-SNAPSHOT</version>
    <properties>
        <java-version>1.6</java-version>
        <org.springframework-version>4.3.14.RELEASE</org.springframework-version>
        <org.aspectj-version>1.6.10</org.aspectj-version>
        <org.slf4j-version>1.6.6</org.slf4j-version>
    </properties>
    <dependencies>
        <!-- Spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${org.springframework-version}</version>
            <exclusions>
                <!-- Exclude Commons Logging in favor of SLF4j -->
                <exclusion>
                    <groupId>commons-logging</groupId>
                    <artifactId>commons-logging</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>

        <!-- AspectJ -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjrt</artifactId>
            <version>${org.aspectj-version}</version>
        </dependency>

        <!-- Logging -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>${org.slf4j-version}</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>jcl-over-slf4j</artifactId>
            <version>${org.slf4j-version}</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>${org.slf4j-version}</version>
            <scope>runtime</scope>
        </dependency>
        <!-- jdbc를 사용할 때, DB와 연결시켜줄 Driver -->
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.9</version>
        </dependency>
            <!-- My Batis 강화 -->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.7</version>
        </dependency>

        <!-- DBCP(DataBase Connection Pool)관리 라이브러리-->
        <!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
        <dependency>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
            <version>4.0.3</version>
        </dependency>


        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.14.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.15</version>
            <exclusions>
                <exclusion>
                    <groupId>javax.mail</groupId>
                    <artifactId>mail</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>javax.jms</groupId>
                    <artifactId>jms</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>com.sun.jdmk</groupId>
                    <artifactId>jmxtools</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>com.sun.jmx</groupId>
                    <artifactId>jmxri</artifactId>
                </exclusion>
            </exclusions>
            <scope>runtime</scope>
        </dependency>

        <!-- @Inject -->
        <dependency>
            <groupId>javax.inject</groupId>
            <artifactId>javax.inject</artifactId>
            <version>1</version>
        </dependency>

        <!-- Servlet -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

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

        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.14</version>
            <scope>provided</scope>
        </dependency>

    </dependencies>
    <build>
        <plugins>
            <plugin>
                <artifactId>maven-eclipse-plugin</artifactId>
                <version>2.9</version>
                <configuration>
                    <additionalProjectnatures>
                        <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
                    </additionalProjectnatures>
                    <additionalBuildcommands>
                        <buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
                    </additionalBuildcommands>
                    <downloadSources>true</downloadSources>
                    <downloadJavadocs>true</downloadJavadocs>
                </configuration>
            </plugin>
            <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>
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>exec-maven-plugin</artifactId>
                <version>1.2.1</version>
                <configuration>
                    <mainClass>org.test.int1.Main</mainClass>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

---

2. DB 연결

root-context

  <beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
    xsi:schemaLocation="
  http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">


    <!-- Root Context: defines shared resources visible to all other web components -->

    <!--bean을 정의하는 파일 -->
    <!-- bean : java 객체 spring에서의 bean은 spring이 생성, 소멸을 ㅘㄴ리 하는 객체 bean태그를 이용해서 
        등록 class : 어떤 객체를 만들것인가 id : 변수명 property : setName(value) -->
    <bean id="board" class="com.smhrd.domain.Board">
        <property name="title" value="스프링Bean"></property>
    </bean>
    <!-- Board board = new Board(); board.setTitle("스프링 Bean") -->



    <!-- DBCP 설정 -->
    <!-- DB와 연결에 필요한 정보를 저장할 객체 생성 (무슨 db쓸래, 아이디비번, 등등~) -->
    <bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">

        <!--hikariConfig class 안에 보면 다 있다 복사해서 넣자 -->

        <!-- Driver Class -->
        <property name="driverClassName"
            value="com.mysql.jdbc.Driver"></property>
        <!-- DB 접속 url -->
        <property name="jdbcUrl"
            value="jdbc:mysql://localhost:3306/mysql"></property>
        <!-- User ID -->
        <property name="username" value="root"></property>
        <!-- User Password -->
        <property name="password" value="12345"></property>
    </bean>


    <!-- hikariConfig를 이용해서 DBCP를 만들어 줄 객체 생성 -->
    <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource">
        <!-- HikariDataSource dataSource = new HikariDataSource(hikariConfig); 
            << () 안에 채워주기 -->
        <constructor-arg ref="hikariConfig"></constructor-arg>

    </bean>

    <!-- DBCP를 활용해서 JDBC 기능을 완성할 SqlSessionFactory 생성 -->
    <!-- mybatis 라이브러 안 확인 -->
    <bean id="sqlSessionFactoryBean"
        class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- sqlSessionFactoryBean.setDataSource(dataSource); -->
        <property name="dataSource" ref="dataSource"></property>
    </bean>


    <!-- Mapper interface와 xml를 찾아낼 수 있도록 scan을 해야함 -->
    <mybatis:scan base-package="com.smhrd.mapper"></mybatis:scan>



</beans>

DBCP 설정

hikariconfig를 이용해서 DBCP를 만들어줄 객체 생성

DBCP를 활용해서 JDBC 기느을 완성할 SqlSessionFactory 생성

Mapper 채우기

• boardMapper.xml

<?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="com.smhrd.mapper.BoardMapper">

    <!-- 
       전체 글 조회하는 SQL문
       select * from board;

       id == 추상메서드의 이름
     -->
    <select id="boardList" resultType="com.smhrd.domain.Board">
        select * from board
    </select>

</mapper>

• boardMapper.java

package com.smhrd.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.smhrd.domain.Board;

// class 가  아닌 interface로 하자.
// 이 파일이 Mapper라고 알려주자
@Mapper
public interface BoardMapper {

    // 전체 글 조회하는 메서드
    // 추상메서드 만들기
    public List<Board> boardList();
}

• boardController.java

    @Autowired //이걸 사용하면 new 블라블라 사용 안해도 된다.
    private BoardMapper mapper;

Mapper interface와 xml을 찾아 낼 수 있도록 scan

→ root-context.xml 추가 시 오류가 발생
구글 Maybatis spring → 왼쪽 → 매퍼주입 탭
아래로 내리면