Package org.supercsv.io
Interface ICsvResultSetWriter
- All Superinterfaces:
AutoCloseable
,Closeable
,Flushable
,ICsvWriter
- All Known Implementing Classes:
CsvResultSetWriter
Interface for CSV writers writing JDBC
ResultSet
- Since:
- 2.4.0
-
Method Summary
Modifier and TypeMethodDescriptionvoid
Writes a JDBCResultSet
as a CSV file.void
write
(ResultSet resultSet, CellProcessor[] cellProcessors) Writes a JDBCResultSet
as a CSV file.Methods inherited from interface org.supercsv.io.ICsvWriter
getLineNumber, getRowNumber, writeComment, writeHeader
-
Method Details
-
write
Writes a JDBCResultSet
as a CSV file. Each column in CSV file corresponds to a column inResultSet
, column order is preserved. Column names in CSV file corresponds to column names stored inResultSetMetaData
.toString
will be called on each element prior to writing.- Parameters:
resultSet
- ResultSet containing the values to write- Throws:
SQLException
- if a database access error occurs or this method is called on a closed result setIOException
- if an I/O error occurredNullPointerException
- if resultSet is nullSuperCsvException
- if there was a general exception while writing- Since:
- 2.4.0
-
write
Writes a JDBCResultSet
as a CSV file. Each column in CSV file corresponds to a column inResultSet
, column order is preserved. Column names in CSV file corresponds to column names stored inResultSetMetaData
.toString
will be called on each (processed) element prior to writing.- Parameters:
resultSet
- ResultSet containing the values to writecellProcessors
- Array of CellProcessors used to further process data before it is written (each element in the processors array corresponds with a CSV column - the number of processors should match the number of columns). Anull
entry indicates no further processing is required (the value returned by toString() will be written as the column value).- Throws:
SQLException
- if a database access error occurs or this method is called on a closed result setIOException
- if an I/O error occurredNullPointerException
- if resultSet or cellProcessors is nullSuperCsvConstraintViolationException
- if a CellProcessor constraint failedSuperCsvException
- if there was a general exception while writing/processing- Since:
- 2.4.0
-