Lombda表达式的排序和模糊查询

Question

select top 1 sernum from posdchgitm where code = 'P200' and sernum like 'PP%' and orgid = #{queryModel.orgid} and polnum = #{queryModel.polnum} AND result ='C' order by enddat desc
我怎么可以把一条sql的模糊查询和排序用lombda去实现

Answer 1

        List<User> userList = new ArrayList<>();
        String searchName = "";
        //根据fullName筛选
        userList = userList.stream().filter(item -> item.getFullName().contains(searchName))
                //根据username排序
                .sorted(Comparator.comparing(User::getUsername)).collect(Collectors.toList());

其中排序 只要是返回int就可以，0,-1,1
0代表等于 -1代表小于 1代表大于
给的示例中Comparator.comparing(User::getUsername) 同下面效果一样
.sorted((v1,v2)->{
return v1.getUsername().compareTo(v2.getUsername())
})
如果能帮到你，请帮忙点下【采纳】，谢啦