Question
Write a code in java that load a CSV data file and transform it into a BINARY file. You MUST name your binary file data.bin.
Write a code in java that load a CSV data file and transform it into a BINARY file. You MUST name your binary file data.bin. Subsequent queries will then operate on the binary file. You could use the Java Data Streams and Object Streams classes, but you are free to design the format of the binary file (compression libraries are allowed!).
Have a method that transform the CSV file with filename into a binary file. The filename of the binary file should be stored in your program.
Have another method prints the rows of the table where the value in column number columnNum is equal to the given value. Column numbers start from one.
Have another method that prints the rows of the table where the value in column number columnNum is greater than the given value.
Here is an example of what in the cvs file:
1|3691|O|194029.55|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among | 2|7801|O|60951.63|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot| 3|12332|F|247296.05|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos| 4|13678|O|53829.87|1995-10-11|5-LOW|Clerk#000000124|0|sits. slyly regular warthogs cajole. regular, regular theodolites acro| 5|4450|F|139660.54|1994-07-30|5-LOW|Clerk#000000925|0|quickly. bold deposits sleep slyly. packages use slyly| 6|5563|F|65843.52|1992-02-21|4-NOT SPECIFIED|Clerk#000000058|0|ggle. special, final requests are against the furiously specia| 7|3914|O|231037.28|1996-01-10|2-HIGH|Clerk#000000470|0|ly special requests |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started