To Projects

IT 313 -- Project 8

JDBC Programming

• Goal: Write at two classes that will store and look up data of your choice.
• See the store and lookup modules in the Jdbc Example.
• Deliverables: An IntelliJ project named Proj6Smith (replace with your last name).
• Details:
  
  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 lines. 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. Download the SQLite3 JAR file from this website:
     https://bitbucket.org/xerial/sqlite-jdbc/downloads/
     Select the most recent version of the JAR file:
     sqlite-jdbc-3.30.1.jar
  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.
• Grading Breakdown:   Load Class: 40%; Display Class 40%; Source code comments: 10%; Indentation 5%; Properly Submitted: 5%