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