If you are really interesting in JDBC API usage you can find a lot of examples in this repository All these examples can be run with database 'shop' . Database can be imported from shop.sql (in resource folder)
zaleslaw/JDBC_Tutorial
30 exercises to learn JDBC API, Spring JDBC, DBUnit, Connection Pooling
JavaMIT