Class QueryConstants
- java.lang.Object
-
- org.castor.cpa.persistence.sql.query.QueryConstants
-
public final class QueryConstants extends java.lang.Object
Constants for SQL queries.- Version:
- $Revision$ $Date: 2006-04-25 15:08:23 -0600 (Tue, 25 Apr 2006) $
- Author:
- Ahmad Hassan, Ralf Joachim
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.String
AND
'AND' keyword for conditions of SQL queries.static char
ASSIGN
Character to assign a value to a column in set clause of an SQL update query.static java.lang.String
DELETE
'DELETE' keyword of a SQL delete query.static char
DOT
Character separating qualifier and column in a SQL query.static java.lang.String
FOR
'FOR' keyword for constructing FOR UPDATE-clauses.static java.lang.String
FROM
'FROM' keyword of a SQL query.static java.lang.String
HOLDLOCK
'HOLDLOCK' keyword for constructing WITH (HOLDLOCK)-clauses.static java.lang.String
INSERT
'INSERT' keyword of a SQL insert query.static java.lang.String
INTO
'INTO' keyword of insert query.static java.lang.String
IS
'IS' keyword for conditions of SQL queries.static java.lang.String
JOIN
'JOIN' keyword for constructing joins of SQL queries.static java.lang.String
LOCK
'LOCK' keyword for constructing WITH LOCK-clauses.static char
LPAREN
Left parenthesis character for SQL query.static java.lang.String
NOT
'NOT' keyword for conditions of SQL queries.static java.lang.String
NULL
'NULL' keyword for conditions of SQL queries.static java.lang.String
ON
'ON' keyword for constructing joins of SQL queries.static java.lang.String
OR
'OR' keyword for conditions of SQL queries.static char
PARAMETER
Character representing a parameter in a SQL query.static char
RPAREN
Right parenthesis character for SQL query.static java.lang.String
SELECT
'SELECT' keyword of a SQL delete query.static char
SEPERATOR
Character to separate multiple assignments in set clause of an SQL update query.static java.lang.String
SET
'SET' keyword of a SQL update query.static char
SPACE
Character to use for spaces in SQL query.static char
STAR
'*' for select query.static java.lang.String
UPDATE
'UPDATE' keyword of a SQL update query.static java.lang.String
VALUES
'VALUES' keyword of a SQL insert query.static java.lang.String
WHERE
'WHERE' keyword of a SQL query.static java.lang.String
WITH
'WITH' keyword for constructing WITH LOCK-clauses.
-
-
-
Field Detail
-
SELECT
public static final java.lang.String SELECT
'SELECT' keyword of a SQL delete query.- See Also:
- Constant Field Values
-
DELETE
public static final java.lang.String DELETE
'DELETE' keyword of a SQL delete query.- See Also:
- Constant Field Values
-
UPDATE
public static final java.lang.String UPDATE
'UPDATE' keyword of a SQL update query.- See Also:
- Constant Field Values
-
INSERT
public static final java.lang.String INSERT
'INSERT' keyword of a SQL insert query.- See Also:
- Constant Field Values
-
VALUES
public static final java.lang.String VALUES
'VALUES' keyword of a SQL insert query.- See Also:
- Constant Field Values
-
INTO
public static final java.lang.String INTO
'INTO' keyword of insert query.- See Also:
- Constant Field Values
-
STAR
public static final char STAR
'*' for select query.- See Also:
- Constant Field Values
-
SET
public static final java.lang.String SET
'SET' keyword of a SQL update query.- See Also:
- Constant Field Values
-
FROM
public static final java.lang.String FROM
'FROM' keyword of a SQL query.- See Also:
- Constant Field Values
-
WHERE
public static final java.lang.String WHERE
'WHERE' keyword of a SQL query.- See Also:
- Constant Field Values
-
AND
public static final java.lang.String AND
'AND' keyword for conditions of SQL queries.- See Also:
- Constant Field Values
-
OR
public static final java.lang.String OR
'OR' keyword for conditions of SQL queries.- See Also:
- Constant Field Values
-
NOT
public static final java.lang.String NOT
'NOT' keyword for conditions of SQL queries.- See Also:
- Constant Field Values
-
IS
public static final java.lang.String IS
'IS' keyword for conditions of SQL queries.- See Also:
- Constant Field Values
-
NULL
public static final java.lang.String NULL
'NULL' keyword for conditions of SQL queries.- See Also:
- Constant Field Values
-
JOIN
public static final java.lang.String JOIN
'JOIN' keyword for constructing joins of SQL queries.- See Also:
- Constant Field Values
-
ON
public static final java.lang.String ON
'ON' keyword for constructing joins of SQL queries.- See Also:
- Constant Field Values
-
FOR
public static final java.lang.String FOR
'FOR' keyword for constructing FOR UPDATE-clauses.- See Also:
- Constant Field Values
-
WITH
public static final java.lang.String WITH
'WITH' keyword for constructing WITH LOCK-clauses.- See Also:
- Constant Field Values
-
LOCK
public static final java.lang.String LOCK
'LOCK' keyword for constructing WITH LOCK-clauses.- See Also:
- Constant Field Values
-
HOLDLOCK
public static final java.lang.String HOLDLOCK
'HOLDLOCK' keyword for constructing WITH (HOLDLOCK)-clauses.- See Also:
- Constant Field Values
-
SPACE
public static final char SPACE
Character to use for spaces in SQL query.- See Also:
- Constant Field Values
-
DOT
public static final char DOT
Character separating qualifier and column in a SQL query.- See Also:
- Constant Field Values
-
PARAMETER
public static final char PARAMETER
Character representing a parameter in a SQL query.- See Also:
- Constant Field Values
-
LPAREN
public static final char LPAREN
Left parenthesis character for SQL query.- See Also:
- Constant Field Values
-
RPAREN
public static final char RPAREN
Right parenthesis character for SQL query.- See Also:
- Constant Field Values
-
ASSIGN
public static final char ASSIGN
Character to assign a value to a column in set clause of an SQL update query.- See Also:
- Constant Field Values
-
SEPERATOR
public static final char SEPERATOR
Character to separate multiple assignments in set clause of an SQL update query.- See Also:
- Constant Field Values
-
-