Chapter 16, Problem 4PC

Population Database

Make sure you have downloaded the hook’s source code from the companion Web site at www.pearson.com/gaddis. In this chapter’s source code folder you will find a program named CreateCityDB.java. Compile and run the program. The program will create a Java

DB or Apache Derby database named CityDB. The CityDB database will have a table named City, with the following columns:

Column Name	Data Type
CityName	CHAR (50)
Primary key
Population	DOUBLE

The CityName column stores the name of a city and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations.

Next, write a program that connects to the CityDB database, and allows the user to select any of the following operations:

• Sort the list of cities by population, in ascending order.
• Sort the list of cities by population, in descending order.
• Sort the list of cities by name.
• Get the total population of all the cities.
• Get the average population of all the cities.
• Get the highest population.
• Get the lowest population.