Ibatis+Spirng配置

1.properties //dblink實際參數

 
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 <property name="location" value="classpath:專案目錄/spring.properties" />
</bean>

2.dblink 配合properties

<bean id="testDataSource" class="org.apache.commons.dbcp.BasicDataSource">
 <property name="driverClassName" value="${test_driverClassName}" />
 <property name="url" value="${test_url}" />
 <property name="username" value="${test_username}" />
 <property name="password" value="${test_password}" />
 <property name="testWhileIdle" value="true"/>
 <property name="validationQuery" value="select 1 from dual"/>
 <property name="logAbandoned" value="true"/>
 <property name="removeAbandoned" value="true"/>
 <property name="removeAbandonedTimeout" value="3600"/>
 <property name="maxWait" value="20"/>
 <property name="maxIdle" value="10"/>
 <property name="maxActive" value="-1"/>
 <property name="accessToUnderlyingConnectionAllowed" value="true"/>
 <bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor" 
  lazy-init="true" />
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true"> 
 <property name="nativeJdbcExtractor"> 
     <ref local="nativeJdbcExtractor" /> 
 </property>
</bean>  
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
      <property name="dataSource" ref="testDataSource"/>
</bean>

3.讀取sqlmapconfig

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
   <property name="dataSource" ref="dataSource"/>
   <property name="configLocation">
       <value>classpath:專案目錄/SqlMapConfig.xml</value>
   </property>
   <property name="transactionConfigProperties">
       <props>
           <prop key="DefaultAutoCommit">false</prop>
       </props>
   </property>
        <property name="lobHandler">
      <ref local="oracleLobHandler" />
  </property>
  </bean> 

4.java 讀取dao

  
 <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
   <property name="sqlMapClient" ref="sqlMapClient" />
   <property name="exceptionTranslator">
       <bean class="org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator">
           <property name="dataSource" ref="dataSource" />
       </bean>
   </property>
</bean>
 <bean id="ibatisDAOProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
   <property name="transactionManager">
       <ref bean="transactionManager"/>
   </property>
   <property name="target">
       <ref bean="baseIbatisDao"/>
   </property>
   <property name="transactionAttributes">
       <props>             
           <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
       </props>
   </property>    
 </bean>