Starting Out with Java: From Control Structures through Objects (6th Edition)

6th Edition

ISBN: 9780133957051

Author: Tony Gaddis

Publisher: PEARSON

See similar textbooks

Videos

Textbook Question

Chapter 17, Problem 5PC

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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 17, Problem 3PC

Chapter 17, Problem 6PC

Students have asked these similar questions

7. See the code below and solve the following. public class Test { public static void main(String[] args) { int result = 0; } result = fn(2,3); System.out.println("The result is: + result); // fn(x, 1) = x // fn(x, y) = fn(x, y-1) + 2, when y>1 public static int fn(int x, int y) { if (x <= 1) return x; else return fn(x, y-1) + 2; } } 7-1. This program has a bug that leads to infinite recursion. Modify fn(int x, int y) method to fix the problem. (2 point) 7-2. Manually trace the recursive call, fn(2,3) and show the output (step by step). (2 point) 7-3. Can you identify the Base Case in recursive method fn(int x, int y)? (1 point)

6. See the code below and solve the following. import java.io.*; public class DataStream { } public static void main(String[] args) } DataOutputStream output = new DataOutputStream(new FileOutputStream("temp.dat")); output.writeUTF("Book1"); output.writeInt(85); output.writeUTF("Book2"); output.writeInt(125); output.writeUTF("Book3"); output.writeInt(70); output.close(); // ToDo: Read all data from temp.dat and print the data to the standard output (monitor) 6-1. This program has a compile error, and the message is “Unhandled exception type FileNotFoundException". How do you fix this error? (1 point) 6-2. Is FileNotFoundException a checked exception or an unchecked exception? (1 point) 6-3. What is the difference between checked exception and unchecked exception? (1 point) 6-4. Please complete the above program by reading all data from temp.dat and print the data to the standard output (monitor) by using System.out.print, System.out.println or System.out.printf method. (2 points)

Write a program that reads a list of integers from input and determines if the list is a palindrome (values are identical from first to last and last to first). The input begins with an integer indicating the length of the list that follows. Assume the list will contain a maximum of 20 integers. Output "yes" if the list is a palindrome and "no" otherwise. The output ends with a newline. Hints: - use a for loop to populate the array based on the specified size (the first number entered) - use a for loop to check first value with last value, second value with second from end, etc. - if the values do not match, set a Boolean variable to flag which statement to output (yes or no) Ex: If the input is (remember to include spaces between the numbers): 6 1 5 9 9 5 1 the output is: yes Ex: If the input is: 5 1 2 3 4 5 the output is: C++ coding

Chapter 17 Solutions

Starting Out with Java: From Control Structures through Objects (6th Edition)

Ch. 17.1 - Why do most businesses use a DBMS to store their...Ch. 17.1 - When a Java programmer uses a DBMS to store and...Ch. 17.1 - Prob. 17.3CP Ch. 17.1 - Prob. 17.4CP Ch. 17.1 - Prob. 17.5CP Ch. 17.1 - Prob. 17.6CP Ch. 17.1 - What static JDBC method do you call to get a...Ch. 17.2 - Describe how the data that is stored in a table is...Ch. 17.2 - What is a primary key?Ch. 17.2 - What Java data types correspond with the following...

Ch. 17.3 - Prob. 17.11CP Ch. 17.3 - Prob. 17.12CP Ch. 17.3 - Prob. 17.13CP Ch. 17.3 - Prob. 17.14CP Ch. 17.3 - What is the purpose of the % symbol in a character...Ch. 17.3 - How can you sort the results of a SELECT statement...Ch. 17.3 - Assume that the following declarations exist:...Ch. 17.3 - How do you submit a SELECT statement to the DBMS?Ch. 17.3 - Prob. 17.19CP Ch. 17.3 - Prob. 17.20CP Ch. 17.4 - Prob. 17.21CP Ch. 17.4 - Prob. 17.22CP Ch. 17.5 - The Midnight Coffee Roastery is running a special...Ch. 17.5 - Prob. 17.24CP Ch. 17.6 - Prob. 17.25CP Ch. 17.6 - Write a statement to delete the Book table you...Ch. 17 - Prob. 1MC Ch. 17 - This is a standard language for working with...Ch. 17 - Prob. 3MC Ch. 17 - The data that is stored in a row is divided...Ch. 17 - This is a column that holds a unique value for...Ch. 17 - This type of SQL statement is used to retrieve...Ch. 17 - This contains the results of an SQL SELECT...Ch. 17 - This clause allows you to specify search criteria...Ch. 17 - Prob. 9MC Ch. 17 - Prob. 10MC Ch. 17 - Prob. 11MC Ch. 17 - Prob. 12MC Ch. 17 - This method is specified in the Statement...Ch. 17 - This SQL statement is used to insert rows into a...Ch. 17 - This SQL statement is used to remove rows from a...Ch. 17 - Prob. 16MC Ch. 17 - Prob. 17MC Ch. 17 - True/False: Java comes with its own built-in DBMS.Ch. 17 - True/False: A Java programmer that uses a DBMS to...Ch. 17 - True/False: You use SQL instead of Java to write...Ch. 17 - True/False: In SQL, the not-equal-to operator is...Ch. 17 - Prob. 22TF Ch. 17 - Prob. 23TF Ch. 17 - Prob. 24TF Ch. 17 - Prob. 1FTE Ch. 17 - Prob. 2FTE Ch. 17 - Prob. 3FTE Ch. 17 - What SQL data types correspond with the following...Ch. 17 - Look at the following SQL statement. SELECT Name...Ch. 17 - Write a SELECT statement that will return all of...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Prob. 5AW Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Write a SELECT statement that will return all of...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Write a SELECT statement that will return the...Ch. 17 - Prob. 10AW Ch. 17 - Write an SQL statement that does the following:...Ch. 17 - Prob. 12AW Ch. 17 - Prob. 13AW Ch. 17 - Assuming that conn references a valid Connection...Ch. 17 - Prob. 17AW Ch. 17 - Prob. 18AW Ch. 17 - Prob. 19AW Ch. 17 - Prob. 1SA Ch. 17 - Prob. 2SA Ch. 17 - Prob. 3SA Ch. 17 - What is a primary key?Ch. 17 - Prob. 5SA Ch. 17 - What are the relational operators in SQL for the...Ch. 17 - What is the number of the first row in a table?...Ch. 17 - Prob. 8SA Ch. 17 - Prob. 9SA Ch. 17 - Customer Inserter Write an application that...Ch. 17 - Customer Updater Write an application that...Ch. 17 - Unpaid Order Sum Write an application that...Ch. 17 - Population Database Make sure you have downloaded...Ch. 17 - Personnel Database Creator Write an application...Ch. 17 - Employee Inserter Write a GUI application that...Ch. 17 - Employee Updater Write a GUI application that...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts

The 50-mm-diameter cylinder is made from Am 1004-T61 magnesium and is placed in the clamp when the temperature ...

Mechanics of Materials (10th Edition)

Arrays are never passed to functions by _______ because there would be too much overhead in copying all the ele...

Starting Out with C++: Early Objects (9th Edition)

This optional Google account security feature sends you a message with a code that you must enter, in addition ...

SURVEY OF OPERATING SYSTEMS

Using the commands SELECT, PROJECT, and JOIN, write a sequence of instructions to answer each of the following ...

Computer Science: An Overview (13th Edition) (What's New in Computer Science)

In the following exercises, write a program to carry out the task. The program should use variables for each of...

Introduction To Programming Using Visual Basic (11th Edition)

What is a flag and how does it work?

Starting Out with Python (4th Edition)

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.