Details of this Paper

JAVA - Population Database

Description

solution


Question

CreateCityDB.java @ http://www.datafilehost.com/download-39868b74.html;Compile and run the CreateCityDB program. The program will create a Java DB 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 bv 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

 

Paper#72973 | Written in 18-Jul-2015

Price : $22
SiteLock