이제는 mybatis로 ...

1. pom.xml

<!-- mybatis --> <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> <exclusions> <exclusion> <artifactId>spring-core</artifactId> <groupId>org.springframework</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.22</version> </dependency>

2. context-datasource.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.2.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"><value>jdbc:mysql://192.168.1.44:3306/javatest</value></property> <property name="username"><value>javauser</value></property> <property name="password"><value>javadude</value></property> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="configLocation"><value>classpath:spring/mybatis-config.xml</value></property> <property name="dataSource" ref="dataSource" /> <property name="mapperLocations" ref="mapperLocations"/> <property name="databaseIdProvider"> <bean class="org.apache.ibatis.mapping.VendorDatabaseIdProvider"/> </property> </bean> </beans>

3. context-sqlmapper.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" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd"> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage"><value>com.tistory.tazz009.**.mapper</value></property> <property name="sqlSessionFactory"><ref bean="sqlSessionFactory"/></property> </bean> <util:list id="mapperLocations"> <value>classpath*:sqlmapper/**/*-mapper.xml</value> </util:list> </beans>

4. test-mapper.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.tistory.tazz009.jfile.mapper.TestMapper"> <select id="selectNow" parameterType="java.util.Map" resultType="java.util.Map"> SELECT NOW() NOW FROM DUAL </select> </mapper>

5. TestMapper.java

맨날 만들던 DAO 클래스 대신 INTERFACE로 ...!!!

괜찮다~~~

거기다 간단한 것은 어노테이션으로...

package com.tistory.tazz009.jfile.mapper; import java.util.Map; import org.apache.ibatis.annotations.Select; public interface TestMapper { public Map<String, Object> selectNow(Map<String, Object> params); @Select("SELECT NOW() NOW FROM DUAL") public Map<String, Object> selectNow2(Map<String, Object> params); }

6. TestMapperTest

package com.tistory.tazz009.jfile.mapper; import static org.junit.Assert.*; import java.util.HashMap; import java.util.Map; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations={ "classpath:spring/context-datasource.xml", "classpath:spring/context-sqlmapper.xml" }) public class TestMapperTest { @Autowired private TestMapper mapper; @Test public void test() { Map<String, Object> selectNow = mapper.selectNow(new HashMap<String, Object>()); System.out.println(selectNow.get("NOW")); Map<String, Object> selectNow2= mapper.selectNow2(new HashMap<String, Object>()); System.out.println(selectNow2.get("NOW")); } }

자세한 mybatis 세팅은 http://mybatis.github.io/spring/ko/index.html ...