【MyBatis-plus】条件构造器详解(1)

in("age",{1,2,3})—>age in (1,2,3)

in(R column, Object… values)

in(boolean condition, R column, Object… values)

字段 IN (v0, v1, …)

例

in("age", 1, 2, 3)—>age in (1,2,3)

notIn

notIn(R column, Collection<?> value)

notIn(boolean condition, R column, Collection<?> value)

• 字段 NOT IN (value.get(0), value.get(1), …)

• 例: notIn("age",{1,2,3})—>age not in (1,2,3)

notIn(R column, Object… values)

notIn(boolean condition, R column, Object… values)

• 字段 NOT IN (v0, v1, …)

• 例: notIn("age", 1, 2, 3)—>age not in (1,2,3)

inSql

inSql(R column, String inValue)

inSql(boolean condition, R column, String inValue)

• 字段 IN ( sql语句 )

• 例: inSql("age", "1,2,3,4,5,6")—>age in (1,2,3,4,5,6)

• 例: inSql("id", "select id from table where id < 3")—>id in (select id from table where id < 3)

notInSql

notInSql(R column, String inValue)

notInSql(boolean condition, R column, String inValue)

• 字段 NOT IN ( sql语句 )

• 例: notInSql("age", "1,2,3,4,5,6")—>age not in (1,2,3,4,5,6)

• 例: notInSql("id", "select id from table where id < 3")—>id not in (select id from table where id < 3)

groupBy

groupBy(R… columns)

groupBy(boolean condition, R… columns)

• 分组：GROUP BY 字段, …

• 例: groupBy("id", "name")—>group by id,name

orderByAsc

排序：ORDER BY 字段, … ASC

orderByAsc(R… columns)

orderByAsc(boolean condition, R… columns)

实例

orderByAsc("id", "name")—>order by id ASC,name ASC

orderByDesc

orderByDesc(R