O'Reilly logo

Ivor Horton's Beginning Java™ 2, JDK™ 5th Edition by Ivor Horton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

24.8. Exercises

You can download the source code for the examples in the book and the solutions to the following exercises from http://www.wrox.com.

  1. Write a program that outputs all authors in the technical_library database with last names starting with the letters A through H.

  2. Write a program that lists all books and the authors for those books. (Hint: You will need an SQL join and the auth_books table.)

  3. Modify the InteractiveSQL program to allow the user to specify which database to use.

  4. Modify the InteractiveSQL program to provide separate input areas for each part of a SELECT statement—one for the table columns, one for the table, one for a possible WHERE clause, and so on.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required