Google

: Class SQLUtil
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES
SUMMARY:  INNER | FIELD | CONSTR | METHOD DETAIL:  FIELD | CONSTR | METHOD

com.bitmechanic.sql
Class SQLUtil

java.lang.Object
  |
  +--com.bitmechanic.sql.SQLUtil
public class SQLUtil
extends java.lang.Object

A set of utility SQL methods. Not really related to the JDBC Pool, but included because you might find it useful

Version:
$Id: SQLUtil.java,v 1.6 1999/08/25 06:20:07 pixel Exp $
Author:
James Cooper

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

SQLUtil

public SQLUtil()
Method Detail

escapeString

public static java.lang.String escapeString(java.lang.String str)
Calls escapeString(str, int) with a length of 999999

escapeString

public static java.lang.String escapeString(java.lang.String str,
                                            int length)
Escapes ' with '' and truncates the string to the length specified.
Parameters:
str - String to escape
length - Maximum allowable length of string

notNull

public static java.lang.String notNull(java.lang.String str)
Checks if str is null, and if it is returns an empty string. Otherwise returns str itself. Useful for wrapping around calls to rs.getString() since that will return null if the field is undefined.

formatMysqlDate

public static java.lang.String formatMysqlDate(java.util.Date date)
Formats a date using the SimpleDateFormat "yyyy-MM-dd"

parseMysqlDate

public static java.util.Date parseMysqlDate(java.lang.String date_str)

formatHiResMysqlDate

public static java.lang.String formatHiResMysqlDate(java.util.Date date)
Formats a date using the SimpleDateFormat "yyyy-MM-dd HH:mm:ss"

booleanToString

public static java.lang.String booleanToString(boolean b)
returns "y" if b is true. otherwise returns "n"

stringToBoolean

public static boolean stringToBoolean(java.lang.String str)
returns true if str is not null and equals "y" otherwise returns true
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES
SUMMARY:  INNER | FIELD | CONSTR | METHOD DETAIL:  FIELD | CONSTR | METHOD