opencsv 5.12.0 · com.opencsv.ResultSetHelperService · APIdia, the JavaDoc alternative

Modifier and Type	Field and Description
protected static final int	CLOBBUFFERSIZE
protected String	dateFormat
protected String	dateTimeFormat
pack-priv static final String	DEFAULT_DATE_FORMAT
pack-priv static final String	DEFAULT_TIMESTAMP_FORMAT
protected NumberFormat	floatingPointFormat
protected NumberFormat	integerFormat
private static final String	NULL_DEFAULT_VALUE
protected String	nullDefault

Access	Constructor and Description
public	ResultSetHelperService() Default constructor.

Method Summary

Modifier and Type	Method and Description
private String	applyFormatter(NumberFormat formatter, Number value)
public String[]	getColumnNames(ResultSet rs) Implements com.opencsv.ResultSetHelper.getColumnNames. Returns the column names from the ResultSet.
private String	getColumnValue(ResultSet rs, int colType, int colIndex, boolean trim, String dateFormatString, String timestampFormatString)
public String[]	getColumnValues(ResultSet rs) Implements com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set.
public String[]	getColumnValues(ResultSet rs, boolean trim) Implements com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set with the values trimmed if desired.
public String[]	getColumnValues(ResultSet rs, boolean trim, String dateFormatString, String timeFormatString) Implements com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set with the values trimmed if desired.
protected String	Returns: the data in the Clob as a string. handleClob(ResultSet - result set rs, int - column location of the data in the result set colIndex) retrieves the data out of a CLOB
protected String	Returns: - a string representing the data from the result set in the format set in dateFomratString. handleDate(ResultSet - result set rs, int - column location of the data in the result set colIndex, String - desired format of the date dateFormatString) retrieves an date from a result set
protected String	Returns: the data in the NCLOB as a string. handleNClob(ResultSet - result set rs, int - column location of the data in the result set colIndex) retrieves the data out of a NCLOB
protected String	Returns: a string representing the NVarChar from the result set handleNVarChar(ResultSet - result set rs, int - column location of the data in the result set colIndex, boolean - should the value be trimmed before being returned trim) retrieves the data from an NVarChar in a result set
protected String	Returns: Formatted time stamp. handleTimestamp(Timestamp Timestamp read from resultset timestamp, String Format string timestampFormatString) The formatted timestamp.
protected String	Returns: a string representing the VarChar from the result set handleVarChar(ResultSet - result set rs, int - column location of the data in the result set colIndex, boolean - should the value be trimmed before being returned trim) retrieves the data from an VarChar in a result set
public void	setDateFormat(String Desired date format dateFormat) Set a default date format pattern that will be used by the service.
public void	setDateTimeFormat(String Desired date time format dateTimeFormat) Set a default date time format pattern that will be used by the service.
public void	setFloatingPointFormat(NumberFormat Desired number format. Should not be null format) Set a default number formatter for integer numbers that will be used by the service.
public void	setIntegerFormat(NumberFormat Desired number format. Should not be null format) Set a default number formatter for floating point numbers that will be used by the service.
public void	setNullDefault(String nullDefault) Set a default value that will be used when column value is null.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

CLOBBUFFERSIZE	back to summary
protected static final int CLOBBUFFERSIZE

dateFormat	back to summary
protected String dateFormat

dateTimeFormat	back to summary
protected String dateTimeFormat

DEFAULT_DATE_FORMAT	back to summary
pack-priv static final String DEFAULT_DATE_FORMAT

DEFAULT_TIMESTAMP_FORMAT	back to summary
pack-priv static final String DEFAULT_TIMESTAMP_FORMAT

floatingPointFormat	back to summary
protected NumberFormat floatingPointFormat

integerFormat	back to summary
protected NumberFormat integerFormat

NULL_DEFAULT_VALUE	back to summary
private static final String NULL_DEFAULT_VALUE

nullDefault	back to summary
protected String nullDefault

ResultSetHelperService	back to summary
public ResultSetHelperService() Default constructor.

Method Detail

applyFormatter	back to summary
private String applyFormatter(NumberFormat formatter, Number value)

getColumnNames	back to summary
public String[] getColumnNames(ResultSet rs) throws SQLException Implements com.opencsv.ResultSetHelper.getColumnNames. Doc from com.opencsv.ResultSetHelper.getColumnNames. Returns the column names from the ResultSet. Annotations @Override Exceptions SQLException: Thrown by the ResultSet.

getColumnNames

back to summary

public String[] getColumnNames(ResultSet rs) throws SQLException

Implements com.opencsv.ResultSetHelper.getColumnNames.

Doc from com.opencsv.ResultSetHelper.getColumnNames.

Returns the column names from the ResultSet.

Annotations

@Override

Exceptions

SQLException:: Thrown by the ResultSet.

getColumnValue	back to summary
private String getColumnValue(ResultSet rs, int colType, int colIndex, boolean trim, String dateFormatString, String timestampFormatString) throws SQLException, IOException

getColumnValues	back to summary
public String[] getColumnValues(ResultSet rs) throws SQLException, IOException Implements com.opencsv.ResultSetHelper.getColumnValues. Doc from com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set. Annotations @Override Exceptions SQLException: Thrown by the ResultSet. IOException: Thrown by the ResultSet.

getColumnValues

back to summary

public String[] getColumnValues(ResultSet rs) throws SQLException, IOException

Implements com.opencsv.ResultSetHelper.getColumnValues.

Doc from com.opencsv.ResultSetHelper.getColumnValues.

Returns the column values from the result set.

Annotations

@Override

Exceptions

SQLException:: Thrown by the ResultSet.
IOException:: Thrown by the ResultSet.

getColumnValues	back to summary
public String[] getColumnValues(ResultSet rs, boolean trim) throws SQLException, IOException Implements com.opencsv.ResultSetHelper.getColumnValues. Doc from com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set with the values trimmed if desired. Annotations @Override Exceptions SQLException: Thrown by the ResultSet. IOException: Thrown by the ResultSet.

getColumnValues

back to summary

public String[] getColumnValues(ResultSet rs, boolean trim) throws SQLException, IOException

Implements com.opencsv.ResultSetHelper.getColumnValues.

Doc from com.opencsv.ResultSetHelper.getColumnValues.

Returns the column values from the result set with the values trimmed if desired.

Annotations

@Override

Exceptions

SQLException:: Thrown by the ResultSet.
IOException:: Thrown by the ResultSet.

getColumnValues	back to summary
public String[] getColumnValues(ResultSet rs, boolean trim, String dateFormatString, String timeFormatString) throws SQLException, IOException Implements com.opencsv.ResultSetHelper.getColumnValues. Doc from com.opencsv.ResultSetHelper.getColumnValues. Returns the column values from the result set with the values trimmed if desired. Also format the date and time columns based on the format strings passed in. Annotations @Override Exceptions SQLException: Thrown by the ResultSet. IOException: Thrown by the ResultSet.

getColumnValues

back to summary

public String[] getColumnValues(ResultSet rs, boolean trim, String dateFormatString, String timeFormatString) throws SQLException, IOException

Implements com.opencsv.ResultSetHelper.getColumnValues.

Doc from com.opencsv.ResultSetHelper.getColumnValues.

Returns the column values from the result set with the values trimmed if desired. Also format the date and time columns based on the format strings passed in.

Annotations

@Override

Exceptions

SQLException:: Thrown by the ResultSet.
IOException:: Thrown by the ResultSet.

handleClob	back to summary
protected String handleClob(ResultSet rs, int colIndex) throws SQLException, IOException retrieves the data out of a CLOB Parameters rs:ResultSet - result set colIndex:int - column location of the data in the result set Returns:String the data in the Clob as a string.

handleClob

back to summary

protected String handleClob(ResultSet rs, int colIndex) throws SQLException, IOException

retrieves the data out of a CLOB

Parameters

rs:ResultSet: - result set
colIndex:int: - column location of the data in the result set

Returns:String

the data in the Clob as a string.

handleDate	back to summary
protected String handleDate(ResultSet rs, int colIndex, String dateFormatString) throws SQLException retrieves an date from a result set Parameters rs:ResultSet - result set colIndex:int - column location of the data in the result set dateFormatString:String - desired format of the date Returns:String - a string representing the data from the result set in the format set in dateFomratString.

handleDate

back to summary

protected String handleDate(ResultSet rs, int colIndex, String dateFormatString) throws SQLException

retrieves an date from a result set

Parameters

rs:ResultSet: - result set
colIndex:int: - column location of the data in the result set
dateFormatString:String: - desired format of the date

Returns:String

- a string representing the data from the result set in the format set in dateFomratString.

handleNClob	back to summary
protected String handleNClob(ResultSet rs, int colIndex) throws SQLException, IOException retrieves the data out of a NCLOB Parameters rs:ResultSet - result set colIndex:int - column location of the data in the result set Returns:String the data in the NCLOB as a string.

handleNClob

back to summary

protected String handleNClob(ResultSet rs, int colIndex) throws SQLException, IOException

retrieves the data out of a NCLOB

Parameters

rs:ResultSet: - result set
colIndex:int: - column location of the data in the result set

Returns:String

the data in the NCLOB as a string.

handleNVarChar	back to summary
protected String handleNVarChar(ResultSet rs, int colIndex, boolean trim) throws SQLException retrieves the data from an NVarChar in a result set Parameters rs:ResultSet - result set colIndex:int - column location of the data in the result set trim:boolean - should the value be trimmed before being returned Returns:String a string representing the NVarChar from the result set

handleNVarChar

back to summary

protected String handleNVarChar(ResultSet rs, int colIndex, boolean trim) throws SQLException

retrieves the data from an NVarChar in a result set

Parameters

rs:ResultSet: - result set
colIndex:int: - column location of the data in the result set
trim:boolean: - should the value be trimmed before being returned

Returns:String

a string representing the NVarChar from the result set

handleTimestamp	back to summary
protected String handleTimestamp(Timestamp timestamp, String timestampFormatString) The formatted timestamp. Parameters timestamp:Timestamp Timestamp read from resultset timestampFormatString:String Format string Returns:String Formatted time stamp.

handleTimestamp

back to summary

protected String handleTimestamp(Timestamp timestamp, String timestampFormatString)

The formatted timestamp.

Parameters

timestamp:Timestamp: Timestamp read from resultset
timestampFormatString:String: Format string

Returns:String

Formatted time stamp.

handleVarChar	back to summary
protected String handleVarChar(ResultSet rs, int colIndex, boolean trim) throws SQLException retrieves the data from an VarChar in a result set Parameters rs:ResultSet - result set colIndex:int - column location of the data in the result set trim:boolean - should the value be trimmed before being returned Returns:String a string representing the VarChar from the result set

handleVarChar

back to summary

protected String handleVarChar(ResultSet rs, int colIndex, boolean trim) throws SQLException

retrieves the data from an VarChar in a result set

Parameters

rs:ResultSet: - result set
colIndex:int: - column location of the data in the result set
trim:boolean: - should the value be trimmed before being returned

Returns:String

a string representing the VarChar from the result set

setDateFormat	back to summary
public void setDateFormat(String dateFormat) Set a default date format pattern that will be used by the service. Parameters dateFormat:String Desired date format

setDateFormat

back to summary

public void setDateFormat(String dateFormat)

Set a default date format pattern that will be used by the service.

Parameters

dateFormat:String: Desired date format

setDateTimeFormat	back to summary
public void setDateTimeFormat(String dateTimeFormat) Set a default date time format pattern that will be used by the service. Parameters dateTimeFormat:String Desired date time format

setDateTimeFormat

back to summary

public void setDateTimeFormat(String dateTimeFormat)

Set a default date time format pattern that will be used by the service.

Parameters

dateTimeFormat:String: Desired date time format

setFloatingPointFormat	back to summary
public void setFloatingPointFormat(NumberFormat format) Set a default number formatter for integer numbers that will be used by the service. Parameters format:NumberFormat Desired number format. Should not be null

setFloatingPointFormat

back to summary

public void setFloatingPointFormat(NumberFormat format)

Set a default number formatter for integer numbers that will be used by the service.

Parameters

format:NumberFormat: Desired number format. Should not be null

setIntegerFormat	back to summary
public void setIntegerFormat(NumberFormat format) Set a default number formatter for floating point numbers that will be used by the service. Parameters format:NumberFormat Desired number format. Should not be null

setIntegerFormat

back to summary

public void setIntegerFormat(NumberFormat format)

Set a default number formatter for floating point numbers that will be used by the service.

Parameters

format:NumberFormat: Desired number format. Should not be null

setNullDefault	back to summary
public void setNullDefault(String nullDefault) Set a default value that will be used when column value is null.

public Class ResultSetHelperService

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail