public interface SQLQuerying
PreparedStatement
.Modifier and Type | Method and Description |
---|---|
String |
constructQuery(Class<?> resultType,
Specification<Composite> whereClause,
OrderBy[] orderBySegments,
Integer firstResult,
Integer maxResults,
Map<String,Object> variables,
List<Object> values,
List<Integer> valueSqlTypes,
Boolean countOnly)
This method will be called when parsing needs to be done from Zest query to SQL query.
|
Integer |
getResultSetType(Integer firstResult,
Integer maxResults) |
Boolean |
isFirstResultSettingSupported() |
String constructQuery(Class<?> resultType, @Optional Specification<Composite> whereClause, @Optional OrderBy[] orderBySegments, @Optional Integer firstResult, @Optional Integer maxResults, Map<String,Object> variables, List<Object> values, List<Integer> valueSqlTypes, Boolean countOnly) throws EntityFinderException
PreparedStatement
.resultType
- The result type of Zest query.whereClause
- The where clause of Zest query.orderBySegments
- The order by segments of Zest query.firstResult
- The first result index of Zest query.maxResults
- The max amount of returned results.values
- Values to put into PreparedStatement
, in the order of the list. This List is created from
the outside and this method is supposed to fill it with necessary values, if any.valueSqlTypes
- The SQL types of the objects in values
. Each SQL type at index x
is
interpreted as type of value at index x
of the values
-list.countOnly
- True if this query should return only the number of matching entities, false otherwise.PreparedStatement
.EntityFinderException
- If SQLException or something else bad happens.Boolean isFirstResultSettingSupported()