스프링3.0 에서 mybatis 설정한 후, 간단한 샘플 코딩 예제를 적어본다. 오랜만에 스프링 웹프로젝트를 하는거라 예전에 했던 것들이 가물가물하여 기록/정리차원에서 그냥 쓱쓱 적는 거임~~ :)
* maven 설정(pom.xml 에 추가)
<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.18</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.0.6</version>
</dependency>
<!-- mybatis spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.0.2</version>
</dependency>
* /MyProject/src/main/resources/property/mybatis.properties 생성
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://server.ip:port/dbname?useUnicode=true&characterEncoding=utf-8&interactiveClient=true&autoReconnect=true&autoReconnectForPools=true&
jdbc.username=접속할 아이디
jdbc.password=비밀번호
* /MyProject/src/main/webapp/WEB-INF/spring/applicationContext-mybatis.xml 생성.
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<bean id="propertyPlaceholderConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<value>classpath:property/mybatis.properties</value>
</property>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<!-- http://groups.google.com/group/ksug/browse_thread/thread/766cd1fd8ba39c96 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:myproject/db/mybatis/mapper/**/*.xml" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
</bean>
</beans>
* /MyProject/src/main/webapp/WEB-INF/web.xml 수정.
<param-value>
/WEB-INF/spring/root-context.xml
/WEB-INF/spring/applicationContext*.xml
</param-value>
* /MyProject/src/main/resources/myproject/db/mybatis/mapper/NoticeBoardMapper.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="myproject.dao.NoticeBoardDao">
<select id="getUserName" parameterType="string" resultType="string">
SELECT EMAIL FROM T_USER WHERE ID = #{userId}
</select>
</mapper>
* DAO 인터페이스 생성(/MyProject/src/main/java/myproject/dao/NoticeBoardDao.java)
package myproject.dao;
public interface NoticeBoardDao {
public String getUserName(String userId);
}
* Controller에 코드 추가(테스트로 HomeController.java에 추가)
@Autowired
private SqlSession sqlSession;
/**
* DB test
*/
@RequestMapping(value = "/dbtest/{userId}", method = RequestMethod.GET)
public String dbtest(@PathVariable("userId") String userId, Model model) {
NoticeBoardDao noticeBoardDao = sqlSession.getMapper(NoticeBoardDao.class)
model.addAttribute("userId", noticeBoardDao.getUserName(userId));
return "dbtest";
}
* /MyProject/src/main/webapp/WEB-INF/views/dbtest.jsp 를 생성.
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page session="false" contentType="text/html;charset=UTF-8" %>
<!DOCTYPE html>
<html>
<meta charset="UTF-8" />
<head>
<title>Home</title>
</head>
<body>
<h1>
Hello world!
</h1>
<P> UserName is ${userId}. </P>
</body>
</html>
* 브라우저에서 id=7 인 사용자 이름 조회 결과.
