Class QueryConstants
java.lang.Object
org.castor.cpa.persistence.sql.query.QueryConstants
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
FieldsModifier and TypeFieldDescriptionstatic final String
'AND' keyword for conditions of SQL queries.static final char
Character to assign a value to a column in set clause of an SQL update query.static final String
'DELETE' keyword of a SQL delete query.static final char
Character separating qualifier and column in a SQL query.static final String
'FOR' keyword for constructing FOR UPDATE-clauses.static final String
'FROM' keyword of a SQL query.static final String
'HOLDLOCK' keyword for constructing WITH (HOLDLOCK)-clauses.static final String
'INSERT' keyword of a SQL insert query.static final String
'INTO' keyword of insert query.static final String
'IS' keyword for conditions of SQL queries.static final String
'JOIN' keyword for constructing joins of SQL queries.static final String
'LOCK' keyword for constructing WITH LOCK-clauses.static final char
Left parenthesis character for SQL query.static final String
'NOT' keyword for conditions of SQL queries.static final String
'NULL' keyword for conditions of SQL queries.static final String
'ON' keyword for constructing joins of SQL queries.static final String
'OR' keyword for conditions of SQL queries.static final char
Character representing a parameter in a SQL query.static final char
Right parenthesis character for SQL query.static final String
'SELECT' keyword of a SQL delete query.static final char
Character to separate multiple assignments in set clause of an SQL update query.static final String
'SET' keyword of a SQL update query.static final char
Character to use for spaces in SQL query.static final char
'*' for select query.static final String
'UPDATE' keyword of a SQL update query.static final String
'VALUES' keyword of a SQL insert query.static final String
'WHERE' keyword of a SQL query.static final String
'WITH' keyword for constructing WITH LOCK-clauses. -
Method Summary
-
Field Details
-
SELECT
'SELECT' keyword of a SQL delete query.- See Also:
-
DELETE
'DELETE' keyword of a SQL delete query.- See Also:
-
UPDATE
'UPDATE' keyword of a SQL update query.- See Also:
-
INSERT
'INSERT' keyword of a SQL insert query.- See Also:
-
VALUES
'VALUES' keyword of a SQL insert query.- See Also:
-
INTO
'INTO' keyword of insert query.- See Also:
-
STAR
public static final char STAR'*' for select query.- See Also:
-
SET
'SET' keyword of a SQL update query.- See Also:
-
FROM
'FROM' keyword of a SQL query.- See Also:
-
WHERE
'WHERE' keyword of a SQL query.- See Also:
-
AND
'AND' keyword for conditions of SQL queries.- See Also:
-
OR
'OR' keyword for conditions of SQL queries.- See Also:
-
NOT
'NOT' keyword for conditions of SQL queries.- See Also:
-
IS
'IS' keyword for conditions of SQL queries.- See Also:
-
NULL
'NULL' keyword for conditions of SQL queries.- See Also:
-
JOIN
'JOIN' keyword for constructing joins of SQL queries.- See Also:
-
ON
'ON' keyword for constructing joins of SQL queries.- See Also:
-
FOR
'FOR' keyword for constructing FOR UPDATE-clauses.- See Also:
-
WITH
'WITH' keyword for constructing WITH LOCK-clauses.- See Also:
-
LOCK
'LOCK' keyword for constructing WITH LOCK-clauses.- See Also:
-
HOLDLOCK
'HOLDLOCK' keyword for constructing WITH (HOLDLOCK)-clauses.- See Also:
-
SPACE
public static final char SPACECharacter to use for spaces in SQL query.- See Also:
-
DOT
public static final char DOTCharacter separating qualifier and column in a SQL query.- See Also:
-
PARAMETER
public static final char PARAMETERCharacter representing a parameter in a SQL query.- See Also:
-
LPAREN
public static final char LPARENLeft parenthesis character for SQL query.- See Also:
-
RPAREN
public static final char RPARENRight parenthesis character for SQL query.- See Also:
-
ASSIGN
public static final char ASSIGNCharacter to assign a value to a column in set clause of an SQL update query.- See Also:
-
SEPERATOR
public static final char SEPERATORCharacter to separate multiple assignments in set clause of an SQL update query.- See Also:
-