两个没有搞明白的点:
- spring.datasource.url=jdbc:h2:file:~/test
和jdbc:h2:tcp://localhost/~/test的区别? - 为什么在spring boot和war里要使用jdbc:h2:file:~/test?
步骤:`首先引入依赖:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.199</version>
</dependency>
//用flyway管理
<plugin>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<version>6.0.8</version>
<configuration>
<url>jdbc:h2:~/community1</url>
<user>sa</user>
<password>123</password>
</configuration>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.199</version>
</dependency>
</dependencies>
</plugin>
</plugins>
然后,用idea自带的数据库管理工具管理数据库。
然后就可以使用了