spring4 jdbc template xml 기반

spring4 jdbc template

pom.xml

<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 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.tistory.tazz009</groupId> <artifactId>spring4_chap13_mybatis</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>spring4_chap13_mybatis</name> <url>http://maven.apache.org</url> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <spring.version>4.0.4.RELEASE</spring.version> </properties> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.4</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.3</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.2.1</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0.4</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>4.0.4.RELEASE</version> <exclusions> <exclusion> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.12</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>jcl-over-slf4j</artifactId> <version>1.7.12</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.7.12</version> </dependency> <dependency> <groupId>net.sf</groupId> <artifactId>log4jdbc3</artifactId> <version>1.1</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>org.lazyluke</groupId> <artifactId>log4jdbc-remix</artifactId> <version>0.2.7</version> </dependency> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> <version>3.4</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-collections4</artifactId> <version>4.1</version> </dependency> </dependencies> <repositories> <repository> <id>egovframe</id> <url>http://www.egovframe.go.kr/maven/</url> <releases> <enabled>true</enabled> </releases> <snapshots> <enabled>false</enabled> </snapshots> </repository> </repositories> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-assembly-plugin</artifactId> <version>2.2.1</version> <configuration> <descriptorRefs> <descriptorRef>jar-with-dependencies</descriptorRef> </descriptorRefs> </configuration> </plugin> <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.7</source> <target>1.7</target> <encoding>utf-8</encoding> </configuration> </plugin> </plugins> </build> </project>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:tx="http://www.springframework.org/schema/tx" 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-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd"> <tx:annotation-driven /> <mybatis:scan base-package="com.tistory.tazz009.spring4.dao" /> <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" /> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="net.sf.log4jdbc.DriverSpy" /> <property name="url" value="jdbc:oracle:thin:@192.168.1.XXX:1521:BASIC" /> <property name="username" value="scott" /> <property name="password" value="tiger" /> <property name="defaultAutoCommit" value="true"/> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:/mybatis-conf.xml" /> <property name="mapperLocations"> <list> <value>classpath:/mybatis/*.xml</value> </list> </property> </bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="clearCache"> <constructor-arg ref="sqlSessionFactory" /> </bean> </beans>

main class

MainForScanXml.java

package com.tistory.tazz009.spring4; import java.sql.SQLException; import org.springframework.context.support.GenericXmlApplicationContext; import com.tistory.tazz009.spring4.dao.TestDao; public class MainForScanXml { public static void main(String[] args) throws SQLException { GenericXmlApplicationContext ctx = new GenericXmlApplicationContext("classpath:/applicationContext.xml"); TestDao dao = ctx.getBean(TestDao.class); String test = dao.test(); System.out.println(test); ctx.close(); } }

dao

TestDao.java

package com.tistory.tazz009.spring4.dao; import java.util.Map; import org.springframework.stereotype.Repository; @Repository public interface TestDao { public String test(); public void insertData(Map<String, String> param); public void insertData2(Map<String, String> param); public void updateAcpnDt(Map<String, String> param); public void updateFixDt(Map<String, String> param); }

mapper 

testdao.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.spring4.dao.TestDao"> <resultMap id="detailData" type="java.util.HashMap"> <result property="CTT" column="CTT" javaType="java.lang.String" jdbcType="CLOB" /> <result property="USER_NM" column="USER_NM" javaType="java.lang.String" jdbcType="VARCHAR" /> <result property="USE_YN" column="USE_YN" javaType="java.lang.String" jdbcType="VARCHAR" /> </resultMap> <select id="test" resultType="String"> SELECT SYSDATE FROM DUAL </select> </mapper>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Mon Feb 03 17:37:44 KST 2014 --> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <setting name="cacheEnabled" value="false" /> <!-- 캐시 사용 설정. default: true --> <setting name="lazyLoadingEnabled" value="false" /> <!-- lazy loading 설정. default: true --> <setting name="multipleResultSetsEnabled" value="false" /> <!-- 하나의 statement에서 다수 ResultSet 허락여부. default: true --> <setting name="defaultExecutorType" value="SIMPLE" /> <!-- 기본 executor지정. default: SIMPLE, 이 설정으로 batch 처리가 가능하다. --> <setting name="jdbcTypeForNull" value="VARCHAR"/> <!-- null 값에 대한 JDBC 타입을 지정 --> <setting name="callSettersOnNulls" value="true"/> <!-- Map사용할 때 리턴값이 null이어도 컬럼 누락되지 않도록. default: false --> </settings> <typeAliases> <typeAlias alias="HMap" type="java.util.HashMap" /> </typeAliases> <typeHandlers> <typeHandler handler="org.apache.ibatis.type.ClobTypeHandler" jdbcType="CLOB" javaType="java.lang.String"/> </typeHandlers> </configuration>

출처 spring4 최범균 - 좋은 책은 사서 보세요. 두번 보세요.