在使用mybatis-plus的时候不想查询某一个字段,执行sql的时候就不包含此字段的查询,可以这样写 ——》
QueryWrapper<Activity> queryWrapper = new QueryWrapper<>();
//查询条件
if (ObjectUtil.isNotEmpty(activityVO.getSearch())) {
queryWrapper.like("title", activityVO.getSearch());
}
if (ObjectUtil.isNotEmpty(activityVO.getStatus())) {
queryWrapper.eq("status", activityVO.getStatus());
}
//分页查询
Page<Activity> activityPage = activityMapper.selectPage(
page, queryWrapper.select(Activity.class, f ->
! f.getColumn().equals("content") && ! f.getColumn().equals("label")));//不展示content,label字段
sql为:
Preparing: SELECT id,title,description,activity_time,status,sort,photo_path,video_name,split_video,video_path,update_time,create_time,isdel FROM activity WHERE isdel=0 AND (title LIKE ? AND status = ?) LIMIT ?,?
Parameters: %红色%(String), 1(Integer), 0(Long), 10(Long)
如有错误欢迎大佬指正!