org.brains2b.sql

Class SQLHelper

java.lang.Object

org.brains2b.sql.SQLHelper

public final class SQLHelper
extends java.lang.Object

[Short description] [Long description]

Version:

0.11.3 [17-10-2007]

Author:

dennis@brains2b.nl

Constructor Summary

Constructors

Constructor and Description
SQLHelper()

Method Summary

Modifier and Type	Method and Description
static java.sql.Date	createDate(java.util.Date d)
static java.sql.Timestamp	createDateTime(java.util.Date d)
static java.sql.Timestamp	createTimestamp(java.util.Date d)
static java.sql.Timestamp	createTimestamp(long time)
static java.util.Date	createUtilDate(java.sql.Date d)
static java.util.Date	createUtilDate(java.sql.Timestamp ts)
static java.lang.String	encode(java.lang.String s) encode a String so it can be inserted into an SQL database by replacing every quote with two quotes
static java.lang.String	limitIdentifier(java.lang.String s, int length) limit the identifier given by String to the length given.
static java.lang.String	stripQuotes(java.lang.String s) strip quotes from the beginning and end of a String from an SQL database

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLHelper

public SQLHelper()

Method Detail

encode

public static final java.lang.String encode(java.lang.String s)

encode a String so it can be inserted into an SQL database by replacing every quote with two quotes

Parameters:

s - String, the String to encode

Returns:

String, the encoded String

stripQuotes

public static final java.lang.String stripQuotes(java.lang.String s)

strip quotes from the beginning and end of a String from an SQL database

Parameters:

s - String, the String to strip

Returns:

String, the stripped String

limitIdentifier

public static final java.lang.String limitIdentifier(java.lang.String s,
                                                     int length)

limit the identifier given by String to the length given.

This is accomplished by removing as much non-vowels as needed from the String

Parameters:

s - String, the identifier to limit

length - int, the length to limit the identifier to

Returns:

String

createTimestamp

public static final java.sql.Timestamp createTimestamp(java.util.Date d)

createTimestamp

public static final java.sql.Timestamp createTimestamp(long time)

createDateTime

public static final java.sql.Timestamp createDateTime(java.util.Date d)

createDate

public static final java.sql.Date createDate(java.util.Date d)

createUtilDate

public static final java.util.Date createUtilDate(java.sql.Date d)

createUtilDate

public static final java.util.Date createUtilDate(java.sql.Timestamp ts)