Enterprise Information Portal APIs

com.ibm.gcs.db.util
Class SQLString

java.lang.Object
  |
  +--com.ibm.gcs.db.util.SQLString

public class SQLString
extends java.lang.Object

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

SELECT

public static final java.lang.String SELECT
"SELECT "

SELECT_STAR

public static final java.lang.String SELECT_STAR
"SELECT * "

FROM

public static final java.lang.String FROM
"FROM "

WHERE

public static final java.lang.String WHERE
"WHERE "

SET

public static final java.lang.String SET
"SET "

INSERT_INTO

public static final java.lang.String INSERT_INTO
"INSERT INTO "

UPDATE

public static final java.lang.String UPDATE
"UPDATE "

COMMA

public static final java.lang.String COMMA
","

QUOTE

public static final java.lang.String QUOTE
"'"

D_QUOTE

public static final java.lang.String D_QUOTE
"\""

SPACE

public static final java.lang.String SPACE
" "

EQ

public static final java.lang.String EQ
"="

LT

public static final java.lang.String LT
"<"

GT

public static final java.lang.String GT
">"

IS_NULL

public static final java.lang.String IS_NULL
"IS NULL "

OPEN_PAREN

public static final java.lang.String OPEN_PAREN
"("

CLOSE_PAREN

public static final java.lang.String CLOSE_PAREN
")"

NOT

public static final java.lang.String NOT
"NOT "

EXCLAM

public static final java.lang.String EXCLAM
"!"

QUES

public static final java.lang.String QUES
"?"

VALUES

public static final java.lang.String VALUES
"VALUES "

DEFAULT

public static final java.lang.String DEFAULT
"DEFAULT "

NULL

public static final java.lang.String NULL
"NULL "

AND

public static final java.lang.String AND
" AND "

OR

public static final java.lang.String OR
" OR "

CREATE_TABLE

public static final java.lang.String CREATE_TABLE
"CREATE TABLE "
Constructor Detail

SQLString

public SQLString(java.lang.String s)
Constructor.
Parameters:
s - A string.
Method Detail

quoted

public java.lang.String quoted()
Convenience method that returns the SQL string enclosed in single quotes (for specifying string literals).
Returns:
String The normalized SQL string enclosed by quotes.

toString

public java.lang.String toString()
Overrides:
toString in class java.lang.Object
Returns:
String The normalized SQL string

escape

public java.lang.String escape(java.lang.String s)
Escapes special characters with the SQL escape sequence '--(e.g., "dog's" becomes "dog''s").. Currently, the only know special character is '.

main

public static void main(java.lang.String[] args)

EIP Web Crawler APIs

(c) Copyright International Business Machines Corporation 1996, 2002. IBM Corp. All rights reserved.