H2 数据库使用

1
2
3
4

dependencies {
  api('p6spy:p6spy')
  api('com.h2database:h2')
}

1
2
3
4
5

# spring boot 配置
spring:
  datasource:
    driverClassName: com.p6spy.engine.spy.P6SpyDriver
    url: jdbc:p6spy:h2:mem:test;DB_CLOSE_DELAY=1000

1
2
3
4
5
6
7
8

# 启动 h2 数据库
java -cp h2*.jar org.h2.tools.Server -ifNotExists

# 启动 h2 console (可选)
java -cp h2*.jar org.h2.tools.Console

# 连接配置，会自动创建文件
url: jdbc:h2:tcp://localhost/~/test