TK.Mapper多条件复杂查询
使用tkmapper实现复杂的多条件查询
使用场景:
比如查询某个用户的订单状态=1或者等于2的订单列表。
SQL语句:
select * from order where user_id="10001" and (status == '1' or status == '2');
代码实现
Example example = new Example(Order.class);
Example.Criteria criteria = example.createCriteria();
criteria.andEqualTo("userId", userId);
Example.Criteria criteria2 = example.createCriteria();
criteria2.orEqualTo("status","1");
criteria2.orEqualTo("status","2");
example.and(criteria2);
orderMapper.selectByExample(example);