This document describes how to create a simple distributed web application that connects to a MySQL database. It also covers some basic ideas and technologies in web development, such as Java Server Pages and three-tier architecture. This tutorial is designed for beginners who have a basic understanding of Java programming and web development and are looking to apply their knowledge using MySQL.

MySQL is a popular Open Source database management system commonly used in web applications due to its speed, flexibility and reliability. MySQL employs SQL, or Structured Query Language, for accessing and processing data contained in databases.

This tutorial continues from the Connecting to a MySQL Database tutorial and assumes that you already have a connection to a MySQL database created and configured in NetBeans IDE. The table data that is included in ifpwafcad.sql. is also required for this tutorial. This SQL file creates two tables, Counselor and Subject, then populates them with sample data. Save this file to a local directory, then open it in NetBeans and run it on the MySQL database. In this tutorial, the database we are working in is named MyNewDatabase.