com.mybatisflex.core.activerecord.query

Class QueryModel<T extends QueryModel<T>>

java.lang.Object

com.mybatisflex.core.activerecord.query.QueryModel<T>

Type Parameters:

T - 实体类类型

Direct Known Subclasses:

Model

public abstract class QueryModel<T extends QueryModel<T>>
extends Object

实体类条件查询构建模型。

该类内部维护了一个 QueryWrapper 属性，用来构建查询条件。 通过实体类属性构建的查询条件都是值等于，该扩展用于非等于值构建，及一些其他方法。 如果不想通过实体类直接构建查询条件，可以不继承该类。

Since:

2023-07-24

Author:

王帅

Constructor Summary

Constructors

Constructor and Description
QueryModel()

Method Summary

Modifier and Type	Method and Description
<E> WhereBuilder<T>	and(LambdaGetter<E> column)
T	and(QueryCondition queryCondition)
T	and(String sql)
T	and(String sql, Object... params)
T	as(String alias)
JoinBuilder<T>	crossJoin(Class<?> entityClass)
JoinBuilder<T>	crossJoin(Class<?> entityClass, boolean when)
JoinBuilder<T>	crossJoin(QueryTable table)
JoinBuilder<T>	crossJoin(QueryTable table, boolean when)
JoinBuilder<T>	crossJoin(QueryWrapper table)
JoinBuilder<T>	crossJoin(QueryWrapper table, boolean when)
JoinBuilder<T>	crossJoin(String table)
JoinBuilder<T>	crossJoin(String table, boolean when)
JoinBuilder<T>	fullJoin(Class<?> entityClass)
JoinBuilder<T>	fullJoin(Class<?> entityClass, boolean when)
JoinBuilder<T>	fullJoin(QueryTable table)
JoinBuilder<T>	fullJoin(QueryTable table, boolean when)
JoinBuilder<T>	fullJoin(QueryWrapper table)
JoinBuilder<T>	fullJoin(QueryWrapper table, boolean when)
JoinBuilder<T>	fullJoin(String table)
JoinBuilder<T>	fullJoin(String table, boolean when)
<E> T	groupBy(LambdaGetter<E>... columns)
T	groupBy(QueryColumn... columns)
T	groupBy(String... names)
T	having(QueryCondition queryCondition)
JoinBuilder<T>	innerJoin(Class<?> entityClass)
JoinBuilder<T>	innerJoin(Class<?> entityClass, boolean when)
JoinBuilder<T>	innerJoin(QueryTable table)
JoinBuilder<T>	innerJoin(QueryTable table, boolean when)
JoinBuilder<T>	innerJoin(QueryWrapper table)
JoinBuilder<T>	innerJoin(QueryWrapper table, boolean when)
JoinBuilder<T>	innerJoin(String table)
JoinBuilder<T>	innerJoin(String table, boolean when)
JoinBuilder<T>	join(Class<?> entityClass)
JoinBuilder<T>	join(Class<?> entityClass, boolean when)
JoinBuilder<T>	join(QueryTable table)
JoinBuilder<T>	join(QueryTable table, boolean when)
JoinBuilder<T>	join(QueryWrapper table)
JoinBuilder<T>	join(QueryWrapper table, boolean when)
JoinBuilder<T>	join(String table)
JoinBuilder<T>	join(String table, boolean when)
protected JoinBuilder<T>	joins(String type, Class<?> entityClass, boolean when)
protected JoinBuilder<T>	joins(String type, QueryTable table, boolean when)
protected JoinBuilder<T>	joins(String type, QueryWrapper queryWrapper, boolean when)
JoinBuilder<T>	leftJoin(Class<?> entityClass)
JoinBuilder<T>	leftJoin(Class<?> entityClass, boolean when)
JoinBuilder<T>	leftJoin(QueryTable table)
JoinBuilder<T>	leftJoin(QueryTable table, boolean when)
JoinBuilder<T>	leftJoin(QueryWrapper table)
JoinBuilder<T>	leftJoin(QueryWrapper table, boolean when)
JoinBuilder<T>	leftJoin(String table)
JoinBuilder<T>	leftJoin(String table, boolean when)
T	limit(Number rows)
T	limit(Number offset, Number rows)
T	offset(Number offset)
<E> WhereBuilder<T>	or(LambdaGetter<E> column)
T	or(QueryCondition queryCondition)
T	or(String sql)
T	or(String sql, Object... params)
<E> OrderByBuilder<T>	orderBy(LambdaGetter<E> column)
<E> T	orderBy(LambdaGetter<E> column, Boolean asc)
T	orderBy(QueryColumn column, Boolean asc)
T	orderBy(QueryOrderBy... orderBys)
T	orderBy(String... orderBys)
T	orderBy(String column, Boolean asc)
protected QueryWrapper	queryWrapper()
JoinBuilder<T>	rightJoin(Class<?> entityClass)
JoinBuilder<T>	rightJoin(Class<?> entityClass, boolean when)
JoinBuilder<T>	rightJoin(QueryTable table)
JoinBuilder<T>	rightJoin(QueryTable table, boolean when)
JoinBuilder<T>	rightJoin(QueryWrapper table)
JoinBuilder<T>	rightJoin(QueryWrapper table, boolean when)
JoinBuilder<T>	rightJoin(String table)
JoinBuilder<T>	rightJoin(String table, boolean when)
T	select()
T	select(Iterable<QueryColumn> queryColumns)
<E> T	select(LambdaGetter<E>... columns)
T	select(QueryColumn... queryColumns)
T	select(QueryColumn[]... queryColumns)
T	select(String... columns)
<E> WhereBuilder<T>	where(LambdaGetter<E> column)
T	where(QueryCondition queryCondition)
T	where(String sql)
T	where(String sql, Object... params)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryModel

public QueryModel()

Method Detail

queryWrapper

protected QueryWrapper queryWrapper()

as

public T as(String alias)

select

public T select()

select

public T select(String... columns)

select

public T select(QueryColumn... queryColumns)

select

public T select(Iterable<QueryColumn> queryColumns)

select

@SafeVarargs
public final <E> T select(LambdaGetter<E>... columns)

select

public T select(QueryColumn[]... queryColumns)

where

public T where(QueryCondition queryCondition)

where

public T where(String sql)

where

public T where(String sql,
               Object... params)

where

public <E> WhereBuilder<T> where(LambdaGetter<E> column)

and

public T and(QueryCondition queryCondition)

and

public T and(String sql)

and

public T and(String sql,
             Object... params)

and

public <E> WhereBuilder<T> and(LambdaGetter<E> column)

or

public T or(QueryCondition queryCondition)

or

public T or(String sql)

or

public T or(String sql,
            Object... params)

or

public <E> WhereBuilder<T> or(LambdaGetter<E> column)

leftJoin

public JoinBuilder<T> leftJoin(String table)

leftJoin

public JoinBuilder<T> leftJoin(String table,
                               boolean when)

leftJoin

public JoinBuilder<T> leftJoin(Class<?> entityClass)

leftJoin

public JoinBuilder<T> leftJoin(Class<?> entityClass,
                               boolean when)

leftJoin

public JoinBuilder<T> leftJoin(QueryTable table)

leftJoin

public JoinBuilder<T> leftJoin(QueryTable table,
                               boolean when)

leftJoin

public JoinBuilder<T> leftJoin(QueryWrapper table)

leftJoin

public JoinBuilder<T> leftJoin(QueryWrapper table,
                               boolean when)

rightJoin

public JoinBuilder<T> rightJoin(String table)

rightJoin

public JoinBuilder<T> rightJoin(String table,
                                boolean when)

rightJoin

public JoinBuilder<T> rightJoin(Class<?> entityClass)

rightJoin

public JoinBuilder<T> rightJoin(Class<?> entityClass,
                                boolean when)

rightJoin

public JoinBuilder<T> rightJoin(QueryTable table)

rightJoin

public JoinBuilder<T> rightJoin(QueryTable table,
                                boolean when)

rightJoin

public JoinBuilder<T> rightJoin(QueryWrapper table)

rightJoin

public JoinBuilder<T> rightJoin(QueryWrapper table,
                                boolean when)

innerJoin

public JoinBuilder<T> innerJoin(String table)

innerJoin

public JoinBuilder<T> innerJoin(String table,
                                boolean when)

innerJoin

public JoinBuilder<T> innerJoin(Class<?> entityClass)

innerJoin

public JoinBuilder<T> innerJoin(Class<?> entityClass,
                                boolean when)

innerJoin

public JoinBuilder<T> innerJoin(QueryTable table)

innerJoin

public JoinBuilder<T> innerJoin(QueryTable table,
                                boolean when)

innerJoin

public JoinBuilder<T> innerJoin(QueryWrapper table)

innerJoin

public JoinBuilder<T> innerJoin(QueryWrapper table,
                                boolean when)

fullJoin

public JoinBuilder<T> fullJoin(String table)

fullJoin

public JoinBuilder<T> fullJoin(String table,
                               boolean when)

fullJoin

public JoinBuilder<T> fullJoin(Class<?> entityClass)

fullJoin

public JoinBuilder<T> fullJoin(Class<?> entityClass,
                               boolean when)

fullJoin

public JoinBuilder<T> fullJoin(QueryTable table)

fullJoin

public JoinBuilder<T> fullJoin(QueryTable table,
                               boolean when)

fullJoin

public JoinBuilder<T> fullJoin(QueryWrapper table)

fullJoin

public JoinBuilder<T> fullJoin(QueryWrapper table,
                               boolean when)

crossJoin

public JoinBuilder<T> crossJoin(String table)

crossJoin

public JoinBuilder<T> crossJoin(String table,
                                boolean when)

crossJoin

public JoinBuilder<T> crossJoin(Class<?> entityClass)

crossJoin

public JoinBuilder<T> crossJoin(Class<?> entityClass,
                                boolean when)

crossJoin

public JoinBuilder<T> crossJoin(QueryTable table)

crossJoin

public JoinBuilder<T> crossJoin(QueryTable table,
                                boolean when)

crossJoin

public JoinBuilder<T> crossJoin(QueryWrapper table)

crossJoin

public JoinBuilder<T> crossJoin(QueryWrapper table,
                                boolean when)

join

public JoinBuilder<T> join(String table)

join

public JoinBuilder<T> join(String table,
                           boolean when)

join

public JoinBuilder<T> join(Class<?> entityClass)

join

public JoinBuilder<T> join(Class<?> entityClass,
                           boolean when)

join

public JoinBuilder<T> join(QueryTable table)

join

public JoinBuilder<T> join(QueryTable table,
                           boolean when)

join

public JoinBuilder<T> join(QueryWrapper table)

join

public JoinBuilder<T> join(QueryWrapper table,
                           boolean when)

groupBy

public T groupBy(String... names)

groupBy

public T groupBy(QueryColumn... columns)

groupBy

@SafeVarargs
public final <E> T groupBy(LambdaGetter<E>... columns)

having

public T having(QueryCondition queryCondition)

orderBy

public T orderBy(QueryOrderBy... orderBys)

orderBy

public T orderBy(QueryColumn column,
                 Boolean asc)

orderBy

public T orderBy(String... orderBys)

orderBy

public T orderBy(String column,
                 Boolean asc)

orderBy

public <E> OrderByBuilder<T> orderBy(LambdaGetter<E> column)

orderBy

public <E> T orderBy(LambdaGetter<E> column,
                     Boolean asc)

limit

public T limit(Number rows)

offset

public T offset(Number offset)

limit

public T limit(Number offset,
               Number rows)

joins

protected JoinBuilder<T> joins(String type,
                               QueryTable table,
                               boolean when)

joins

protected JoinBuilder<T> joins(String type,
                               Class<?> entityClass,
                               boolean when)

joins

protected JoinBuilder<T> joins(String type,
                               QueryWrapper queryWrapper,
                               boolean when)