Class 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.
    • Method Summary

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • 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
      • 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