导出sql查询结果为csv或excel [英] exporting sql query result to a csv or excel

问题描述

我想将sql查询的结果写入csv或excel文件并将其保存在特定的文件夹中。我想知道是否可以使用可以重用于任何sql查询结果的java程序来实现。我也想知道这是否可以用于不同类型的数据库（oracle，mysql，MS sql server等）。我计划将保存的文件附加到电子邮件（这是可能直接导出sql查询结果到电子邮件）。请帮助。

I want to write the result of an sql query to a csv or excel file and save it in a particular folder.I would like to know if this can be achieved using a java program which can be reused for any sql query result.I would also like to know if this can be used for different types of databases(oracle,mysql,MS sql server etc).I plan to attach the saved file to an email(is this possible directly exporting a sql query result to an email).Please help.

推荐答案

使用openCSV API，可以导出csv文件中的数据。

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

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

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

writer.writeAll(myResultSet, includeHeaders);

writer.close();

这篇关于导出sql查询结果为csv或excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！