Module com.aoapps.sql

Package com.aoapps.sql

Class SQLUtility

java.lang.Object

com.aoapps.sql.SQLUtility

public final class SQLUtility
extends Object

SQL utilities.

Author:

AO Industries, Inc.

Field Summary

Fields

Modifier and Type	Field	Description
static final long	MAX_TIMESTAMP_SECONDS	The maximum number of seconds in a Timestamp.
static final long	MIN_TIMESTAMP_SECONDS	The minimum number of seconds in a Timestamp.

Method Summary

Modifier and Type	Method	Description
static String	formatDate(long time)
static String	formatDate(long time, TimeZone timeZone)
static String	formatDate(Long time)
static String	formatDate(Long time, TimeZone timeZone)
static String	formatDate(Date date)
static String	formatDate(Date date, TimeZone timeZone)
static String	formatDateTime(long time)
static String	formatDateTime(long time, TimeZone timeZone)
static String	formatDateTime(Long time)
static String	formatDateTime(Long time, TimeZone timeZone)
static String	formatDateTime(Date date)
static String	formatDateTime(Date date, TimeZone timeZone)
static String	formatDecimal2(int pennies)	Converts a number of pennies into decimal representation.
static String	formatDecimal2(long pennies)	Converts a number of pennies into decimal representation.
static String	formatDecimal3(int millis)	Converts a number of millis into decimal representation.
static String	formatDecimal3(long millis)	Converts a number of millis into decimal representation.
static String	formatTime(long time)
static String	formatTime(long time, TimeZone timeZone)
static String	formatTime(Long time)
static String	formatTime(Long time, TimeZone timeZone)
static String	formatTime(Date date)
static String	formatTime(Date date, TimeZone timeZone)
static Timestamp	newTimestamp(long seconds, int nanos)	Converts a number of seconds and nanoseconds into a new Timestamp.
static <Ex extends Throwable> Timestamp	newTimestamp(long seconds, int nanos, Class<? extends Ex> exClass)	Deprecated. Please use newTimestamp(long, int, java.util.function.Function), typically with lambda constructor reference
static <Ex extends Throwable> Timestamp	newTimestamp(long seconds, int nanos, Function<? super String,? extends Ex> exSupplier)	Converts a number of seconds and nanoseconds into a new Timestamp.
static UnmodifiableTimestamp	newUnmodifiableTimestamp(long seconds, int nanos)	Converts a number of seconds and nanoseconds into a new UnmodifiableTimestamp.
static <Ex extends Throwable> UnmodifiableTimestamp	newUnmodifiableTimestamp(long seconds, int nanos, Class<? extends Ex> exClass)	Deprecated. Please use newUnmodifiableTimestamp(long, int, java.util.function.Function), typically with lambda constructor reference
static <Ex extends Throwable> UnmodifiableTimestamp	newUnmodifiableTimestamp(long seconds, int nanos, Function<? super String,? extends Ex> exSupplier)	Converts a number of seconds and nanoseconds into a new UnmodifiableTimestamp.
static Date	parseDate(String yyyy_mm_dd)
static Date	parseDate(String yyyy_mm_dd, TimeZone timeZone)
static Timestamp	parseDateTime(String dateTime)
static Timestamp	parseDateTime(String dateTime, TimeZone timeZone)
static int	parseDecimal2(String decimal2)	Gets the number of pennies represented by a String containing a decimal(?,2) type.
static int	parseDecimal3(String decimal3)	Gets the number of millis represented by a String containing a decimal(?,3) type.
static long	parseLongDecimal2(String decimal2)	Gets the number of pennies represented by a String containing a decimal(?,2) type.
static long	parseLongDecimal3(String decimal3)	Gets the number of millis represented by a String containing a decimal(?,3) type.
static void	printTable(Object[] titles, Iterable<? extends Object[]> rows, Appendable out, boolean isInteractive, boolean[] alignRights)	Prints a table.
static void	printTable(Object[] titles, Object[] values, Appendable out, boolean isInteractive, boolean[] alignRights)	Deprecated. Please use printTable(java.lang.Object[], java.lang.Iterable, java.lang.Appendable, boolean, boolean[]) when possible, as it may provide for more efficiency on large datasets.
static void	printTable(Object[] titles, Collection<Object> values, Appendable out, boolean isInteractive, boolean[] alignRights)	Deprecated. Please use printTable(java.lang.Object[], java.lang.Iterable, java.lang.Appendable, boolean, boolean[]) when possible, as it may provide for more efficiency on large datasets.
static void	toTimestamp(long seconds, int nanos, Timestamp ts)	Converts a number of seconds and nanoseconds into a given Timestamp.
static <Ex extends Throwable> void	toTimestamp(long seconds, int nanos, Timestamp ts, Class<? extends Ex> exClass)	Deprecated. Please use toTimestamp(long, int, java.sql.Timestamp, java.util.function.Function), typically with lambda constructor reference
static <Ex extends Throwable> void	toTimestamp(long seconds, int nanos, Timestamp ts, Function<? super String,? extends Ex> exSupplier)	Converts a number of seconds and nanoseconds into a given Timestamp.

Methods inherited from class java.lang.Object

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

Field Details

MAX_TIMESTAMP_SECONDS

public static final long MAX_TIMESTAMP_SECONDS

The maximum number of seconds in a Timestamp.

See Also:

• Constant Field Values

MIN_TIMESTAMP_SECONDS

public static final long MIN_TIMESTAMP_SECONDS

The minimum number of seconds in a Timestamp.

See Also:

• Constant Field Values

Method Details

formatDate

public static String formatDate(long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

formatDate

public static String formatDate(long time)

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

formatDate

public static String formatDate(Long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

formatDate

public static String formatDate(Long time)

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

formatDate

public static String formatDate(Date date,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

formatDate

public static String formatDate(Date date)

See Also:

• CalendarUtils.formatDate(java.util.Calendar)

parseDate

public static Date parseDate(String yyyy_mm_dd,
 TimeZone timeZone)
                      throws IllegalArgumentException

Parameters:

yyyy_mm_dd - The date in YYYY-MM-DD format.

timeZone - The time zone to use or null to use the default time zone

Throws:

IllegalArgumentException

See Also:

• CalendarUtils.parseDate(java.lang.String, java.util.TimeZone)

parseDate

public static Date parseDate(String yyyy_mm_dd)
                      throws IllegalArgumentException

Parameters:

yyyy_mm_dd - The date in YYYY-MM-DD format.

Throws:

IllegalArgumentException

See Also:

• CalendarUtils.parseDate(java.lang.String)

formatDateTime

public static String formatDateTime(long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

formatDateTime

public static String formatDateTime(long time)

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

formatDateTime

public static String formatDateTime(Long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

formatDateTime

public static String formatDateTime(Long time)

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

formatDateTime

public static String formatDateTime(Date date,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

formatDateTime

public static String formatDateTime(Date date)

See Also:

• CalendarUtils.formatDateTime(java.util.Calendar)

parseDateTime

public static Timestamp parseDateTime(String dateTime,
 TimeZone timeZone)
                               throws IllegalArgumentException

Parameters:

timeZone - The time zone to use or null to use the default time zone

Throws:

IllegalArgumentException

See Also:

• CalendarUtils.parseDateTime(java.lang.String, java.util.TimeZone, com.aoapps.lang.util.CalendarUtils.DateTimeProducer)

parseDateTime

public static Timestamp parseDateTime(String dateTime)
                               throws IllegalArgumentException

Throws:

IllegalArgumentException

See Also:

• CalendarUtils.parseDateTime(java.lang.String)

formatTime

public static String formatTime(long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatTime

public static String formatTime(long time)

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatTime

public static String formatTime(Long time,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatTime

public static String formatTime(Long time)

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatTime

public static String formatTime(Date date,
 TimeZone timeZone)

Parameters:

timeZone - The time zone to use or null to use the default time zone

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatTime

public static String formatTime(Date date)

See Also:

• CalendarUtils.formatTime(java.util.Calendar)

formatDecimal2

public static String formatDecimal2(int pennies)

Converts a number of pennies into decimal representation.

formatDecimal2

public static String formatDecimal2(long pennies)

Converts a number of pennies into decimal representation.

parseDecimal2

public static int parseDecimal2(String decimal2)

Gets the number of pennies represented by a String containing a decimal(?,2) type.

parseLongDecimal2

public static long parseLongDecimal2(String decimal2)

Gets the number of pennies represented by a String containing a decimal(?,2) type.

formatDecimal3

public static String formatDecimal3(int millis)

Converts a number of millis into decimal representation.

formatDecimal3

public static String formatDecimal3(long millis)

Converts a number of millis into decimal representation.

parseDecimal3

public static int parseDecimal3(String decimal3)

Gets the number of millis represented by a String containing a decimal(?,3) type.

parseLongDecimal3

public static long parseLongDecimal3(String decimal3)

Gets the number of millis represented by a String containing a decimal(?,3) type.

printTable

public static void printTable(Object[] titles,
 Iterable<? extends Object[]> rows,
 Appendable out,
 boolean isInteractive,
 boolean[] alignRights)
                       throws IOException

Prints a table.

Parameters:

titles - Optional titles to display

rows - Iterated once in non-interactive mode. Iterated twice in interactive mode (first to find widest columns, then to display output). Must provide consistent output when iterated twice for interactive mode.

Throws:

IOException

printTable

@Deprecated
public static void printTable(Object[] titles,
 Collection<Object> values,
 Appendable out,
 boolean isInteractive,
 boolean[] alignRights)
                       throws IOException

Deprecated.

Please use printTable(java.lang.Object[], java.lang.Iterable, java.lang.Appendable, boolean, boolean[]) when possible, as it may provide for more efficiency on large datasets.

Parameters:

values - One element for each row and column

Throws:

IOException

printTable

@Deprecated
public static void printTable(Object[] titles,
 Object[] values,
 Appendable out,
 boolean isInteractive,
 boolean[] alignRights)
                       throws IOException

Deprecated.

Please use printTable(java.lang.Object[], java.lang.Iterable, java.lang.Appendable, boolean, boolean[]) when possible, as it may provide for more efficiency on large datasets.

Parameters:

values - One element for each row and column

Throws:

IOException

toTimestamp

public static <Ex extends Throwable> void toTimestamp(long seconds,
 int nanos,
 Timestamp ts,
 Function<? super String,? extends Ex> exSupplier)
                                               throws Ex

Converts a number of seconds and nanoseconds into a given Timestamp.

Throws:

Ex

toTimestamp

@Deprecated
public static <Ex extends Throwable> void toTimestamp(long seconds,
 int nanos,
 Timestamp ts,
 Class<? extends Ex> exClass)
                                               throws Ex

Deprecated.

Please use toTimestamp(long, int, java.sql.Timestamp, java.util.function.Function), typically with lambda constructor reference

Converts a number of seconds and nanoseconds into a given Timestamp.

Throws:

Ex

toTimestamp

public static void toTimestamp(long seconds,
 int nanos,
 Timestamp ts)

Converts a number of seconds and nanoseconds into a given Timestamp.

newTimestamp

public static <Ex extends Throwable> Timestamp newTimestamp(long seconds,
 int nanos,
 Function<? super String,? extends Ex> exSupplier)
                                                     throws Ex

Converts a number of seconds and nanoseconds into a new Timestamp.

Throws:

Ex

newTimestamp

@Deprecated
public static <Ex extends Throwable> Timestamp newTimestamp(long seconds,
 int nanos,
 Class<? extends Ex> exClass)
                                                     throws Ex

Deprecated.

Please use newTimestamp(long, int, java.util.function.Function), typically with lambda constructor reference

Converts a number of seconds and nanoseconds into a new Timestamp.

Throws:

Ex

newTimestamp

public static Timestamp newTimestamp(long seconds,
 int nanos)
                              throws IllegalArgumentException

Converts a number of seconds and nanoseconds into a new Timestamp.

Throws:

IllegalArgumentException

newUnmodifiableTimestamp

public static <Ex extends Throwable>
UnmodifiableTimestamp newUnmodifiableTimestamp(long seconds,
 int nanos,
 Function<? super String,? extends Ex> exSupplier)
                                        throws Ex

Converts a number of seconds and nanoseconds into a new UnmodifiableTimestamp.

Throws:

Ex

newUnmodifiableTimestamp

@Deprecated
public static <Ex extends Throwable>
UnmodifiableTimestamp newUnmodifiableTimestamp(long seconds,
 int nanos,
 Class<? extends Ex> exClass)
                                        throws Ex

Deprecated.

Please use newUnmodifiableTimestamp(long, int, java.util.function.Function), typically with lambda constructor reference

Converts a number of seconds and nanoseconds into a new UnmodifiableTimestamp.

Throws:

Ex

newUnmodifiableTimestamp

public static UnmodifiableTimestamp newUnmodifiableTimestamp(long seconds,
 int nanos)
                                                      throws IllegalArgumentException

Converts a number of seconds and nanoseconds into a new UnmodifiableTimestamp.

Throws:

IllegalArgumentException