Download the 1337PPQ2Spr2017.zip file to your desktop.

Extract (unzip) the file into a 1337PPQ2Spr2017 directory.

Start Eclipse. From the File menu select Switch Workspace -> Other. Click the Browse button and select Desktop. Click Ok. Ok.

Import the project named 1337PPQ2Spr2017 from the Desktop,

Put your name as a comment before the class header.

Review the project components.

Console

Welcome to the Country Manager

1 - List countries

2 - Add a country

3 - Exit

Enter menu number: 1

India

Japan

Mexico

Spain

United States

1 - List countries

2 - Add a country

3 - Exit

Enter menu number: 2

Enter country: France

France has been added.

1 - List countries

2 - Add a country

3 - Exit

Enter menu number: 1

France

India

Japan

Mexico

Spain

United States

1 - List countries

2 - Add a country

3 - Exit

Enter menu number: 3

Goodbye!

Operation

The application begins by displaying a menu with three menu items. (10 points)

If the user chooses the first item, the application displays a list of countries that are stored in a database. (10 points)

If the user chooses the second item, the application prompts the user to enter a country and then it adds that country to the database. (10 points)

If the user chooses the third item, the application displays a goodbye message and exits. (10 points)

Specifications

Create a table in the mma database described in chapter 19 to store the necessary data. To do that, you can use the SQL script stored in the create_country_table.sql file thats supplied. If this script isnt supplied, you can create your own SQL script. (10 points)

Create a class named CountryDB that contains two methods: one that allows you to read a list of countries and another method that allows you to add a country to the list. For example: (10 points)

public ArrayList getCountries()

public boolean addCountry(String country)

Create a class named CountryApp that displays the menu and responds to the users choices. (10 points)

Use the Console class described in chapter 8 or a variation of it to get the users entries. (10 points)

Add meaningful javadoc comments and generate documentation (10 points)

This documentation should include descriptions for all of the constructors and methods as well as information about all parameters and return values.

Generate the documentation for the entire project.

View the documentation to be sure it is complete.

Limit to 1000 rows 1 USE mma; 3 DROP TABLE IF EXISTS Country; 5 CREATE TABLE Country INT PRIMARY KEY AUTO INCREMENT, ID Name VARCHAR(100) 10 11 INSERT INTO Country VALUES (1, India 12 13 (2, Japan 3, Mexico 14 15 (4, Spain 16 (5, United States 17