Modifier and Type | Field and Description |
---|---|
private static SimpleDateFormat |
DATE_FORMATTER |
static char |
DEFAULT_ESCAPE_CHARACTER
The character used for escaping quotes.
|
static String |
DEFAULT_LINE_END
Default line terminator uses platform encoding.
|
static char |
DEFAULT_QUOTE_CHARACTER
The default quote character to use if none is supplied to the
constructor.
|
static char |
DEFAULT_SEPARATOR
The default separator to use if none is supplied to the constructor.
|
private char |
escapechar |
private String |
lineEnd |
static char |
NO_ESCAPE_CHARACTER
The escape constant to use when you wish to suppress all escaping.
|
static char |
NO_QUOTE_CHARACTER
The quote constant to use when you wish to suppress all quoting.
|
private PrintWriter |
pw |
private char |
quotechar |
private Writer |
rawWriter |
private char |
separator |
private static SimpleDateFormat |
TIMESTAMP_FORMATTER |
Constructor and Description |
---|
CSVWriter(Writer writer)
Constructs CSVWriter using a comma for the separator.
|
CSVWriter(Writer writer,
char separator)
Constructs CSVWriter with supplied separator.
|
CSVWriter(Writer writer,
char separator,
char quotechar)
Constructs CSVWriter with supplied separator and quote char.
|
CSVWriter(Writer writer,
char separator,
char quotechar,
char escapechar)
Constructs CSVWriter with supplied separator and quote char.
|
CSVWriter(Writer writer,
char separator,
char quotechar,
char escapechar,
String lineEnd)
Constructs CSVWriter with supplied separator, quote char, escape char and line ending.
|
CSVWriter(Writer writer,
char separator,
char quotechar,
String lineEnd)
Constructs CSVWriter with supplied separator and quote char.
|
Modifier and Type | Method and Description |
---|---|
void |
close()
Close the underlying stream writer flushing any buffered content.
|
void |
flush()
Flush underlying stream to writer.
|
private static String |
getColumnValue(ResultSet rs,
int colType,
int colIndex) |
private static String |
read(Clob c) |
void |
writeAll(List allLines)
Writes the entire list to a CSV file.
|
void |
writeAll(ResultSet rs,
boolean includeColumnNames)
Writes the entire ResultSet to a CSV file.
|
protected void |
writeColumnNames(ResultSetMetaData metadata) |
void |
writeNext(String[] nextLine)
Writes the next line to the file.
|
private PrintWriter pw
private char separator
private char quotechar
private char escapechar
public static final char DEFAULT_ESCAPE_CHARACTER
public static final char DEFAULT_SEPARATOR
public static final char DEFAULT_QUOTE_CHARACTER
public static final char NO_QUOTE_CHARACTER
public static final char NO_ESCAPE_CHARACTER
public static final String DEFAULT_LINE_END
private static final SimpleDateFormat TIMESTAMP_FORMATTER
private static final SimpleDateFormat DATE_FORMATTER
public CSVWriter(Writer writer)
writer
- the writer to an underlying CSV source.public CSVWriter(Writer writer, char separator)
writer
- the writer to an underlying CSV source.separator
- the delimiter to use for separating entries.public CSVWriter(Writer writer, char separator, char quotechar)
writer
- the writer to an underlying CSV source.separator
- the delimiter to use for separating entriesquotechar
- the character to use for quoted elementspublic CSVWriter(Writer writer, char separator, char quotechar, char escapechar)
writer
- the writer to an underlying CSV source.separator
- the delimiter to use for separating entriesquotechar
- the character to use for quoted elementsescapechar
- the character to use for escaping quotechars or escapecharspublic CSVWriter(Writer writer, char separator, char quotechar, String lineEnd)
writer
- the writer to an underlying CSV source.separator
- the delimiter to use for separating entriesquotechar
- the character to use for quoted elementslineEnd
- the line feed terminator to usepublic CSVWriter(Writer writer, char separator, char quotechar, char escapechar, String lineEnd)
writer
- the writer to an underlying CSV source.separator
- the delimiter to use for separating entriesquotechar
- the character to use for quoted elementsescapechar
- the character to use for escaping quotechars or escapecharslineEnd
- the line feed terminator to usepublic void writeAll(List allLines)
allLines
- a List of String[], with each String[] representing a line of
the file.protected void writeColumnNames(ResultSetMetaData metadata) throws SQLException
SQLException
public void writeAll(ResultSet rs, boolean includeColumnNames) throws SQLException, IOException
rs
- the recordset to writeincludeColumnNames
- true if you want column names in the output, false otherwiseSQLException
IOException
private static String getColumnValue(ResultSet rs, int colType, int colIndex) throws SQLException, IOException
SQLException
IOException
private static String read(Clob c) throws SQLException, IOException
SQLException
IOException
public void writeNext(String[] nextLine)
nextLine
- a string array with each comma-separated element as a separate
entry.public void flush() throws IOException
IOException
- if bad things happenpublic void close() throws IOException
IOException
- if bad things happenWebARTS Library Licensed Under the GNU - General Public License. Other Libraries licensed under their respective Open Source Licenses