第1集 Spring 常⻅的事务管理-⾯test site

简介：讲解Spring常⻅的事务管理 

• 事务：多个操作,要么同时成功,or after failure⼀rollback 
  • 具备ACID四种特性
    • Atomic（原⼦性）

      Consistency（⼀致性）

      Isolation（隔离性）

      Durability（持久性）
• You know that often⻅的Spring事务管理⽅式吗 
• 编程式事务管理:

* 代码中调⽤beginTransaction()、commit()、rollback()related to business management⽅法,通过

TransactionTempalte⼿Dynamic management(⽤的少)

声明式事务管理:

* 通过AOP实现,可配置⽂件⽅formula or annotation⽅management control of transactions(⽤的多)

• Do you know the essence of declarative transaction management?： 

• 事务隔离级别: means if⼲The degree of isolation between concurrent transactions 
  • @Transactional(isolation = Isolation.READ_UNCOMMITTED) 读取未提交数据(会出现脏读, 不可重复读) basically do not use⽤
  • @Transactional(isolation = Isolation.READ_COMMITTED) 读取已提交数据(会出现不可重复读和幻读)

    @Transactional(isolation = Isolation.REPEATABLE_READ) 可重复读(会出现幻读)

    @Transactional(isolation = Isolation.SERIALIZABLE) 串⾏化

MYSQL: 默认为REPEATABLE_READ级别 

第3集 新版SpringBoot-Spring-MybatsiTransaction Control Explained 

简介：新版SSM @Transactional Transaction Control Explained 

快速创建SpringBoot+Spring+Mybatsi项⽬ 

        https://start.spring.io/

#配置数据源
spring.datasource.driver-class-name =com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mybatis?
useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
#使⽤阿⾥巴巴druid数据源,默认使⽤⾃带的
#spring.datasource.type =com.alibaba.druid.pool.DruidDataSource
#开启控制台打印sql
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

Maven插件
 

<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<!--引入JDBC-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.19</version>
		</dependency>

		<!--导入mybatis依赖包-->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.5.4</version>
		</dependency>

	</dependencies>

 控制层：

@RestController
@RequestMapping("api/v1/pri/videoOrder")
public class VideoOrderController {
    @Autowired
    private VideoOrderService videoOrderService;
    //下单操作
    @RequestMapping("save")
    public JsonData Save(){
        VideoOrder videoOrder = new VideoOrder();
        videoOrder.setUserId(6);
        videoOrder.setVideoId(6);

        videoOrder.setVideoTitle("Mavericks looking for work");
        int save = videoOrderService.save(videoOrder);
       JsonData jsonData=  save == 1 ? JsonData.JsonDataBuild("插入成功") : JsonData.JsonDataError("",-100,"插入失败");
        return jsonData;
    }
}

服务层：Insert transaction in business

public interface VideoOrderService {


    int save(VideoOrder videoOrder);
}

@Service
@Transactional(propagation= Propagation.REQUIRED) //开启事务
public class VideoOrderServiceImpl implements VideoOrderService {
    @Autowired
    private VideoOrderMapper videoOrderMapper;
    @Override

    public int save(VideoOrder videoOrder) {
//        int i = 1/ 0;
        return videoOrderMapper.save(videoOrder);

    }
}

Mapper：

@Repository

public interface VideoOrderMapper {
    /**
     * 关联查询
     */
    List<VideoOrder> findVideoOrderList();
    //下单操作
    @Insert("insert into video_order(video_id,user_id,video_title) values(#{VideoId},#{userId},#{videoTitle})")
    int save(VideoOrder videoOrder);


}

启动类：

@SpringBootApplication
@MapperScan("com.example.ssmdemo.Mapper")
@EnableTransactionManagement //开启事务注解
public class SsmdemoApplication {

	public static void main(String[] args) {
		SpringApplication.run(SsmdemoApplication.class, args);
	}

}

运行结果：

 第4集 新版SpringBoot-Spring-MybatsiCourse summary and follow-up content preview

Comprehensive item⽬Practical planning