by.belsoft.report.tools.utils
Class WhereBuilder

java.lang.Object
  |
  +--by.belsoft.report.tools.utils.WhereBuilder

public class WhereBuilder

extends java.lang.Object

The class to work with where clause

Author:

Ilya Kirillov

Constructor Summary

WhereBuilder()

Method Summary

java.lang.StringBuffer	getQue() The query buffer getter
java.lang.String	getSortOrder(java.lang.String criterias) getSortOrder gets sort order from string
boolean	hasPoint(java.lang.String token) hasPoint checks if it is a point inside given string
boolean	isInside(java.lang.String[] signs, java.lang.String sign) isInside checks given signs presence
java.util.ArrayList	makeCriteriasFromString(java.lang.String criterias) makeCriteriasFromString makes criterias list from string
java.lang.String	makeOrderClause(java.util.ArrayList sfields) makeOrderClause makes order by clause
java.util.ArrayList	makeSortFromString(java.lang.String criterias) makeSortFromString makes sort list drom string
java.lang.String	makeWhereClause(java.util.ArrayList criterias) makeWhereClause makes where clause
java.lang.String	parseWherePart(java.lang.String query, boolean flag) parseWherePart parses where part
void	setQue(java.lang.StringBuffer que) setQue The query buffer getter

Methods inherited from class java.lang.Object

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

Constructor Detail

WhereBuilder

public WhereBuilder()

Method Detail

makeWhereClause

public java.lang.String makeWhereClause(java.util.ArrayList criterias)

makeWhereClause makes where clause

Parameters:

criterias - ArrayList the list of criterias

Returns:

String the return where statement

parseWherePart

public java.lang.String parseWherePart(java.lang.String query,
                                       boolean flag)

parseWherePart parses where part

Parameters:

query - String the query to get criterias

flag - boolean to choise what part to get

Returns:

String the result string

makeOrderClause

public java.lang.String makeOrderClause(java.util.ArrayList sfields)

makeOrderClause makes order by clause

Parameters:

sfields - ArrayList the list of criterias

Returns:

String the result order by clause

isInside

public boolean isInside(java.lang.String[] signs,
                        java.lang.String sign)

isInside checks given signs presence

Parameters:

signs - String[] the signs given

sign - String the sign to look

Returns:

boolean the result state

hasPoint

public boolean hasPoint(java.lang.String token)

hasPoint checks if it is a point inside given string

Parameters:

token - String the string to look

Returns:

boolean the result state

makeCriteriasFromString

public java.util.ArrayList makeCriteriasFromString(java.lang.String criterias)

makeCriteriasFromString makes criterias list from string

Parameters:

criterias - String the criterias string

Returns:

ArrayList the result list

getSortOrder

public java.lang.String getSortOrder(java.lang.String criterias)

getSortOrder gets sort order from string

Parameters:

criterias - String the criterias string

Returns:

String the sort string

makeSortFromString

public java.util.ArrayList makeSortFromString(java.lang.String criterias)

makeSortFromString makes sort list drom string

Parameters:

criterias - String the criterias string

Returns:

ArrayList the list with sort fields

getQue

public java.lang.StringBuffer getQue()

The query buffer getter

Returns:

Returns the query.

setQue

public void setQue(java.lang.StringBuffer que)

setQue The query buffer getter

Parameters:

que - StringBuffer the query