Spring 事务源码(一)：源码分析示例

1、新建数据库及表

　　商品库存表

CREATE TABLE `product_stock` ( 
    `goods_id` VARCHAR ( 30 ) NOT NULL, 
    `stock` INT ( 8 ) DEFAULT NULL, 
    PRIMARY KEY ( `goods_id` ) 
) ENGINE = INNODB DEFAULT CHARSET = utf8;

　　初始化数据

insert into `product_stock` values ('202212032152', 10000);
insert into `product_stock` values ('202212032153', 10000);
commit;

2、xml方式

1、ProductDao

package com.snails.transaction.xml.dao;

import org.springframework.jdbc.core.JdbcTemplate;

public class ProductDao {

   JdbcTemplate jdbcTemplate;

   public JdbcTemplate getJdbcTemplate() {
      return jdbcTemplate;
   }

   public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
      this.jdbcTemplate = jdbcTemplate;
   }

   /**
    * 更新库存
    * @param goodsId
    */
   public void updateStock(String goodsId) {
      String sql = "update product_stock set stock=stock-1 where goods_id=?";
      jdbcTemplate.update(sql,goodsId);
   }

}

2、ProductService

package com.snails.transaction.xml.service;

import com.snails.transaction.xml.dao.ProductDao;

public class ProductService {

   ProductDao productDao;

   public ProductDao getProductDao() {
      return productDao;
   }

   public void setProductDao(ProductDao productDao) {
      this.productDao = productDao;
   }

   /**
    * 某个用户购买指定商品
    * @param buyerName
    * @param goodsId
    */
   public void sellProduct(String buyerName, String goodsId) {
      // 更新库存
      productDao.updateStock(goodsId);
   }

}

3、配置文件

3.1、dbconfig.properties

jdbc.username=root
jdbc.password=root
jdbc.url=jdbc:mysql://localhost:3306/tx
jdbc.driverClassName=com.mysql.jdbc.Driver

3.2、tx.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.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
   <!--引入外部资源文件-->
   <context:property-placeholder location="classpath:dbconfig.properties"></context:property-placeholder>
   <!--Druid数据源-->
   <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
      <property name="username" value="${jdbc.username}"></property>
      <property name="password" value="${jdbc.password}"></property>
      <property name="url" value="${jdbc.url}"></property>
      <property name="driverClassName" value="${jdbc.driverClassName}"></property>
   </bean>
   <!--jdbc模板-->
   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
      <constructor-arg name="dataSource" ref="dataSource"></constructor-arg>
   </bean>
   <!--事务管理器-->
   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="dataSource"></property>
   </bean>
   <!--商品服务-->
   <bean id="productDao" class="com.snails.transaction.xml.dao.ProductDao">
      <property name="jdbcTemplate" ref="jdbcTemplate"></property>
   </bean>
   <bean id="productService" class="com.snails.transaction.xml.service.ProductService">
      <property name="productDao" ref="productDao"></property>
   </bean>
   <!--aop切点切面定义-->
   <aop:config>
      <aop:pointcut id="txPoint" expression="execution(* com.snails.transaction.xml.*.*.*(..))"/>
      <aop:advisor advice-ref="myAdvice" pointcut-ref="txPoint"></aop:advisor>
   </aop:config>
   <!--Advice-->
   <tx:advice id="myAdvice" transaction-manager="transactionManager">
      <tx:attributes>
         <tx:method name="sellProduct" propagation="REQUIRED" />
         <tx:method name="updateStock" propagation="REQUIRED" />
      </tx:attributes>
   </tx:advice>
</beans>

4、TxXmlTest - 测试代码

package com.snails.transaction;

import com.snails.transaction.xml.service.ProductService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.sql.SQLException;

public class TxXmlTest {
   public static void main(String[] args) throws SQLException {
      ApplicationContext context = new ClassPathXmlApplicationContext("tx.xml");
      ProductService productService = context.getBean("productService", ProductService.class);
      productService.sellProduct("黑风衣","202212032152");
   }
}

5、执行测试代码成功后，查看数据库库存

　　至此，xml方式的事务源码入口已完成，可以开始Spring事务源码学习之旅了。