com.suncode.pwfl.search.sql

Class SQLBuilder

java.lang.Object

com.suncode.pwfl.search.sql.SQLBuilder

public class SQLBuilder
extends Object

Pozwala stworzyć definicję zapytania SQL

Author:

Paweł Rosolak 5 lut 2014

Constructor Summary

Constructors

Constructor and Description
SQLBuilder()
SQLBuilder(String query)
SQLBuilder(String query, Map<String,org.hibernate.type.Type> scalars, List<SQLFilter> filters)

Method Summary

Modifier and Type	Method and Description
void	addFilter(SQLFilter filter)
void	addScalar(String alias, org.hibernate.type.Type type)
void	addSorter(Sorter sorter)
String	buildQuery()
String	buildQuery(String baseQuery)
String	getCountQuery()
List<SQLFilter>	getFilters()
Map<String,Object>	getParameters()
Map<String,Collection<Object>>	getParametersList()
String	getQuery()
Map<String,org.hibernate.type.Type>	getScalars()
List<Sorter>	getSorters()
boolean	isUseScalars()
void	setCountQuery(String countQuery)
void	setFilters(List<SQLFilter> filters)
void	setFilters(Map<String,Object> params)
void	setParameter(String alias, Object value)
void	setParameterList(String alias, Collection<Object> value)
void	setParameters(List<SQLFilter> filters)
void	setParameters(Map<String,Object> parameters)
void	setParametersList(Map<String,Collection<Object>> parametersList)
void	setQuery(String query)
void	setScalars(Map<String,org.hibernate.type.Type> scalars)
void	setSorters(List<Sorter> sorters)
void	setUseScalars(boolean useScalars)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLBuilder

public SQLBuilder()

SQLBuilder

public SQLBuilder(String query)

SQLBuilder

public SQLBuilder(String query,
                  Map<String,org.hibernate.type.Type> scalars,
                  List<SQLFilter> filters)

Method Detail

getQuery

public String getQuery()

setQuery

public void setQuery(String query)

isUseScalars

public boolean isUseScalars()

setUseScalars

public void setUseScalars(boolean useScalars)

getScalars

public Map<String,org.hibernate.type.Type> getScalars()

setScalars

public void setScalars(Map<String,org.hibernate.type.Type> scalars)

getFilters

public List<SQLFilter> getFilters()

setFilters

public void setFilters(List<SQLFilter> filters)

setFilters

public void setFilters(Map<String,Object> params)

addScalar

public void addScalar(String alias,
                      org.hibernate.type.Type type)

getSorters

public List<Sorter> getSorters()

setSorters

public void setSorters(List<Sorter> sorters)

getParameters

public Map<String,Object> getParameters()

setParameters

public void setParameters(Map<String,Object> parameters)

setParameter

public void setParameter(String alias,
                         Object value)

getParametersList

public Map<String,Collection<Object>> getParametersList()

setParametersList

public void setParametersList(Map<String,Collection<Object>> parametersList)

setParameterList

public void setParameterList(String alias,
                             Collection<Object> value)

addFilter

public void addFilter(SQLFilter filter)

setParameters

public void setParameters(List<SQLFilter> filters)

addSorter

public void addSorter(Sorter sorter)

buildQuery

public String buildQuery()

buildQuery

public String buildQuery(String baseQuery)

getCountQuery

public String getCountQuery()

setCountQuery

public void setCountQuery(String countQuery)