Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create a Java application that will consume a CSV file, parse the data, and insert valid records into a SQLite database. a. Database name: .db

image text in transcribedcreate a Java application that will consume a CSV file, parse the data, and insert valid records into a SQLite database. a. Database name: .db b. It should have 1 table with 10 columns, A, B, C, D, E, F, G, H, I, J, that correspond to the CSV file column header names.

2. Each record needs to be verified to contain the right number of data elements to match the columns. a. Records that do not match the column count must be written to: -bad.csv

3. At the end of processing, write statistics to a log file: .log a. # of records received b. # of records successful c. # of records failed 4. Data sets can be extremely large, so be sure the processing is optimized. 5. Application should be re-runnable, meaning that multiple runs with the same input produce the same results.

Douglas Stone dstonel@wix.com Male Amanda Alvarez aalvarez1@merriam-wet Female Jason Brooks jbrooks2@tumblr.com Male Chris Rodriguez crodriguez3@hao123.cor Male Marie Ross mross4@ovh.net Female Lawrence Gutierrez Igutierrez5@economist.c Male Bobby Evans bevans6@geocities.com Male Katherine Lawrence klawrence7@facebook.cc Female Jean Howell jhowell8@diigo.com Female Carol Thompsor cthompson9@state.tx.us Female Harold Fisher Male Chris Nguyen cnguyenb@hatena.ne.jp Male Frank Vasquez fvasquezc@comcast.net Sean Jenkins sjenkinsd@ow.ly Male Edward emendozae@parallels.com Nancy Medina nmedinaf@boston.com Female Teresa Jacobs tjacobsg@about.com Female Aaron Watkins awatkinsh@google.pl Male Janice Adams jadamsi@microsoft.com Female Carolyn Martinez Female Marilyn Jackson mjacksonk@google.de Female data:image/png;ba switch data:image/png;ba china-unionpay data:image/png;ba switch diners-club-enroute data:image/png;ba jcb data:image/png;ba switch data:image/png;ba visa data:image/png;ba china-unionpay data:image/png;bajcb data:image/png;ba visa data:image/png;ba jcb data:image/png;ba jcb data:image/png;ba americanexpress data:image/png;ba china-unionpay data:image/png;base64,iVBORwOKGgoA data:image/png;ba jcb data:image/png;ba jcb data:image/png;bajcb data:image/png;bajcb data:image/png;ba jcb data:image/png;ba visa-electron $0.02 $6.96 $5.15 $1.82 $8.47 $4.68 $0.73 $1.68 $4.47 $3.90 $4.89 $1.22 $6.26 $1.97 $2.49 $6.41 $5.08 $6.89 $7.66 $1.52 $2.27 TRUE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE FALSE Cangzhou FALSE Quxi FALSE Funza TRUE Bojonghaur TRUE Ljupina FALSE la kha TRUE Ayn al Arab FALSE Al MaYIb TRUE Miami FALSE Hongguang Neftobod FALSE Bu%im TRUE Emmen FALSE Saint Andrews FALSE Aseri FALSE Dazhou FALSE Duzhenwan FALSE Paitan Este FALSE Bogoria Caherconlish TRUE Santo Tomas Douglas Stone dstonel@wix.com Male Amanda Alvarez aalvarez1@merriam-wet Female Jason Brooks jbrooks2@tumblr.com Male Chris Rodriguez crodriguez3@hao123.cor Male Marie Ross mross4@ovh.net Female Lawrence Gutierrez Igutierrez5@economist.c Male Bobby Evans bevans6@geocities.com Male Katherine Lawrence klawrence7@facebook.cc Female Jean Howell jhowell8@diigo.com Female Carol Thompsor cthompson9@state.tx.us Female Harold Fisher Male Chris Nguyen cnguyenb@hatena.ne.jp Male Frank Vasquez fvasquezc@comcast.net Sean Jenkins sjenkinsd@ow.ly Male Edward emendozae@parallels.com Nancy Medina nmedinaf@boston.com Female Teresa Jacobs tjacobsg@about.com Female Aaron Watkins awatkinsh@google.pl Male Janice Adams jadamsi@microsoft.com Female Carolyn Martinez Female Marilyn Jackson mjacksonk@google.de Female data:image/png;ba switch data:image/png;ba china-unionpay data:image/png;ba switch diners-club-enroute data:image/png;ba jcb data:image/png;ba switch data:image/png;ba visa data:image/png;ba china-unionpay data:image/png;bajcb data:image/png;ba visa data:image/png;ba jcb data:image/png;ba jcb data:image/png;ba americanexpress data:image/png;ba china-unionpay data:image/png;base64,iVBORwOKGgoA data:image/png;ba jcb data:image/png;ba jcb data:image/png;bajcb data:image/png;bajcb data:image/png;ba jcb data:image/png;ba visa-electron $0.02 $6.96 $5.15 $1.82 $8.47 $4.68 $0.73 $1.68 $4.47 $3.90 $4.89 $1.22 $6.26 $1.97 $2.49 $6.41 $5.08 $6.89 $7.66 $1.52 $2.27 TRUE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE FALSE Cangzhou FALSE Quxi FALSE Funza TRUE Bojonghaur TRUE Ljupina FALSE la kha TRUE Ayn al Arab FALSE Al MaYIb TRUE Miami FALSE Hongguang Neftobod FALSE Bu%im TRUE Emmen FALSE Saint Andrews FALSE Aseri FALSE Dazhou FALSE Duzhenwan FALSE Paitan Este FALSE Bogoria Caherconlish TRUE Santo Tomas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design And Implementation

Authors: David M. Kroenke

5th Edition

B000CSIH5A, 978-0023668814

More Books

Students also viewed these Databases questions

Question

what is a peer Group? Importance?

Answered: 1 week ago