Spring Boot 使用 H2 内存数据库

太过爱你忘了你带给我的痛 2022-04-17 06:35 292阅读 0赞

> H2 is one of the popular in memory databases.

> H2 is a relational database management system written in Java. It can be embedded in Java applications or run in the client-server mode.

添加**H2** POM依赖

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

创建**Student**实体

@Entity
    @Getter
    @Setter
    @AllArgsConstructor
    @NoArgsConstructor
    @ToString
    public class Student {
        @Id
        @GeneratedValue
        private Long id;
        private String name;
        private String passportNumber;
    }

启用**H2 Web Console**

# Enabling H2 Console
    spring.h2.console.enabled=true

SpringBoot中**H2 DataSource**配置

# DataSource Configuration
    spring.datasource.url=jdbc:h2:mem:cib
    spring.datasource.driverClassName=org.h2.Driver
    spring.datasource.username=root
    spring.datasource.password=root
    spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
    spring.jpa.hibernate.ddl-auto = update
    spring.jpa.show-sql = true

启动应用程序，访问**H2 Web Console**：[http://localhost:8090/h2-console][http_localhost_8090_h2-console]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmdrYW5nbG91_size_16_color_FFFFFF_t_70]

数据库查询  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmdrYW5nbG91_size_16_color_FFFFFF_t_70 1]

--------------------

http://www.springboottutorial.com/spring-boot-and-h2-in-memory-database

[http_localhost_8090_h2-console]: http://localhost:8090/h2-console
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmdrYW5nbG91_size_16_color_FFFFFF_t_70]: /images/20220417/85c8e7a8defd4bef9c33928630ef7dcc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmdrYW5nbG91_size_16_color_FFFFFF_t_70 1]: /images/20220417/df0ff118d978404297a548c9f979754f.png