xml映射文件:
<select id="selectImages" resultType="org.jeecg.modules.supervise.device.entity.DataCollector">
SELECT
t1.*
FROM
data_collector t1
WHERE
t1.collector_id in
<foreach item="id" collection="deviceCollectorIds" index="index" open="(" separator=","
close=")">
#{id}
</foreach>
<if test="startTime != null and startTime != ''">
AND t1.collector_time between #{startTime} and #{endTime}
</if>
order by t1.collector_time desc
</select>
mapper文件:
List<DataCollector> selectImages(List<String> deviceCollectorIds,
String startTime,