ch.emf.dao.filtering

Class Search

java.lang.Object

ch.emf.dao.filtering.Search

public class Search
extends Object

Classe qui mémorise toutes les informations nécessaires à un filtrage de données. Plusieurs filtres peuvent être définis, séparés par des opérateurs de type AND, OR ou NOT. L'ordre de tri (sort) peut aussi être fixé. On peut aussi limiter le nombre d'enregistrements retourné (setMaxResults).

Exemple d'utilisation :

   Search search = new Search(Personne.class);
   addFilterEqual("nom", "Dupond");
   search.setMaxResults(10);
   search.addSortAsc("nom");
   search.addSortAsc("prenom");
 

Ensuite :

   dao.getList(search);
 

Author:

Jean-Claude Stritt

Depend:

- - - Filter, - - - Sort

Opt:

nodefillcolor LemonChiffon

Constructor Summary

Constructors

Constructor and Description
Search(Class<?> cl)

Method Summary

Modifier and Type	Method and Description
void	addField(Field field)
void	addField(String fieldName)
void	addFields(Field... myFields)
void	addFields(String... fieldNames)
void	addFilter(Filter filter)
void	addFilterAnd()
void	addFilterBetween(Field field, Object startValue, Object endValue)
void	addFilterBetween(String fieldName, Object startValue, Object endValue)
void	addFilterByOp(Field field, Operator op, Object value)
void	addFilterByOp(String fieldName, Operator op, Object value)
void	addFilterCloseParenthesis()
void	addFilterEqual(Field field, Object value)
void	addFilterEqual(String fieldName, Object value)
void	addFilterGreaterOrEqual(Field field, Object value)
void	addFilterGreaterOrEqual(String fieldName, Object value)
void	addFilterGreaterThan(Field field, Object value)
void	addFilterGreaterThan(String fieldName, Object value)
void	addFilterIlike(Field field, String value)
void	addFilterIlike(String fieldName, String value)
void	addFilterIn(Field field, Object... values)
void	addFilterIn(String fieldName, Object... values)
void	addFilterIsEmpty(Field field)
void	addFilterIsEmpty(String fieldName)
void	addFilterIsNotEmpty(Field field)
void	addFilterIsNotEmpty(String fieldName)
void	addFilterIsNotNull(Field field)
void	addFilterIsNotNull(String fieldName)
void	addFilterIsNull(Field field)
void	addFilterIsNull(String fieldName)
void	addFilterLessOrEqual(Field field, Object value)
void	addFilterLessOrEqual(String fieldName, Object value)
void	addFilterLessThan(Field field, Object value)
void	addFilterLessThan(String fieldName, Object value)
void	addFilterLike(Field field, String value)
void	addFilterLike(String fieldName, String value)
void	addFilterNotEqual(Field field, Object value)
void	addFilterNotEqual(String fieldName, Object value)
void	addFilterNotIn(Field field, Object... values)
void	addFilterNotIn(String fieldName, Object... values)
void	addFilterOpenParenthesis()
void	addFilterOr()
void	addFilters(Filter... myFilters)
void	addGroupByField(Field... myFields)
void	addGroupByField(Field field)
void	addGroupByField(String... fieldNames)
void	addGroupByField(String fieldName)
void	addHavingCondition(String condition)
void	addHavingConditions(String... conditions)
void	addSort(Sort sort)
void	addSort(String fieldName, boolean desc)
void	addSort(String fieldName, boolean desc, boolean ignoreCase)
void	addSortAsc(String... fieldNames)
void	addSortAsc(String fieldName)
void	addSortAsc(String fieldName, boolean ignoreCase)
void	addSortDesc(String... fieldNames)
void	addSortDesc(String fieldName)
void	addSortDesc(String fieldName, boolean ignoreCase)
void	addSorts(Sort... mySorts)
Class<?>	getEntity()
List<Field>	getFields()
List<Filter>	getFilters()
int	getFirstResult()
List<String>	getFunctions()
List<Field>	getGroupbyFields()
List<String>	getHavingConditions()
int	getMaxResults()
List<Sort>	getSorts()
boolean	isDistinct()
void	setDistinct(boolean distinct)
void	setFilters(List<Filter> filters)
void	setFirstResult(int firstResult)
void	setMaxResults(int maxResults)
void	setSort(List<Sort> sorts)

Methods inherited from class java.lang.Object

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

Constructor Detail

Search

public Search(Class<?> cl)

Method Detail

getEntity

public Class<?> getEntity()

getFields

public List<Field> getFields()

getFilters

public List<Filter> getFilters()

setFilters

public void setFilters(List<Filter> filters)

getSorts

public List<Sort> getSorts()

setSort

public void setSort(List<Sort> sorts)

getFunctions

public List<String> getFunctions()

getGroupbyFields

public List<Field> getGroupbyFields()

getHavingConditions

public List<String> getHavingConditions()

getFirstResult

public int getFirstResult()

setFirstResult

public void setFirstResult(int firstResult)

getMaxResults

public int getMaxResults()

setMaxResults

public void setMaxResults(int maxResults)

isDistinct

public boolean isDistinct()

setDistinct

public void setDistinct(boolean distinct)

addField

public void addField(Field field)

addField

public void addField(String fieldName)

addFields

public void addFields(Field... myFields)

addFields

public void addFields(String... fieldNames)

addFilter

public void addFilter(Filter filter)

addFilters

public void addFilters(Filter... myFilters)

addFilterEqual

public void addFilterEqual(Field field,
                           Object value)

addFilterEqual

public void addFilterEqual(String fieldName,
                           Object value)

addFilterNotEqual

public void addFilterNotEqual(Field field,
                              Object value)

addFilterNotEqual

public void addFilterNotEqual(String fieldName,
                              Object value)

addFilterLessThan

public void addFilterLessThan(Field field,
                              Object value)

addFilterLessThan

public void addFilterLessThan(String fieldName,
                              Object value)

addFilterGreaterThan

public void addFilterGreaterThan(Field field,
                                 Object value)

addFilterGreaterThan

public void addFilterGreaterThan(String fieldName,
                                 Object value)

addFilterLessOrEqual

public void addFilterLessOrEqual(Field field,
                                 Object value)

addFilterLessOrEqual

public void addFilterLessOrEqual(String fieldName,
                                 Object value)

addFilterGreaterOrEqual

public void addFilterGreaterOrEqual(Field field,
                                    Object value)

addFilterGreaterOrEqual

public void addFilterGreaterOrEqual(String fieldName,
                                    Object value)

addFilterLike

public void addFilterLike(Field field,
                          String value)

addFilterLike

public void addFilterLike(String fieldName,
                          String value)

addFilterIlike

public void addFilterIlike(Field field,
                           String value)

addFilterIlike

public void addFilterIlike(String fieldName,
                           String value)

addFilterBetween

public void addFilterBetween(Field field,
                             Object startValue,
                             Object endValue)

addFilterBetween

public void addFilterBetween(String fieldName,
                             Object startValue,
                             Object endValue)

addFilterIn

public void addFilterIn(Field field,
                        Object... values)

addFilterIn

public void addFilterIn(String fieldName,
                        Object... values)

addFilterNotIn

public void addFilterNotIn(Field field,
                           Object... values)

addFilterNotIn

public void addFilterNotIn(String fieldName,
                           Object... values)

addFilterIsNull

public void addFilterIsNull(Field field)

addFilterIsNull

public void addFilterIsNull(String fieldName)

addFilterIsNotNull

public void addFilterIsNotNull(Field field)

addFilterIsNotNull

public void addFilterIsNotNull(String fieldName)

addFilterIsEmpty

public void addFilterIsEmpty(Field field)

addFilterIsEmpty

public void addFilterIsEmpty(String fieldName)

addFilterIsNotEmpty

public void addFilterIsNotEmpty(Field field)

addFilterIsNotEmpty

public void addFilterIsNotEmpty(String fieldName)

addFilterAnd

public void addFilterAnd()

addFilterOr

public void addFilterOr()

addFilterOpenParenthesis

public void addFilterOpenParenthesis()

addFilterCloseParenthesis

public void addFilterCloseParenthesis()

addFilterByOp

public void addFilterByOp(Field field,
                          Operator op,
                          Object value)

addFilterByOp

public void addFilterByOp(String fieldName,
                          Operator op,
                          Object value)

addGroupByField

public void addGroupByField(Field field)

addGroupByField

public void addGroupByField(String fieldName)

addGroupByField

public void addGroupByField(Field... myFields)

addGroupByField

public void addGroupByField(String... fieldNames)

addHavingCondition

public void addHavingCondition(String condition)

addHavingConditions

public void addHavingConditions(String... conditions)

addSort

public void addSort(Sort sort)

addSorts

public void addSorts(Sort... mySorts)

addSort

public void addSort(String fieldName,
                    boolean desc,
                    boolean ignoreCase)

addSort

public void addSort(String fieldName,
                    boolean desc)

addSortAsc

public void addSortAsc(String fieldName)

addSortAsc

public void addSortAsc(String... fieldNames)

addSortAsc

public void addSortAsc(String fieldName,
                       boolean ignoreCase)

addSortDesc

public void addSortDesc(String fieldName)

addSortDesc

public void addSortDesc(String... fieldNames)

addSortDesc

public void addSortDesc(String fieldName,
                        boolean ignoreCase)