資源簡介
java csv大數據量導出(千萬級別,不會內存溢出),多線程導出 ,生產環境已經很穩定的使用著
代碼片段和文件信息
package?com.onmusic.controller.junit.excel;
import?java.io.File;
import?java.io.IOException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Arrays;
import?java.util.Date;
import?java.util.List;
/**
?*?Created?with?IntelliJ?IDEA.
?*?User:?Administrator
?*?Date:?15-2-26
?*?Time:?上午11:31
?*?To?change?this?template?use?File?|?Settings?|?File?Templates.
?*/
public?class?CsvExport?{
????public?static?void?main(String[]?args)?throws?IOException?{
????????long?startTime?=?System.currentTimeMillis();
????????//?設置表格頭
????????object[]?head?=?{“序號““小說名稱““作者““出版日期“};
????????Listject>?headList?=?Arrays.asList(head);
????????Listject>>?dataList?=?getNovel();
????????//?導出文件路徑
????????String?downloadFilePath?=?“C:“?+?File.separator?+?“cap4j“?+?File.separator?+?“download“+File.separator;
????????//?導出文件名稱
????????String??fileName?=?“download“;
????????//?導出CSV文件
????????File?csvFile?=?CSVUtils.createCSVFile(headList?dataList?downloadFilePath?fileName);
????????long?endTime?=?System.currentTimeMillis();
????????System.out.println(“整個CSV導出“+(endTime-startTime));
????}
????private?static?Listject>>?getNovel()?{
????????Listject>>?dataList?=?new?ArrayListject>>();
????????Listject>?rowList?=?null;
????????for?(int?i?=?0;?i?16510000;?i++)?{
????????????rowList?=?new?ArrayListject>();
????????????object[]?row?=?new?object[4];
????????????row[0]?=?i;
????????????row[1]?=?“風云第一刀“+i+““;
????????????row[2]?=?“古龍“+i+““;
????????????row[3]?=?new?SimpleDateFormat(“yyyy-MM-dd?HH:mm:ss“).format(new?Date());
????????????for(int?j=0;j ????????????????rowList.add(row[j]);
????????????}
????????????dataList.add(rowList);
????????}
????????return?dataList;
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1908??2015-02-28?11:45??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\CsvExport.java
?????文件???????2721??2018-07-31?15:13??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\CsvExportBatch.java
?????文件???????3518??2015-02-28?16:08??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\CsvExportThread.java
?????文件???????2163??2018-07-31?15:13??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\CSVUtils.java
?????文件???????1301??2018-07-31?15:13??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\DownLoad.java
?????文件???????2642??2018-07-31?15:13??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\ExecutorThread.java
?????文件????????825??2018-07-31?15:12??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\Novel.java
?????文件???????1532??2018-07-31?15:12??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\ThreadPools.java
?????文件???????6317??2015-02-28?12:42??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\ZipUtil.java
?????文件??????????0??2018-11-19?10:24??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出\千萬級別導出.txt
?????目錄??????????0??2018-11-19?10:24??java中csv大數據(千萬級別)導出\java中csv大數據(千萬級別)導出
?????目錄??????????0??2018-11-19?10:12??java中csv大數據(千萬級別)導出
-----------?---------??----------?-----??----
????????????????22927????????????????????12
評論
共有 條評論