The java code should generate a csv file from the result of a select query.
Say example select * from employee;. The output of the query should be in csv file in the destination path mentioned in the code.
Please help.
-
1Lots of CSV API recommendations here: stackoverflow.com/questions/101100/csv-api-for-javaskaffman– skaffman2010-02-23 13:41:48 +00:00Commented Feb 23, 2010 at 13:41
-
Also stackoverflow.com/questions/200609/…defines– defines2010-02-23 14:30:13 +00:00Commented Feb 23, 2010 at 14:30
Add a comment
|
3 Answers
Don't do it in Java. Any decent database already provides builtin facilities for this. It won't be any more efficient in Java than the DB does. Just consult its documentation for export facilities. As you didn't mention which one you're using, I'll just give a MySQL targeted example: LOAD DATA INFILE.
Comments
I'm not sure what your trouble is. Generating CSV files is pretty much trivial in any language that supports file I/O. Parsing CSV files is where things get interesting.
1 Comment
gb96
Generating CSV is not trivial. What do you do when one of the values you want to output contains a comma? e.g. "Hello, world!" Double quotes? e.g. 'He said: "Hello, world!"' Escaped double quotes? And so on..
Skaffman made a good comment... you can check out other posts in SO about CSV parsers. For example, check out OpenCSV.
