spring和ibatis集成application-system.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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">


<!--1. 配置数据源 -->
    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName">
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</property>
<property name="url">
<value>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ibatis</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>huawei</value>
</property>
    </bean>

    <!--2. 配置sqlMapClient 相当于hibernate的sessionFactory -->
    <bean id="mySqlMapClient"
        class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation"
            value="com/huawei/test/ibatis/SqlMapConfig.xml"/>
        <property name="dataSource" ref="myDataSource"/>
    </bean>

    <!--3. 配置DAO -->
    <bean id="MessageDao" class="com.huawei.test.ibatis.dao.MessageDAO">
        <property name="dataSource" ref="myDataSource"/>
<property name="sqlMapClient" ref="mySqlMapClient"/>

</bean>

    <!--4. 配置服务类 -->
    <bean id="MessageServiceImpl"
class="com.huawei.test.ibatis.service.MessageImpl">
<property name="messageDao" ref="MessageDao" />
</bean>

    <!--5. 配置事务管理器TransactionManager -->
    <bean id="myTransactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="myDataSource"/>
    </bean>

    <!--6. 配置事务代理 -->
    <bean id="abstrac"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
        abstract="true">
        <property name="transactionManager" ref="myTransactionManager"/>
        <property name="transactionAttributes">
            <props>
                <!--把CustomBuyException减去.说明它即使不是runtimeException,也会rollback-->
                <!--把CustomBuyException加上.说明它即使是runtimeException,也不会rollback-->
                <prop key="*">-DataAccessException</prop>
            </props>
        </property>
    </bean>

    <!-- 继承abstrac 方便多个service来映射 -->
    <bean id="messageService" parent="abstrac">
        <property name="target" ref="MessageServiceImpl"/>
    </bean>

</beans>