seal

希望我們 有光明的未來
還有能夠裝下星空的期待
可現實為何讓我感到如此懈怠
總懷念相遇時我們無視落葉和人海

是你讓我勇敢不再像顆塵埃
是你常幫我照料裝著夢的盆栽
每一天我們都是如此愉快
一直到天色漸晚看著落日無奈離開

我知道你愛集郵愛笑甚至愛發呆
我知道你怕草蟲還有夜晚的妖怪
我喜歡你有一點心不在焉的狀態
看起來像個回到七歲時候的小孩

Level 7: H2-Console

While using H2 mem-database, we can use localhost:post/h2-console to log in to h2-Console.

H2-console is a web-based management tool provided by the H2 mem-db.It allows you to view the database structure,execute SQL queries, and manage data directly in the browser, which is convenient when developing and debugging Spring Boot applications.

Configuration

when enter this URL(localhost:post/h2-console), you ll be redirected to login page.

you need to focus on conlumns below:

1. JDBC URL When using mem-DB, you just set it as jdbc:h2:mem:testdb is OK
2. User Name and Password These datas are configured in application.properties, you can get them easily

Use Page

while logining in , you can use SQL queries to select datas, such as :
SELECT * FROM CAR
This code will select any data in CAR set