mybatis plus分页联表查询

@GetMapping(value = "/list/{size}/{current}")
public ResponseMessage> list/confirm/i(@PathVariable @Min(1) Integer current,
                                                        @PathVariable @Range(min = 1, max = 100) Integer size) {
    return ResponseMessage.success(this.su/confirm/iService.listPage(current, size));
}

service

IPage listPage(@NonNull Integer current, @NonNull Integer size);

serviceImpl

@Override
public IPage listPage(@NonNull Integer current, @NonNull Integer size) {
	return this.suBillMapper.listPage(new Page<>(current, size));
}

mapper

IPage listPage(@Param("page") Page page);

mapper.xml

        SELECT
            pb.*, sb.*
        FROM
            svr_pub_bill pb, svr_su_bill sb
        WHERe
            pb.bill_id = sb.bill_id
        AND
            pb.bill_status = '/confirm/i'
   

如果有其他条件，也可以在serviceImpl 中的 listPage(new Page<>(current, size), wrapper)，加个wrapper条件**