public class FunctionsTest {

    @H2DB(value = "/sql/testing.sql")
    H2DBUtil h2DBUtil;

    @Test
    public void test() {
        h2DBUtil.executeQuery();
    }
}

@Configuration
@MapperScan(basePackages = "com.lucky.example.infrastructure.*.mapper", sqlSessionFactoryRef = "sqlSessionFactory")
public class MockDatabaseConfig {
    

    @Bean(name = "sampleDataSource")
    public DataSource sampleDatasource(){
        return MockDatabase.context.dataSource();
    }


    @Resource(name = "sampleDataSource")
    private DataSource sampleDataSource;


    @Bean(name = "transactionManager")
    public DataSourceTransactionManager transactionManager() {
        return new DataSourceTransactionManager(sampleDataSource);
    }

    @Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory()
            throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(sampleDataSource);
        bean.setMapperLocations(
                // 设置mybatis的xml所在位置
                new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*.xml"));
        return bean.getObject();
    }
}
``` 
接着，我们把持久层的接口注入进来，就能进行持久层的单元测试了。
```java
@Import({MockDatabaseConfig.class})
@ExtendWith(SpringExtension.class)
@Component
@TestMethodOrder(MethodOrderer.OrderAnnotation.class)
@Rollback(false)
public class GoodsMapperTest {

    @Resource
    GoodsMapper goodsMapper;

    @Test
    @Order(1)
    @DisplayName("数据库单测用例 - 查询")
    public void select() {
        GoodsPo goodsPo = new GoodsPo("1", "张三", "sku-1", 10);
        GoodsPo result = goodsMapper.selectOne(goodsPo.getId());
        Assertions.assertThat(result)
                .hasFieldOrPropertyWithValue("id", goodsPo.getId())
                .hasFieldOrPropertyWithValue("name", goodsPo.getName())
                .hasFieldOrPropertyWithValue("sku", goodsPo.getSku())
                .hasFieldOrPropertyWithValue("inventory", goodsPo.getInventory());
    }
}

public class H2Function {
    /**
     * Mysql function alias，etc：version
     */
    private String function;

    /**
     * The full class name for this function implementation
     */
    private String fullClassName;
}

public class H2FunctionsLoader {

    protected static final Set<H2Function> H2_FUNCTIONS = new CopyOnWriteArraySet<>();

    /**
     * @param h2Function
     */
    protected static void add(H2Function h2Function) {
        H2_FUNCTIONS.add(h2Function);
    }

    /**
     * @param collection
     */
    protected static void addAll(Collection<H2Function> collection) {
        H2_FUNCTIONS.addAll(collection);
    }
}