java - Exporting SQL query result to csv or Excel

Question

I want to write the result of a SQL query to a csv or Excel file and save it in a particular folder. I have following requests:

1. I would like to know, if this can be achieved using a Java program which can be reused for any SQL query result.
2. I would also like to know, if this can be used for different databases (Oracle, MySQL, SQL Server, etc.).
3. I plan to attach the saved file to an email. Is it possible to export SQL query results to an email directly?.

Answer 1

With use of openCSV API, you can export your data in csv file.

CSVWriter writer = new CSVWriter(new FileWriter("yourfile.csv"), '');
Boolean includeHeaders = true;

java.sql.ResultSet myResultSet = .... //your resultset logic here

writer.writeAll(myResultSet, includeHeaders);

writer.close();