java实现手动分页

int pageSize = 500;
// 先查询表的总数量
int total = temperatureMapper.getTemperatureListCount(query, tableName);
                if (total == 0) {
                    process.setRtn_Msg("查询失败");
                    process.setRtn_Data("查询温度数据为空，请检查！");
                    return process;
                }

int totalPage = (total + pageSize - 1) / pageSize;


for (int i = 0; i < totalPage; i++) {
List<GetHistoryTemperatureInfoDto> list = temperatureMapper.getTemperatureList2(query, tableName,i,pageSize);

}

/**
     * 历史温度查询,支持分页
     * @param query 参数
     * @param tableName 表名
     * @return 结果
     */
    List<GetHistoryTemperatureInfoDto> getTemperatureList2(@Param("query") GetHistoryTemperatureInfoQuery query, @Param("tableName") String tableName,@Param("pageNum") int pageNum,@Param("pageSize") int pageSize);

<select id="getTemperatureList2"
            resultType="com.transportmonitor.dto.GetHistoryTemperatureInfo.GetHistoryTemperatureInfoDto">
        select
        id
        ,vehicle as CarNumber
        ,ifnull(equipment,'') as Gpsno
        ,lon Lng
        ,lat Lat
        ,ifnull(temperature1,'') temperate1
        ,ifnull(temperature1,'') T1Temperature
        ,ifnull(temperature2,'') temperate2
        ,ifnull(temperature2,'') T2Temperature
        ,ifnull(temperature3,'') temperate3
        ,ifnull(temperature4,'') temperate4
        ,date_format(gps_time,'%Y-%m-%d %H:%i:%s') Time
        ,date_format(create_time,'%Y-%m-%d %H:%i:%s') createTime
        from
        <choose>
            <when test="tableName!=null and tableName!=''">
                ${tableName}
            </when>
            <otherwise>
                temperature
            </otherwise>
        </choose>
        t
        where gps_time >= #{query.StartTime}
        and gps_time &lt;= #{query.EndTime}
        and (temperature1 != '-999' or temperature2 != '-999')
        <if test="query.vehicleList!=null and query.vehicleList.size()>0">
            and vehicle in (
            <foreach collection="query.vehicleList" item="item" separator=",">
                #{item}
            </foreach>
            )
        </if>
        <if test="query.CarNumber !=null and query.CarNumber != ''">
            and vehicle = #{query.CarNumber}
        </if>
        <if test="query.Thermometer !=null and query.Thermometer != ''">
            and equipment = #{query.Thermometer}
        </if>
        limit #{pageNum},#{pageSize}
    </select>

@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class GetHistoryTemperatureInfoDto {
    /**
     * 历史温度id
     */
    @JSONField(name = "id")
    private String id;

    /**
     * 创建时间
     */
    @JSONField(name = "createTime")
    private Date createTime;

    /**
     * 设备号
     */
    @JSONField(name = "Gpsno")
    private String Gpsno;

    /**
     * 车牌号
     */
    @JSONField(name = "CarNumber")
    private String CarNumber;

    /**
     * 日期
     */
    @JSONField(name = "Time")
    private String Time;

    /**
     * 探头1温度
     */
    @JSONField(name = "T1Temperature")
    private String T1Temperature;

    /**
     * 探头2温度
     */
    @JSONField(name = "T2Temperature")
    private String T2Temperature;

    /**
     * 探头1湿度
     */
    @JSONField(name = "T1Humidity")
    private String T1Humidity;

    /**
     * 探头2湿度
     */
    @JSONField(name = "T2Humidity")
    private String T2Humidity;

    /**
     * 探头1温度
     */
    private String temperate1;
    /**
     * 探头2温度
     */
    private String temperate2;
    /**
     * 探头3温度
     */
    private String temperate3;
    /**
     * 探头4温度
     */
    private String temperate4;

    /**
     * 经度
     */
    @JSONField(name = "Lng")
    private String Lng;

    /**
     * 维度
     */
    @JSONField(name = "Lat")
    private String Lat;

    /**
     * 时间分组字段
     */
    private String groupTime;


    /**
     * 自定义车牌号
     */
    private String customVehicle;
}