Class SelectBuilder
- java.lang.Object
-
- org.javers.repository.sql.session.SelectBuilder
-
public class SelectBuilder extends java.lang.Object
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description SelectBuilder
and(java.lang.String columnName, java.lang.Long value)
SelectBuilder
and(java.lang.String columnName, java.lang.String value)
SelectBuilder
and(java.lang.String columnName, java.lang.String operator, Parameter parameter)
SelectBuilder
and(java.lang.String columnName, java.math.BigDecimal value)
SelectBuilder
and(java.lang.String predicateSQL, Parameter... params)
SelectBuilder
append(java.lang.String moreSql, Parameter... params)
<T> java.util.List<T>
executeQuery(ObjectMapper<T> objectMapper)
SelectBuilder
from(java.lang.String fromClauseSQL)
java.util.List<Parameter>
getParameters()
java.lang.String
getQueryName()
SelectBuilder
limit(int limit, int offset)
SelectBuilder
orderByAsc(java.lang.String columns)
SelectBuilder
orderByDesc(java.lang.String columns)
long
queryForLong(java.lang.String queryName)
java.util.Optional<java.math.BigDecimal>
queryForOptionalBigDecimal(java.lang.String queryName)
java.util.Optional<java.lang.Long>
queryForOptionalLong()
T
queryName(java.lang.String queryName)
SelectBuilder
sql(java.lang.String sql)
SelectBuilder
wrap(java.lang.String leftSql, java.lang.String rightSql, Parameter... params)
-
-
-
Method Detail
-
sql
public SelectBuilder sql(java.lang.String sql)
-
from
public SelectBuilder from(java.lang.String fromClauseSQL)
-
and
public SelectBuilder and(java.lang.String columnName, java.lang.String operator, Parameter parameter)
-
and
public SelectBuilder and(java.lang.String predicateSQL, Parameter... params)
-
and
public SelectBuilder and(java.lang.String columnName, java.lang.Long value)
-
and
public SelectBuilder and(java.lang.String columnName, java.lang.String value)
-
and
public SelectBuilder and(java.lang.String columnName, java.math.BigDecimal value)
-
limit
public SelectBuilder limit(int limit, int offset)
-
orderByDesc
public SelectBuilder orderByDesc(java.lang.String columns)
-
orderByAsc
public SelectBuilder orderByAsc(java.lang.String columns)
-
wrap
public SelectBuilder wrap(java.lang.String leftSql, java.lang.String rightSql, Parameter... params)
-
append
public SelectBuilder append(java.lang.String moreSql, Parameter... params)
-
queryForLong
public long queryForLong(java.lang.String queryName)
-
queryForOptionalBigDecimal
public java.util.Optional<java.math.BigDecimal> queryForOptionalBigDecimal(java.lang.String queryName)
-
queryForOptionalLong
public java.util.Optional<java.lang.Long> queryForOptionalLong()
-
executeQuery
public <T> java.util.List<T> executeQuery(ObjectMapper<T> objectMapper)
-
queryName
public T queryName(java.lang.String queryName)
-
getParameters
public java.util.List<Parameter> getParameters()
-
getQueryName
public java.lang.String getQueryName()
-
-