Question
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
- Select all authors from the Authors table.
- Select a specific author and list all books for that author. Include each books title, year, and ISBN. Order the information chronologically.
- Select a specific title and list all authors for that title. Order the authors alphabetically by last name and then by first name.
- 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.
- Add a new author.
- Edit the existing information for an author.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started