LambdaQueryWrapper和LambdaUpdateWrapper怎么使用

川长思鸟来 2023-10-03 19:38 2阅读 0赞

> Mybatis Plus 插件 LambdaQueryWrapper 与 LambdaUpdateWrapper 【使用指南】

<table> 
 <thead> 
  <tr> 
   <th align="center">函数名</th> 
   <th align="center">说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="center">eq</td> 
   <td align="center">=</td> 
  </tr> 
  <tr> 
   <td align="center">ne</td> 
   <td align="center">&lt;&gt;</td> 
  </tr> 
  <tr> 
   <td align="center">gt</td> 
   <td align="center">&gt;</td> 
  </tr> 
  <tr> 
   <td align="center">ge</td> 
   <td align="center">&gt;=</td> 
  </tr> 
  <tr> 
   <td align="center">lt</td> 
   <td align="center">&lt;</td> 
  </tr> 
  <tr> 
   <td align="center">le</td> 
   <td align="center">&lt;=</td> 
  </tr> 
  <tr> 
   <td align="center">between</td> 
   <td align="center">between</td> 
  </tr> 
  <tr> 
   <td align="center">notBetween</td> 
   <td align="center">not between</td> 
  </tr> 
  <tr> 
   <td align="center">like</td> 
   <td align="center">like <strong>%key%</strong></td> 
  </tr> 
  <tr> 
   <td align="center">notLike</td> 
   <td align="center">not like <strong>%key%</strong></td> 
  </tr> 
  <tr> 
   <td align="center">likeLeft</td> 
   <td align="center">like %key</td> 
  </tr> 
  <tr> 
   <td align="center">likeRight</td> 
   <td align="center">like key%</td> 
  </tr> 
  <tr> 
   <td align="center">isNull</td> 
   <td align="center">is null</td> 
  </tr> 
  <tr> 
   <td align="center">isNotNull</td> 
   <td align="center">is not null</td> 
  </tr> 
  <tr> 
   <td align="center">in</td> 
   <td align="center">in</td> 
  </tr> 
  <tr> 
   <td align="center">notIn</td> 
   <td align="center">not in</td> 
  </tr> 
  <tr> 
   <td align="center">inSql</td> 
   <td align="center">in (sql语句)</td> 
  </tr> 
  <tr> 
   <td align="center">notInSql</td> 
   <td align="center">not in (sql语句)</td> 
  </tr> 
  <tr> 
   <td align="center">groupBy</td> 
   <td align="center">group by</td> 
  </tr> 
  <tr> 
   <td align="center">orderByAsc</td> 
   <td align="center">order by 字段 asc</td> 
  </tr> 
  <tr> 
   <td align="center">orderByDesc</td> 
   <td align="center">order by 字段 desc</td> 
  </tr> 
  <tr> 
   <td align="center">orderBy</td> 
   <td align="center">order by 字段 asc/desc</td> 
  </tr> 
  <tr> 
   <td align="center">having</td> 
   <td align="center">having(sql语句)</td> 
  </tr> 
  <tr> 
   <td align="center">or</td> 
   <td align="center">a or b<br>eq(“id”,1).or().eq(“name”,“Tom”)</td> 
  </tr> 
  <tr> 
   <td align="center">and</td> 
   <td align="center">a and b（使用同or）</td> 
  </tr> 
  <tr> 
   <td align="center">apply</td> 
   <td align="center">拼接sql，消除sql注入风险</td> 
  </tr> 
  <tr> 
   <td align="center">last</td> 
   <td align="center">无视优化规则，直接拼接到sql的最后（有sql注入的风险）<br>last(“limit 1”)</td> 
  </tr> 
  <tr> 
   <td align="center">exists</td> 
   <td align="center">exists(sql语句)<br>exists(“select id from table where age = 1”)<br>【等于】exists (select id from table where age = 1)</td> 
  </tr> 
  <tr> 
   <td align="center">notExists</td> 
   <td align="center">not exists(sql语句)</td> 
  </tr> 
  <tr> 
   <td align="center">nested</td> 
   <td align="center">正常嵌套，不带and或者or<br>nested(i -&gt; i.eq(“name”, “Tom”).ne(“status”, “alive”))<br>【等于】(name = ‘Tom’ and status &lt;&gt; ‘alive’)</td> 
  </tr> 
  <tr> 
   <td align="center">allEq</td> 
   <td align="center">({id:1,age:null})<br>等于：id = 1 and age is null</td> 
  </tr> 
  <tr> 
   <td align="center">func</td> 
   <td align="center">func(i -&gt; if(true) {i.eq(“id”, 1)} else {i.ne(“id”, 1)})</td> 
  </tr> 
  <tr> 
   <td align="center">set</td> 
   <td align="center">set(“name”, null)</td> 
  </tr> 
  <tr> 
   <td align="center">setSql</td> 
   <td align="center">setSql(sql语句)</td> 
  </tr> 
 </tbody> 
</table>