Spring——事务操作(完全注解模式)

Spring基于注解的事务操作:

创建配置类
BookConfig.java

package com.example.demo1;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration//配置类
@ComponentScan(basePackages = "com.example.demo1")//组件扫描
@EnableTransactionManagement//事务管理
public class BookConfig {
    @Bean(value = "druidDataSource")
    public DruidDataSource getDruidDataSource(){
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        druidDataSource.setUrl("jdbc:mysql://localhost:3306/springdemo?serverTimezone=Asia/Shanghai");
        druidDataSource.setUsername("root");
        druidDataSource.setPassword("123456");
        return druidDataSource;
    }
    @Bean(value = "jdbcTemplate")
    public JdbcTemplate getJdbcTemplate(DruidDataSource druidDataSource){
        JdbcTemplate jdbcTemplate = new JdbcTemplate();
        jdbcTemplate.setDataSource(druidDataSource);
        return jdbcTemplate;

    }
    @Bean(value = "dataSourceTransactionManager")
    public DataSourceTransactionManager getDaSourceTransactionManager(DruidDataSource druidDataSource){
        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();
        dataSourceTransactionManager.setDataSource(druidDataSource);
        return dataSourceTransactionManager;
    }
}

BookDao.java

package com.example.demo1.dao;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

@Repository(value = "bookDao")//创建bean
public class BookDao {
    @Autowired//属性注入,自动装配
    private JdbcTemplate jdbcTemplate;
    public void add(String b){
        String sql = "update person set money = money + 100 where name = ?";
        int update = jdbcTemplate.update(sql, b);
        System.out.println(update+"add");

    }
    public void minus(String a){
        String sql = "update person set money = money - 100 where name = ?";
        int update = jdbcTemplate.update(sql, a);
        System.out.println(update+"minus");
    }
}

BookService.java

package com.example.demo1.service;

import com.example.demo1.dao.BookDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service(value = "bookService")
@Transactional//开启事务
public class BookService {
    @Autowired
    private BookDao bookDao;
    public void money(String a,String b){
        bookDao.minus(a);
        int c = 1/0;//模拟错误
        bookDao.add(b);
        System.out.println("转账完成");
    }
}

测试:
Test.java

    @org.junit.Test
    public void money(){
        ApplicationContext applicationContext = new AnnotationConfigApplicationContext(BookConfig.class);
        applicationContext.getBean("bookService", com.example.demo1.service.BookService.class).money("张三","李四");
    }

在这里插入图片描述
在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值