QueryBuilder (xpert-framework 1.8.3-SNAPSHOT API)

java.lang.Object
- com.xpert.persistence.query.QueryBuilder

public class QueryBuilder
extends Object

Author:: Ayslan

Constructor Summary

Constructors
Constructor and Description

QueryBuilder(javax.persistence.EntityManager entityManager)

Constructors
Constructor and Description
`QueryBuilder(javax.persistence.EntityManager entityManager)`

Method Summary

Methods
Modifier and Type	Method and Description
`QueryBuilder`	`add(List<Restriction> restrictions)` Add a restriction list
`QueryBuilder`	`add(Map<String,Object> restrictions)` Add a restriction map
`QueryBuilder`	`add(Restriction restriction)` Add a restriction
`QueryBuilder`	`add(String property, Object value)` Add a RestrictionType.EQUALS
`QueryBuilder`	`add(String property, RestrictionType restrictionType)` Add a restriction
`QueryBuilder`	`add(String property, RestrictionType restrictionType, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar restriction
`QueryBuilder`	`add(String property, RestrictionType restrictionType, Date value, javax.persistence.TemporalType temporalType)` Add a Date restriction
`QueryBuilder`	`add(String property, RestrictionType restrictionType, Object value)` Add a restriction
`QueryBuilder`	`add(String property, RestrictionType restrictionType, Object value, LikeType likeType)` Add a restriction
`QueryBuilder`	`addQueryString(String property)` Add a RestrictionType.QUERY_STRING
`QueryBuilder`	`addQueryString(String property, List<QueryParameter> parameters)` Add a RestrictionType.QUERY_STRING
`QueryBuilder`	`addQueryString(String property, QueryParameter parameter)` Add a RestrictionType.QUERY_STRING
`Number`	`avg(String property)`
`Number`	`avg(String property, Number valueWhenNull)`
`Long`	`count()`
`static javax.persistence.Query`	`createNativeQueryFromFile(javax.persistence.EntityManager entityManager, String queryPath, Class daoClass)`
`static javax.persistence.Query`	`createNativeQueryFromFile(javax.persistence.EntityManager entityManager, String queryPath, Class daoClass, Class resultClass)`
`javax.persistence.Query`	`createQuery()`
`QueryBuilder`	`debug()`
`QueryBuilder`	`endGroup()` Add a RestrictionType.END_GROUP
`QueryBuilder`	`equals(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.EQUALS (property '=' value)
`QueryBuilder`	`equals(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.EQUALS (property '=' value)
`QueryBuilder`	`equals(String property, Object value)` Add a RestrictionType.EQUALS (property '=' value)
`QueryBuilder`	`from(Class from)`
`QueryBuilder`	`from(Class from, String alias)`
`List<Restriction>`	`getNormalizedRestrictions()`
`static <T> List<T>`	`getNormalizedResultList(String attributes, List resultList, Class<T> clazz)`
`List<QueryParameter>`	`getQueryParameters()`
`static String`	`getQuerySelectClausule(QueryType type, String select)`
`String`	`getQueryString()`
`static String`	`getQueryStringFromRestrictions(List<Restriction> restrictions)`
`<T> List<T>`	`getResultList()`
`<T> List<T>`	`getResultList(Class expectedType)`
`Object`	`getSingleResult()`
`QueryBuilder`	`greaterEqualsThan(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.GREATER_EQUALS_THAN (property '>=' value)
`QueryBuilder`	`greaterEqualsThan(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.GREATER_EQUALS_THAN (property '>=' value)
`QueryBuilder`	`greaterEqualsThan(String property, Object value)` Add a RestrictionType.GREATER_EQUALS_THAN (property '>=' value)
`QueryBuilder`	`greaterThan(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.GREATER_THAN (property '>' value)
`QueryBuilder`	`greaterThan(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.GREATER_THAN (property '>' value)
`QueryBuilder`	`greaterThan(String property, Object value)` Add a RestrictionType.GREATER_THAN (property '>' value)
`QueryBuilder`	`in(String property, Object value)` Add a RestrictionType.IN (property 'in' value)
`static void`	`initializeCascade(String property, Object bean)`
`QueryBuilder`	`innerJoin(String join)`
`QueryBuilder`	`innerJoin(String join, String alias)`
`QueryBuilder`	`innerJoinFetch(String join)`
`QueryBuilder`	`innerJoinFetch(String join, String alias)`
`QueryBuilder`	`isNotNull(String property)` Add a RestrictionType.NOT_NULL (property 'is not null')
`QueryBuilder`	`isNull(String property)` Add a RestrictionType.NULL (property 'is null')
`QueryBuilder`	`join(JoinBuilder joinBuilder)`
`QueryBuilder`	`join(String join)`
`QueryBuilder`	`join(String join, String alias)`
`QueryBuilder`	`joinFetch(String join)`
`QueryBuilder`	`joinFetch(String join, String alias)`
`QueryBuilder`	`leftJoin(String join)`
`QueryBuilder`	`leftJoin(String join, String alias)`
`QueryBuilder`	`leftJoinFetch(String join)`
`QueryBuilder`	`leftJoinFetch(String join, String alias)`
`QueryBuilder`	`lessEqualsThan(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.LESS_EQUALS_THAN (property '<=' value)
`QueryBuilder`	`lessEqualsThan(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.LESS_EQUALS_THAN (property '<=' value)
`QueryBuilder`	`lessEqualsThan(String property, Object value)` Add a RestrictionType.LESS_EQUALS_THAN (property '<=' value)
`QueryBuilder`	`lessThan(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.LESS_THAN (property '<' value)
`QueryBuilder`	`lessThan(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.LESS_THAN (property '<' value)
`QueryBuilder`	`lessThan(String property, Object value)` Add a RestrictionType.LESS_THAN (property '<' value)
`QueryBuilder`	`like(String property, Object value)` Add a RestrictionType.LIKE (property 'like' value)
`QueryBuilder`	`like(String property, Object value, boolean ilike)` Add a RestrictionType.LIKE (property 'like' value)
`QueryBuilder`	`like(String property, Object value, LikeType likeType)` Add a RestrictionType.LIKE (property 'like' value)
`QueryBuilder`	`like(String property, Object value, LikeType likeType, boolean ilike)` Add a RestrictionType.LIKE (property 'like' value)
`Object`	`max(String property)`
`Object`	`max(String property, Object valueWhenNull)`
`Object`	`min(String property)`
`Object`	`min(String property, Object valueWhenNull)`
`QueryBuilder`	`notEquals(String property, Calendar value, javax.persistence.TemporalType temporalType)` Add a Calendar RestrictionType.NOT_EQUALS (property '!
`QueryBuilder`	`notEquals(String property, Date value, javax.persistence.TemporalType temporalType)` Add a Date RestrictionType.NOT_EQUALS (property '!
`QueryBuilder`	`notEquals(String property, Object value)` Add a RestrictionType.NOT_EQUALS (property '!
`QueryBuilder`	`notIn(String property, Object value)` Add a RestrictionType.NOT_IN (property 'not in' value)
`QueryBuilder`	`notLike(String property, Object value)` Add a RestrictionType.NOT_LIKE (property 'not like' value)
`QueryBuilder`	`notLike(String property, Object value, boolean ilike)` Add a RestrictionType.NOT_LIKE (property 'not like' value)
`QueryBuilder`	`notLike(String property, Object value, LikeType likeType)` Add a RestrictionType.NOT_LIKE (property 'not like' value)
`QueryBuilder`	`notLike(String property, Object value, LikeType likeType, boolean ilike)` Add a RestrictionType.NOT_LIKE (property 'not like' value)
`QueryBuilder`	`or()` Add a RestrictionType.OR
`QueryBuilder`	`orderBy(List<String> order)`
`QueryBuilder`	`orderBy(String order)`
`static String`	`readInputStreamAsString(InputStream inputStream)`
`QueryBuilder`	`rightJoin(String join)`
`QueryBuilder`	`rightJoin(String join, String alias)`
`QueryBuilder`	`rightJoinFetch(String join)`
`QueryBuilder`	`rightJoinFetch(String join, String alias)`
`QueryBuilder`	`select(String attributes)`
`QueryBuilder`	`selectDistinct(String attributes)`
`QueryBuilder`	`setFirstResult(Integer firstResult)`
`QueryBuilder`	`setMaxResults(Integer maxResults)`
`QueryBuilder`	`startGroup()` Add a RestrictionType.START_GROUP
`Number`	`sum(String property)`
`Number`	`sum(String property, Number valueWhenNull)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryBuilder

public QueryBuilder(javax.persistence.EntityManager entityManager)

Method Detail

from
```
public QueryBuilder from(Class from)
```

from

public QueryBuilder from(Class from,
                String alias)

selectDistinct

public QueryBuilder selectDistinct(String attributes)

select

public QueryBuilder select(String attributes)

orderBy

public QueryBuilder orderBy(String order)

orderBy

public QueryBuilder orderBy(List<String> order)

debug
```
public QueryBuilder debug()
```

getQuerySelectClausule

public static String getQuerySelectClausule(QueryType type,
                            String select)

getQueryStringFromRestrictions
```
public static String getQueryStringFromRestrictions(List<Restriction> restrictions)
```
Parameters:
restrictions -

Returns:
String of the part after "WHERE" from JPQL generated

getQueryString
```
public String getQueryString()
```
Returns:
The complete String of JPQL generated in this QueryBuilder

getQueryParameters

public List<QueryParameter> getQueryParameters()

count
```
public Long count()
```
Returns:
Value of clausule "SELECT COUNT(*)"

avg
```
public Number avg(String property)
```
Parameters:
property - Property to query

Returns:
Value of clausule "SELECT AVG(property)"

avg
```
public Number avg(String property,
         Number valueWhenNull)
```
Parameters:
property - Property to query
valueWhenNull - Return value when query result is null

Returns:
Value of clausule "SELECT AVG(property)"

sum
```
public Number sum(String property)
```
Parameters:
property - Property to query

Returns:
Value of clausule "SELECT SUM(property)"

sum
```
public Number sum(String property,
         Number valueWhenNull)
```
Parameters:
property - property Property to query
valueWhenNull - Return value when query result is null

Returns:
Value of clausule "SELECT SUM(property)"

max
```
public Object max(String property)
```
Parameters:
property - Property to query

Returns:
Value of clausule "SELECT max(property)"

max
```
public Object max(String property,
         Object valueWhenNull)
```
Parameters:
property - Property to query
valueWhenNull - Return value when query result is null

Returns:
Value of clausule "SELECT max(property)"

min
```
public Object min(String property)
```
Parameters:
property - Property to query

Returns:
Value of clausule "SELECT min(property)"

min
```
public Object min(String property,
         Object valueWhenNull)
```
Parameters:
property - Property to query
valueWhenNull - Return value when query result is null

Returns:
Value of clausule "SELECT min(property)"

createQuery

public javax.persistence.Query createQuery()

getSingleResult
```
public Object getSingleResult()
```
Returns:
entityManager.getSingleResult(), returns null when NoResultExceptionis throw

setMaxResults
```
public QueryBuilder setMaxResults(Integer maxResults)
```
Parameters:
maxResults - max results in Query

Returns:

setFirstResult
```
public QueryBuilder setFirstResult(Integer firstResult)
```
Parameters:
firstResult - min results in Query

Returns:

getResultList
```
public <T> List<T> getResultList()
```
Type Parameters:
T - Result Type

Returns:
entityManager.getResultList()

getResultList
```
public <T> List<T> getResultList(Class expectedType)
```
Type Parameters:
T - Result Type
Parameters:
expectedType - The expected type in result

Returns:
entityManager.getResultList()

getNormalizedResultList

public static <T> List<T> getNormalizedResultList(String attributes,
                                  List resultList,
                                  Class<T> clazz)

Type Parameters:: T - Result Type
Parameters:: attributes - Attributes to select; resultList - The Query Result List; clazz - The expected type in result
Returns:

initializeCascade

public static void initializeCascade(String property,
                     Object bean)

createNativeQueryFromFile

public static javax.persistence.Query createNativeQueryFromFile(javax.persistence.EntityManager entityManager,
                                                String queryPath,
                                                Class daoClass)

createNativeQueryFromFile

public static javax.persistence.Query createNativeQueryFromFile(javax.persistence.EntityManager entityManager,
                                                String queryPath,
                                                Class daoClass,
                                                Class resultClass)

readInputStreamAsString

public static String readInputStreamAsString(InputStream inputStream)
                                      throws IOException

Throws:: IOException

getNormalizedRestrictions

public List<Restriction> getNormalizedRestrictions()

add
```
public QueryBuilder add(Map<String,Object> restrictions)
```
Add a restriction map

Parameters:
restrictions -

Returns:
Current QueryBuilder with added restriction

add
```
public QueryBuilder add(List<Restriction> restrictions)
```
Add a restriction list

Parameters:
restrictions -

Returns:
Current QueryBuilder with added restriction

add
```
public QueryBuilder add(Restriction restriction)
```
Add a restriction

Parameters:
restriction -

Returns:
Current QueryBuilder with added restriction

add

public QueryBuilder add(String property,
               RestrictionType restrictionType)

Add a restriction

Parameters:: property -; restrictionType -
Returns:: Current QueryBuilder with added restriction

add
```
public QueryBuilder add(String property,
               Object value)
```
Add a RestrictionType.EQUALS

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

add

public QueryBuilder add(String property,
               RestrictionType restrictionType,
               Date value,
               javax.persistence.TemporalType temporalType)

Add a Date restriction

Parameters:: property -; restrictionType -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

add

public QueryBuilder add(String property,
               RestrictionType restrictionType,
               Calendar value,
               javax.persistence.TemporalType temporalType)

Add a Calendar restriction

Parameters:: property -; restrictionType -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

add

public QueryBuilder add(String property,
               RestrictionType restrictionType,
               Object value)

Add a restriction

Parameters:: property -; restrictionType -; value -
Returns:: Current QueryBuilder with added restriction

add

public QueryBuilder add(String property,
               RestrictionType restrictionType,
               Object value,
               LikeType likeType)

Add a restriction

Parameters:: property -; restrictionType -; value -; likeType -
Returns:: Current QueryBuilder with added restriction

addQueryString
```
public QueryBuilder addQueryString(String property)
```
Add a RestrictionType.QUERY_STRING

Parameters:
property -

Returns:
Current QueryBuilder with added restriction

addQueryString

public QueryBuilder addQueryString(String property,
                          List<QueryParameter> parameters)

Add a RestrictionType.QUERY_STRING

Parameters:: property -; parameters -
Returns:: Current Restrictions with added restriction

addQueryString

public QueryBuilder addQueryString(String property,
                          QueryParameter parameter)

Add a RestrictionType.QUERY_STRING

Parameters:: property -; parameter -
Returns:: Current Restrictions with added restriction

isNull
```
public QueryBuilder isNull(String property)
```
Add a RestrictionType.NULL (property 'is null')

Parameters:
property -

Returns:
Current QueryBuilder with added restriction

isNotNull
```
public QueryBuilder isNotNull(String property)
```
Add a RestrictionType.NOT_NULL (property 'is not null')

Parameters:
property -

Returns:
Current QueryBuilder with added restriction

like
```
public QueryBuilder like(String property,
                Object value)
```
Add a RestrictionType.LIKE (property 'like' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

like
```
public QueryBuilder like(String property,
                Object value,
                boolean ilike)
```
Add a RestrictionType.LIKE (property 'like' value)

Parameters:
property -
value -
ilike -

Returns:
Current QueryBuilder with added restriction

like

public QueryBuilder like(String property,
                Object value,
                LikeType likeType)

Add a RestrictionType.LIKE (property 'like' value)

Parameters:: property -; value -; likeType -
Returns:: Current QueryBuilder with added restriction

like

public QueryBuilder like(String property,
                Object value,
                LikeType likeType,
                boolean ilike)

Add a RestrictionType.LIKE (property 'like' value)

Parameters:: property -; value -; likeType -; ilike -
Returns:: Current QueryBuilder with added restriction

notLike
```
public QueryBuilder notLike(String property,
                   Object value)
```
Add a RestrictionType.NOT_LIKE (property 'not like' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

notLike
```
public QueryBuilder notLike(String property,
                   Object value,
                   boolean ilike)
```
Add a RestrictionType.NOT_LIKE (property 'not like' value)

Parameters:
property -
value -
ilike -

Returns:
Current QueryBuilder with added restriction

notLike

public QueryBuilder notLike(String property,
                   Object value,
                   LikeType likeType)

Add a RestrictionType.NOT_LIKE (property 'not like' value)

Parameters:: property -; value -; likeType -
Returns:: Current QueryBuilder with added restriction

notLike

public QueryBuilder notLike(String property,
                   Object value,
                   LikeType likeType,
                   boolean ilike)

Add a RestrictionType.NOT_LIKE (property 'not like' value)

Parameters:: property -; value -; likeType -; ilike -
Returns:: Current QueryBuilder with added restriction

greaterThan
```
public QueryBuilder greaterThan(String property,
                       Object value)
```
Add a RestrictionType.GREATER_THAN (property '>' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

greaterThan

public QueryBuilder greaterThan(String property,
                       Date value,
                       javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.GREATER_THAN (property '>' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

greaterThan

public QueryBuilder greaterThan(String property,
                       Calendar value,
                       javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.GREATER_THAN (property '>' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

greaterEqualsThan
```
public QueryBuilder greaterEqualsThan(String property,
                             Object value)
```
Add a RestrictionType.GREATER_EQUALS_THAN (property '>=' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

greaterEqualsThan

public QueryBuilder greaterEqualsThan(String property,
                             Date value,
                             javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.GREATER_EQUALS_THAN (property '>=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

greaterEqualsThan

public QueryBuilder greaterEqualsThan(String property,
                             Calendar value,
                             javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.GREATER_EQUALS_THAN (property '>=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

lessThan
```
public QueryBuilder lessThan(String property,
                    Object value)
```
Add a RestrictionType.LESS_THAN (property '<' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

lessThan

public QueryBuilder lessThan(String property,
                    Date value,
                    javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.LESS_THAN (property '<' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

lessThan

public QueryBuilder lessThan(String property,
                    Calendar value,
                    javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.LESS_THAN (property '<' value)

Parameters:: property -; value -; temporalType -
Returns:

lessEqualsThan
```
public QueryBuilder lessEqualsThan(String property,
                          Object value)
```
Add a RestrictionType.LESS_EQUALS_THAN (property '<=' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

lessEqualsThan

public QueryBuilder lessEqualsThan(String property,
                          Date value,
                          javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.LESS_EQUALS_THAN (property '<=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

lessEqualsThan

public QueryBuilder lessEqualsThan(String property,
                          Calendar value,
                          javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.LESS_EQUALS_THAN (property '<=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

in
```
public QueryBuilder in(String property,
              Object value)
```
Add a RestrictionType.IN (property 'in' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

notIn
```
public QueryBuilder notIn(String property,
                 Object value)
```
Add a RestrictionType.NOT_IN (property 'not in' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

equals
```
public QueryBuilder equals(String property,
                  Object value)
```
Add a RestrictionType.EQUALS (property '=' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

equals

public QueryBuilder equals(String property,
                  Date value,
                  javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.EQUALS (property '=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

equals

public QueryBuilder equals(String property,
                  Calendar value,
                  javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.EQUALS (property '=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

notEquals
```
public QueryBuilder notEquals(String property,
                     Object value)
```
Add a RestrictionType.NOT_EQUALS (property '!=' value)

Parameters:
property -
value -

Returns:
Current QueryBuilder with added restriction

notEquals

public QueryBuilder notEquals(String property,
                     Date value,
                     javax.persistence.TemporalType temporalType)

Add a Date RestrictionType.NOT_EQUALS (property '!=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

notEquals

public QueryBuilder notEquals(String property,
                     Calendar value,
                     javax.persistence.TemporalType temporalType)

Add a Calendar RestrictionType.NOT_EQUALS (property '!=' value)

Parameters:: property -; value -; temporalType -
Returns:: Current QueryBuilder with added restriction

or
```
public QueryBuilder or()
```
Add a RestrictionType.OR

Returns:
Current QueryBuilder with added restriction

startGroup
```
public QueryBuilder startGroup()
```
Add a RestrictionType.START_GROUP

Returns:
Current QueryBuilder with added restriction

endGroup
```
public QueryBuilder endGroup()
```
Add a RestrictionType.END_GROUP

Returns:
Current QueryBuilder with added restriction

join

public QueryBuilder join(JoinBuilder joinBuilder)

leftJoin

public QueryBuilder leftJoin(String join)

leftJoin

public QueryBuilder leftJoin(String join,
                    String alias)

leftJoinFetch

public QueryBuilder leftJoinFetch(String join)

leftJoinFetch

public QueryBuilder leftJoinFetch(String join,
                         String alias)

innerJoin

public QueryBuilder innerJoin(String join)

innerJoin

public QueryBuilder innerJoin(String join,
                     String alias)

innerJoinFetch

public QueryBuilder innerJoinFetch(String join)

innerJoinFetch

public QueryBuilder innerJoinFetch(String join,
                          String alias)

join

public QueryBuilder join(String join)

join

public QueryBuilder join(String join,
                String alias)

joinFetch

public QueryBuilder joinFetch(String join)

joinFetch

public QueryBuilder joinFetch(String join,
                     String alias)

rightJoin

public QueryBuilder rightJoin(String join)

rightJoin

public QueryBuilder rightJoin(String join,
                     String alias)

rightJoinFetch

public QueryBuilder rightJoinFetch(String join)

rightJoinFetch

public QueryBuilder rightJoinFetch(String join,
                          String alias)

Class QueryBuilder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

QueryBuilder

Method Detail

from

from

selectDistinct

select

orderBy

orderBy

debug

getQuerySelectClausule

getQueryStringFromRestrictions

getQueryString

getQueryParameters

count

avg

avg

sum

sum

max

max

min

min

createQuery

getSingleResult

setMaxResults

setFirstResult

getResultList

getResultList

getNormalizedResultList

initializeCascade

createNativeQueryFromFile

createNativeQueryFromFile

readInputStreamAsString

getNormalizedRestrictions

add

add

add

add

add

add

add

add

add

addQueryString

addQueryString

addQueryString

isNull

isNotNull

like

like

like

like

notLike

notLike

notLike

notLike

greaterThan

greaterThan

greaterThan

greaterEqualsThan

greaterEqualsThan

greaterEqualsThan

lessThan

lessThan

lessThan

lessEqualsThan

lessEqualsThan

lessEqualsThan

in

notIn

equals

equals

equals

notEquals

notEquals