H2 Web Console to In Memory Database – Spring Boot

最新推荐文章于 2025-04-22 08:00:00 发布

转载最新推荐文章于 2025-04-22 08:00:00 发布 · 112 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/boltwu/blog/776346

文章标签：

#数据库 #java

本文介绍如何在SpringBoot项目中集成H2数据库Web控制台，通过配置H2的WebServlet并映射到指定路径，实现对内存数据库的在线管理与操作。

为什么80%的码农都做不了架构师？>>>

To get an H2 Database Web Console accessing an in-memory database running on Spring Boot:

Register H2’s WebServlet (with UrlMapping /console/*) to your Spring project in a Configuration annotated class. Restart your Application.
Open a web page to http://localhost:8080/console/
Be sure you’re accessing the correct database JDBC URL (default would be jdbc:h2:mem:testdb)

(Credit: Spring Framework Guru)

import org.h2.server.web.WebServlet;
import org.springframework.boot.context.embedded.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class H2ConsoleWebConfiguration {

    @Bean
    ServletRegistrationBean h2servletRegistration() {
        ServletRegistrationBean registrationBean = new ServletRegistrationBean(new WebServlet());
        registrationBean.addUrlMappings("/console/*");
        return registrationBean;
    }
}

转载于:https://my.oschina.net/boltwu/blog/776346