Question: Kindly assist to solve the below ADVANCED JAVA Implement, using java, an application to transfer data from a Data Base to a Binary File. Open
Kindly assist to solve the below ADVANCED JAVA

Implement, using java, an application to transfer data from a Data Base to a Binary File. Open with Google Docs Requirements: 1- Connect successfully the source database (MarketDB) (10 pts) 2- Create / access the binary file (Market Products.dat) (10 pts) 3- Copy all data form the table Products into the file MarketProducts.dat" (30 pts) Save the data into the file after reading each and every record from the table (one record at a time) (10 pts) Data must be saved in the file within the same types as the table columns (10 pts) 4- Make sure to close all the active connections (10 pts) 5- If any error occurs while accessing the table, display the following message: "Can't read the data from the DataBase" (10 pts) 6- If any error occurs while creating / accessing the file, display the following message: "Can't save the data into the File" (10 pts) 7- In all cases (whether the data copied successfully or an error happens), display the following message at the end (even if the data were copied successfully): The accuracy of the data is your responsibility, checkup the results (10 pts) Source (DB): Database name: Market DB UserName: Manager Password: Man@gerPswrd Table Name: Products Table Columns (& types): ProdID (integer), ProdName (text), UnitPrice (Decimal Number), Quantity (integer) Sample of data: ProdID ProdName UnitPrice Quantity 11 Sugar 20000 10 Page 7, 1 + 5 6000 20 400
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
