mybatisplus多条件对象xml分页查询

不要用它自带的

selectPage方法，会有传参问题

controller

import java.util.Set;@RestController
@RequiredArgsConstructor
@RequestMapping("/deviceInfo" )
public class DeviceInfoController {private final  DeviceInfoService deviceInfoService;/*** 分页查询* @param page 分页对象* @param queryDto 设备信息查询对象* @return*/@GetMapping("/page" )@PreAuthorize("@pms.hasPermission('proxy_deviceInfo_view')" )public R selectPage(Page page, @Validated(value = SelectVerify.class) DeviceInfoDTO queryDto) {return R.ok(deviceInfoService.selectForPage(page, queryDto));}}

Mapper

public interface DeviceInfoMapper extends BaseMapper<DeviceInfo> {IPage<DeviceInfoVO> selectForPage(Page page, @Param("queryDto") DeviceInfoDTO queryDto);List<DeviceInfoVO> selectList(DeviceInfoDTO queryDto);
}

xml

<resultMap id="deviceInfoVoMap" type="xx.xx.vo.DeviceInfoVO"><id property="id" column="id"/><id property="groupId" column="group_id"/><id property="deviceNumber" column="device_number"/><id property="deviceCategory" column="device_category"/><id property="deviceType" column="device_type"/><id property="manufacturer" column="manufacturer"/><id property="deviceModel" column="device_model"/><id property="remark" column="remark"/><id property="createBy" column="create_by"/><id property="createTime" column="create_time"/><id property="updateBy" column="update_by"/><id property="updateTime" column="update_time"/></resultMap><select id="selectForPage" resultMap="deviceInfoVoMap">SELECTdi.*FROM device_info di<where><if test="queryDto.groupId != null">AND di.group_id = #{queryDto.groupId}</if><if test="queryDto.deviceNumber != null and queryDto.deviceNumber != ''">AND di.device_number = #{queryDto.deviceNumber}</if><if test="queryDto.deviceTypeCollection != null and queryDto.deviceTypeCollection.size > 0">AND di.device_type IN<foreach collection="queryDto.deviceTypeCollection" index="idx" item="item" separator="," open="(" close=")">#{item}</foreach></if></where>ORDER BY di.device_number ASC</select>

Server

public interface DeviceInfoService extends IService<DeviceInfo> {/*** 分页查询*/IPage<DeviceInfoVO> selectForPage(Page page, DeviceInfoDTO queryDto);}

impl

@Service
@RequiredArgsConstructor
public class DeviceInfoServiceImpl extends ServiceImpl<DeviceInfoMapper, DeviceInfo> implements DeviceInfoService {public IPage<DeviceInfoVO> selectForPage(Page page, DeviceInfoDTO queryDto) {return baseMapper.selectForPage(page, queryDto);}}