|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.bitmechanic.sql.SQLUtil
A set of utility SQL methods. Not really related to the JDBC Pool, but included because you might find it useful
Constructor Summary | |
SQLUtil()
|
Method Summary | |
static java.lang.String |
booleanToString(boolean b)
returns "y" if b is true. |
static java.lang.String |
escapeString(java.lang.String str)
Calls escapeString(str, int) with a length of 999999 |
static java.lang.String |
escapeString(java.lang.String str,
int length)
Escapes ' with '' and truncates the string to the length specified. |
static java.lang.String |
formatHiResMysqlDate(java.util.Date date)
Formats a date using the SimpleDateFormat "yyyy-MM-dd HH:mm:ss" |
static java.lang.String |
formatMysqlDate(java.util.Date date)
Formats a date using the SimpleDateFormat "yyyy-MM-dd" |
static java.lang.String |
notNull(java.lang.String str)
Checks if str is null, and if it is returns an empty string. |
static java.util.Date |
parseMysqlDate(java.lang.String date_str)
|
static boolean |
stringToBoolean(java.lang.String str)
returns true if str is not null and equals "y" otherwise returns true |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Constructor Detail |
public SQLUtil()
Method Detail |
public static java.lang.String escapeString(java.lang.String str)
public static java.lang.String escapeString(java.lang.String str, int length)
str
- String to escapelength
- Maximum allowable length of stringpublic static java.lang.String notNull(java.lang.String str)
public static java.lang.String formatMysqlDate(java.util.Date date)
public static java.util.Date parseMysqlDate(java.lang.String date_str)
public static java.lang.String formatHiResMysqlDate(java.util.Date date)
public static java.lang.String booleanToString(boolean b)
public static boolean stringToBoolean(java.lang.String str)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |