A java application connected to mysql.
The goal of this project is to use JDBC to create a Books database, populate it, and then execute different SQL statements to query or manipulate the Books database.
Overview: In this project, using JDBC application that access the Oracle RDBMS in the design center (you need to have an account), you will need to: • Create the Books database tables as specified in the schema definition below.
• Initialize the different tables (at least 15 entries per table) appropriately: all fields cannot be null.
• Issue the following SQL statements. For queries print the results from java into your console:
• Select all authors from the authors table. Order the information alphabetically by the author’s last name and first name.
• Select all publishers from the publishers table.
• Select a specific publisher and list all books published by that publisher. Include the title, year and ISBN number. Order the information alphabetically by title.
• Add new author
• Edit/Update the existing information about an author
• Add a new title for an author
• Add new publisher
• Edit/Update the existing information about a publisher