com.sh.common.csv

类 CSVWriter

java.lang.Object

com.sh.common.csv.CSVWriter

所有已实现的接口:

java.io.Closeable, java.lang.AutoCloseable

public class CSVWriter
extends java.lang.Object
implements java.io.Closeable

Description: 生成CSV文件 Title:首亨软件 - CRM、TSS、ERP等信息化管理软件

版本:

3.0

作者:

江兴春

字段概要

字段

限定符和类型	字段和说明
static char	DEFAULT_ESCAPE_CHARACTER
static java.lang.String	DEFAULT_LINE_END
static char	DEFAULT_QUOTE_CHARACTER
static char	DEFAULT_SEPARATOR
static int	INITIAL_STRING_SIZE
static char	NO_ESCAPE_CHARACTER
static char	NO_QUOTE_CHARACTER

构造器概要

构造器

构造器和说明
CSVWriter(java.io.Writer writer) Constructs CSVWriter using a comma for the separator.
CSVWriter(java.io.Writer writer, char separator) Constructs CSVWriter with supplied separator.
CSVWriter(java.io.Writer writer, char separator, char quotechar) Constructs CSVWriter with supplied separator and quote char.
CSVWriter(java.io.Writer writer, char separator, char quotechar, char escapechar) Constructs CSVWriter with supplied separator and quote char.
CSVWriter(java.io.Writer writer, char separator, char quotechar, char escapechar, java.lang.String lineEnd) Constructs CSVWriter with supplied separator, quote char, escape char and line ending.
CSVWriter(java.io.Writer writer, char separator, char quotechar, java.lang.String lineEnd) Constructs CSVWriter with supplied separator and quote char.

方法概要

限定符和类型	方法和说明
boolean	checkError() Checks to see if the there has been an error in the printstream.
void	close() 关闭流及缓存空间 Close the underlying stream writer flushing any buffered content.
void	flush() 刷新输出流
void	setResultService(ResultSetHelper resultService)
void	writeAll(java.util.List<java.lang.String[]> allLines) 将list中的数据写入CSV文件
void	writeAll(java.sql.ResultSet rs, boolean includeColumnNames) 将ResultSet中的数据写入CSV文件中
void	writeNext(java.lang.String[] nextLine) 加入新的一行

从类继承的方法 java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

INITIAL_STRING_SIZE

public static final int INITIAL_STRING_SIZE

另请参阅:

常量字段值

DEFAULT_ESCAPE_CHARACTER

public static final char DEFAULT_ESCAPE_CHARACTER

另请参阅:

常量字段值

DEFAULT_SEPARATOR

public static final char DEFAULT_SEPARATOR

另请参阅:

常量字段值

DEFAULT_QUOTE_CHARACTER

public static final char DEFAULT_QUOTE_CHARACTER

另请参阅:

常量字段值

NO_QUOTE_CHARACTER

public static final char NO_QUOTE_CHARACTER

另请参阅:

常量字段值

NO_ESCAPE_CHARACTER

public static final char NO_ESCAPE_CHARACTER

另请参阅:

常量字段值

DEFAULT_LINE_END

public static final java.lang.String DEFAULT_LINE_END

另请参阅:

常量字段值

构造器详细资料

CSVWriter

public CSVWriter(java.io.Writer writer)

Constructs CSVWriter using a comma for the separator.

参数:

writer - the writer to an underlying CSV source.

CSVWriter

public CSVWriter(java.io.Writer writer,
                 char separator)

Constructs CSVWriter with supplied separator.

参数:

writer - the writer to an underlying CSV source.

separator - the delimiter to use for separating entries.

CSVWriter

public CSVWriter(java.io.Writer writer,
                 char separator,
                 char quotechar)

Constructs CSVWriter with supplied separator and quote char.

参数:

writer - the writer to an underlying CSV source.

separator - the delimiter to use for separating entries

quotechar - the character to use for quoted elements

CSVWriter

public CSVWriter(java.io.Writer writer,
                 char separator,
                 char quotechar,
                 char escapechar)

Constructs CSVWriter with supplied separator and quote char.

参数:

writer - the writer to an underlying CSV source.

separator - the delimiter to use for separating entries

quotechar - the character to use for quoted elements

escapechar - the character to use for escaping quotechars or escapechars

CSVWriter

public CSVWriter(java.io.Writer writer,
                 char separator,
                 char quotechar,
                 java.lang.String lineEnd)

Constructs CSVWriter with supplied separator and quote char.

参数:

writer - the writer to an underlying CSV source.

separator - the delimiter to use for separating entries

quotechar - the character to use for quoted elements

lineEnd - the line feed terminator to use

CSVWriter

public CSVWriter(java.io.Writer writer,
                 char separator,
                 char quotechar,
                 char escapechar,
                 java.lang.String lineEnd)

Constructs CSVWriter with supplied separator, quote char, escape char and line ending.

参数:

writer - the writer to an underlying CSV source.

separator - the delimiter to use for separating entries

quotechar - the character to use for quoted elements

escapechar - the character to use for escaping quotechars or escapechars

lineEnd - the line feed terminator to use

方法详细资料

writeAll

public void writeAll(java.util.List<java.lang.String[]> allLines)

将list中的数据写入CSV文件

参数:

allLines - 存放String[]对象的List对象

writeAll

public void writeAll(java.sql.ResultSet rs,
                     boolean includeColumnNames)
              throws java.sql.SQLException,
                     java.io.IOException

将ResultSet中的数据写入CSV文件中

参数:

rs - the recordset to write

includeColumnNames - true if you want column names in the output, false otherwise

抛出:

java.sql.SQLException - SQLException

java.io.IOException - IOException

writeNext

public void writeNext(java.lang.String[] nextLine)

加入新的一行

参数:

nextLine - a string array with each comma-separated element as a separate entry

flush

public void flush()
           throws java.io.IOException

刷新输出流

抛出:

java.io.IOException - IOException

close

public void close()
           throws java.io.IOException

关闭流及缓存空间 Close the underlying stream writer flushing any buffered content.

指定者:

close 在接口中 java.io.Closeable

指定者:

close 在接口中 java.lang.AutoCloseable

抛出:

java.io.IOException - IOException

checkError

public boolean checkError()

Checks to see if the there has been an error in the printstream.

返回:

boolean

setResultService

public void setResultService(ResultSetHelper resultService)