db.properties

## oracle
## oracle
JDBC.driverClassName=oracle.jdbc.driver.OracleDriver
JDBC.url=jdbc:oracle:thin:@127.0.0.1:1521:XE
JDBC.username=system
JDBC.password=1234

1. db.properties 에서 db 연동 코드 기술

 

 

 

 

 

 

 

 

 

 

  <!-- Database, transaction 설정 파일 -->
    <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:/db.properties</value>
            </list>
        </property>
    </bean>
  <!-- 

2. dao-context.xml 에서 설정

 

 

 

 

 

 

dao-context.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:context="http://www.springframework.org/schema/context"
	xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd">
    

  <!-- Database, transaction 설정 파일 -->
    <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:/db.properties</value>
            </list>
        </property>
    </bean>
  <!-- 
  #####################################################
  # DataSource
  #####################################################
 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${JDBC.driverClassName}"/>
        <property name="url" value="${JDBC.url}"/>
        <property name="username" value="${JDBC.username}"/>
        <property name="password" value="${JDBC.password}"/>
        <property name="minIdle" value="50"/>
        <property name="maxIdle" value="50"/>
        <property name="maxActive" value="100"/> 
    </bean>
 
  <!-- 
  #####################################################
  # Spring JDBC setting
  #####################################################
 --> 
    <bean id="JdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
  <!-- 
  #####################################################
  # myBatis setting
  #####################################################
 --> 
 	<bean id="factoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
 		<property name="dataSource" ref="dataSource"/>
        <property name="configLocation"   value="classpath:config/mybatis/SqlMapConfig.xml"/>
    </bean>
    
    <!-- 아래태그없으면  에러발생  -->
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg ref="factoryBean" />
	</bean>
	
</beans>