pub struct LambdaQueryWrapper<T> {
pub inner: AbstractWrapper,
pub func: FuncSegments,
/* private fields */
}Expand description
基于类型安全列引用的查询构建器(对标 Java LambdaQueryWrapper<T>)。
使用 Column<F> 替代字符串列名,编译期保证列名正确性。
列引用通常由 #[derive(TableName)] 宏自动生成。
§对应 Java
com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper<T>com.baomidou.mybatisplus.core.conditions.AbstractLambdaWrapper<T, Children>
§Example
use rbatis_plus::core::conditions::query::LambdaQueryWrapper;
// 假设 User 已 derive TableName,生成了 User::column_name() 等方法
let w = LambdaQueryWrapper::<User>::new()
.eq(User::column_name(), "Alice")
.ge(User::column_age(), 18)
.order_by_desc(User::column_create_time());
let sql = w.build_select_sql("sys_user");
// SELECT * FROM sys_user WHERE name = 'Alice' AND age >= 18 ORDER BY create_time DESCFields§
§inner: AbstractWrapper内部条件构建状态。
func: FuncSegmentsGROUP BY / ORDER BY / HAVING 状态。
Implementations§
Source§impl<T> LambdaQueryWrapper<T>
impl<T> LambdaQueryWrapper<T>
Sourcepub fn new() -> LambdaQueryWrapper<T>
pub fn new() -> LambdaQueryWrapper<T>
创建空的 Lambda 查询构建器。
Sourcepub fn select<F>(&mut self, column: Column<F>) -> &mut LambdaQueryWrapper<T>
pub fn select<F>(&mut self, column: Column<F>) -> &mut LambdaQueryWrapper<T>
设置查询字段(类型安全列引用)。
对应 Java LambdaQueryWrapper.select(SFunction...)
Sourcepub fn select_columns(&mut self, columns: &[&str]) -> &mut LambdaQueryWrapper<T>
pub fn select_columns(&mut self, columns: &[&str]) -> &mut LambdaQueryWrapper<T>
批量设置查询字段。
Sourcepub fn eq<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn eq<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column = value(等值比较)
对应 Java AbstractWrapper.eq(boolean condition, R column, Object val)
Sourcepub fn if_eq<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_eq<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件等值比较 — 仅当 condition 为 true 时生效。
Sourcepub fn ne<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn ne<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column <> value(不等比较)
对应 Java AbstractWrapper.ne(...)
Sourcepub fn if_ne<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_ne<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件不等比较。
Sourcepub fn gt<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn gt<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column > value(大于)
对应 Java AbstractWrapper.gt(...)
Sourcepub fn if_gt<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_gt<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件大于比较。
Sourcepub fn ge<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn ge<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column >= value(大于等于)
对应 Java AbstractWrapper.ge(...)
Sourcepub fn if_ge<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_ge<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件大于等于比较。
Sourcepub fn lt<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn lt<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column < value(小于)
对应 Java AbstractWrapper.lt(...)
Sourcepub fn if_lt<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_lt<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件小于比较。
Sourcepub fn le<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn le<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column <= value(小于等于)
对应 Java AbstractWrapper.le(...)
Sourcepub fn if_le<F>(
&mut self,
condition: bool,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_le<F>( &mut self, condition: bool, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件小于等于比较。
Sourcepub fn between<F>(
&mut self,
column: Column<F>,
val1: impl Into<Value>,
val2: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn between<F>( &mut self, column: Column<F>, val1: impl Into<Value>, val2: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column BETWEEN val1 AND val2
对应 Java AbstractWrapper.between(...)
Sourcepub fn if_between<F>(
&mut self,
condition: bool,
column: Column<F>,
val1: impl Into<Value>,
val2: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_between<F>( &mut self, condition: bool, column: Column<F>, val1: impl Into<Value>, val2: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件 BETWEEN。
Sourcepub fn not_between<F>(
&mut self,
column: Column<F>,
val1: impl Into<Value>,
val2: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn not_between<F>( &mut self, column: Column<F>, val1: impl Into<Value>, val2: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column NOT BETWEEN val1 AND val2
对应 Java AbstractWrapper.notBetween(...)
Sourcepub fn if_not_between<F>(
&mut self,
condition: bool,
column: Column<F>,
val1: impl Into<Value>,
val2: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_not_between<F>( &mut self, condition: bool, column: Column<F>, val1: impl Into<Value>, val2: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
条件 NOT BETWEEN。
Sourcepub fn eq_or_is_null<F>(
&mut self,
column: Column<F>,
value: impl Into<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn eq_or_is_null<F>( &mut self, column: Column<F>, value: impl Into<Value>, ) -> &mut LambdaQueryWrapper<T>
column = value OR column IS NULL
对应 Java AbstractWrapper.eqOrIsNull(...)
Sourcepub fn like<F>(
&mut self,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn like<F>( &mut self, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
column LIKE '%value%'(模糊匹配)
对应 Java AbstractWrapper.like(...)
Sourcepub fn if_like<F>(
&mut self,
condition: bool,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn if_like<F>( &mut self, condition: bool, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
条件 LIKE。
Sourcepub fn not_like<F>(
&mut self,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn not_like<F>( &mut self, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
column NOT LIKE '%value%'
对应 Java AbstractWrapper.notLike(...)
Sourcepub fn if_not_like<F>(
&mut self,
condition: bool,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn if_not_like<F>( &mut self, condition: bool, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
条件 NOT LIKE。
Sourcepub fn like_right<F>(
&mut self,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn like_right<F>( &mut self, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
column LIKE 'value%'(右匹配)
对应 Java AbstractWrapper.likeRight(...)
Sourcepub fn if_like_right<F>(
&mut self,
condition: bool,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn if_like_right<F>( &mut self, condition: bool, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
条件右匹配 LIKE。
Sourcepub fn like_left<F>(
&mut self,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn like_left<F>( &mut self, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
column LIKE '%value'(左匹配)
对应 Java AbstractWrapper.likeLeft(...)
Sourcepub fn if_like_left<F>(
&mut self,
condition: bool,
column: Column<F>,
value: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn if_like_left<F>( &mut self, condition: bool, column: Column<F>, value: &str, ) -> &mut LambdaQueryWrapper<T>
条件左匹配 LIKE。
Sourcepub fn is_null<F>(&mut self, column: Column<F>) -> &mut LambdaQueryWrapper<T>
pub fn is_null<F>(&mut self, column: Column<F>) -> &mut LambdaQueryWrapper<T>
column IS NULL
对应 Java AbstractWrapper.isNull(...)
Sourcepub fn if_is_null<F>(
&mut self,
condition: bool,
column: Column<F>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_is_null<F>( &mut self, condition: bool, column: Column<F>, ) -> &mut LambdaQueryWrapper<T>
条件 IS NULL。
Sourcepub fn is_not_null<F>(
&mut self,
column: Column<F>,
) -> &mut LambdaQueryWrapper<T>
pub fn is_not_null<F>( &mut self, column: Column<F>, ) -> &mut LambdaQueryWrapper<T>
column IS NOT NULL
对应 Java AbstractWrapper.isNotNull(...)
Sourcepub fn if_is_not_null<F>(
&mut self,
condition: bool,
column: Column<F>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_is_not_null<F>( &mut self, condition: bool, column: Column<F>, ) -> &mut LambdaQueryWrapper<T>
条件 IS NOT NULL。
Sourcepub fn in_values<F>(
&mut self,
column: Column<F>,
values: Vec<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn in_values<F>( &mut self, column: Column<F>, values: Vec<Value>, ) -> &mut LambdaQueryWrapper<T>
column IN (v1, v2, ...)
对应 Java AbstractWrapper.in(...)
Sourcepub fn if_in_values<F>(
&mut self,
condition: bool,
column: Column<F>,
values: Vec<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_in_values<F>( &mut self, condition: bool, column: Column<F>, values: Vec<Value>, ) -> &mut LambdaQueryWrapper<T>
条件 IN。
Sourcepub fn not_in<F>(
&mut self,
column: Column<F>,
values: Vec<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn not_in<F>( &mut self, column: Column<F>, values: Vec<Value>, ) -> &mut LambdaQueryWrapper<T>
column NOT IN (v1, v2, ...)
对应 Java AbstractWrapper.notIn(...)
Sourcepub fn if_not_in<F>(
&mut self,
condition: bool,
column: Column<F>,
values: Vec<Value>,
) -> &mut LambdaQueryWrapper<T>
pub fn if_not_in<F>( &mut self, condition: bool, column: Column<F>, values: Vec<Value>, ) -> &mut LambdaQueryWrapper<T>
条件 NOT IN。
Sourcepub fn in_sql<F>(
&mut self,
column: Column<F>,
sql: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn in_sql<F>( &mut self, column: Column<F>, sql: &str, ) -> &mut LambdaQueryWrapper<T>
column IN (subquery)
对应 Java AbstractWrapper.inSql(...)
Sourcepub fn not_in_sql<F>(
&mut self,
column: Column<F>,
sql: &str,
) -> &mut LambdaQueryWrapper<T>
pub fn not_in_sql<F>( &mut self, column: Column<F>, sql: &str, ) -> &mut LambdaQueryWrapper<T>
column NOT IN (subquery)
对应 Java AbstractWrapper.notInSql(...)
Sourcepub fn group_by(&mut self, columns: &[&str]) -> &mut LambdaQueryWrapper<T>
pub fn group_by(&mut self, columns: &[&str]) -> &mut LambdaQueryWrapper<T>
GROUP BY 多列(类型安全列引用,支持混合字段类型)。
对应 Java AbstractWrapper.groupBy(boolean condition, R... columns)
因为 Rust 泛型不允许 slice 中混合不同类型,此方法接受列名字符串切片。
推荐配合 derive 宏生成的 COLUMN_* 常量使用。
Sourcepub fn order_by<F>(
&mut self,
column: Column<F>,
is_asc: bool,
) -> &mut LambdaQueryWrapper<T>
pub fn order_by<F>( &mut self, column: Column<F>, is_asc: bool, ) -> &mut LambdaQueryWrapper<T>
ORDER BY(类型安全列引用)。
对应 Java AbstractWrapper.orderBy(boolean condition, boolean isAsc, R... columns)
Sourcepub fn order_by_asc<F>(
&mut self,
column: Column<F>,
) -> &mut LambdaQueryWrapper<T>
pub fn order_by_asc<F>( &mut self, column: Column<F>, ) -> &mut LambdaQueryWrapper<T>
ORDER BY ASC(类型安全列引用)。
Sourcepub fn order_by_desc<F>(
&mut self,
column: Column<F>,
) -> &mut LambdaQueryWrapper<T>
pub fn order_by_desc<F>( &mut self, column: Column<F>, ) -> &mut LambdaQueryWrapper<T>
ORDER BY DESC(类型安全列引用)。
Sourcepub fn having(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn having(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
HAVING 子句。
对应 Java AbstractWrapper.having(...)
Sourcepub fn or(&mut self) -> &mut LambdaQueryWrapper<T>
pub fn or(&mut self) -> &mut LambdaQueryWrapper<T>
下一个条件用 OR 连接。
对应 Java AbstractWrapper.or()
Sourcepub fn and_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn and_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
AND (sub-conditions)
对应 Java AbstractWrapper.and(...)
Sourcepub fn or_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn or_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
OR (sub-conditions)
对应 Java AbstractWrapper.or(Consumer) — 字符串版本
Sourcepub fn nested(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn nested(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
嵌套条件 AND (conditions)
对应 Java AbstractWrapper.nested(...)
Sourcepub fn not_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn not_group(&mut self, inner_sql: &str) -> &mut LambdaQueryWrapper<T>
NOT (sub-conditions)
对应 Java AbstractWrapper.not(...)
Sourcepub fn apply(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn apply(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
自定义 SQL 片段拼接。
对应 Java AbstractWrapper.apply(...)
Sourcepub fn exists(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn exists(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
EXISTS (subquery)
对应 Java AbstractWrapper.exists(...)
Sourcepub fn not_exists(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn not_exists(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
NOT EXISTS (subquery)
对应 Java AbstractWrapper.notExists(...)
Sourcepub fn last(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn last(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
追加 SQL 到末尾(如 LIMIT 1)。
对应 Java AbstractWrapper.last(...)
Sourcepub fn comment(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn comment(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
SQL 注释(前置)。
对应 Java AbstractWrapper.comment(...)
Sourcepub fn first(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
pub fn first(&mut self, sql: &str) -> &mut LambdaQueryWrapper<T>
SQL first(最前置)。
对应 Java AbstractWrapper.first(...)
Sourcepub fn build_select_sql(&self, table_name: &str) -> String
pub fn build_select_sql(&self, table_name: &str) -> String
构建完整 SELECT SQL。
对应 Java QueryWrapper.getSqlSelect() → SqlUtils.SqlSegment
Sourcepub fn build_count_sql(&self, table_name: &str) -> String
pub fn build_count_sql(&self, table_name: &str) -> String
构建 COUNT SQL(用于分页)。
Trait Implementations§
Source§impl<T> Clone for LambdaQueryWrapper<T>where
T: Clone,
impl<T> Clone for LambdaQueryWrapper<T>where
T: Clone,
Source§fn clone(&self) -> LambdaQueryWrapper<T>
fn clone(&self) -> LambdaQueryWrapper<T>
1.0.0 (const: unstable) · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source. Read more