MyBatisPlus中常用条件构造器示例代码

淡淡的烟草味﹌ 2023-10-18 16:48 134阅读 0赞

## 场景 ##

MybatisPlus 条件构造器官方文档

[https://baomidou.gitee.io/mybatis-plus-doc/\#/wrapper][https_baomidou.gitee.io_mybatis-plus-doc_wrapper]

## 实现 ##

1.查询相等属性的实体类

QueryWrapper<WmsInOrder> wmsInOrderQueryWrapper =new QueryWrapper<WmsInOrder>();
     wmsInOrderQueryWrapper.eq("code",Code);
     int count =  wmsInOrderMapper.selectCount(wmsInOrderQueryWrapper);

其中WmsInOrder是实体类，code是对应实体类在数据库中的字段。

这里就是查询code字段属性为Code的记录在数据库中的记录数。

如果是两个条件可以继续添加：

wmsReceiveOrderDetailsQueryWrapper.eq("receive_id",wmsReceiveOrder.getId());
      wmsReceiveOrderDetailsQueryWrapper.eq("salver_code",salverCode);
      wmsReceiveOrderDetailsQueryWrapper.eq("materiel_number",materielNumber);

2.模糊搜索

QueryWrapper<WmsInOrder> wmsInOrderQueryWrapper2 =new QueryWrapper<WmsInOrder>();
     wmsInOrderQueryWrapper2.like("code","SI"+formatStr);
     List<WmsInOrder> wmsInOrderList =wmsInOrderMapper.selectList(wmsInOrderQueryWrapper2);

这里就是查询code属性中包含"SI"+formatStr字段的记录数，会返回一个List。

其中后面模糊搜索的表达式可以用正常的String包含%来表示：

String likeCode=wmsReceiveOrderDetails.getMaterielNumber()+"@"+wmsReceiveOrderDetails.getSupplierBatch()+"%"+"@"+simpleDateFormat.format(wmsReceiveOrderDetails.getProductDate());
    
     QueryWrapper<BusTrayMateriel> busTrayMaterielQueryWrapper =new QueryWrapper<BusTrayMateriel>();
    busTrayMaterielQueryWrapper.like("materiel_bar_code",likeCode);
    int count =busTrayMaterielMapper.selectCount(busTrayMaterielQueryWrapper);

3.其他条件参数使用类似

<table> 
 <thead> 
  <tr> 
   <th>查询方式</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>setSqlSelect</td> 
   <td>设置 SELECT 查询字段</td> 
  </tr> 
  <tr> 
   <td>where</td> 
   <td>WHERE 语句，拼接 +&nbsp;<code>WHERE 条件</code></td> 
  </tr> 
  <tr> 
   <td>and</td> 
   <td>AND 语句，拼接 +&nbsp;<code>AND 字段=值</code></td> 
  </tr> 
  <tr> 
   <td>andNew</td> 
   <td>AND 语句，拼接 +&nbsp;<code>AND (字段=值)</code></td> 
  </tr> 
  <tr> 
   <td>or</td> 
   <td>OR 语句，拼接 +&nbsp;<code>OR 字段=值</code></td> 
  </tr> 
  <tr> 
   <td>orNew</td> 
   <td>OR 语句，拼接 +&nbsp;<code>OR (字段=值)</code></td> 
  </tr> 
  <tr> 
   <td>eq</td> 
   <td>等于=</td> 
  </tr> 
  <tr> 
   <td>allEq</td> 
   <td>基于 map 内容等于=</td> 
  </tr> 
  <tr> 
   <td>ne</td> 
   <td>不等于&lt;&gt;</td> 
  </tr> 
  <tr> 
   <td>gt</td> 
   <td>大于&gt;</td> 
  </tr> 
  <tr> 
   <td>ge</td> 
   <td>大于等于&gt;=</td> 
  </tr> 
  <tr> 
   <td>lt</td> 
   <td>小于&lt;</td> 
  </tr> 
  <tr> 
   <td>le</td> 
   <td>小于等于&lt;=</td> 
  </tr> 
  <tr> 
   <td>like</td> 
   <td>模糊查询 LIKE</td> 
  </tr> 
  <tr> 
   <td>notLike</td> 
   <td>模糊查询 NOT LIKE</td> 
  </tr> 
  <tr> 
   <td>in</td> 
   <td>IN 查询</td> 
  </tr> 
  <tr> 
   <td>notIn</td> 
   <td>NOT IN 查询</td> 
  </tr> 
  <tr> 
   <td>isNull</td> 
   <td>NULL 值查询</td> 
  </tr> 
  <tr> 
   <td>isNotNull</td> 
   <td>IS NOT NULL</td> 
  </tr> 
  <tr> 
   <td>groupBy</td> 
   <td>分组 GROUP BY</td> 
  </tr> 
  <tr> 
   <td>having</td> 
   <td>HAVING 关键词</td> 
  </tr> 
  <tr> 
   <td>orderBy</td> 
   <td>排序 ORDER BY</td> 
  </tr> 
  <tr> 
   <td>orderAsc</td> 
   <td>ASC 排序 ORDER BY</td> 
  </tr> 
  <tr> 
   <td>orderDesc</td> 
   <td>DESC 排序 ORDER BY</td> 
  </tr> 
  <tr> 
   <td>exists</td> 
   <td>EXISTS 条件语句</td> 
  </tr> 
  <tr> 
   <td>notExists</td> 
   <td>NOT EXISTS 条件语句</td> 
  </tr> 
  <tr> 
   <td>between</td> 
   <td>BETWEEN 条件语句</td> 
  </tr> 
  <tr> 
   <td>notBetween</td> 
   <td>NOT BETWEEN 条件语句</td> 
  </tr> 
  <tr> 
   <td>addFilter</td> 
   <td>自由拼接 SQL</td> 
  </tr> 
  <tr> 
   <td>last</td> 
   <td>拼接在最后，例如：last("LIMIT 1")</td> 
  </tr> 
 </tbody> 
</table>

[https_baomidou.gitee.io_mybatis-plus-doc_wrapper]: https://baomidou.gitee.io/mybatis-plus-doc/#/wrapper