Part 1
Part 2
Database Access
The objective of this assignment is to allow you to work with JDBC via an ODBC-connected Access database.
Your first task for this assignment is to locate and set up the “exampleMDB.mdb” file in the supplemental chapters section of the CD-rom that came with your Liang text. Copy this file to your hard drive. Next, create an ODBC connection to this database called “assignment8”.
Next, create a simple Java program that connects to this database using JDBC. Your program should then query this database’s “student” table and display a list of all the students’ names in alphabetic order (based upon last name).
If you implement your program correctly, this is the output you should see:
Rick R. CarterFrank E. JonesJoy P. KennedyToni R. PetersonJosh R. SmithJean K. SmithGeorge K. SmithJacob R. SmithJohn K. StevensonPatrick R. StonemanJosh R. Woo
Please do not waste my time if you do not know Java
Access database cannot be uploaded as file type is not allowed. Will email it separately.