mybatis list

 <select id="getDataByMetricIdsAndTimeList" resultMap="MetricDataMap" resultType="map" >
	SELECT
	 DATE_FORMAT(mdt.measure_time,'%Y-%m-%d %H:%i:%s') measure_time 
		, mdt.metric_code,mdt.`value`,mdt.producer_code,mdt.device_sn,
		mdt.channel,mdt.metric_id
	FROM
		metric_data_t mdt
	<where>
		<if test="startTime != null">
			<![CDATA[AND mdt.measure_time >= #{startTime,jdbcType=VARCHAR}]]>
		</if>
		<if test="endTime != null">
			<![CDATA[AND mdt.measure_time <= #{endTime,jdbcType=VARCHAR}]]>
		</if>
		<if test="metricIds != null">
            AND mdt.metric_id in (
		      <foreach collection="metricIds" item="metricId" index="index" separator=",">
			#{metricId,jdbcType=BIGINT}
		      </foreach>
		      ) 
		</if>
	</where>
	ORDER BY mdt.measure_time
  </select>

<select id="getRoadStakeListByRoadIds" resultMap="RoadStakeMap" parameterType="map">
        SELECT
        <include refid="RoadInfo_Stake"/>
        FROM bs_road_stake_info_t AS RoadStake
        <where>
            <if test="roadIds != null and roadIds.size() > 0">
                RoadStake.road_id IN
                <foreach item="item" index="index" collection="roadIds" open="(" separator="," close=")">
                    ${item}
                </foreach>
            </if>

        </where>
    </select>