Question: use java programming language input from a .xls (csv file) containing data as shown above. sample run ------------------- //datetime, depth, magnitude, address, state 2020-01-10T23:45:16.3602,10,2.3,22km SSE

use java programming languageuse java programming language input from a .xls (csv file) containing data

input from a .xls (csv file) containing data as shown above.

sample run -------------------

as shown above. sample run ------------------- //datetime, depth, magnitude, address, state 2020-01-10T23:45:16.3602,10,2.3,"22km

//datetime, depth, magnitude, address, state 2020-01-10T23:45:16.3602,10,2.3,"22km SSE of Helena, Oklahoma" 2020-01-10T23:44:31.2407,6.3,0.72,"22km N of Ridgecrest, CA" 2020-01-10T23:44:00.800Z,5.44,0.57,"23km N of Ridgecrest, CA" 2020-01-10T23:30:52.550Z, 16.19, 2.37,"2km NE of Colton, CA" 2020-01-10T23:13:42.3952, 124.8,2.5,"79km E of Old Iliamna, Alaska" Your program shall do the followings: reads earthquake data from earthquake.xls file into a dynamic array list (ArrayList) prompts user to enter date interval, magnitude and state as the place for the earthquake as search criteria performs search on the dynamic array based on the search criteria stores matching earthquakes in another dynamic array list displays the search results to the console together with the total number of events found saves the search results in a text file and name the file using state information (e.g Earthquake_Alaska.txt) keeps running the application as long as user wants to continue handles exceptions o if user enters an invalid input, displays an error message o if there is no record found, displays "No records found" message o if file is not found, displays "File not found message Date [yyyy-mm-dd][from] : 2016-11-1 Date [yyyy-mm-dd][to]: 2016-11-14 State:Alaska Magnitude [min]:5.0 2016-11-14T02:12:17.830Z>>Magnitude: 5.4 2016-11-12T21:52:36.956Z>>Magnitude: 5.2 2016-11-11T08:13:46.1907>>Magnitude: 5.2 2016-11-14T02:12:17.830Z>>Magnitude: 5.4 2016-11-12T21:52:36.956Z>>Magnitude: 5.2 2016-11-11T08:13:46.190Z>>Magnitude: 5.2 Results found: 3 Earthquake_Alaska.txt Results found: 3 Do you want to continue (yeso): yes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!