<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
    <scope>test</scope>
</dependency>

SET MODE MYSQL;
CREATE TABLE `test`(
...
);
INSERT INTO `test` (`column1`) Values ('test');

class H2DatabaseTest {
    private final ApplicationContextRunner contextRunner = new ApplicationContextRunner()
            .withConfiguration(AutoConfigurations.of(PrometheusMetricsExportAutoConfiguration.class,
                    MetricsAutoConfiguration.class,
                    CompositeMeterRegistryAutoConfiguration.class,
                    MybatisAutoConfiguration.class,
                    H2DatabaseTest.DataSourceConfiguration.class))
            .withPropertyValues("xxx.uuid.standalone=false");
    @Test
    void testWithUserUse() {
        contextRunner.run(context -> {
            .....
        });
    }
    @Configuration
    public static class DataSourceConfiguration {
        @Bean
        public DataSource dataSource() {
            return new EmbeddedDatabaseBuilder()
                    .setType(EmbeddedDatabaseType.H2)
                    //建表和初始化数据
                    .addScript("h2.sql")
                    .build();
        }
    }
}