springboot 单元测试事务回滚

「爱情、让人受尽委屈。」 2022-09-14 14:26 188阅读 0赞

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

## springboot 单元测试事务回滚 ##

**应用：单元测试时，对数据库数据操作后可回滚**

## \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ##

**示例**

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**配置文件**

**application.yml**

spring:
      datasource:
        druid:
          url: jdbc:mysql://localhost:3306/h3?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
          driver-class-name: com.mysql.cj.jdbc.Driver
          username: root
          password: 123456
    
    mybatis-plus:
      mapper-locations: classpath:/mappers/*.xml
      type-aliases-package: com.example.demo.pojo

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**pojo 层**

**Person**

@Getter
    @Setter
    @ApiModel(value = "Person对象", description = "")
    public class Person extends Model<Person> {
    
        private static final long serialVersionUID = 1L;
    
        @TableId(value = "id", type = IdType.AUTO)
        private Integer id;
    
        private String name;
    
        private Integer age;
    
    
        @Override
        public Serializable pkVal() {
            return this.id;
        }
    
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**dao 层**

**PersonMapper**

public interface PersonMapper extends BaseMapper<Person> {
    
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**service 层**

**PersonService**

public interface PersonService extends IService<Person> {
    
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**service.impl 层**

**PersonServiceImpl**

@Service
    public class PersonServiceImpl extends ServiceImpl<PersonMapper, Person> implements PersonService {
    
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**controller 层**

**PersonController**

@RestController
    @RequestMapping("/person")
    public class PersonController {
    
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**单元测试类**

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_9_color_FFFFFF_t_70_g_se_x_16][]

**PersonServiceImplTest**

@SpringBootTest
    class PersonServiceImplTest {
    
        @Resource
        private PersonService personService;
    
        @Test
        public void test(){
            Person person=new Person();
            person.setId(1);
            person.setName("瓜田李下");
            person.setAge(20);
    
            personService.save(person);
        }
    
        @Test
        @Transactional
        public void test2(){
            Person person=new Person();
            person.setId(2);
            person.setName("海贼王");
            person.setAge(20);
    
            personService.save(person);
        }
    
        @Test
        @Transactional
        @Rollback(value = false)
        public void test3(){
            Person person=new Person();
            person.setId(3);
            person.setName("海贼王");
            person.setAge(20);
    
            personService.save(person);
        }
    }

## \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ##

**使用测试**

**test**

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 1][]

**测试通过，并且测试数据插入到数据库中 **

**test2**

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 2][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 3][]

**测试通过，测试数据没有插入到数据库中 **

**test3**

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 4][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 5][]

**测试通过，测试数据插入到数据库中 **

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_9_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/b5b6725479114e0196ea75c47058d029.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/f1ebe692fafb4041a4820b7161da5bc3.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/4df308b721874ac78975a76b136e7ee9.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 2]: /images/20220828/23f0159443c14389ac6c33ce5e2d15c0.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 3]: /images/20220828/a59e6e1405864c49b6015b00558fe0e2.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 4]: /images/20220828/b57d69497dec45758e5f72384fd48e30.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAb1_nk5znlLDmnY7kuItfbw_size_15_color_FFFFFF_t_70_g_se_x_16 5]: /images/20220828/f9537ff211b745d2886c3f65f569a523.png