# 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 1. Using JDBC to connect to a MySQL database 2. Fetching a ResultSet from the database (Querying the database) 3. Adding records to the database 4. Creating a GUI to display data retrieved from the database 5. Using a GUI to add data to the database # Prerequisites You'll need access to a MySQL database. Try [http://www.usbwebserver.net/en/](http://www.usbwebserver.net/en/) or [https://www.apachefriends.org/index.html](https://www.apachefriends.org/index.html) You will also need some basic knowledge of MySQL. This website is an excellent introduction: [http://sqlzoo.net/](http://sqlzoo.net/) # Contents - [[JDBC 1 Quick Start]] - [[JDBC 2 Database Class]] - [[JDBC 3 Queries]] - [[JDBC 4 The Code so Far]] - [[JDBC 5 Creating a GUI]] - [[JDBC 6 Get Pupils and Display in GUI]] - [[JDBC 7 Adding students using a GUI]] - [[JDBC 8 The Complete Code]] - [[+ JDBC Project]]