10. root-context.xml에 mybatis 연동하기 위한 설정 정보 등록

• root-context.xml

1. jdbc.properties 등록
2. DBCP 등록
3. TransactionManager 등록
4. SqlSessionFactoryBean 등록
   - XXXMapper.xml 별칭주기
   - DTO에 별칭주기
5. SqlSessionTemplate 등록

 

<!-- jdbc.properties 등록 -->
<context:property-placeholder location="classpath:com/config/jdbc.properties"/>

<!-- DB연결정보 설정하기 - DataSource 등록 -->	
<bean id="xxx" class="org.apache.commons.dbcp2.BasicDataSource">
	<property name="driverClassName" value="${jdbc.driver}" />
	<property name="url" value="${jdbc.url}" />
	<property name="username" value="${jdbc.username}" />
	<property name="password" value="${jdbc.password}" />
</bean>

<!-- transaction -->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
   <!-- (this dependency is defined somewhere else) -->
   <property name="dataSource" ref="xxx"/>
</bean>
<tx:annotation-driven transaction-manager="txManager"/>

<!-- Sqlsessionfactory등록 ( mybatis SqlSessionFactoryBean ) -->
	<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       <property name="dataSource" ref="xxx" />
       <property name="mapperLocations">
         <list>
          <value>classpath:com/config/CartMapper.xml</value>
          <value>classpath:com/config/GoodsMapper.xml</value>
          <value>classpath:com/config/MemberMapper.xml</value>
          <value>classpath:com/config/OrderMapper.xml</value>
         </list>
       </property>
       <property name="typeAliases">
         <list>
           <value>com.dto.CartDTO</value>
           <value>com.dto.GoodsDTO</value>
           <value>com.dto.MemberDTO</value>
           <value>com.dto.OrderDTO</value>
         </list>
       </property>
    </bean>

<!-- SqlSessionTemplate 등록 -->
<bean id="session" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg name="sqlSessionFactory" ref="sessionFactory" />
</bean>

 

---