Algorithms and Data Structures
Requirements: You are required to execute a Java application which permits a user to create, read, update and delete data in a table in a My SQL database. Your program should use a Java class which encapsulates all the code to access the database (such classes are employed to create ‘data access objects’). This class must be implemented by using the JDBC library.
Your program must present the user with a menu of choices, including the capability to create, read (or view), update and delete the entities in database table. The code used to implement the user interface of the application must be encapsulated in a single class as much as probable. The code to implement the options accessible on the menu(es) must be encapsulated inside the main method (within the other methods in the class containing the main method). This program design is named as the Model-View-Controller design pattern.