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

Kindly assist to solve the below ADVANCED JAVA Implement, using java, an

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!