mybatisplus分页查询

//调用分页查询
public IPage<CarRbcOrderLogVO> selectPage(CarRbcOrderLogVO vo) {
        Page<CarRbcOrderLogVO> page = new Page<>(vo.getPageNum(), vo.getPageSize());
        String startTime=null,endTime = null;
        if (null!=vo.getOperateTimeSlot() && vo.getOperateTimeSlot().length>=2) {
            String[] timeArray = vo.getOperateTimeSlot();
            startTime = timeArray[0];
            endTime = timeArray[1];
        }
        page.addOrder(OrderItem.desc("create_time"));
        return carRbcOrderLogDao.findByPage(page, vo,startTime,endTime);
}
    
// 分页查询mapper
public interface CarRbcOrderLogDao extends BaseMapper<CarRbcOrderLog> {

    //分页查询维护记录列表
    // @Param 在xml文件里的引用
    IPage<CarRbcOrderLogVO> findByPage(Page<CarRbcOrderLogVO> page
            , @Param("crRbcOrderLogVO") CarRbcOrderLogVO crRbcOrderLogVO
            , @Param("startTime") String startTime
            , @Param("endTime") String endTime
    );
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.catl.swap.service.manager.dao.CarRbcOrderLogDao">

    <select id="findByPage" parameterType="com.catl.swap.manager.vo.CarRbcOrderLogVO"
            resultType="com.catl.swap.manager.vo.CarRbcOrderLogVO">
        select l.*,u.username as createUsername from log_car_rbc_order l left join sys_user u on l.create_user_id = u.id
        where 1=1
        <if test="crRbcOrderLogVO.batterySn !=null and crRbcOrderLogVO.batterySn !=''">
            and l.battery_sn like CONCAT('%', #{crRbcOrderLogVO.batterySn}, '%')
        </if>
        <if test="crRbcOrderLogVO.batteryBin !=null and crRbcOrderLogVO.batteryBin !=''">
            and l.battery_bin like CONCAT('%', #{crRbcOrderLogVO.batteryBin}, '%')
        </if>
        <if test="crRbcOrderLogVO.batteryLevel !=null and crRbcOrderLogVO.batteryLevel !=''">
            and l.battery_level like CONCAT('%', #{crRbcOrderLogVO.batteryLevel}, '%')
        </if>
        <if test="crRbcOrderLogVO.batterySoc !=null and crRbcOrderLogVO.batterySoc !=''">
            and l.battery_soc like CONCAT('%', #{crRbcOrderLogVO.batterySoc}, '%')
        </if>
        <if test="startTime != null and startTime !='' or endTime != null and endTime !='' ">
            and l.create_time between STR_TO_DATE(#{startTime}, '%Y-%m-%d %H:%i:%s') and STR_TO_DATE(#{endTime}, '%Y-%m-%d %H:%i:%s')
        </if>
    </select>
</mapper>