LambdaQueryWrapper 的条件构造器方法对应Sql

it2023-06-26  69

setSqlSelectSELECT 查询字段whereWHERE 语句,拼接 + WHERE 条件andAND 语句,拼接 + AND 字段=值andNewAND 语句,拼接 + AND (字段=值)orOR 语句,拼接 + OR 字段=值orNewOR 语句,拼接 + OR (字段=值)eq等于=allEq基于 map 内容等于=ne不等于<>gt大于>ge大于等于>=lt小于<le小于等于<=like模糊查询 LIKEnotLikeNOT LIKE模糊查询inIN 查询notInNOT IN 查询isNullNULL 值查询isNotNullIS NOT NULLgroupBy分组 GROUP BYhaving HAVING 关键词orderBy 排序 ORDER BYorderAscAsc 排序 ORDER BYorderDescDESC 排序 ORDER BYexistsEXISTS 条件语句notExistsNOT EXISTS 条件语句betweenBETWEEN 条件语句notBetweenNOT BETWEEN 条件语句addFilter自由拼接 SQLlast拼接在最后,例如:last(“LIMIT 1”)
最新回复(0)