Student Learning Outcomes. After completion of this lab, students will be able to write a Java program that

uses relational databases

queries a database with the Structured Query Language (SQL)

connects to a database with Java Database Connectivity (JDBC)

inserts, updates, and deletes data in a relational database

creates Java Server Pages (.jsp) and html pages in the development of dynamic web pages

Activity Create a series of Java Server Pages (.jsp) that use a database. Use the slides, examples and recording as a reference for this lab

Review the previous lab on JDBC.

Using the database or a similar database to the one you created in the previous lab, create jsp pages that perform the following:

Creates the database and populates with a least 3 records.

Displays all the records in the database in nicely formatted table.

Displays record based on search criteria for example in our author example db, we could search on authors ID or web address.

The code only need to search one field at a time.

All output must be in a web page, no command line output.

Zip up your program and turn them in to the Lab 12 Dropbox.