資源簡介
csv導出使用的使用的是univocity-parsers的支持類庫，sftp上傳采用的是jsch的類庫，兩者結合實現了數據導出成csv文件并上傳指定服務器
代碼片段和文件信息
package?com.csv;
import?java.io.ByteArrayInputStream;
import?java.io.ByteArrayOutputStream;
import?java.io.IOException;
import?java.io.OutputStream;
import?java.util.ArrayList;
import?java.util.List;
import?com.jcraft.jsch.SftpException;
import?com.univocity.parsers.csv.CsvFormat;
import?com.univocity.parsers.csv.CsvWriter;
import?com.univocity.parsers.csv.CsvWriterSettings;
public?class?CsvUploadDemo?{
/**
?*?創建csv文件
?*?@param?heads
?*?@param?rows
?*?@param?outPutPath
?*?@param?filename
?*?@param?outTemp
?*/
public?static?void?createCSVFile（String[]?heads?Listject[]>?rowsOutputStream?outTemp）
????{
????????try
????????{
???????? //設置csv格式
????????????CsvWriterSettings?settings?=?new?CsvWriterSettings（）;
????????????CsvFormat?format?=?sett ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-10-09?11:53??CsvDemo\
?????文件?????????606??2017-09-29?16:33??CsvDemo\.classpath
?????目錄???????????0??2017-09-28?10:19??CsvDemo\.myeclipse\
?????文件?????????294??2017-09-28?10:19??CsvDemo\.myme
?????文件????????1197??2017-09-28?10:19??CsvDemo\.project
?????目錄???????????0??2017-09-29?16:56??CsvDemo\.settings\
?????文件?????????500??2017-09-28?10:19??CsvDemo\.settings\.jsdtscope
?????文件?????????330??2017-09-28?10:19??CsvDemo\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2017-09-28?10:19??CsvDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-09-28?10:19??CsvDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-09-29?16:56??CsvDemo\src\
?????目錄???????????0??2017-09-29?16:56??CsvDemo\src\com\
?????目錄???????????0??2017-09-28?10:20??CsvDemo\src\com\comm\
?????目錄???????????0??2017-09-29?16:56??CsvDemo\src\com\csv\
?????文件????????2055??2017-09-29?16:55??CsvDemo\src\com\csv\CsvUploadDemo.java
?????文件????????7730??2017-09-29?16:48??CsvDemo\src\com\csv\SFTPUtil.java
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\
?????文件?????????834??2017-09-28?10:19??CsvDemo\WebRoot\index.jsp
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\me
?????文件??????????36??2017-09-28?10:19??CsvDemo\WebRoot\me
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\WEB-INF\
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-09-29?16:33??CsvDemo\WebRoot\WEB-INF\classes\com\comm\
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\WEB-INF\classes\com\csv\
?????文件????????2755??2017-09-29?16:55??CsvDemo\WebRoot\WEB-INF\classes\com\csv\CsvUploadDemo.class
?????文件????????4745??2017-09-29?16:48??CsvDemo\WebRoot\WEB-INF\classes\com\csv\SFTPUtil.class
?????目錄???????????0??2017-09-29?16:56??CsvDemo\WebRoot\WEB-INF\lib\
?????文件??????180376??2017-06-08?17:50??CsvDemo\WebRoot\WEB-INF\lib\com.jcraft.jsch_0.1.31.jar
?????文件???????61562??2017-06-08?17:50??CsvDemo\WebRoot\WEB-INF\lib\commons-io.jar
?????文件??????286125??2017-09-29?16:24??CsvDemo\WebRoot\WEB-INF\lib\univocity-parsers-2.0.2.jar
............此處省略2個文件信息
- 上一篇：xm
l＋jsp實現簡單留言板 - 下一篇：AS離線插件——simpleUML
評論
共有 條評論