Package org.eclnt.ccee.db.util

Class QueryUtils

java.lang.Object

org.eclnt.ccee.db.util.QueryUtils

All Implemented Interfaces:

ICCEEConstants

public class QueryUtils
extends Object
implements ICCEEConstants

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	QueryUtils.IValueClassProvider

Field Summary

Fields inherited from interface org.eclnt.ccee.ICCEEConstants

AND, ASC, AVG, BETWEEN, BRC, BRO, COUNT, DEFAULT_CONTEXT, DESC, FUNCTIONRESULT, GREATER, GREATEREQUAL, IN, IS, ISNOT, LIKE, LL_DBG, LL_ERR, LL_INF, LL_WAR, LOWER, LOWEREQUAL, MAX, MIN, NULL, OR, ORDERBY, QPFUNCTION_LOWER, QPFUNCTION_UPPER, SUM

Constructor Summary

Constructors

Constructor	Description
QueryUtils()

Method Summary

Modifier and Type	Method	Description
static boolean	checkIfObjectIsOrderByInstrcution(Object o)
static boolean	checkIfObjectIsQueryLogic(Object o)
static boolean	checkIfObjectIsSQLComparator(Object o)
static String	cutClassCastInfoFromValueString(String token)
static Class	findPropertyClassFromQueryValueString(String token)
static Map<String,String>	parseExecQuerySQLColumnsIntoAliasAndSqlName(String execQuerySQLColumns)
static Object[]	transferQueryStringIntoQueryObjects(String structureName, String[] query, QueryUtils.IValueClassProvider valueClassProvider)
static Object[]	transferQueryStringIntoQueryObjects(String structureName, String query, QueryUtils.IValueClassProvider valueClassProvider)
static Object[]	transferSortStringIntoQueryObjects(String orderBy)
static Object[]	transferSortStringIntoQueryObjects(String[] orderBy)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QueryUtils

public QueryUtils()

Method Details

checkIfObjectIsQueryLogic

public static boolean checkIfObjectIsQueryLogic(Object o)

checkIfObjectIsOrderByInstrcution

public static boolean checkIfObjectIsOrderByInstrcution(Object o)

checkIfObjectIsSQLComparator

public static boolean checkIfObjectIsSQLComparator(Object o)

transferSortStringIntoQueryObjects

public static Object[] transferSortStringIntoQueryObjects(String[] orderBy)

transferSortStringIntoQueryObjects

public static Object[] transferSortStringIntoQueryObjects(String orderBy)

transferQueryStringIntoQueryObjects

public static Object[] transferQueryStringIntoQueryObjects(String structureName,
 String[] query,
 QueryUtils.IValueClassProvider valueClassProvider)

findPropertyClassFromQueryValueString

public static Class findPropertyClassFromQueryValueString(String token)

cutClassCastInfoFromValueString

public static String cutClassCastInfoFromValueString(String token)

transferQueryStringIntoQueryObjects

public static Object[] transferQueryStringIntoQueryObjects(String structureName,
 String query,
 QueryUtils.IValueClassProvider valueClassProvider)

parseExecQuerySQLColumnsIntoAliasAndSqlName

public static Map<String,String> parseExecQuerySQLColumnsIntoAliasAndSqlName(String execQuerySQLColumns)

Parameters:

execQuerySQLColumns - Example: "cceejob.id as jobid,cceejob.name as jobname"

Returns:

Example: map with jobid -> cceejob.id and jobname -> cceejob.name; so the key of the map is the alias, the value is the full SQL name