官网

http://www.h2database.com/html/main.html

特定

  1. H2 提供了 In-Memory Mode，能将数据在内存中进行操作，速度更快，能够让测试快读验证
  2. H2 安装、启动都非常方便能够使测试在本地、集成测试环境能够快速搭建测试环境并进行验证

SpringBoot

pom.xml

1
2
3
4
5
<dependency>
  <groupId>com.h2database</groupId>
  <artifactId>h2</artifactId>
  <scope>runtime</scope>
</dependency>

application.yml

1
2
3
4
5
6
7
spring:
  datasource:
    driver-class-name: org.h2.Driver
    schema: classpath:db/schema-h2.sql
    url: jdbc:h2:mem:test
    username: root
    password: test

schema-h2.sql

1
2
3
4
5
6
7
8
9
10
DROP TABLE IF EXISTS user;

CREATE TABLE user
(
	id BIGINT(20) NOT NULL COMMENT '主键ID',
	name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
	age INT(11) NULL DEFAULT NULL COMMENT '年龄',
	email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
	PRIMARY KEY (id)
);