Question

1 Approved Answer

Posted on Sep 07, 2024

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

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 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.

here is the link to the file: https://media.cheggcdn.com/media/36a/36a91a2b-1bcc-466e-a444-19f2813ebf36/phpoxrUnM.png image text in transcribed

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