spring与其它框架的集成(三) spring+ibatis

spring与其它框架的集成(三) spring+ibatis

spring 2008-12-18 19:27:41 阅读122 评论0 字号：大中小

这一章主要介绍一下spring和ibatis的集成
1. applicationCtx.xml中定义如下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans
default-autowire="byName"
default-lazy-init="false"
default-dependency-check="none"
>
<!-- spring hibernate start -->
<bean id="propertyConfigurer"
  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  <property name="locations">
   <list>
    <value>classpath:database.properties</value>
   </list>
  </property>
</bean>
<bean id="dataSource"
  class="org.apache.commons.dbcp.BasicDataSource"
  destroy-method="close">
  <property name="driverClassName"
   value="${hibernate.connection.driver_class}" />
  <property name="url" value="${hibernate.connection.url}" />
  <property name="username"
   value="${hibernate.connection.username}" />
  <property name="password"
   value="${hibernate.connection.password}" />
  <property name="maxActive" value="500" />
  <property name="maxIdle" value="50" />
  <property name="maxWait" value="5000" />
  <property name="defaultAutoCommit" value="true" />
  <property name="removeAbandoned" value="true" />
  <property name="removeAbandonedTimeout" value="60" />
  <property name="minEvictableIdleTimeMillis" value="-1" />
</bean>

<!--与配置hibernate不同的地方 start-->
     <!--根据dataSource和configLocation创建一个SqlMapClient-->
<bean id="sqlMapClient"
  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <property name="configLocation">
   <value>/WEB-INF/sqlMapConfig.xml</value>
  </property> 
</bean>
<!--根据dataSource和configLocation创建一个SqlMapClient-->
<bean id="transactionManager"
     class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
     abstract="false" lazy-init="default"
     autowire="default" dependency-check="default"> 
     <property name="dataSource"> 
         <ref bean="dataSource" /> 
     </property> 
</bean>
<!--与配置hibernate不同的地方 end-->

<!-- spring hibernate end -->
<bean id="txProxyTemplate" abstract="true"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager" ref="transactionManager"/>
        <property name="transactionAttributes">
            <props>
              <prop key="update*">PROPAGATION_REQUIRED</prop>
     <prop key="save*">PROPAGATION_REQUIRED</prop>
     <prop key="delete*">PROPAGATION_REQUIRED</prop>
     <prop key="remove*">PROPAGATION_REQUIRED</prop>
     <prop key="add*">PROPAGATION_REQUIRED</prop>
     <prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
            </props>
        </property>
    </bean>
</beans>

3. 在database.properties中配置：
hibernate.connection.username=postgres
hibernate.connection.password=postgres
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.dialect.ant=jp.co.softbrain.bpm2.tools.hbm2ddl.dialect.PostgreSQLDialect
hibernate.connection.url=jdbc\:postgresql\://localhost/HibernateTest?useUnicode\=true&characterEncoding\=utf-8
hibernate.connection.driver_class=org.postgresql.Driver
database.name=postgres
database.schema=public
database.type=postgresql
以供dataSource中调用，dataSource是配置数据源。
4. transactionManager集成hibernate。
5. txProxyTemplate配置spring事务

6. 配置service使用代理
<bean id="loginService" parent="txProxyTemplate">
  <property name="target">
            <bean class="servletTest.service.impl.LoginServiceImpl" autowire="byName"/>
        </property>
</bean>
这样loginService就有事务了
如果不要事务：
<bean id="loginService" class="servletTest.service.impl.LoginServiceImpl" autowire="byName"/>

7. 配置dao
<bean id="loginDao" class="servletTest.dao.impl.LoginDaoImpl" autowire="byName" />

8. sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE sqlMapConfig
  PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
  "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
     <settings
        lazyLoadingEnabled="true"
         useStatementNamespaces="true" />
   <sqlMap resource="/ibatis/home/User.ibatis.xml"/>
</sqlMapConfig>

9. User.ibatis.xml
<?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
  "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
  <typeAlias alias="User" type="servletTest.model.User"/>
  <resultMap id="User"
   class="servletTest.model.User">
   <result property="userId" column="user_id" />
   <result property="name" column="name" />
   <result property="sex" column="sex" />
   <result property="age" column="age" />
  </resultMap>
  <select id="selectAllUsers" resultClass="User">
     select * from usera
  </select>
  <select id="selectUser" resultClass="User" parameterClass="string">
   select * from usera where user_id=#id#
  </select>
  <delete id="deleteUser" parameterClass="string">
   delete from usera where user_id=#id#
  </delete>
  <insert id="saveUser" parameterClass="User">
   insert into usera(user_id,name,sex,age) values(#userId#,#name#,#sex#,#age#)
  </insert>
</sqlMap>
ok, 到这里就完成了spring与ibatis的整合了。不难发现ibatis与hibernate在与spring集成时。只是在 applicationCtx.xml中 区别定 义了自己的bean以及加载的配置文件。其它部分不需要任何改动，如 service，dao，controller等的配置。这很好的说明了 spring可其它框架集成的可插拔性。