mybatis 세팅

Query.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">

 

 

========================================================

 

 

SqlMapConfig.xml

 

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

 

 

=========================================================

 

 

db.properties  (file)

 

driver=oracle.jdbc.driver.OracleDriver

url=jdbc:oracle:thin:@localhost:1521:XE

username=계정id

password=계정비밀번호

 

 

==============================================

 

 

application-config

 예전엔 만들어 주었으나 4버젼은 자동파일생성된다..설정만 하면됨

 

<bean class="">
    <property name="">
        <value></value>
    </property>
  </bean>
  
  
  <!--oracle  -->
  <bean id="dataSource"  class="">
    <property name="" value=""></property>
    <property name="" value=""></property>
    <property name="" value=""></property>
    <property name="" value=""></property>
  </bean>
  
  
  <bean id="sqlSessionFactory" class="">
   <property name="" ref=""></property>
   <property name="" value="classPath:"></property>
  </bean>
  
  <bean id="sqlSessionTemplate" class="">
   <constructor-arg ref=""></constructor-arg>
  </bean>
  
 <!--dao  -->
 
 <bean id="" class="">
 <property name="" ref=""></property>
 </bean>

 

 

==============================================================

 

실제적용

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="locations">
        <value>WEB-INF/db.properties</value>
    </property>
  </bean>
  
  
  <!--oracle  -->
  <bean id="dataSource"  class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
    <property name="driverClass" value="${driver}"></property>
    <property name="url" value="${url}"></property>
    <property name="username" value="${username}"></property>
    <property name="password" value="${password}"></property>
  </bean>
  
  
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
   <property name="dataSource" ref="dataSource"></property>
   <property name="configLocation" value="classPath:mybatis/setting/SqlMapConfig.xml"></property>
  </bean>
  
  <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
   <constructor-arg ref="sqlSessionFactory"></constructor-arg>
  </bean>
  
 <!--dao  -->
 
 <bean id="pdao" class="spring.model.PersonDAO">
 <property name="sqlSessionTemplate" ref="sqlSessionTemplate"></property>
 </bean>
    <!-- Uncomment and add your base-package here:
         <context:component-scan
            base-package="org.springframework.samples.service"/>  -->