MyBatis를 통한 Spring과 MySQL 연결

자세한 사항은 아래 URL 참고

https://mybatis.github.io/spring/index.html

1. MySQL 과 MyBatis 관련 library 설치

- pom.xml 에서 아래 dependency 추가

<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.1.1</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.21</version> </dependency>

2. DispatcherServlet-context.xml 설정 (datasource, sqlSessionFactory)

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://127.0.0.1:3306/db명" /> <property name="username" value="계정명" /> <property name="password" value="비밀번호" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> </bean>

3. 쿼리 결과를 담을 entity class 생성

4. 쿼리를 목록으로 하는 interface 생성

- src/main/java 에 위치

- @Select 와 같은 쿼리 annotation은 매핑되는 xml에 쿼리가 있는 경우 무시된다.

ex)

package groupContactsManager.mapper; import groupContactsManager.domain.Product; import java.util.List; public interface UserMapper { @Select("SELECT * FROM PRODUCTS") List<Product> getAllProducts(); }

5. resultMap 과 쿼리를 목록으로 하는 xml 생성

- src/main/resources 에 위치하며, interface와 동일한 위치, 동일한 파일명을 가져야 한다.

- mapper namespace="src/main/resources 아래 xml 위치"

- resultMap type="src/main/java 아래 entity file 위치"

<?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="groupContactsManager.mapper.UserMapper"> <resultMap id="product" type="groupContactsManager.domain.Product"> <id property="productId" column="PRODUCT_ID"></id> <result property="name" column="NAME"></result> <result property="unitPrice" column="UNIT_PRICE"></result> <result property="description" column="DESCRIPTION"></result> <result property="category" column="CATEGORY"></result> <result property="unitsInStock" column="UNITS_IN_STOCK"></result> <result property="unitsInOrder" column="UNITS_IN_ORDER"></result> <result property="discontinued" column="DISCONTINUED"></result> </resultMap> <select id="getAllProducts" resultMap="product"> SELECT * FROM PRODUCTS </select> </mapper>

6. DispatcherServlet-context.xml 설정 (쿼리 xml)

<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="groupContactsManager.mapper.UserMapper" /> <property name="sqlSessionFactory" ref="sqlSessionFactory" /> </bean>

7. java에서 쿼리 사용

- DispatcherServlet-context.xml 설정 (쿼리 xml 을 사용할 java 파일)

<bean id="ProductService" class="groupContactsManager.service.impl.ProductServiceImpl"> <property name="userMapper" ref="userMapper" /> </bean>

- java에서 사용

package groupContactsManager.service.impl; import groupContactsManager.domain.Product; import groupContactsManager.mapper.UserMapper; import groupContactsManager.service.ProductService; import java.util.List; public class ProductServiceImpl implements ProductService { private UserMapper userMapper; public void setUserMapper(UserMapper userMapper) { this.userMapper = userMapper; } public List<Product> getAllProducts() { return userMapper.getAllProducts(); } }