spring与mybatis整合声明式事务开发步骤

1.在pml.xml文件中引入依赖的坐标

        <!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/log4j/log4j -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>5.3.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>5.3.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-expression -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-expression</artifactId>
            <version>5.3.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/aopalliance/aopalliance -->
        <dependency>
            <groupId>aopalliance</groupId>
            <artifactId>aopalliance</artifactId>
            <version>1.0</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.6.9</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.springframework/spring-aop -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.3.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.3</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.3.3</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/commons-pool/commons-pool -->
        <dependency>
            <groupId>commons-pool</groupId>
            <artifactId>commons-pool</artifactId>
            <version>1.6</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

2.创建并配置mybatis的核心配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--    配置mybatis的log打印日志实现为LOG4J 写法固定-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>
    <!--类型别名 -->
    <typeAliases>
        <package name="com.ck.pojo" />
    </typeAliases>
</configuration>

 3.创建spring的配置文件

        1.文件中导入相关的命名空间

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.2.xsd">

        2.开启组件扫描和AOP的自动代理

    <context:component-scan base-package="com.ck.service,com.ck.aop"/>
    <aop:aspectj-autoproxy/>

        3.配置数据库相关参数properties的属性：${ }

    <!-- 1、配置数据库相关参数properties的属性：${url} -->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!--配置数据源（配置连接数据库的相关信息）-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

        4.配置SqlSessionFactory的Bean,让容器中其他的类可以获取SqlSession

    <!-- 配置SqlSessionFactoryBean,让容器中其他的类可以获取SqlSession -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 引用数据源组件 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 引用MyBatis配置文件中的配置 -->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--指定mapper映射文件位置-->
        <property name="mapperLocations">
            <list>
                <value>classpath:mapper/*.xml</value>
            </list>
        </property>
    </bean>

        5.配置Dao（mapper）层

    <!-- 配置DAO层 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--MapperScannerConfigurer扫描这个包以及子包中所有的接口，
        如果这些接口在SQL映射文件中定义过，就会自动的生成接口的实现类-->
        <property name="basePackage" value="com.ck.mapper"/>
    </bean>

4.接下来就编写mapper层和service层的逻辑代码这里不演示（其中mapper层和service层的注入使用的注解方式）

@Service("userServise") //注解标注service层的bean
public class SmbmsUserServiceImpl implements SmbmsUserService {
    @Autowired //自动注入mapper层的bean
    private SmbmsUserMapper sum;

    @Override
    public int modifyUserById(SmbmsUser smbmsUser) {
        return sum.updateUser(smbmsUser);
    }
}

5.在spring的配置文件中配置声明式的事务

        1.定义事务管理器bean

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--注入配置好的数据源-->
        <property name="dataSource" ref="dataSource"/>
    </bean>

        2.配置事务规则（针对不同的方法使用什么样的事务规则）

<tx:advice id="txAdvice">
        <tx:attributes>
            <!--propagation事务的传播机制-->
            <!--SUPPORTS如果当前方法存在一个事务，则使用当前事务，否则就使用非事务 适用于查询方法-->
            <tx:method name="find*" propagation="SUPPORTS"/>
            <!--REQUIRED开启或使用当前事务，适用于增删改方法-->
            <tx:method name="add*" propagation="REQUIRED"/>
            <tx:method name="del*" propagation="REQUIRED"/>
            <tx:method name="update*" propagation="REQUIRED"/>
            <!--NEVER表示不开启事务，讲有关set方法不开启事务-->
            <tx:method name="set*" propagation="NEVER"/>
            <!--使用*设置除以上已经选中的方法外使用REQUIRED作为首选的传播机制-->
            <tx:method name="*" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>

        3.配置切面，将上方制定好的事务规则，织入到具体的方法中

    <aop:config>
        <!--定义切入点-->
        <aop:pointcut id="serviceMethod" expression="execution(* com.ck.service..*.*(..))"/>
        <!--织入-->
        <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethod"/>
    </aop:config>

---

-------也可以使用注解的方式配置声明式事务--------

-------------通过注解的方式就不需要在spring的配置文件中配置事务规则，也就是上方的第5节中的2和3小点

1.必须要开启使用注解的方式配置声明式事务

    <!--transaction-manager引入上方配置好的事务管理器bean的id-->
    <tx:annotation-driven transaction-manager="transactionManager"/>

2.在需要增强声明式事务的类名上添加注解@Transactional

@Transactional
@Service("smbmsProviderService")
public class SmbmsProviderServiceImpl implements SmbmsProviderService {}

3.在具体的方法上添加事务支持注解@Transactional(propagation = Propagation.REQUIRED)

    /**
     * 查询方法
     */
    @Override
    @Transactional(propagation = Propagation.SUPPORTS)
    public List<SmbmsProvider> findProviderAndBillByCond(SmbmsBill smbmsBill) {
        return spm.getProviderAndBillByCond(smbmsBill);
    }

    /**
     * 修改方法
     */
    @Override
    @Transactional(propagation = Propagation.REQUIRED)
    public int updateProvider(SmbmsProvider smbmsProvider) {
        int i = spm.updateProvider(smbmsProvider);
        return i;
    }