mybatis分页查询与筛选

mybatis查询(可分页或不分页)

  <select id="getPicAndVideoList" resultMap="CarTypeDtoMap">
         select
        ct.id, ct.carSystemId , rcs.name as car_system_name , ct.product_id, ct.product_code, ct.product_name, ct.brand_code, ct.brand_name, ct.series_code,
        ct.series_name, ct.model_code, ct.model_name,ct.config_code,ct.config_name, ct.oem_directive_price,ct.directive_price,
        ct.is_valid, ct.create_time ,
        rcv.id as video_id, rcv.videoName,rcv.videoAddress,rcv.isPublicVideo
        from cartype ct
        left join room_cartype_videos rcv     on rcv.carTypeId = ct.id
        left join room_car_system rcs         on rcs.id = ct.carSystemId
        <include refid="searchCarType"/>
        <choose>
            <when test="orderBy!=null">
                order by ct.${orderBy}
                <if test="sort!=null"> ${sort}</if>
            </when>
            <otherwise>
                order by ct.create_time desc
            </otherwise>
        </choose>
        <if test="limit!=null">
            limit #{limit}
        </if>
        <if test="start !=null and pageSize !=null">
            limit #{start},#{pageSize}
        </if>
  </select>
    <sql id="searchCarType">
        where 1=1
    </sql>

注意: order by 要在limit之前, group by先
order by优先级最低，在最后
书写顺序为: group by – order by – limit