스프링(Spring Framework) MyBatis 설정

스프링(Srping Framework) MyBatis 설정

1. 프로젝트 생성

• File - Spring Legacy Project
• Project name 설정
• Templates 에서 Spring MVC Project 선택
• package 설정

2. pom.xml에 라이브러리 추가

• junit 버전 변경(4.12), spring-test, spring-jdbc, mysql-connector-java, mybatis, mybatis-spring

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

    <!-- spring jUnit test, was 구동없이 동작 확인, junit 버전은 4.11 이상이어야함 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${org.springframework-version}</version>
    </dependency>

    <!-- spring jdbc -->
     <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${org.springframework-version}</version>
     </dependency> 

     <!-- mysql -->
     <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.41</version>
     </dependency>

     <!-- MyBatis -->
     <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.1</version>
     </dependency>

     <!-- MyBatis-spring -->
     <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.3.0</version>
     </dependency>

3. root-context.xml 설정(DataSource, SqlSessionFactory, SqlSessionTemplate bean으로 등록)

• root-context.xml에서 namespace 설정

• src/main/webapp/WEB-INF/spring/root-context.xml 수정

  
    <!-- mySql과 연결을 담당하는 dataSource -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/데이터베이스이름?useSSL=false"></property>
        <property name="username" value="MySQL 아이디"></property>
        <property name="password" value="MySQL 비밀번호"></property>
    </bean>
  
    <!-- SqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="classpath:/mybatis-config.xml"></property>
        <property name="mapperLocations" value="classpath:/testMapper.xml"></property>
    </bean>
  
    <!-- SqlSessionTemplate -->
    <bean id="sqlSessoinTemplate" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
    </bean>
  

• src/main/resources/에 ‘mybatis-config.xml’, ‘testMapper.xml’ 생성

• mybatis-config.xml

    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    </configuration>
  

• testMapper.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="testMapper">
  
    </mapper>