edu.uoc.pfc.lcamps.persistenciaFW.constants
Class SQLConstants

java.lang.Object
  extended by edu.uoc.pfc.lcamps.persistenciaFW.constants.SQLConstants

public final class SQLConstants
extends java.lang.Object

Classe que conté les constants per realitzar les querys a la BBDD

Author:
Llorenç Camps 12/12/2013

Field Summary
static java.lang.String AND
           
static java.lang.String CLOSE_BRACKET
           
static java.lang.String COMILLA_SIMPLE
           
static java.lang.String COMMA
           
static java.lang.String DATABASE_DATE_FORMAT
           
static java.lang.String DATABASE_JAVA_DATE_FORMAT
           
static java.lang.String DATE_INF
           
static java.lang.String DATE_MAX
           
static java.lang.String DELETE
           
static java.lang.String DOBLE_COMILLA_SIMPLE
           
static java.lang.String EQUALS
           
static java.lang.String FROM
           
static java.lang.String ID_AUTO_INCREMENTAL_ORACLE
           
static java.lang.String IN
           
static java.lang.String INSERT
           
static java.lang.String LIKE
           
static java.lang.String MYSQL
           
static java.lang.String NULL_LAST
           
static java.lang.String NULL_STRING
           
static java.lang.String OPEN_BRACKET
           
static java.lang.String OR
           
static java.lang.String ORACLE
           
static java.lang.String ORDER_ASC
           
static java.lang.String ORDER_BY
           
static java.lang.String ORDER_DESC
           
static java.lang.String QRY_ID_MYSQL
           
static java.lang.String QRY_PAGINATED_RESULT
           
static java.lang.String QRY_SELECT_COUNT
           
static java.lang.String QRY_SELECT_SEQUENCE
           
static java.lang.String SELECT
           
static java.lang.String SELECT_ALL
           
static java.lang.String SEMICOLON
           
static java.lang.String SET
           
static java.lang.String TIMESTAMP
           
static java.lang.String TO_DATE
           
static java.lang.String TRANSLATE
           
static java.lang.String TRANSLATE_ACCENT_VALUES
           
static java.lang.String UPDATE
           
static java.lang.String UPPER
           
static java.lang.String VALUES
           
static java.lang.String WHERE
           
 
Constructor Summary
SQLConstants()
           
 
Method Summary
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ID_AUTO_INCREMENTAL_ORACLE

public static final java.lang.String ID_AUTO_INCREMENTAL_ORACLE
See Also:
Constant Field Values

ORACLE

public static final java.lang.String ORACLE
See Also:
Constant Field Values

MYSQL

public static final java.lang.String MYSQL
See Also:
Constant Field Values

OPEN_BRACKET

public static final java.lang.String OPEN_BRACKET
See Also:
Constant Field Values

CLOSE_BRACKET

public static final java.lang.String CLOSE_BRACKET
See Also:
Constant Field Values

EQUALS

public static final java.lang.String EQUALS
See Also:
Constant Field Values

SELECT

public static final java.lang.String SELECT
See Also:
Constant Field Values

FROM

public static final java.lang.String FROM
See Also:
Constant Field Values

SELECT_ALL

public static final java.lang.String SELECT_ALL
See Also:
Constant Field Values

INSERT

public static final java.lang.String INSERT
See Also:
Constant Field Values

UPDATE

public static final java.lang.String UPDATE
See Also:
Constant Field Values

DELETE

public static final java.lang.String DELETE
See Also:
Constant Field Values

WHERE

public static final java.lang.String WHERE
See Also:
Constant Field Values

SET

public static final java.lang.String SET
See Also:
Constant Field Values

VALUES

public static final java.lang.String VALUES
See Also:
Constant Field Values

QRY_SELECT_COUNT

public static final java.lang.String QRY_SELECT_COUNT
See Also:
Constant Field Values

QRY_SELECT_SEQUENCE

public static final java.lang.String QRY_SELECT_SEQUENCE
See Also:
Constant Field Values

QRY_PAGINATED_RESULT

public static final java.lang.String QRY_PAGINATED_RESULT
See Also:
Constant Field Values

QRY_ID_MYSQL

public static final java.lang.String QRY_ID_MYSQL
See Also:
Constant Field Values

ORDER_ASC

public static final java.lang.String ORDER_ASC
See Also:
Constant Field Values

ORDER_DESC

public static final java.lang.String ORDER_DESC
See Also:
Constant Field Values

AND

public static final java.lang.String AND
See Also:
Constant Field Values

OR

public static final java.lang.String OR
See Also:
Constant Field Values

ORDER_BY

public static final java.lang.String ORDER_BY
See Also:
Constant Field Values

NULL_LAST

public static final java.lang.String NULL_LAST
See Also:
Constant Field Values

COMMA

public static final java.lang.String COMMA
See Also:
Constant Field Values

SEMICOLON

public static final java.lang.String SEMICOLON
See Also:
Constant Field Values

TIMESTAMP

public static final java.lang.String TIMESTAMP
See Also:
Constant Field Values

LIKE

public static final java.lang.String LIKE
See Also:
Constant Field Values

UPPER

public static final java.lang.String UPPER
See Also:
Constant Field Values

IN

public static final java.lang.String IN
See Also:
Constant Field Values

TRANSLATE

public static final java.lang.String TRANSLATE
See Also:
Constant Field Values

TRANSLATE_ACCENT_VALUES

public static final java.lang.String TRANSLATE_ACCENT_VALUES
See Also:
Constant Field Values

DOBLE_COMILLA_SIMPLE

public static final java.lang.String DOBLE_COMILLA_SIMPLE
See Also:
Constant Field Values

NULL_STRING

public static final java.lang.String NULL_STRING
See Also:
Constant Field Values

TO_DATE

public static final java.lang.String TO_DATE
See Also:
Constant Field Values

DATABASE_DATE_FORMAT

public static final java.lang.String DATABASE_DATE_FORMAT
See Also:
Constant Field Values

DATABASE_JAVA_DATE_FORMAT

public static final java.lang.String DATABASE_JAVA_DATE_FORMAT
See Also:
Constant Field Values

COMILLA_SIMPLE

public static final java.lang.String COMILLA_SIMPLE
See Also:
Constant Field Values

DATE_INF

public static final java.lang.String DATE_INF
See Also:
Constant Field Values

DATE_MAX

public static final java.lang.String DATE_MAX
See Also:
Constant Field Values
Constructor Detail

SQLConstants

public SQLConstants()