mybatis Example简单使用

mybatis Example 特性

Example - 新增

场景：订单模块。查询条件：订单号|订单时间|状态|明细|订单名称

简单的增删改业务，不需要涉及查询SQL。直接用Example，Po搞定，上代码 ↓。

OrderPo po=new OrderPo();
po.setOrderNo('xxx123456');
orderMappingMapper.insert(po)

Example - 查询

等同查询 - andEqualTo

Example example=new Example(OrderPo.class);
Example.Criteria criteria=example.createCriteria();
criteria.andEqualTo("orderNo",request.getOrderNo());
List<OrderPo> list=orderMappingMapper.selectByExample(example);

复制代码

时间查询 - andGreaterThanOrEqualTo - 大于等于

criteria.andGreaterThanOrEqualTo("orderTimeStart",request.getOrderTimeStart()); // >=orderTimeStart  

复制代码

时间查询 - andLessThan - 小于

criteria.andLessThan("orderTimeEnd",request.getOrderTimeEnd());// <orderTimeEnd

复制代码

明细 ids in - andIn

criteria.andIn("recIds",request.getOrderDetails());//相当于sql recIds in(xxx,xxx,xxx)

复制代码

模糊查询 - andCondition

String condition =" and orderName like = '%"+request.getOrderName()+"%'";
criteria.andCondition(condition);

复制代码

排序 - setOrderByClause

example.setOrderByClause(" create_time desc ");//时间降序排序

Example - 修改

更新不为空的值

Example example = new Example(OrderPo.class);
example.createCriteria().andEqualTo("orderNo", request.getOrderNo());//订单号为request.getOrderNo()
OrderPo po=new OrderPo();
po.setModifyTime(new Date());
po.setModifyUser("admin");
po.setModifyUserName("admin");
po.setStatus("1");//已审核
orderMappingMapper.updateByExampleSelective(po,example);

复制代码

也可以通过主键更新

OrderPo po=new OrderPo();
po.setOrderNo(rquest.getOrderNo());//主键
po.setModifyTime(new Date());
po.setModifyUser("admin");
po.setModifyUserName("admin");
po.setStatus("1");//已审核
orderMappingMapper.updateByPrimaryKeySelective(po);

复制代码
Example - 删除

删除同样可以根据条件删除

Example example = new Example(OrderPo.class);
example.createCriteria().andEqualTo("status", "1");//删除已审核的数据
orderMappingMapper.deleteByExample(po);