1. H2数据库
  • pom中引入相关依赖
<dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
  • application.yml配置文件中进行相关配置
server:
  port: 80

spring:
  h2:
    console:
      enabled: true 项目上线后必须改成false，或者注释掉H2数据库相关配置
      path: /h2  访问路径

  datasource:
    hikari:
      driver-class-name: org.h2.Driver
      username: sa
      password: 123456
    url: jdbc:h2:~/test 存储路径

默认用户名：sa，默认密码：123456，首次使用可以在网页进行连接http://localhost:端口/h2

image.png