|
Enterprise Information Portal APIs |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.gcs.db.util.SQLString
This class converts Java-type strings to SQL-type strings by escaping special characters. It also provides references to a set of commonly used SQL tokens. Classes which construct SQL statements may use this set of strings to avoid expensive Java String construction operations.
Field Summary | |
static java.lang.String |
AND
" AND " |
static java.lang.String |
CLOSE_PAREN
")" |
static java.lang.String |
COMMA
"," |
static java.lang.String |
CREATE_TABLE
"CREATE TABLE " |
static java.lang.String |
D_QUOTE
"\"" |
static java.lang.String |
DEFAULT
"DEFAULT " |
static java.lang.String |
EQ
"=" |
static java.lang.String |
EXCLAM
"!" |
static java.lang.String |
FROM
"FROM " |
static java.lang.String |
GT
">" |
static java.lang.String |
INSERT_INTO
"INSERT INTO " |
static java.lang.String |
IS_NULL
"IS NULL " |
static java.lang.String |
LT
"<" |
static java.lang.String |
NOT
"NOT " |
static java.lang.String |
NULL
"NULL " |
static java.lang.String |
OPEN_PAREN
"(" |
static java.lang.String |
OR
" OR " |
static java.lang.String |
QUES
"?" |
static java.lang.String |
QUOTE
"'" |
static java.lang.String |
SELECT
"SELECT " |
static java.lang.String |
SELECT_STAR
"SELECT * " |
static java.lang.String |
SET
"SET " |
static java.lang.String |
SPACE
" " |
static java.lang.String |
UPDATE
"UPDATE " |
static java.lang.String |
VALUES
"VALUES " |
static java.lang.String |
WHERE
"WHERE " |
Constructor Summary | |
SQLString(java.lang.String s)
Constructor. |
Method Summary | |
java.lang.String |
escape(java.lang.String s)
Escapes special characters with the SQL escape sequence ' --(e.g., "dog's"
becomes "dog''s").. |
static void |
main(java.lang.String[] args)
|
java.lang.String |
quoted()
Convenience method that returns the SQL string enclosed in single quotes (for specifying string literals). |
java.lang.String |
toString()
|
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
public static final java.lang.String SELECT
public static final java.lang.String SELECT_STAR
public static final java.lang.String FROM
public static final java.lang.String WHERE
public static final java.lang.String SET
public static final java.lang.String INSERT_INTO
public static final java.lang.String UPDATE
public static final java.lang.String COMMA
public static final java.lang.String QUOTE
public static final java.lang.String D_QUOTE
public static final java.lang.String SPACE
public static final java.lang.String EQ
public static final java.lang.String LT
public static final java.lang.String GT
public static final java.lang.String IS_NULL
public static final java.lang.String OPEN_PAREN
public static final java.lang.String CLOSE_PAREN
public static final java.lang.String NOT
public static final java.lang.String EXCLAM
public static final java.lang.String QUES
public static final java.lang.String VALUES
public static final java.lang.String DEFAULT
public static final java.lang.String NULL
public static final java.lang.String AND
public static final java.lang.String OR
public static final java.lang.String CREATE_TABLE
Constructor Detail |
public SQLString(java.lang.String s)
s
- A string.Method Detail |
public java.lang.String quoted()
public java.lang.String toString()
toString
in class java.lang.Object
public java.lang.String escape(java.lang.String s)
'
--(e.g., "dog's"
becomes "dog''s")..
Currently, the only know special character is '
.public static void main(java.lang.String[] args)
|
EIP Web Crawler APIs | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |