springboot+mybatis+h2单元测试

我就是我 2022-12-07 13:58 294阅读 0赞

首先看一下项目的整体结构  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjMyODM3NQ_size_16_color_FFFFFF_t_70_pic_center]

1.导入依赖

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.chujianyun</groupId>
        <artifactId>h2-unit-test-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties/>
    
        <parent>
            <artifactId>spring-boot-parent</artifactId>
            <groupId>org.springframework.boot</groupId>
            <version>2.1.1.RELEASE</version>
        </parent>
        <dependencies>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
                <version>2.1.1.RELEASE</version>
            </dependency>
    
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <version>2.1.1.RELEASE</version>
                <scope>test</scope>
            </dependency>
    
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.0</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.h2database</groupId>
                <artifactId>h2</artifactId>
                <version>RELEASE</version>
                <scope>runtime</scope>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.8</version>
                <scope>provided</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
           </plugins>
        </build>
    
    </project>

2.实体类

@Data
    public class UserInfoDO { 
    
        private Long id;
    
        private String name;
    
        private Integer age;
    }

3.mapper层

package h2demo.mapper;
    
    import org.apache.ibatis.annotations.Mapper;
    
    @Mapper
    public interface UserInfoMapper { 
    
        int deleteById(Long id);
    }

4.mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="h2demo.mapper.UserInfoMapper">
    
        <delete id="deleteById" parameterType="java.lang.Long">
            delete from user_info where id=#{ id}
        </delete>
    </mapper>

5.application.properties

spring.application.name=h2-test-demo
    # 数据库配置
    spring.datasource.url=jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MODE=MySQL
    spring.datasource.username=
    spring.datasource.password=
    spring.datasource.driver-class-name=org.h2.Driver
    spring.datasource.schema=schema.sql
    spring.datasource.data=data.sql
    
    #mybatis配置
    mybatis.config-location=classpath:mybatis/mybatis-config.xml
    mybatis.mapper-locations=classpath*:mybatis/mappers/*.xml

6.BaseTest.java

package h2demo.mapper;
    
    import org.junit.runner.RunWith;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    @RunWith(SpringRunner.class)
    @SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.NONE)
    public class BaseMapperTest { 
    }

7.测试

package h2demo.mapper;
    
    import org.assertj.core.api.Assertions;
    import org.junit.Test;
    
    import javax.annotation.Resource;
    
    
    public class UserInfoMapperTest extends BaseMapperTest { 
    
        @Resource
        private UserInfoMapper userInfoMapper;
    
        @Test
        public void deleteById() { 
            int rows = userInfoMapper.deleteById(1L);
            Assertions.assertThat(rows).isGreaterThan(0);
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjMyODM3NQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/9afb33adf8034377ac8e0f1b9a93640c.png