MybatisPlus 按字段排序、in

ZeroKoop

已于 2024-03-18 11:07:51 修改

阅读量774

点赞数

文章标签： java 前端 javascript

于 2023-10-17 16:19:08 首次发布

本文链接：https://blog.csdn.net/hdhsZero/article/details/133886911

版权

使用wrapper查询

Page<Note> page = new Page<>(noteVo.getCurrent(), noteVo.getSize());
page.addOrder(OrderItem.desc("gmt_modified"));
noteService.getBaseMapper().selectPage(page, new LambdaQueryWrapper<Note>()
                .eq(StringUtils.isNoneBlank(netScope), Note::getNetScope, netScope)
                .eq(null != createBy, Note::getCreateBy, createBy)
                .in((null != noteType && 0 < noteType.length), Note::getNoteType, noteType)
                .like(StringUtils.isNoneBlank(title), Note::getTitle, title));

in在xml中使用

使用foreach

<if test="List != null and List.size()!=0 ">
	and list in
	<foreach collection="List" item="item" index="index" open="(" close=")" separator=",">
		#{item}
	</foreach>
</if>