com.aoindustries.sql

Class SQLUtility

java.lang.Object

com.aoindustries.sql.SQLUtility

public class SQLUtility
extends Object

SQL utilities.

Author:

AO Industries, Inc.

Method Summary

Modifier and Type	Method and Description
static String	decodeString(String S)
static String	encodeString(String S)
static String	escapeSQL(String S) Deprecated. use PreparedStatement instead
static void	escapeSQL(String S, StringBuilder B) Deprecated. use PreparedStatement instead
static String	getDate(long time)
static Date	getDate(String yyyy_mm_dd)
static String	getDateTime(long time) Gets the database format for a date/time field.
static Date	getDateTime(String s) Gets the date and time from the YYYY-MM-DD HH:MM:SS format.
static long	getDaysFromMillis(long time) Gets the number of days from epoch
static String	getDecimal(int pennies) Converts a number of pennies into decimal representation.
static String	getDecimal(long pennies) Converts a number of pennies into decimal representation.
static String	getMilliDecimal(int millis) Converts a number of millis into decimal representation.
static String	getMilliDecimal(long millis) Converts a number of millis into decimal representation.
static int	getMillis(String decimal) Gets the number of millis represented by a String containing a decimal(8,3) type.
static long	getMillisFromDays(long time) Gets the number of millis from epoch
static int	getPennies(String decimal) Gets the number of pennies represented by a String containing a decimal type.
static long	getPenniesLong(String decimal) Gets the number of pennies represented by a String containing a decimal type.
static String	getTime(long time) Gets the database format for a time field.
static int	negIntIfEmpty(String s) Removes the milliseconds from a time, rounds down every time.
static long	negLongIfEmpty(String s) Removes the milliseconds from a time, rounds down every time.
static String	nullIfEmpty(String S) Returns null if the string is null or empty.
static void	printResultSetHTMLTable(ResultSet results, Appendable out, String title, boolean wordWrap)
static void	printTable(Object[] titles, Collection<Object> values, Appendable out, boolean isInteractive, boolean[] alignRights)
static void	printTable(Object[] titles, Object[] values, Appendable out, boolean isInteractive, boolean[] alignRights)
static long	roundToDay(long time) Rounds the time to an exact day.

Methods inherited from class java.lang.Object

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

Method Detail

escapeSQL

@Deprecated
public static String escapeSQL(String S)

Deprecated. use PreparedStatement instead

Escapes SQL so that it can be used safely in queries.

Parameters:

S - the string to be escaped.

escapeSQL

@Deprecated
public static void escapeSQL(String S,
                                         StringBuilder B)

Deprecated. use PreparedStatement instead

Escapes SQL so that it can be used safely in queries.

Parameters:

S - the string to be escaped.

B - the StringBuilder to append to.

encodeString

public static String encodeString(String S)

decodeString

public static String decodeString(String S)

getDate

public static String getDate(long time)

See Also:

CalendarUtils.formatDate(java.util.Calendar)

getDate

public static Date getDate(String yyyy_mm_dd)
                    throws IllegalArgumentException

Throws:

IllegalArgumentException

See Also:

CalendarUtils.parseDate(java.lang.String)

getDateTime

public static Date getDateTime(String s)
                        throws IllegalArgumentException

Gets the date and time from the YYYY-MM-DD HH:MM:SS format.

Throws:

IllegalArgumentException

getDateTime

public static String getDateTime(long time)

Gets the database format for a date/time field. If the time is -1, returns null

getTime

public static String getTime(long time)

Gets the database format for a time field. If the time is -1, returns null

getDaysFromMillis

public static long getDaysFromMillis(long time)

Gets the number of days from epoch

getMillisFromDays

public static long getMillisFromDays(long time)

Gets the number of millis from epoch

roundToDay

public static long roundToDay(long time)

Rounds the time to an exact day.

getDecimal

public static String getDecimal(int pennies)

Converts a number of pennies into decimal representation.

getDecimal

public static String getDecimal(long pennies)

Converts a number of pennies into decimal representation.

getMilliDecimal

public static String getMilliDecimal(int millis)

Converts a number of millis into decimal representation.

getMilliDecimal

public static String getMilliDecimal(long millis)

Converts a number of millis into decimal representation.

getMillis

public static int getMillis(String decimal)

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

getPennies

public static int getPennies(String decimal)

Gets the number of pennies represented by a String containing a decimal type.

getPenniesLong

public static long getPenniesLong(String decimal)

Gets the number of pennies represented by a String containing a decimal type.

negIntIfEmpty

public static int negIntIfEmpty(String s)

Removes the milliseconds from a time, rounds down every time.

negLongIfEmpty

public static long negLongIfEmpty(String s)

Removes the milliseconds from a time, rounds down every time.

nullIfEmpty

public static String nullIfEmpty(String S)

Returns null if the string is null or empty.

printResultSetHTMLTable

public static void printResultSetHTMLTable(ResultSet results,
                                           Appendable out,
                                           String title,
                                           boolean wordWrap)
                                    throws SQLException,
                                           IOException

Throws:

SQLException

IOException

printTable

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

Throws:

IOException

printTable

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

Throws:

IOException