com.kheops.util

Class SQLQueryUtil

java.lang.Object

com.kheops.util.SQLQueryUtil

public class SQLQueryUtil
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
SQLQueryUtil(java.lang.String sqlQuery)

Method Summary

Modifier and Type	Method and Description
java.lang.String[]	getColumns(boolean parseColumnAliases) Returns column names found in the 'SELECT' part of the SQL query.
java.lang.String	getFromClause()
java.lang.String	getRealColumnName(java.lang.String aliasName, boolean ignoreCase)
java.lang.String	getSelectClause()
java.lang.String	getTableAlias(java.lang.String name, boolean containsField, boolean canReturnNull)
java.util.HashMap	getTableAliases()
java.lang.String[]	getTables()
java.lang.String	getWhereClause()
void	removeAllFieldAliases()
void	removeAllTableAliases()
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLQueryUtil

public SQLQueryUtil(java.lang.String sqlQuery)

Method Detail

getFromClause

public java.lang.String getFromClause()

getSelectClause

public java.lang.String getSelectClause()

getWhereClause

public java.lang.String getWhereClause()

getColumns

public java.lang.String[] getColumns(boolean parseColumnAliases)

Returns column names found in the 'SELECT' part of the SQL query.

Parameters:

parseColumnAliases - a flag that defines whether or not column aliases are returned instead of column names

Returns:

column names found in the 'SELECT' part of the SQL query

getRealColumnName

public java.lang.String getRealColumnName(java.lang.String aliasName,
                                          boolean ignoreCase)

getTables

public java.lang.String[] getTables()

getTableAliases

public java.util.HashMap getTableAliases()

getTableAlias

public java.lang.String getTableAlias(java.lang.String name,
                                      boolean containsField,
                                      boolean canReturnNull)

removeAllTableAliases

public void removeAllTableAliases()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

removeAllFieldAliases

public void removeAllFieldAliases()