Project 7: JDBC Programming
‡oal: Write two classes, a Load class and a Display class, that will store and
look up data of your choice.
“ee the store and lookup modules in the JDBC Example.
„eliverables: An IntelliJ project named Proj7Smith (replace with your last
name).
„etails:
Modify the LoadKids and DisplayKids classes from the JDBC Example.
1. Choose a data schema that contains at least five columns, one of
which is a primary key.
2. Create a comma delimited .txt file with at least eight data rows. The
first row contains the column names.
3. Write a Load class with a main method that loads the data from
the .txt file into the database table.
4. Add the sqlite3-jdbc.jar file in this zip file to your project:
jar_files.zip
5. Set up a module dependency on the JAR file.
6. Write a Display class with a main method that inputs a primary key,
then displays on the screen the corresponding data in a row of the
table.
‡rading Breakdown: Load Class: 35%; Display Class 35%; Creativity
10%; Source code comments: 10%; Indentation 5%; Properly Submitted:
5%

Purchase answer to see full
attachment