Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Having som errors on my code: java.sql.SQLException: No suitable driver found for jdbc:derby:books at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at AuthorQueries.(AuthorQueries.java:34) at Project13.(Project13.java:84) at Project13.(Project13.java:21) at Project13$1.run(Project13.java:71)

Having som errors on my code:

java.sql.SQLException: No suitable driver found for jdbc:derby:books at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at AuthorQueries.(AuthorQueries.java:34) at Project13.(Project13.java:84) at Project13.(Project13.java:21) at Project13$1.run(Project13.java:71) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) BUILD FAILED (total time: 0 seconds)

Instructions:

Using the techniques shown in the Reading & Study materials, create a Java application that performs the following queries on the books database: Deitel & Deitel: ch. 24

  1. Select all authors from the Authors table.
  2. Select a specific author and list all books for that author. Include each books title, year, and ISBN. Order the information chronologically.
  3. Select a specific title and list all authors for that title. Order the authors alphabetically by last name and then by first name.
  4. Provide 2 additional queries of your own choosing that you feel would be appropriate for the books database.

Create a Java GUI application that allows the user to perform the tasks below on the books database. The user must be able to enter new data and edit existing data using a graphical user interface.

  1. Add a new author.
  2. Edit the existing information for an author.
  3. Add a new title for an author. (Remember that the book must have an entry in the AuthorISBN table).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific

1st Edition

3030287297, 978-3030287290

More Books

Students also viewed these Databases questions

Question

Explain how a Trojan horse works.

Answered: 1 week ago