- use
db.sql
to create the schema and tables - configure the
url
,username
,password
in/utils/ConnectDB.java
- run
main
function inhw_jdbc.java
which is the of same level with the spring app file
- the orders in
hw_jdbc.java
are fixed to follow foreign key constraints, otherwise may require executingset foreign_key_check=0
- the test files in
test
directory require canceling foreign key check, or manually preload the needed data to satisfy foreign key constraint. However, they are not prerequisites to runhw_jdbc.java
Insert a static hello message
Insert a parameterized hello message
Retrieve all hello messages