Overview
This course was written to demonstrate how to use Java and JDBC to query a MySQL database. The original audience was 14-18 year old students.
The course covers the following
- Using JDBC to connect to a MySQL database
- Fetching a ResultSet from the database (Querying the database)
- Adding records to the database
- Creating a GUI to display data retrieved from the database
- Using a GUI to add data to the database
Prerequisites
You’ll need access to a MySQL database. Try http://www.usbwebserver.net/en/ or https://www.apachefriends.org/index.html
You will also need some basic knowledge of MySQL. This website is an excellent introduction: http://sqlzoo.net/
Update
Following the COVID19 outbreak, I hurriedly recorded some YouTube Videos. I’ve incorporated links in the course. I may re record these properly if I have time. Feel free to leave feedback on what needs improving.