Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS (src)    NEXT CLASS (src) FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.jboss.ejb.plugins.cmp.jdbc
Class SQLUtil

java.lang.Object
  extended byorg.jboss.ejb.plugins.cmp.jdbc.SQLUtil
public final class SQLUtil
extends java.lang.Object

SQLUtil helps with building sql statements.

Nested Class Summary
static class SQLUtil.OldColumns (src)
          utility class to store the information returned by getOldColumns()
static class SQLUtil.OldIndexes (src)
          utility class to store the information returned by getOldColumns()
 
Field Summary
static java.lang.String ABS
           
static java.lang.String AND
           
static java.lang.String ASC
           
static java.lang.String AVG
           
static java.lang.String BETWEEN
           
static java.lang.String COMMA
           
static java.lang.String CONCAT
           
static java.lang.String COUNT
           
static java.lang.String CREATE_INDEX
           
static java.lang.String CREATE_TABLE
           
static java.lang.String DELETE_FROM
           
static java.lang.String DESC
           
static java.lang.String DISTINCT
           
static java.lang.String DROP_TABLE
           
static java.lang.String EMPTY
           
static java.lang.String EMPTY_STRING
           
static java.lang.String ESCAPE
           
static java.lang.String EXISTS
           
static java.lang.String FROM
           
static java.lang.String IN
           
static java.lang.String INSERT_INTO
           
static java.lang.String IS
           
static java.lang.String LCASE
           
static java.lang.String LEFT_JOIN
           
static java.lang.String LEFT_OUTER_JOIN
           
static java.lang.String LENGTH
           
static java.lang.String LIKE
           
static java.lang.String LIMIT
           
static java.lang.String LOCATE
           
static java.lang.String MAX
           
static java.lang.String MEMBER_OF
           
static java.lang.String MIN
           
static java.lang.String MOD
           
static java.lang.String NOT
           
static java.lang.String NOT_EQUAL
           
static java.lang.String NULL
           
static java.lang.String OFFSET
           
static java.lang.String ON
           
static java.lang.String OR
           
static java.lang.String ORDERBY
           
static java.lang.String SELECT
           
static java.lang.String SET
           
static java.lang.String SQRT
           
static java.lang.String SUBSTRING
           
static java.lang.String SUM
           
static java.lang.String TYPE
           
static java.lang.String UCASE
           
static java.lang.String UPDATE
           
static java.lang.String VALUES
           
static java.lang.String WHERE
           
 
Constructor Summary
SQLUtil()
           
 
Method Summary
static void addToRwords(java.lang.String word)
           
static java.lang.StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge (src)  entity, java.lang.String eagerLoadGroup, java.lang.StringBuffer sb)
          Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'
static java.lang.StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge (src)  entity, java.lang.String eagerLoadGroup, java.lang.String alias, java.lang.StringBuffer sb)
          Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'
static java.lang.StringBuffer appendColumnNamesClause(JDBCFieldBridge (src) [] fields, boolean[] mask, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'
static java.lang.StringBuffer appendColumnNamesClause(JDBCFieldBridge (src) [] fields, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'
static void dropTable(DataSource (src)  dataSource, java.lang.String tableName)
           
static java.lang.String fixConstraintName(java.lang.String name, DataSource (src)  dataSource)
           
static java.lang.String fixTableName(java.lang.String tableName, DataSource (src)  dataSource)
           
static java.lang.StringBuffer getColumnNamesClause(JDBCEntityBridge.FieldIterator (src)  loadIter, java.lang.StringBuffer sb)
          Returns columnName0 [, columnName1 [AND columnName2 [...]]]
static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src) [] fields, java.lang.StringBuffer sb)
          Returns columnName0 [, columnName1 [AND columnName2 [...]]]
static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src) [] fields, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns columnName0 [, columnName1 [AND columnName2 [...]]]
static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src)  field, java.lang.StringBuffer sb)
          Returns columnName0 [, columnName1 [, columnName2 [...]]]
static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src)  field, java.lang.String identifier, java.lang.StringBuffer sb)
          Returns identifier.columnName0 [, identifier.columnName1 [, identifier.columnName2 [...]]]
static java.lang.String getCreateTableColumnsClause(JDBCFieldBridge (src) [] fields)
           
static java.lang.String getCreateTableColumnsClause(JDBCType (src)  type)
          Returns columnName0 sqlType0 [, columnName1 sqlType0 [, columnName2 sqlType0 [...]]]
static java.lang.StringBuffer getIsNullClause(boolean not, JDBCFieldBridge (src) [] fields, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]]
static java.lang.StringBuffer getIsNullClause(boolean not, JDBCFieldBridge (src)  field, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]]
static java.lang.StringBuffer getJoinClause(JDBCAbstractCMRFieldBridge (src)  cmrField, java.lang.String parentAlias, java.lang.String childAlias, java.lang.StringBuffer buf)
           
static java.lang.StringBuffer getJoinClause(JDBCFieldBridge (src) [] pkFields, java.lang.String parent, JDBCFieldBridge (src) [] fkFields, java.lang.String child, java.lang.StringBuffer buf)
           
static SQLUtil.OldColumns (src) getOldColumns(java.lang.String tableName, DataSource (src)  dataSource)
           
static SQLUtil.OldIndexes (src) getOldIndexes(java.lang.String tableName, DataSource (src)  dataSource)
           
static java.lang.StringBuffer getRelationTableJoinClause(JDBCAbstractCMRFieldBridge (src)  cmrField, java.lang.String parentAlias, java.lang.String relationTableAlias, java.lang.StringBuffer buf)
           
static java.lang.String getSchema(java.lang.String tableName)
           
static java.lang.StringBuffer getSelfCompareWhereClause(JDBCFieldBridge (src) [] fields, java.lang.String fromIdentifier, java.lang.String toIdentifier, java.lang.StringBuffer buf)
           
static java.lang.StringBuffer getSelfCompareWhereClause(JDBCFieldBridge (src)  fromField, JDBCFieldBridge (src)  toField, java.lang.String fromIdentifier, java.lang.String toIdentifier, java.lang.StringBuffer buf)
           
static java.lang.StringBuffer getSetClause(JDBCEntityBridge.FieldIterator (src)  fieldsIter, java.lang.StringBuffer buf)
          Returns columnName0=? [, columnName1=? [, columnName2=? [...]]]
static java.lang.String getTableNameWithoutSchema(java.lang.String tableName)
           
static java.lang.StringBuffer getValuesClause(JDBCFieldBridge (src) [] fields, java.lang.StringBuffer buf)
          Returns ? [, ? [, ? [...]]]
static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields, long mask, java.lang.StringBuffer buf)
          Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]
static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields, java.lang.StringBuffer buf)
          Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]
static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]]
static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src)  field, java.lang.StringBuffer buf)
          Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]
static java.lang.StringBuffer getWhereClause(JDBCType (src)  type, java.lang.String identifier, java.lang.StringBuffer buf)
          Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]]
static boolean tableExists(java.lang.String tableName, DataSource (src)  dataSource)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

EMPTY_STRING

public static final java.lang.String EMPTY_STRING
See Also:
Constant Field Values (src)

INSERT_INTO

public static final java.lang.String INSERT_INTO
See Also:
Constant Field Values (src)

VALUES

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

SELECT

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

DISTINCT

public static final java.lang.String DISTINCT
See Also:
Constant Field Values (src)

FROM

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

WHERE

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

ORDERBY

public static final java.lang.String ORDERBY
See Also:
Constant Field Values (src)

DELETE_FROM

public static final java.lang.String DELETE_FROM
See Also:
Constant Field Values (src)

AND

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

OR

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

NOT

public static final java.lang.String NOT
See Also:
Constant Field Values (src)

EXISTS

public static final java.lang.String EXISTS
See Also:
Constant Field Values (src)

COMMA

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

LEFT_JOIN

public static final java.lang.String LEFT_JOIN
See Also:
Constant Field Values (src)

LEFT_OUTER_JOIN

public static final java.lang.String LEFT_OUTER_JOIN
See Also:
Constant Field Values (src)

ON

public static final java.lang.String ON
See Also:
Constant Field Values (src)

NOT_EQUAL

public static final java.lang.String NOT_EQUAL
See Also:
Constant Field Values (src)

CREATE_TABLE

public static final java.lang.String CREATE_TABLE
See Also:
Constant Field Values (src)

DROP_TABLE

public static final java.lang.String DROP_TABLE
See Also:
Constant Field Values (src)

CREATE_INDEX

public static final java.lang.String CREATE_INDEX
See Also:
Constant Field Values (src)

NULL

public static final java.lang.String NULL
See Also:
Constant Field Values (src)

IS

public static final java.lang.String IS
See Also:
Constant Field Values (src)

IN

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

EMPTY

public static final java.lang.String EMPTY
See Also:
Constant Field Values (src)

BETWEEN

public static final java.lang.String BETWEEN
See Also:
Constant Field Values (src)

LIKE

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

MEMBER_OF

public static final java.lang.String MEMBER_OF
See Also:
Constant Field Values (src)

ESCAPE

public static final java.lang.String ESCAPE
See Also:
Constant Field Values (src)

CONCAT

public static final java.lang.String CONCAT
See Also:
Constant Field Values (src)

SUBSTRING

public static final java.lang.String SUBSTRING
See Also:
Constant Field Values (src)

LCASE

public static final java.lang.String LCASE
See Also:
Constant Field Values (src)

UCASE

public static final java.lang.String UCASE
See Also:
Constant Field Values (src)

LENGTH

public static final java.lang.String LENGTH
See Also:
Constant Field Values (src)

LOCATE

public static final java.lang.String LOCATE
See Also:
Constant Field Values (src)

ABS

public static final java.lang.String ABS
See Also:
Constant Field Values (src)

MOD

public static final java.lang.String MOD
See Also:
Constant Field Values (src)

SQRT

public static final java.lang.String SQRT
See Also:
Constant Field Values (src)

COUNT

public static final java.lang.String COUNT
See Also:
Constant Field Values (src)

MAX

public static final java.lang.String MAX
See Also:
Constant Field Values (src)

MIN

public static final java.lang.String MIN
See Also:
Constant Field Values (src)

AVG

public static final java.lang.String AVG
See Also:
Constant Field Values (src)

SUM

public static final java.lang.String SUM
See Also:
Constant Field Values (src)

ASC

public static final java.lang.String ASC
See Also:
Constant Field Values (src)

DESC

public static final java.lang.String DESC
See Also:
Constant Field Values (src)

OFFSET

public static final java.lang.String OFFSET
See Also:
Constant Field Values (src)

LIMIT

public static final java.lang.String LIMIT
See Also:
Constant Field Values (src)

UPDATE

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

SET

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

TYPE

public static final java.lang.String TYPE
See Also:
Constant Field Values (src)
Constructor Detail

SQLUtil

public SQLUtil()
Method Detail

getTableNameWithoutSchema

public static java.lang.String getTableNameWithoutSchema(java.lang.String tableName)

getSchema

public static java.lang.String getSchema(java.lang.String tableName)

fixTableName

public static java.lang.String fixTableName(java.lang.String tableName,
                                            DataSource (src)  dataSource)
                                     throws DeploymentException (src)
Throws:
DeploymentException (src)

addToRwords

public static void addToRwords(java.lang.String word)

fixConstraintName

public static java.lang.String fixConstraintName(java.lang.String name,
                                                 DataSource (src)  dataSource)
                                          throws DeploymentException (src)
Throws:
DeploymentException (src)

getCreateTableColumnsClause

public static java.lang.String getCreateTableColumnsClause(JDBCFieldBridge (src) [] fields)

getCreateTableColumnsClause

public static java.lang.String getCreateTableColumnsClause(JDBCType (src)  type)
Returns columnName0 sqlType0 [, columnName1 sqlType0 [, columnName2 sqlType0 [...]]]

getColumnNamesClause

public static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src) [] fields,
                                                          java.lang.StringBuffer sb)
Returns columnName0 [, columnName1 [AND columnName2 [...]]]

getColumnNamesClause

public static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src) [] fields,
                                                          java.lang.String identifier,
                                                          java.lang.StringBuffer buf)
Returns columnName0 [, columnName1 [AND columnName2 [...]]]

getColumnNamesClause

public static java.lang.StringBuffer getColumnNamesClause(JDBCEntityBridge.FieldIterator (src)  loadIter,
                                                          java.lang.StringBuffer sb)
Returns columnName0 [, columnName1 [AND columnName2 [...]]]

getColumnNamesClause

public static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src)  field,
                                                          java.lang.StringBuffer sb)
Returns columnName0 [, columnName1 [, columnName2 [...]]]

getColumnNamesClause

public static java.lang.StringBuffer getColumnNamesClause(JDBCFieldBridge (src)  field,
                                                          java.lang.String identifier,
                                                          java.lang.StringBuffer sb)
Returns identifier.columnName0 [, identifier.columnName1 [, identifier.columnName2 [...]]]

appendColumnNamesClause

public static java.lang.StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge (src)  entity,
                                                             java.lang.String eagerLoadGroup,
                                                             java.lang.StringBuffer sb)
Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'

appendColumnNamesClause

public static java.lang.StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge (src)  entity,
                                                             java.lang.String eagerLoadGroup,
                                                             java.lang.String alias,
                                                             java.lang.StringBuffer sb)
Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'

appendColumnNamesClause

public static java.lang.StringBuffer appendColumnNamesClause(JDBCFieldBridge (src) [] fields,
                                                             boolean[] mask,
                                                             java.lang.String identifier,
                                                             java.lang.StringBuffer buf)
Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'

appendColumnNamesClause

public static java.lang.StringBuffer appendColumnNamesClause(JDBCFieldBridge (src) [] fields,
                                                             java.lang.String identifier,
                                                             java.lang.StringBuffer buf)
Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]'

getSetClause

public static java.lang.StringBuffer getSetClause(JDBCEntityBridge.FieldIterator (src)  fieldsIter,
                                                  java.lang.StringBuffer buf)
Returns columnName0=? [, columnName1=? [, columnName2=? [...]]]

getValuesClause

public static java.lang.StringBuffer getValuesClause(JDBCFieldBridge (src) [] fields,
                                                     java.lang.StringBuffer buf)
Returns ? [, ? [, ? [...]]]

getWhereClause

public static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields,
                                                    java.lang.StringBuffer buf)
Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]

getWhereClause

public static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields,
                                                    java.lang.String identifier,
                                                    java.lang.StringBuffer buf)
Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]]

getWhereClause

public static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src) [] fields,
                                                    long mask,
                                                    java.lang.StringBuffer buf)
Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]

getWhereClause

public static java.lang.StringBuffer getWhereClause(JDBCFieldBridge (src)  field,
                                                    java.lang.StringBuffer buf)
Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]]

getWhereClause

public static java.lang.StringBuffer getWhereClause(JDBCType (src)  type,
                                                    java.lang.String identifier,
                                                    java.lang.StringBuffer buf)
Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]]

getIsNullClause

public static java.lang.StringBuffer getIsNullClause(boolean not,
                                                     JDBCFieldBridge (src) [] fields,
                                                     java.lang.String identifier,
                                                     java.lang.StringBuffer buf)
Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]]

getIsNullClause

public static java.lang.StringBuffer getIsNullClause(boolean not,
                                                     JDBCFieldBridge (src)  field,
                                                     java.lang.String identifier,
                                                     java.lang.StringBuffer buf)
Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]]

getJoinClause

public static java.lang.StringBuffer getJoinClause(JDBCAbstractCMRFieldBridge (src)  cmrField,
                                                   java.lang.String parentAlias,
                                                   java.lang.String childAlias,
                                                   java.lang.StringBuffer buf)

getRelationTableJoinClause

public static java.lang.StringBuffer getRelationTableJoinClause(JDBCAbstractCMRFieldBridge (src)  cmrField,
                                                                java.lang.String parentAlias,
                                                                java.lang.String relationTableAlias,
                                                                java.lang.StringBuffer buf)

getJoinClause

public static java.lang.StringBuffer getJoinClause(JDBCFieldBridge (src) [] pkFields,
                                                   java.lang.String parent,
                                                   JDBCFieldBridge (src) [] fkFields,
                                                   java.lang.String child,
                                                   java.lang.StringBuffer buf)

getSelfCompareWhereClause

public static java.lang.StringBuffer getSelfCompareWhereClause(JDBCFieldBridge (src) [] fields,
                                                               java.lang.String fromIdentifier,
                                                               java.lang.String toIdentifier,
                                                               java.lang.StringBuffer buf)

getSelfCompareWhereClause

public static java.lang.StringBuffer getSelfCompareWhereClause(JDBCFieldBridge (src)  fromField,
                                                               JDBCFieldBridge (src)  toField,
                                                               java.lang.String fromIdentifier,
                                                               java.lang.String toIdentifier,
                                                               java.lang.StringBuffer buf)

tableExists

public static boolean tableExists(java.lang.String tableName,
                                  DataSource (src)  dataSource)
                           throws DeploymentException (src)
Throws:
DeploymentException (src)

getOldColumns

public static SQLUtil.OldColumns (src)  getOldColumns(java.lang.String tableName,
                                               DataSource (src)  dataSource)
                                        throws DeploymentException (src)
Throws:
DeploymentException (src)

getOldIndexes

public static SQLUtil.OldIndexes (src)  getOldIndexes(java.lang.String tableName,
                                               DataSource (src)  dataSource)
                                        throws DeploymentException (src)
Throws:
DeploymentException (src)

dropTable

public static void dropTable(DataSource (src)  dataSource,
                             java.lang.String tableName)
                      throws DeploymentException (src)
Throws:
DeploymentException (src)
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS (src)    NEXT CLASS (src) FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD