Java Lab@15

1.Take the existing Employee DAO Memory application and refactor thecode to use JDBC instead. The solution from the "Exceptions and Assertions" lesson has beenrenamed to EmployeeDAOJDBC. You will need to create an EmployeeDAOJDBCImpl class toreplace the EmployeeDAOMemoryImpl class, and modify the EmployeeDAOFactory toreturn an instance of your new implementation class instead of the Memory version.


Ans   https://drive.google.com/open?id=0B-yL1mP3zqTbeTBBZC1GOXhaZ0U


2.Take the existing Employee DAO Memory application and refactor thecode to use JDBC instead. The solution from the "Exceptions and Assertions" lesson has beenrenamed to EmployeeDAOJDBC. You will need to create an EmployeeDAOJDBCImpl class toreplace the EmployeeDAOMemoryImpl class, and modify the EmployeeDAOFactory toreturn an instance of your new implementation class instead of the Memory version.


Ans   https://drive.google.com/open?id=0B-yL1mP3zqTbSnFnSUtBM1F5ZVk



3.Peter needs to create an application that will enable the staff of City Library to update the details of the publishers according to their ID. For this, the application should allow the staff member to select the field and update its value. Help Peter to achieve the preceding requirement. Prerequisite: To perform this exercise, you need to ensure that the Publisher table with appropriate values exists in the Library database. If the database and the table with appropriate values do not exist, you need to create the Library database, and then execute scripts in the Create_Publisher.txt and Insert_Publisher.txt files.


Ans  https://drive.google.com/open?id=0B-yL1mP3zqTbV192dXBmRmw5M3M