QueryWrapper的基本用法
话不多说,直接上代码
更多使用方法传送门
public void mybatisPlusTest(Long id, String startTime, String endTime) {
QueryWrapper<ReturnCommissionLog> eqWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> eqList = returnCommissionLogMapper.selectList(eqWrapper.eq("id",id));
QueryWrapper<ReturnCommissionLog> leWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> leList = returnCommissionLogMapper.selectList(leWrapper.le("id",id));
QueryWrapper<ReturnCommissionLog> geWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> geList = returnCommissionLogMapper.selectList(geWrapper.ge("id",id));
QueryWrapper<ReturnCommissionLog> betweenWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> betweenList = returnCommissionLogMapper.selectList(betweenWrapper.between("logtime",startTime,endTime));
QueryWrapper<ReturnCommissionLog> groupByWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> groupByList = returnCommissionLogMapper.selectList(groupByWrapper.groupBy("id"));
QueryWrapper<ReturnCommissionLog> orderByWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> orderByList = returnCommissionLogMapper.selectList(orderByWrapper.orderByDesc("id"));
QueryWrapper<ReturnCommissionLog> orWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> orList = returnCommissionLogMapper.selectList(orWrapper.like("id",id).or().between("logtime",startTime,endTime));
QueryWrapper<ReturnCommissionLog> andWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> andList = returnCommissionLogMapper.selectList(andWrapper.and(i ->i.like("id",id).between("logtime",startTime,endTime)));
QueryWrapper<ReturnCommissionLog> lastWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> lastList = returnCommissionLogMapper.selectList(lastWrapper.last(" order by id desc limit 10"));
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)