Package org.relique.jdbc.csv

Class StringConverter

java.lang.Object

org.relique.jdbc.csv.StringConverter

public class StringConverter
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static String	COLUMN_NAME

Constructor Summary

Constructors

Constructor	Description
StringConverter(String dateformat, String timeformat, String timestampformat, String timeZoneName, boolean useDateTimeFormatter)
StringConverter(String dateformat, String timeformat, String timestampformat, String timeZoneName, Locale locale, boolean useDateTimeFormatter)

Method Summary

Modifier and Type	Method	Description
Object	convert(String sqlTypeName, String stringRepresentation)
String	formatDate(Date d)	Create date string in format accepted by method parseDate.
String	formatTime(Time t)	Create time string in format accepted by method parseTime.
String	formatTimestamp(Timestamp timestamp)	Create timestamp string in format accepted by method parseTimestamp.
Class<?>	forSQLName(String sqlTypeName)
static Object	getLiteralForTypeName(String sqlTypeName)	Get a value that has the type of an SQL data type.
static List<Object[]>	getTypeInfo()
static String	getTypeNameForLiteral(Object literal)	Get SQL data type of an object.
String[]	inferColumnTypes(Object[] fieldValues)
InputStream	parseAsciiStream(String str)
BigDecimal	parseBigDecimal(String str)
Boolean	parseBoolean(String str)
Byte	parseByte(String str)
byte[]	parseBytes(String str)
Date	parseDate(String str)
Double	parseDouble(String str)
Float	parseFloat(String str)
Integer	parseInt(String str)
Long	parseLong(String str)
Number	parseNumberPattern(String value, String pattern)	Parse number from string using a java.text.DecimalFormat pattern.
Short	parseShort(String str)
String	parseString(String str)
Time	parseTime(String str)
Timestamp	parseTimestamp(String str)
static String	removeQuotes(String string)

Methods inherited from class java.lang.Object

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

Field Detail

COLUMN_NAME

public static final String COLUMN_NAME

See Also:

Constant Field Values

Constructor Detail

StringConverter

public StringConverter(String dateformat,
                       String timeformat,
                       String timestampformat,
                       String timeZoneName,
                       boolean useDateTimeFormatter)

StringConverter

public StringConverter(String dateformat,
                       String timeformat,
                       String timestampformat,
                       String timeZoneName,
                       Locale locale,
                       boolean useDateTimeFormatter)

Method Detail

parseString

public String parseString(String str)

parseBoolean

public Boolean parseBoolean(String str)

parseByte

public Byte parseByte(String str)

parseShort

public Short parseShort(String str)

parseInt

public Integer parseInt(String str)

parseLong

public Long parseLong(String str)

parseFloat

public Float parseFloat(String str)

parseDouble

public Double parseDouble(String str)

parseBytes

public byte[] parseBytes(String str)

parseBigDecimal

public BigDecimal parseBigDecimal(String str)

parseDate

public Date parseDate(String str)

formatDate

public String formatDate(Date d)

Create date string in format accepted by method parseDate.

Parameters:

d - date to format.

Returns:

formatted date.

parseTime

public Time parseTime(String str)

formatTime

public String formatTime(Time t)

Create time string in format accepted by method parseTime.

Parameters:

t - time to format.

Returns:

formatted time.

parseTimestamp

public Timestamp parseTimestamp(String str)

formatTimestamp

public String formatTimestamp(Timestamp timestamp)

Create timestamp string in format accepted by method parseTimestamp.

Parameters:

timestamp - timestamp to format.

Returns:

formatted timestamp.

parseAsciiStream

public InputStream parseAsciiStream(String str)

convert

public Object convert(String sqlTypeName,
                      String stringRepresentation)

forSQLName

public Class<?> forSQLName(String sqlTypeName)

getLiteralForTypeName

public static Object getLiteralForTypeName(String sqlTypeName)

Get a value that has the type of an SQL data type.

Parameters:

sqlTypeName - name of SQL data type.

Returns:

a constant value with this data type.

getTypeNameForLiteral

public static String getTypeNameForLiteral(Object literal)

Get SQL data type of an object.

Parameters:

literal - object to get SQL data type for.

Returns:

SQL data type name.

getTypeInfo

public static List<Object[]> getTypeInfo()

removeQuotes

public static String removeQuotes(String string)

inferColumnTypes

public String[] inferColumnTypes(Object[] fieldValues)

parseNumberPattern

public Number parseNumberPattern(String value,
                                 String pattern)

Parse number from string using a java.text.DecimalFormat pattern.

Parameters:

value - string to parse.

pattern - a java.text.DecimalFormat pattern for parsing string.

Returns:

parsed number, or NULL if complete string cannot be parsed to a number.