Exercises

25.2Using the techniques shown in this chapter, define a complete query application for the books database. Provide the following predefined queries:

  1. Select all authors from the authors table.

  2. Select a specific author and list all books for that author. Include each book’s title, year and ISBN. Order the information alphabetically by the author’s last then first name.

  3. Select a specific publisher and list all books published by that publisher. Include the title, year and ISBN. Order the information alphabetically by title.

  4. Provide any other queries you feel are appropriate.

Display a JComboBox with appropriate names for each predefined query. Also allow users to supply their own queries.

25.3Define a data-manipulation application for the ...

Get Java™ How to Program, Seventh Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial