在使用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,isdelFROM activityWHERE isdel=0AND(titleLIKE ?ANDstatus= ?)LIMIT ?,?
Parameters:%红色%(String),1(Integer),0(Long),10(Long)
如有错误欢迎大佬指正!