applicationContext.xml

• DB + MyBatis + 트랜잭션 관리

✔ 구성

1) DB 연결 (DataSource)

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
   <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
   <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe" />
   <property name="username" value="scott" />
   <property name="password" value="1234" />
</bean>

• Oracle DB 연결 설정

2) 트랜잭션 관리

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
   <property name="dataSource" ref="dataSource" />
</bean>

• DB 작업의 commit/rollback 관리

3) MyBatis 설정

SqlSessionFactory

<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
   <property name="dataSource" ref="dataSource" />
   <property name="configLocation" value="classpath:/mybatis-config.xml" />
</bean>

• MyBatis 설정 파일 로딩

SqlSessionTemplate

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean">
	</constructor-arg>
</bean>

• 실제 DAO에서 DB 접근할 때 사용

전체 xml 코드