如何在java Web应用程序中公开测试数据库?简单的Sqlsheet servlet?

时间:2022-01-28 05:51:09

I have a java web application which i'm developing using a local embedded HSQL database. Is there kind of a servlet which I can plug-in into my application and expose it /dbconsole, where I can fire sql statements, inspect tables, fields and table data?

我有一个java Web应用程序,我正在使用本地嵌入式HSQL数据库进行开发。是否有一种servlet可以插入到我的应用程序中并公开/ dbconsole,我可以在哪里触发sql语句,检查表,字段和表数据?

1 个解决方案

#1


1  

I think you can try H2 Database which is a fast java opensource database. It can be easily embedded and it has a build-in servlet (org.h2.server.web.WebServlet) for db admin usage. We have used it in our production several years and it is very stable.

我想你可以试试H2 Database这是一个快速的java开源数据库。它可以很容易地嵌入,并且有一个用于db admin使用的内置servlet(org.h2.server.web.WebServlet)。我们已经在我们的生产中使用它几年,它非常稳定。

Here's its web console UI rendered by org.h2.server.web.WebServlet: 如何在java Web应用程序中公开测试数据库?简单的Sqlsheet servlet?

这是由org.h2.server.web.WebServlet呈现的Web控制台UI:

#1


1  

I think you can try H2 Database which is a fast java opensource database. It can be easily embedded and it has a build-in servlet (org.h2.server.web.WebServlet) for db admin usage. We have used it in our production several years and it is very stable.

我想你可以试试H2 Database这是一个快速的java开源数据库。它可以很容易地嵌入,并且有一个用于db admin使用的内置servlet(org.h2.server.web.WebServlet)。我们已经在我们的生产中使用它几年,它非常稳定。

Here's its web console UI rendered by org.h2.server.web.WebServlet: 如何在java Web应用程序中公开测试数据库?简单的Sqlsheet servlet?

这是由org.h2.server.web.WebServlet呈现的Web控制台UI: