代码如下:
QueryWrapper<Banner> queryWrapper = new QueryWrapper<>();
// 需要把时间为空的值也查出来
queryWrapper.and(wp->{wp.ge("end_time", new Date()).or().isNull("end_time");});
// 需要根据order排序 并且需要把order为空的排序到最后位
queryWrapper.orderByAsc("(CASE WHEN `order` IS NULL THEN 1 ELSE 0 END)");
queryWrapper.orderByAsc("`order`");