使用MyBatisPlus+Spring实现声明式事务(实现转账功能)

墨蓝 2023-10-11 19:59 6阅读 0赞

**在往期的银行管理系统中,我们是用JDBC实现功能的实现,同时包括转账功能,也是运用事务**![f8d2e8efb415499790ae609689f43fd1.png][]

**通过上述图片可以看到事务需要这么冗长的代码量,而且容易码写错误,现在我们可以通过MyBatisPlus+Spring注解实现事务**

## 导入库 ##

![63051d2cffe14a8da367181485780ced.png][]

![9a3f05cea4f348f4961d77b000f8304b.png][]

## 功能实现 ##

--------------------

### 结构图 ###

![d4c4fe2bc0e54c6fbc66f85a7f7e903a.png][]

### 导入porm依赖 ###

这里我们导入的依赖是**mybatis-plus**,**mysql,lombok**

<dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.4.3.1</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>

### application.yml文件 ###

![db3d75b14bba4579962bf2b090fa4d68.png][]

server:
      port: 8070
    spring:
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/jdbctest?useSSL=false&useUnicode=true&characterEncoding=utf-8
        username: root
        password: 123456

### 测试类 ###

![b5552212c4c34db19d8138329a92a24e.png][]

package demo;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan("demo.mapper")
    public class Demo {
        public static void main(String[] args) {
            SpringApplication.run(Demo.class,args);
        }
    }

### 实体类 ###

![10874cf201df4e33a45878b375c41f1f.png][]

package demo.entity;
    
    import com.baomidou.mybatisplus.annotation.TableId;
    import com.baomidou.mybatisplus.annotation.TableName;
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    @TableName("acount")
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class Account {
        @TableId
        private Long id;
        private String name;
        private Float money;
    }

### mapper层 ###

### ![bbc47b33913e4312beabe3fc9b3bdf5b.png][] ###

package demo.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import demo.entity.Account;
    
    public interface AccountMapper extends BaseMapper<Account> {
    }

### service层 ###

#### 接口 ####

![10db31262e2045be8c87832940d74535.png][]

#### 实现类 ####

![0c45e6a0e1b543c0adf57984a962f715.png][]

package demo.service.impl;
    
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import demo.entity.Account;
    import demo.mapper.AccountMapper;
    import demo.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    @Service
    public class AccountServiceImpl implements AccountService {
        @Autowired(required = false)
        private AccountMapper accountMapper;
    
        //开启事务
        @Transactional
        @Override
        public boolean transfer(String source, String target, float money) {
            //第1步:获取汇款方
            //创建条件构造器
            QueryWrapper<Account> queryWrapper1 = new QueryWrapper<>();
            queryWrapper1.eq("name", source);
            Account accountSource = accountMapper.selectOne(queryWrapper1);
            //执行查询
            //第2步:获取收款方
            //创建条件构造器
            QueryWrapper<Account> queryWrapper2 = new QueryWrapper<>();
            queryWrapper2.eq("name", target);
            Account accountTarget = accountMapper.selectOne(queryWrapper2);
            //执行查询
            //第3步:修改汇款方金额
            accountSource.setMoney(accountSource.getMoney() - 200);
            //调用mybatis-plus的修改的方法
            int sourceResult = accountMapper.updateById(accountSource);
            //第4步:修改收款方金额
            accountTarget.setMoney(accountTarget.getMoney() + 200);
            //调用mybatis-plus的修改的方法
            int targetResult = accountMapper.updateById(accountTarget);
            if (sourceResult > 0 && targetResult > 0) {
                return true;
            } else {
                return false;
            }
    
    
        }
    }

### controller层 ###

![398d45b2c87749519d7568e546addc94.png][]

package demo.controller;
    
    import demo.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class TestControll {
        @Autowired
        private AccountService accountService;
    
        @RequestMapping("/test")
        public String test(){
            boolean isOK = accountService.transfer("A", "B", 200);
            if (isOK){
                return "转账成功";
            }else{
                return "转账失败";
            }
        }
    }

[f8d2e8efb415499790ae609689f43fd1.png]: https://img-blog.csdnimg.cn/f8d2e8efb415499790ae609689f43fd1.png
[63051d2cffe14a8da367181485780ced.png]: https://img-blog.csdnimg.cn/63051d2cffe14a8da367181485780ced.png
[9a3f05cea4f348f4961d77b000f8304b.png]: https://img-blog.csdnimg.cn/9a3f05cea4f348f4961d77b000f8304b.png
[d4c4fe2bc0e54c6fbc66f85a7f7e903a.png]: https://img-blog.csdnimg.cn/d4c4fe2bc0e54c6fbc66f85a7f7e903a.png
[db3d75b14bba4579962bf2b090fa4d68.png]: https://img-blog.csdnimg.cn/db3d75b14bba4579962bf2b090fa4d68.png
[b5552212c4c34db19d8138329a92a24e.png]: https://img-blog.csdnimg.cn/b5552212c4c34db19d8138329a92a24e.png
[10874cf201df4e33a45878b375c41f1f.png]: https://img-blog.csdnimg.cn/10874cf201df4e33a45878b375c41f1f.png
[bbc47b33913e4312beabe3fc9b3bdf5b.png]: https://img-blog.csdnimg.cn/bbc47b33913e4312beabe3fc9b3bdf5b.png
[10db31262e2045be8c87832940d74535.png]: https://img-blog.csdnimg.cn/10db31262e2045be8c87832940d74535.png
[0c45e6a0e1b543c0adf57984a962f715.png]: https://img-blog.csdnimg.cn/0c45e6a0e1b543c0adf57984a962f715.png
[398d45b2c87749519d7568e546addc94.png]: https://img-blog.csdnimg.cn/398d45b2c87749519d7568e546addc94.png